Log into Plesk Control Panel and steer yourself to “phpMyAdmin”
For Backup of MySQL database click on Export.
1) Make sure that entire database is selected for Export, and not just one table.
All the Tables under Database list should be added in Export List.
2) Now, follow the steps given
select “SQL” for output format
Check “Structure”
and “Add AUTO_INCREMENT” value
Check “Enclose table and field name with back quotes”
Check “DATA”
check use “hexadecimal for binary field”
Export type set to “INSERT”
3) Check “Save as file”, it is not necessary to change the file name.
Click “GO” to download the backup file.
Backup of your MySQL database is created !
Now, for Restoring backup of MySql database
1) Click on SQL tab, to start restoration of your backup file.
2) Un-Check “Show this query here again”.
3) Browse to your database backup file.
4) Click – “GO”
Backup is Restored !
Large MySQL Backups:
Error: MySQL has gone away
To restore large SQL backups there are 2 setting that you will need to take of:
1. Make sure that you PHP upload size is great than your MySQL backup file, this setting will be needed to be changed in php.ini file. Only those who has server administrator access would be able to make changes in PHP.INI file. Hence you will have to contact your Hosting provider if you are hosted on a Shared server. But if you have a Dedicated Server then this file is normally stored in C:\Windows\php.ini or you can esily get the path from phpinfo() page. The option that you need to change is upload_max_filesize. It is also suggested that you increase the following parameters as per the size of your MySQL backup file:
max_execution_time = 30 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
memory_limit = 8M ; Maximum amount of memory a script may consume (8MB)
2. You will need to increase the MySQL buffer size in MySQL configuration size, the file is my.cnf in Linux server and my.ini on Windows Server. The parameter that you need to change is:
read_buffer_size
By default it is set to 1MB, if the entry is not present then add it under [MYSQLD] section.
Please Make sure that you restart IIS webserver after making change to php.ini and restart MySQL after making changes in my.ini file.
If you looking backup MySQL using VBS or ASP script then refer the link below:
How to backup MySQL using VBS or ASP script.
