I am trying to do a dump of all databases with:
C:\MySQL_DUMP>mysqldump --opt --all-databases > c:\mysql_dump\all_dbs.sql -u root -p 123
However, my all_dbs.sql file simply contains the following contents, which I know is incorrect:
Usage: mysqldump [OPTIONS] database [tables]
OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help
I know I should expect over 100 lines with CREATE and INSERT statements.
As well, afterwards, how would I import?
The reason that I need to do this is because I need to reformat my system.