mysqldump writes information as SQL statements to the standard output. You can save the output in a file:
shell>To dump all databases, invoke mysqldump with themysqldump [
arguments
] >file_name
--all-databases
option: shell>To dump only specific databases, name them on the command line and use themysqldump -uusername -pxxxxxx --all-databases > dump.sql
--databases
option: shell>mysqldump
-uusername -pxxxxxx
--databases db1 db2 db3 > dump.sql
Comments
Post a Comment