Backup and restoration of a MySQL database through phpMyAdmin
This article deals with the backup and restoration of MySQL databases:
You can reach phpMyAdmin through the database management in your password-protected Customer login. To do this, please select the menu option Administration/ Database Administration and click on the option To Administration for the desired database.
Please use the Export menu option on the right side. As the type of export, please select the option Adjusted - show all possible options and then under Output select the option Save output in file. .
Normally, you can leave the rest of the presets. Compression is a good idea for a larger database. By clicking on the OK button, your database backup will be offered for download.
After you have connected to the desired database via phpMyAdmin through the database administration, first click on the Databases tab and select the database of yours in which the import should be carried out.
If yes, remove this line so that the import can be carried out without restrictions.
After this, please click directly on the Import, tab in order to start the database import.
Subsequently, please select Search in order to select your locally saved database backup. Then click on OK, in order to start the import.
After a few seconds, it will show you that the database was successfully restored. This can be seen through the output: The import was completed successfully..
Since the size of the backup file may not exceed 2048 KB when restoring through phpMyAdmin, customers without SSH access reach their limits. Software solutions like mysqldumper or the BackupDB tool can help here. Mysqldumper can temporarily save the backup status before reaching the size and/or time restriction and continue to record after an automatic restart.
Detailed instructions on how to install mysqldumper are available under the following Link with a video.
After you have completed the installation and configuration of mysqldumper, please click on the left side on theAdministration menu option.
After this, click on the Search.."(1) button, so that you can select the backup file that you want to use for the restore. After you have selected the file, click on the Upload file , button on the right next to it so that the file is uploaded to the system.
Through the area highlighted in point (2) , you will be able to see that the uploading of the file was successfully executed, as the number, date and time of the uploaded file will be shown to you.
Now click on the left side in the menu on the option Restore (1) and then on the Files from other programs (2) link.
Dadurch haben Sie nun die Möglichkeit die soeben hochgeladene Sicherungsdatei auszuwählen, in dem Sie vor dem Dateinamen dateiname.sql (3) einen Punkt setzten. Abschließend klicken Sie auf die Schaltfläche Wiederherstellen (4).
Now the next dialog window asks you to confirm that the content of the backup file should be restored with the selected database.
During the last step before restoration, you now have the option of selecting the coding of the backup file (1) ,if you did not use standard coding. Finally, you can start the restoration by pressing the Restore (2) button.
In the following image, you will see an active restoration process from a backup file.
Once the restoration process is complete, the program will congratulate you and you will receive information that the database was completely restored.
How can I restore a backup of my data (*.sql file) through PUTTY/SSH or how can I write my *.sql file to the database?