CentrioHost Blog

Stories and News from IT Industry, Reviews & Tips | Technology Blog


Backup and restore a mysql table using mysqldump

There are two  methods for taking backup of a single table from a database and restore in into another database

1) Method 1

In this method you can take  a backup of a database table and  restore into another db. But this restoration will remove the  already existing  table and recreate it in the new database .

#  mysqldump old_db table  > old_db.table.sql
#  mysql new_db < old_db.table.sql

2)Method 2

In this method you can table only the backup of database table  data ( not the sql scheme )  and restore it into new database without removing the old data in new database

#  mysqldump -t old_db table  > old_db.table.sql
#  mysql new_db << old_db.table.sql

Make sure to table backups of new database before doing the restoration

Subscribe Now

10,000 successful online businessmen like to have our content directly delivered to their inbox. Subscribe to our newsletter!

Archive Calendar

SatSunMonTueWedThuFri
1234567
891011121314
15161718192021
22232425262728
2930 

Over 20000 Satisfied Customers!

  • web hosting reviewer
    Valerie Quinn
    CTO, Acteon Group

    Centriohost staff were fantastic, I had a concern with a domain and they got back to me very quickly and they helped me to resolve the issue! ~ . . . Read more

  • Joomla hosting reviewer
    Collin Bryan
    Photographer, Allister Freeman

    I'm using centrio for my portfolio since 2006. The transition was seamless, the support was immediate, and everything works perfectly. ~ . . . Read more

  • dedicated server reviewer
    Harry Collett
    Actor, A&J Artists

    Very easy to understand & use even though I am not very technologically minded. No complications whatsoever & I wouldn't hesitate to recommend it to all. ~ . . . Read more

  • vps web hosting reviewer
    Porfirio Santos
    Technician, Diageo PLC

    Centrio support team have been amazingly responsive and helpful to any of my queries, thank you so much to the Centriohost have been amazingly responsive and helpful to any of my queries 👍👍👍 ~ . . . Read more

  • wordpress hosting plans reviewer
    Catherine Auer
    Doctor, SmartClinics

    Anytime I've had a problem I can't solve, I've found Centriohost to be diligent and persistent. They simply won't let an issue go until the client is happy. ~ . . . Read more

  • reseller hosting reviewer
    Effectivo Social
    Freelancer, Fiverr

    Recommend their shared hosting for all my SME web design clients. Their cloud or VME offerings are too great to deal with. Pricing is perfect and suitable for all users (͠≖ ͜ʖ͠≖) 👌 ~ . . . Read more

Top