To accomplish this, we'll use the -C option, like so ( USER is the username that has permission to work with the databases): mysqldump -u USER -p -C products > /mnt/backups/

Let's stick with our same example as above, only with compression. This is another feature the developers of MySQL rolled in. If your database is considerably larger and you plan on manually running backups on a daily basis, you might consider compressing the backups. If you want to back up all of your databases, you can accomplish this with the -all-databases option, like so: mysqldump -u USER -p -all-databases > /mnt/backups/all_databases.sql Compressing your backup Remember: After completing the task, exit out of the root bash prompt with the exit command. If you don't want to run the risk of opening the permissions on that backup directory, you can first issue the command sudo su and then run the mysqldump command.

If that fails (depending upon your setup), you may have to include the option to instruct mysqldump which user has said permission, like so ( USER is the actual user that has permission to work with the databases, such as root): mysqldump -u USER -p products > /mnt/backups/products.sqlĪnother issue might appear if the user doesn't have write permission to that directory if this is the case, you will receive a Permission denied error. First and foremost, you must use the -p option this instructs mysqldump that you will be entering the password associated with the MySQL user. The basic command to run that dump (aka backup) would be this: sudo mysqldump -p products > /mnt/backups/products.sql Let's say you have a database named products, and you want to back it up to an external drive mounted at /mnt/backups/.

The command's structure looks like this: mysqldump The command that does the heavy lifting is mysqldump.

Install mysqldump windows