Saturday, February 19, 2011

backup a mysql table

Take a backup:
mysqldump -p database_name table_name >some_file.sql


Restore:
mysqldump -p database_name <some_file.sql

No comments:

Post a Comment