Export mysql database based on a where condition
MYSQLDUMP exports data from MySQL databases. It is commonly used to export all data from a table or database, but it can also export selected data…
EXPLORE THE TOPIC
mysqldump.
4 articles on this topic
How to compress mysqldump output with gzip/bzip2
mysqldump exports MySQL data in SQL format and is commonly used for backups. Normally these backups are not compressed.
How to uses mysqldump to get structure or schema data only
mysqldump normally exports both database structure and data. Add -d or --no-data to export only the structure or schema.
Tips for speeding up dump and import data in MySQL
Importing large SQL datasets into MySQL can take a long time. These tips speed it up by adjusting indexes, inserts, autocommit, and constraint checks.