Restoring From Database Archive
In the unfortunate event that you have to restore your database, you have two options: either doing it through PHPMyAdmin included in both limited and Premium versions of DesktopServer, or DS-CLI, our command line interface.
For Instructions on how to do it through the DS-CLI, click on the contextual help and select [ Restoring Archives ] for the steps
- Access PHPMyAdmin through the DesktopServer localhost Sites page. Simply click on [ Sites] on your DesktopServer and your browser will open your localhost page
- Select the [ Database ] button which corresponds to the site you'd need to restore the database
- Once the database is displayed, we recommend you select the [ Check All ] box and select [ Drop } in the dropdown menu and then click on [ Go }. Confirm that you wish to execute the command and the tables will be deleted
- Now that the database itself is empty, click on the [ Import ] tab above. Click on [ Choose File ] and select the .sql file that corresponds to the site's database. It will have the same name as the site in the file name. Note: Do not select the file containing the word "credentials"
- Once you have selected your file, click on [ Open ] in PHPMyAdmin and then click on [ Go }. PHPMyAdmin will now import the database. This might take several minutes depending on the size of your file.
- Once it is finished, PHPMyAdmin will show a report of how many queries it has successfully executed.
- In the event of a large database, you may need to repeat the file selection step multiple times in order for the whole database to be imported. In these cases, PHPMyAdmin will let you know that you will need to import the file again until it is finished.
- You can now test your site to verify that it's working