Backuping a single table from a database
mysqldump -u -p database_one table_name > /var/www/backups/table_name.sql
Restoring the table into another database
mysql -u -p database_two < /var/www/backups/table_name.sql
For more Linux commands, please refer to:
Always nice to see mysqldump info. You have a better tutorial than most. Keep up the good work!
Thank you!
excellent tips thanks :)
thanks for this nice little tip :)
nice little tip, thanks.
u saved my time :)
Thanks. Concise and helpful
Good tips, I just read another good (and similar) guide here:
http://www.bukisa.com/articles/409623_how-to-backup-a-mysql-database