How do I move MySQL databases to idologic? Print

  • 54

To manually move a MySQL database:

  1. SSH into your old server.
  2. Type in the following command: mysqldump -u username -p database_name > dumpfile.sql
    This will prompt you for your password and export the database into a text file.
  3. SSH into your Idologic account. Now use the previously created text file to recreate the database on our server as follows:

    mysql -u username -p database_name < dumpfile.sql

    NOTE: The username is your mysql username, not your web account username.

If you are using cPanel or DirectAdmin then you can use phpMyAdmin to create a database dump and it can then be imported using phpMyAdmin on our server.

Should you run into any problems though then submit a ticket and we will assist you in the move to our service.

Was this answer helpful?

« Back