How to backup your MYSQL database
We advise that you take regular backups of your database. Backup your MYSQL database to not only protect you from data loss, it can also protect you from accidental deletion and human error.
You can take backups using your LCN backup tool as shown in our guide here, however, it is still beneficial to take a manual backup as well.
Before we start to backup your MYSQL database you are going to need your database Username, Password and Hostname. You would have chosen your Username and Password when you created the database, the hostname is included with these details in your LCN account under the MySQL section of your domain.
Let’s Get started…
- Go to http://domain.com/mysqladmin (replace domain.com with your actual domain name).
- Log in to phpMyAdmin with your Database Username and Password, choose the correct Hostname from the Server Choice dropdown.
- Select Databases and choose your database e.g. domain_com_db
- Click Export and click Go.
- You’ll be asked to Download the file and Save it to a location on your machine.
That’s it! You have now backed up your database.