Sunday, March 27, 2011

mysql dump and restore

http://www.patrickpatoray.com/?Page=30

mysqldump --user=XXXXXXXX --password=XXXXXXXX --databases DB_NAME --tables TABLE_NAME > /PATH/TO/DUMPFILE.SQL

mysql --verbose --user=XXXXXXXX --password=XXXXXXXX DB_NAME < /PATH/TO/DUMPFILE.SQL

No comments:

Related Posts Plugin for WordPress, Blogger...