Importing a MySQL database

Its easy to import an existing database into Islandnet.com's database server using Shell commands.

$ mysql -u username -p -h mysql55.islandnet.com
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1757151
Server version: 5.5.5-m3 FreeBSD port: mysql-server-5.5.5

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use databasename
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> source filenameofexportedDB.sql

... Bunch of import stuff happens here

mysql> quit
Bye

- The data-base-name with the name of the database you just create - The username with the username you used just create - change data.sql for the name of the dump file you uploaded. This should populate the new database you created allowing you to migrate a website from another provider to Islandnet.com easily, if you have difficulties please open a support ticket or call us.