{"id":6133,"date":"2015-05-21T23:19:51","date_gmt":"2015-05-21T19:19:51","guid":{"rendered":"http:\/\/www.msp360.com\/blog\/?p=6133"},"modified":"2023-12-13T13:11:38","modified_gmt":"2023-12-13T09:11:38","slug":"how-to-back-up-mysql-database","status":"publish","type":"post","link":"https:\/\/www.msp360.com\/resources\/blog\/how-to-back-up-mysql-database\/","title":{"rendered":"How to Back Up MySQL Database Using MSP360 Backup"},"content":{"rendered":"

The main point is that you need a script for the MySQL database backup that MSP360 Backup will run before uploading the backup to the cloud. Below there is a step-by-step guide for the MySQL backup with MSP360 Backup.<\/p>\n

<\/p>\n

\n
\n
FREE WHITEPAPER<\/div>\n
MS SQL Server Backup and Recovery<\/div>\n
Check out the ultimate guide\u00a0with best practices for MSPs:<\/div>\n\"CTA\"<\/a><\/span><\/span>\n<\/div>\n
\"Exchange<\/div>\n<\/div>\n

Setting Up a MySQL Database Backup<\/h2>\n

Step 1. <\/strong>Choose temporary storage and create a folder for your backup files. For example, a C:\\MySQLBackup\\ folder.<\/p>\n

Step 2. <\/strong>Write a script that will create a backup of your MySQL database. You can see an example below (where the database name is \u201ctest\u201d; \"root \/ p1234\" is a login account to MySQL):<\/p>\n

\"C:\\Program Files\\MySQL\\MySQL Server 5.6\\bin\\mysqldump.exe\" -u root -p1234 test > C:\\MySQLBackup\\testbackup.sql<\/pre>\n
Save this command as C:\\MySQLBackup\\MySQLBackup.bat.<\/p>\n
Note: <\/strong>Please replace \u201c1234\u201d with your root password and \u201ctest\u201d with the name of the database that you want to back up. Also, the \u201cmysqldump.exe\u201d location can be different in your environment.<\/p>\n
Step 3.<\/strong> Launch MSP360 Backup then click on the \"Backup Files<\/strong>\" button in the top menu.<\/p>\n
Specify the Backup Source. Here you need to choose the folder created in Step 1<\/strong>. If it is a network share, don't forget to specify your network credentials<\/a> in \u201cTools | Network Credentials<\/strong>\u201d.<\/p>\n
Step 4.<\/strong> We strongly recommended to include empty folders and hidden\/system files into your backup to fully keep the MySQL database structure.<\/p>\n
\"MySQL<\/p>\n
Step 5.<\/strong> On the Pre\/Post Actions<\/strong> step, you need to specify the script created in Step 2<\/strong>. It will be executed before the backup job runs.<\/p>\n
\"MySQL<\/p>\n
Note:<\/strong> If you don't want to store the results of the \u201cmysqldump\u201d backup after you have uploaded it to the cloud, you can create the BAT file that will delete those files.<\/p>\n
Further reading<\/span> Deleting Files From Local Storage After a Successful Backup<\/a><\/p>\n
Step 6.<\/strong> Run your backup plan, and it will execute a pre-action that creates a copy of your database and push it to the cloud afterward.<\/p>\n
Summary<\/h2>\n
MSP360 Backup allows you to back up MySQL databases to any cloud storage. Its Pre\/Post Action<\/strong> step automatically creates a \u201cmysqldump\u201d backup of your database and then it uploads the backup to the cloud.<\/p>\n
Note:<\/strong> You can skip the Pre\/Post Actions<\/strong> and intermediate folder steps if you manually execute the mysqldump.exe, and then specify the folder with MySQL backup data when creating a backup plan in MSP360 Backup.<\/p>\n","protected":false},"excerpt":{"rendered":"
The main point is that you need a script for the MySQL database backup that MSP360 Backup will run before uploading the backup to the cloud. Below there is a step-by-step guide for the MySQL backup with MSP360 Backup.<\/p>\n","protected":false},"author":69,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[877,894,882],"tags":[],"class_list":["post-6133","post","type-post","status-publish","format-standard","hentry","category-blog-articles","category-msp360-backup","category-msp360-news"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/6133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/users\/69"}],"replies":[{"embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/comments?post=6133"}],"version-history":[{"count":4,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/6133\/revisions"}],"predecessor-version":[{"id":56902,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/posts\/6133\/revisions\/56902"}],"wp:attachment":[{"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/media?parent=6133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/categories?post=6133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.msp360.com\/resources\/wp-json\/wp\/v2\/tags?post=6133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}