18 Sep, 2008
Backuping and restoring a single table using mysqldump
Web Development » Snippets » Backuping and restoring a single table using mysqldump
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:
Other similiar posts that you might be interested in:
- Get directory size using Linux command
- Utf-8 encoding problem with MySQL restore
- 15 tips on optimising MySQL databases and MySQL queries
- Links Love Series 2: MySQL server fine tuning and administrating
- Sun acquired MySQL for $1 billion
- Why are my subqueries slow?
- Connecting to mysql from command line (eg: PuTTY, ssh)
