« MySql: Show, Desc, Info on Database and Table
Tech: Derby vs Oracle Berkely DB JE »

MySql: backup, mysqldump nodata, no structure, no create table

January 14th, 2009 by jeremychone

MySql Dump

# mysqldump -u dbuser -p[pwd] --opt database > database_backup.sql

MySql Dump without data (only structure)

# mysqldump -u dbuser -p[pwd] --no-data database > database_backup.sql

MySql Dump without structure (no drop/create table)

# mysqldump -u dbuser -p[pwd] --no-create-db --no-create-info database > database_backup.sql

Import SQL file

mysql -u user_name -p  database_name < /path/to/file.sql

Posted: Wednesday, January 14th, 2009
Tags: Mysql.
Actions: RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “MySql: backup, mysqldump nodata, no structure, no create table”

  1. [Quicktip] MySQL Dump ohne Create-Anweisungen | netzmensch-design blog Says:
    August 30th, 2010 at 5:50 am

    [...] http://www.bitsandpix.com Kürzlich wollte ich einen Dump einer Datenbank-Tabelle anlegen, um diese anschließend in auf [...]

Leave a Reply