Install Mysqldump Windows
Posted : admin On 25.12.2019Post updated to MariaDB 10.3.13-GA release, released on February 21, 2019.If you like playing with MySQL or MariaDB servers, you most likely know that both of these great open-source DBMS come with mysqldump, a neat command-line utility that can be used to perform backup copies (or “dumps”, as its name implies) of their data. There are many things that make mysqldump great, such as:.
It’s completely free, so it won’t cost you a penny. It’s also already bundled with any MySQL or MariaDB installation, therefore you don’t even have to download and install it you already have it. It’s blazingly fast: with a decent SSD, it will backup many GB of data in a matter of seconds. It’s super-easy to use. And with “super-easy”, I mean that you will be able to perform a full backup with a single command-line – as long as you’ve got the permissions to do that. It doesn’t require you to shutdown your database down, even if it’s strongly advisable to lock the database before performing the backup to avoid potential data loss (more on that later).How does it workThe mysqldump tool works in a very straightforward way: it retrieves the data and schema from each database and table and “dumps” everything into a single, gigantic, SQL-formatted text file. Such file will basically contain all the SQL statements necessary to reconstruct the databases and data from scratch: if you open a dump file generated by mysqldump, you will see the various CREATE TABLE statements, followed by a (arguably huge) number of INSERT statements, one for each row of data.
Complete BackupHere’s the (in)famous “command-line one-liner” to dump all the databases contained in your MySQL or MariaDB using mysqldump. Mysqldump -user =db root user -password -lock -tables -databases db name /bak /db backup.sqlThe only significant difference here is that we switched out the –all-databases ( -A) option and replaced it with the –databases ( -B) option, followed by the database name(s) we want to backup.
Mysqldump Syntax
To export multiple databases, you can enter multiple names, separating them with a single space. Dumping TablesFor very large databases, you may want to backup the data based on tables rather than the whole database. This can be done with an one-liner as well. Mysqldump -user =db root user -password -lock -tables db name table name /bak /db backup.sqlAs you can see, we’re not using the –all-databases (-A) and/or –databases (-B) options here: with such syntax, mysqldump will just assume that the first name given is a database and the second name is a table. Again, to backup multiple tables, just list them after the database name separating them by a single space. ConclusionThis more or less concludes our brief analysis of mysqldump, which is clearly among the best options you can use to perform quick backups of single database and also of your whole DBMS Service.
Install Mysqldump On Windows
In case you need additional info about it, you can check out the. Also, if you’re using Windows, you could take a look at SQLyog, a great MySQL/MariaDB GUI which I reviewed few months ago ( DISCLAIMER: they didn’t pay me or this blog to review it – it’s just that I genuinely like it a lot).