Pages

Tuesday, February 5, 2013

MySQL dump

Taking mysql dump

# mysqldump -u user -ppassword DB_name --ignore-table=DB_name.table_name1 --ignore-table=DB_name.table_name1 > DB_dump.sql

Restoring from the dump 

# mysql -uroot -proot DB_name < DB_dump.sql
Posted by at
Labels:

1 comment:

  1. AnonymousAugust 23, 2017 at 10:00 PM

    Very shortly this web site will be famous amid all blogging people, due
    to it's fastidious articles or reviews

    ReplyDelete

Subscribe to: Post Comments (Atom)