In this guide, we will see how to import your MySQL database and place it on our servers.
This option is reserved for to subscribers who have ordered the MySQL Private (SQLGOLD).
Import my MySQL database
First, go to your trademark control panel, Magic Online or Nuxit.
Then click on Lodging.
If you have a standard mutualized offer, go to MANAGEMENT WEB.
If you have a private MySQL offer, click on the button DATABASE MANAGEMENT.
In the section YOUR MYSQL DATABASES click on the button IMPORT A DATABASE.
You have two choices for importing a database.
External import
Click on the button FROM ANOTHER HOST.
Set the connection parameters to the external server that contains the database. Make sure that the port used is open on the remote server.
Finally click on VALIDATE.
Internal import
Click on the button FROM THE SAME CUSTOMER ACCOUNT.
Choose the database to import from the list proposed by the interface. Then click on VALIDATE to apply the import.
The import will start and take a few minutes depending on the size of the imported data.
New Planet space
Always start by going to your client interface Magic Online or Nuxit.
Then click on the menu Support or Authcode domain which lead directly to the Planet interface.
Once the interface is open, follow the menu Shared Hosting.
Click on WEB MANAGEMENT of the accommodation in question.
In the section Your MySql Databases click on the button IMPORT A DATABASE.
You have two choices for importing a database.
External import
Click on the button FROM ANOTHER HOST.
Set the connection parameters to the external server that contains the database. Make sure that the port used is open on the remote server.
Finally click on VALIDATE.
The import will start and take a few minutes depending on the size of the imported data.
Internal import
Click on the button FROM THE SAME CUSTOMER ACCOUNT.
Choose the database to import from the list proposed by the interface. Then click on IMPORT to apply the import.
The import will start and take a few minutes depending on the size of the imported data.
Alternative import/export methods
Via PhpMyAdmin
To import a MySQL database, you need to have a backup file with the extension .sql.
If you have a file .sql.gzIt is possible to import it directly.
First, empty the database if it is still full, to avoid import errors.
Access your PhpMyAdmin interfaceand then click on the button Import.
Then click on the button Choose a file. At this point, it is enough to find the file .sql in the right location on your local machine. Select the file and validate.
Click on the button at the bottom Import.
If you have an error in timoutThis means that the uploaded file is large. This is due to the fact that resources are limited, especially for shared offers.
If you have shared hosting, or your server is managed, please upload the file via FTP. Once this is done, open a ticket to ask our technical support to import it for you. Don't forget to specify the file name .sql that you have uploaded to the FTP account of your subscription.
Command line (Premium, VPS, Dedicated)
- Export of base(s) (dump)
mysqldump -h'server_name' -u'login_sql' -pmotdepassedelabase_name > /directory/my_dump.sql
- Restoration of base(s)
mysql -h'server_name' -u'login_sql' -base_passwordbase_name < /path/my_dump.sql
- Export/import database(s) with on-the-fly file compression/decompression
Compress .sql files on the fly in gunzip (.gz) to save space you can use at dump time:
mysqldump -hlocalhost -uloginsql -pmotdepassedelabase -databases base1 base2 | gzip > /repertoiredesdump/dump.sql.gz
And to directly re-import these compressed dumps:
gunzip < /repertoiredesdump/dump.sql.gz | mysql -uloginsql -pmotdepassedelabase -hlocalhost
English 
Français 
Español