How do I export a MySQL database?

Start by accessing your Web Hosting dashboard.

On your dashboard, select the option phpMyAdmin from the navbar.

Select your database in the top left-hand corner.

Once done, click the Export tab in the navbar.

If you only want to export specific tables, select Custom – display all possible options under ‘Export method’ and choose the tables in the database you would like to export.

Whichever option you choose, ensure that the SQL format is selected.

Now click on the Go button. You’ll then be asked to open or save your file.

Your database will start to download in your Web Browser.

Start by logging in to your 123 Reg Control Panel.

From there, select Web Hosting or Premium Hosting within the ‘Manage active products’ section, depending on which product you wish to use.

Next, select Manage opposite the ‘(bought before XX/XX/XX)’ option.

This will show you an overview of your current hosting packages. Click Manage for the account you wish to use.

On the next page, select Manage for the domain you wish to update.

In the Web Tools section, click on MySQL Databases.

In the Manage MySQL Databases section, enter the password for the database you wish to export and then click on Manage.

This will open up phpMyAdmin.

Click on your database in the top left hand corner.

Now click on the Export tab.

You can now choose the tables in the database you would like to export.

Ensure that the MySQL button is selected.

Now click on the Go button.

Your database will start to download in your Web Browser.