Showing posts with label table. Show all posts
Showing posts with label table. Show all posts

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