Mysqldump is a client utility that is used to perform logical backups of the MySQL database. Learn Mysqldump Best Practices Prerequisites
Mysqldump is a client utility that is used to perform logical backups of the MySQL database. This popular migration tool is useful for various use cases of MySQL such as:
Mysqldump works by reading the source database objects and generating a set of SQL statements that are stored in a dump file. By replaying these statements on the destination database server, the original data is reconstructed. Since this model uses reading of the whole database and then essentially rebuilding, both dump and restore are time-consuming operations for a large database. The process might even turn cumbersome if you encounter errors during either dump or restore as it may lead you to fix the issues and re-run the operations. This is why it’s important to plan well before you take up the dump and restore activity.
In this 2-part blog series, we discuss some of the common aspects you should handle upfront to ensure a successful dump and restore activity. In the first part, we focus on the prerequisites you need to take care while importing the MySQL table data and in the second part, we will talk about how to handle import for stored program objects and views.
Compare ScaleGrid MySQL vs. DigitalOcean Managed Databases - See which offers the best MySQL throughput, latency, and pricing on DigitalOcean across workloads.
Setting MySQL Configuration Variables - MySQL 5.7 vs MySQL 8.0. In this article, we will explain the differences in managing the configuration variables between MySQL 5.7 and MySQL 8.0.
MySQL configuration variables are a set of server system variables used to configure the operation and behavior of the server. In this blog post, we will explain the differences in managing the configuration variables between MySQL 5.7 and MySQL 8.0.
How MySQL Ripple binlog server can help you improve the performance of your master server by introducing a proxy server between the master and slave servers.MySQL does not limit the number of slaves that you can connect to the master server in a replication topology.
Mysqldump Best Practices: MySQL Prerequisites. mysqldump is a client utility that is used to perform logical backups of the MySQL database. What do you need to set up a successful mysqldump? Let's take a look.