Sunday 20 December 2015

Restoring Large MySQL Dump

Hello,

This is tutorial how to restore your Database:
  1. Create dump file:
    • mysqldump -uroot -ppassword dbname > dbname_backup.sql
  2. Split dump file:
    • mkdir splits
    • split -n 1000 dbname_backup.sql splits/sql
  3. Create new database: dbname_clone
  4. Restore database:
    • cd splits
    • cat sql* | mysql -uroot -ppassword dbname_clone
Good luck!
Posted by at
Labels: ,

2 comments:

  1. herry misty9 March 2016 at 14:33

    Hi!This is extremely helpful post for everybody. Much thanks to you so much this post.Just about everything looks great showed.
    Decontamination vermiculite

    ReplyDelete
  2. Unknown9 May 2016 at 02:42

    Great blog and post thanks for sharing essay writer remarkable and knowledge with us.

    ReplyDelete

Subscribe to: Post Comments (Atom)