Web Development Blog

Web Development » Snippets » Backuping and restoring a single table using mysqldump

18 Sep, 2008

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:

Practical Guide to Linux Commands, Editors, and Shell Programming

Found this article useful? Share it with your friends:

Love what you've just read? Subscribe to our newsletter to receive tips, resources and special offers related to web development & design.

Your name:   Your email:  

Other similar posts that you might be interested in:

• Get directory size using Linux command
• 15 tips on optimising MySQL databases and MySQL queries
• Utf-8 encoding problem with MySQL restore
• 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)

8 Responses to “Backuping and restoring a single table using mysqldump”

1. Chat says:

   January 3, 2009 at 5:30 pm

   Always nice to see mysqldump info. You have a better tutorial than most. Keep up the good work!
2. R says:

   July 30, 2009 at 7:28 pm

   Thank you!
3. ajax samples says:

   December 30, 2009 at 3:16 am

   excellent tips thanks :)
4. ajax samples says:

   December 30, 2009 at 3:16 am

   thanks for this nice little tip :)
5. Andrea says:

   March 24, 2010 at 11:39 pm

   nice little tip, thanks.
6. chandan says:

   March 25, 2010 at 7:51 am

   u saved my time :)
7. farshid says:

   November 9, 2010 at 7:32 am

   Thanks. Concise and helpful
8. ciri says:

   December 7, 2010 at 8:53 am

   Good tips, I just read another good (and similar) guide here:

   http://www.bukisa.com/articles/409623_how-to-backup-a-mysql-database