This one time, at band camp, "Sunfire" <[EMAIL PROTECTED]> wrote: > how do you copy a database from a server over to another.. do all i need to > do is copy the tables over to the sql server after i make the db? or is it > more involved than that..
assuming you are using MySQL.... mysqldump [dbname] > dbname.sql -u [db_username] -p This will give you a file called dbname.sql. On the second machine you use this file to create the second db... mysqladmin create db_two -u [db2_username] -p mysql db_two < dbname.sql -u [db_two] -p hope this helps Kevin -- ______ (_____ \ _____) ) ____ ____ ____ ____ | ____/ / _ ) / _ | / ___) / _ ) | | ( (/ / ( ( | |( (___ ( (/ / |_| \____) \_||_| \____) \____) Kevin Waterson Port Macquarie, Australia -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php