Software solutions like mysqldumper or the BackupDB tool can help here. Since the size of the backup file may not exceed 2048 KB when restoring through phpMyAdmin, customers without SSH access reach their limits. This can be seen through the output: The import was completed successfully. After a few seconds, it will show you that the database was successfully restored. Then click on OK, in order to start the import. Subsequently, please select Search in order to select your locally saved database backup. If yes, remove this line so that the import can be carried out without restrictions.Īfter this, please click directly on the Import, tab in order to start the database import. Note:Please open the exported database with an editor and check if it contains the following line: CREATE DATABASE `DBxxxxxx`. Restoring an existing databaseĪfter 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. By clicking on the OK button, your database backup will be offered for download. Compression is a good idea for a larger database. Normally, you can leave the rest of the presets. ![]() ![]() 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. Please use the Export menu option on the right side. To do this, please select the menu option Administration/ Database Administration and click on the option To Administration for the desired database. You can reach phpMyAdmin through the database management in your password-protected Customer login. This article deals with the backup and restoration of MySQL databases:īacking up an existing database via phpMyAdmin Restoration of an existing database Alternative restoration of an existing database Artikel weiterleiten Backup and restoration of a MySQL database through phpMyAdmin
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |