Monday, January 31, 2011

mysqldump no data , mysqldump a table with data

1, Dump whole DB schema
$ mysqldump --no-data -u mysqluser -pMysql_DB_PW api > api.mysql

2, Dump a table data from DB
$ mysqldump  -u mysqluser -pMysql_DB_PW  api_DB a_table  > db_table.mysql
at

1 comment:

  1. GlenFebruary 1, 2011 at 9:10 AM

    restore:

    $ mysql -u mysqluser -pMysql_DB_PW api_DB < db_table.mysql

    ReplyDelete

Subscribe to: Post Comments (Atom)