If you are looking to restore a MySQL databases from a backup, we offer a tool called phpMyAdmin which makes this really easy to do. You need to first make sure you have an active database or create one following the guide at the link below:

How to create a mysql database

  1. Firstly, log into the phpMyAdmin control panel for your domain. This is found by typing /phpmyadmin after your domain name. For example:

    http://www.lcnsupport.co.uk/phpmyadmin
  2. Once logged in, select the Import tab.
  3. Click the Choose File button and select the backup file you wish to restore your database from. You should not need to change any of the settings on the page.
  4. Click the Go button at the bottom of the page and phpMyAdmin will restore your database from the backup file you have chosen.
  5. If successful, it will generate a message to let you know and also give you a breakdown of the queries executed.

Need a hand? Search over a hundred step-by-step support guides