Menu
following is the that I create dump from mysql database.
mysqldump -u root tempbkk > ttt.dump but I want to create a dump that exclude one or more file while creating dump from database we select.What is the command for that ?
797
To generate a dump select the database or table in the Object Browser and select Database -> Backup/Export -> Backup Database As SQL Dump… This option is also available in Table -> Backup/Export -> Backup Database As SQL Dump... or just press Ctrl+Alt+E.
It dumps one or more MySQL databases for backup or transfer to another SQL server. The mysqldump command can also generate output in CSV, other delimited text, or XML format.
mysqldump -u user -p some_database > some_database_dump.sql
118
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
