Menu
I have used the MySQL mysqldump command. It said "dump complete". Where can I now find the file which contains the MySQL statments?
224
Then the dump will be in the file backup-file. sql in the current directory. If you don't redirect then the output will just be displayed to the screen, not saved to a file.
The memory dump is stored in the SQL instance MSSQL\LOG\ directory by default.
Mysqldump is a command-line utility that is used to generate the logical backup of the MySQL database. It produces the SQL Statements that can be used to recreate the database objects and data. The command can also be used to generate the output in the XML, delimited text, or CSV format.
Usually you use this command from the command line and pipe the output to a file:
mysqldump db_name > backup-file.sql
Then the dump will be in the file backup-file.sql in the current directory. If you don't redirect then the output will just be displayed to the screen, not saved to a file.
198
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
