Web Development Blog

by Ei Sabai Nyo

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:

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:  

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

  1. Chat says:

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

  2. R says:

    Thank you!

  3. ajax samples says:

    excellent tips thanks :)

  4. ajax samples says:

    thanks for this nice little tip :)

  5. Andrea says:

    nice little tip, thanks.

  6. chandan says:

    u saved my time :)

  7. farshid says:

    Thanks. Concise and helpful

  8. ciri says:

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

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

Profile PicHello! Welcome to Web development blog! My name is Ei Sabai and on this blog, I write about web development, mobile app development, latest web technologies and the likes. Read more about me or have a look at some of the tips & resources I've written.
Subscribe to our newsletter to receive tips, resources and special offers related to web development & design.
We do NOT spam.
Your name:  
Your email:  

Tips & Resources

Tips & Resources
WordPress Web Hosting
Recommended web hosting providers for WordPress 3.0
iPhone Native App Development
Important steps into iPhone app development for beginners
iPhone Web App Development
Tips for iPhone web app development
Coupons for Web Developers
Get discounts on web hosting, domain names, templates, etc
10 Useful jQuery Snippets
Easy-to-use jQuery snippets for any website
HTML Email Newsletter
Step-by-step tutorial on how to code an HTML email newsletter
  • bluehost Hosting $6.95/month
  • Joomla Templates

Recommended Book

Categories