MySQL

Backup a MySQL database from WebSitePanel

Step. 1. Sign into your WebSitePanel , Click on the Databases icon and select MySQL.

Step. 2. Select the database you want to backup (Click on the name)

Step. 3. "SQL Database Properties" page appears, expand the Maintenance Tools option then click on Backup button

Step. 4. "Backup SQL database" Page appears

Type the file name in the Backup file name text box.
Select if you want the file to be zipped or not in the 'Zip Backup' check box
'Backup destination' as \mydomain.com\data\ folder (here replace mydomain.com with your actual domain name). We recommend backup to the server rather than download via HTTP especially for slow connection.
After selecting the required options, click on the "Backup" button

Note: Once the backup process is over, download the backup file to your local server /PC via any FTP client. Please make sure to delete the backup file from the server immediately after download.

Note 2 - Alternatively you can backup your database or a specific table via phpmyadmin.

Related articles