Make sure you re-connect the username and database together. Remember just like the cPanel backup facility, if you use usernames for each database you’ll need to set that up individually, for instance if you restored the backup via the cPanel facility. If all goes well you should see the contents of the database all there. Simply select ‘Browse’ and find the relevant gzipped file, and leave all settings as default.Once you’ve created the database and you’re inside it, from the top menu again click Import. So create a new database (name it the same as the database name that you backed up previously). To restore via the phpMyAdmin facility unfortunately you’ll already need the database setup to restore the inner contents, such as the tables, etc. Scroll down on that page until you get to a ‘Save as file’ option and select ‘gzipped’ and leave the settings as default.Once you’ve accessed the phpMyAdmin facility go into the database (empty or otherwise) and from the top menu click Export.tar.gz format which means you’ll be able to restore it via the cPanel facility if you need to do so. Just like the backup facility in cPanel, it can give backups to you as a. Click the Export tab in the top navigation bar. Select the database you want to back up from the list in the left pane. Here’s a step-by-step guide to backup your database: 1. Creating a database backup with phpMyAdmin is very easy and takes only a few simple clicks. You can backup via phpMyAdmin in the Export section of the facility. How to Backup MySQL Database Using phpMyAdmin. You are able to backup databases in a variety of ways, one of which is via the Backup Facility with cPanel but there are other alternatives to Backup MySQL databases without the need of that facility on its own.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |