How one person represents the data may well be different to how you want it.If I did have one request, it would be to know what the field sizes were for various things. This has several implications.When you reload the dump file, you must specify a defaultdatabase name so that the server knows which database toreload.For reloading, you can specify a database name differentfrom the original name, which enables you to reload the datainto a different database.If the database to be reloaded does not exist, you mustcreate it first.Because the output will contain nostatement,theoption has no effect. In this case, writes astatement precedingeach statement.To dump a single database, name it on the command line:shell mysqldump -databases test dump.sqlIn the single-database case, it is permissible to omit theoption:shell mysqldump test dump.sqlThe difference between the two preceding commands is thatwithout, the dumpoutput contains no orstatements. 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.

Imdb database dump files in windows