![]() ![]() If you want to cause the dump file to force adrop of each database before recreating it, use theoption aswell. Thisensures that when the dump file is reloaded, it creates eachdatabase if it does not exist and makes it the default databaseso database contents are loaded into the same database fromwhich they came. ![]() ![]() You can save the outputin a file:shell mysqldump arguments filenameTo dump all databases, invoke withthe option:shell mysqldump -all-databases dump.sqlTo dump only specific databases, name them on the command lineand use theoption:shell mysqldump -databases db1 db2 db3 dump.sqlThe option causesall names on the command line to be treated as database names.Without this option, treats thefirst name as a database name and those following as tablenames.With or,writes andstatements prior to the dump output for each database. For information about reloadingsuch dump files, see.By default, writes information asSQL statements to the standard output. 7.4.1 Dumping Data in SQL Format with mysqldumpThis section describes how to useto create SQL-format dump files. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |