Mysqldump command line examples

An example of the common mysqldump usages.

Kept here for my reference.

Empty database

mysqldump [OPTIONS] --add-drop-table --no-data [DATABASE] | grep ^DROP | mysql [OPTIONS] [DATABASE]

Copy database

mysqldump [OPTIONS] --add-drop-table [OLD_DATABASE] | mysql [OPTIONS] [NEW_DATABASE]

Comments

Post new comment

Copyright Eristocrat Inc. 20072557 W Superior St - Unit G - Chicago, IL 60612