Wednesday, October 8, 2008

Mysql Backup a single table from the database

and to restore a specific table from the database:

mysqldump -u readonly -preadonly --single-transaction db_name --tables table_name > dir/sql/name

This really worked well for me and will do for you as well...:~))

No comments:

 
Custom Search