Information about the best way to move a MySQL database is available below. The information below will be enough to successfully move most MySQL databases.
Exporting the database
First, you need to export the database at your current provider. There are several ways to do this. Op this page we will explain how to do this using phpMyAdmin.
Login to phpMyAdmin
Login to phpMyAdmin at your old server/provider. The address of phpMyAdmin differs greatly per server/provider. If you are unable to login to phpMyAdmin, please contact your old provider and ask them about the address of phpMyAdmin and the associated login details. After you have logged into phpMyAdmin, please navigate to database that is to be moved. This also differs per phpMyAdmin installation.
Export database
Click 'Export' at the top and then 'Start'. You will be given an .SQL file which you can use at Versio.
Importing the database
Login to phpMyAdmin
Login to phpMyAdmin at Versio. You must first have created a MySQL user name and MySQL database under MySQL Management" in DirectAdmin. Login using the details of the MySQL user you have created. The link to phpMyAdmin is also available in DirectAdmin.
Select database
After logging into phpMyAdmin, please click the name of the database on your left.
Import database
Click 'Import' at the top. Here, select the .SQL file you downloaded and click 'Start'.
