Hi,
I am moving my site from one server to another, how can i copy all the data
in my datbase to my new server? Also is it possibel to do this one table at
a time?
Backup from command line:
mysqldump -h MYSQLHOST -u MYSQLUSER -p DATABASE backup.sql
or
mysqldump -h MYSQLHOST -u MYSQLUSER -p DATABASE TABLE 1
TABLE 2 ... TABLE N backup.sql
In backup.sql you get CREATE and INSERT syntax.
In new server you can execute:
mysql -h NEWMYSQLHOST -u MYSQLUSER -p DATABASE backup.sql
Of course in new server you must create DATABASE before.
--
Krzysztof Dziekiewicz
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php