{"id":8607,"date":"2021-03-23T15:46:17","date_gmt":"2021-03-23T14:46:17","guid":{"rendered":"https:\/\/assistance.groupemagiconline.com\/?post_type=ht_kb&p=8607"},"modified":"2022-10-11T12:43:28","modified_gmt":"2022-10-11T10:43:28","slug":"importer-ma-base-de-donnees-mysql","status":"publish","type":"ht_kb","link":"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/importer-ma-base-de-donnees-mysql\/","title":{"rendered":"Import my MySQL database"},"content":{"rendered":"

In this guide, we will see how to import your MySQL database and place it on our servers.<\/p>\n

\t\t

\r\n \t\t\t \t\t\t \t\t\t\t

\r\n \t\t\t\t\tThis option is reserved for<\/strong> to subscribers who have ordered the MySQL Private (SQLGOLD)<\/strong><\/a>. \t\t\t\t<\/p>\r\n \t\t\t \t\t\t\r\n \t\t<\/div>\r\n \t\t<\/p>\n

Import my MySQL database<\/h2>\n

First, go to your trademark control panel, Magic Online<\/a> or Nuxit<\/a>.<\/p>\n

Then click on Lodging<\/strong>.<\/p>\n

\"Lodging<\/a><\/pre>\n
If you have a standard mutualized offer, go to MANAGEMENT <\/strong>WEB<\/strong>.<\/p>\n
\"Web<\/a><\/pre>\n
If you have a private MySQL offer, click on the button DATABASE MANAGEMENT<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
In the section YOUR MYSQL DATABASES<\/strong> click on the button IMPORT A DATABASE<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
You have two choices for importing a database.<\/p>\n
\"\"<\/a><\/pre>\n
External import<\/strong><\/h3>\n
Click on the button FROM ANOTHER HOST<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Set the connection parameters to the external server that contains the database. Make sure that the port used is open on the remote server.
\nFinally click on\u00a0VALIDATE<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Internal import<\/strong><\/h3>\n
Click on the button FROM THE SAME CUSTOMER ACCOUNT<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Choose the database to import from the list proposed by the interface. Then click on VALIDATE<\/strong> to apply the import.<\/p>\n
\"\"<\/a><\/pre>\n
The import will start and take a few minutes depending on the size of the imported data.<\/p>\n
\"\"<\/a><\/pre>\n
New Planet space<\/h2>\n
Always start by going to your client interface Magic Online<\/a> or Nuxit<\/a>.<\/p>\n
Then click on the menu Support<\/strong> or Authcode domain<\/strong>\u00a0which lead directly to the Planet interface.<\/p>\n
\"\"<\/a><\/pre>\n
Once the interface is open, follow the menu\u00a0Shared Hosting<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Click on WEB MANAGEMENT<\/strong> of the accommodation in question.<\/p>\n
\"Nuxit<\/a><\/pre>\n
In the section Your MySql Databases<\/strong> click on the button IMPORT A DATABASE<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
You have two choices for importing a database.<\/p>\n
\"\"<\/a><\/pre>\n
External import<\/strong><\/h3>\n
Click on the button FROM ANOTHER HOST<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Set the connection parameters to the external server that contains the database. Make sure that the port used is open on the remote server.
\nFinally click on\u00a0VALIDATE<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
The import will start and take a few minutes depending on the size of the imported data.<\/p>\n
\"\"<\/a><\/pre>\n
Internal import<\/strong><\/h3>\n
Click on the button FROM THE SAME CUSTOMER ACCOUNT<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Choose the database to import from the list proposed by the interface. Then click on IMPORT<\/strong> to apply the import.<\/p>\n
\"\"<\/a><\/pre>\n
The import will start and take a few minutes depending on the size of the imported data.<\/p>\n
\"\"<\/a><\/pre>\n
Alternative import\/export methods<\/span><\/h2>\n
Via PhpMyAdmin<\/span><\/strong><\/h3>\n
To import a MySQL database, you need to have a backup file with the extension .sql<\/strong>.<\/p>\n
If you have a file .sql.gz<\/strong>It is possible to import it directly.<\/p>\n
First, empty the database if it is still full, to avoid import errors.<\/strong><\/p>\n
Access your PhpMyAdmin interface<\/a>and then click on the button\u00a0Import<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
Then click on the button Choose a file<\/strong>. At this point, it is enough to find the file .sql<\/strong> in the right location on your local machine. Select the file and validate.<\/p>\n
\"\"<\/a><\/pre>\n
Click on the button at the bottom Import<\/strong>.<\/p>\n
\"\"<\/a><\/pre>\n
If you have an error in timout<\/strong>This means that the uploaded file is large. This is due to the fact that resources are limited, especially for shared offers.<\/p>\n
If you have shared hosting, or your server is managed, please upload the file via FTP. Once this is done, open a ticket<\/a> to ask our technical support to import it for you. Don't forget to specify the file name .sql<\/strong> that you have uploaded to the FTP account of your subscription.<\/p>\n
If you want to import or export a rather heavy database, phpMyAdmin will do a timeout (exceeding the maximum execution time for a script) preventing you from performing the operation. The easiest way is to use a script such as BigDump<\/a>\u00a0or a third party software such as\u00a0MySQLFront<\/a>\u00a0or\u00a0MySQL WorkBench<\/a>to connect to the server and create or restore the DUMP.<\/div>\n
Command line (Premium, VPS, Dedicated)<\/span><\/strong><\/h3>\n
    \n
  • Export of base(s) (dump)<\/span><\/li>\n<\/ul>\n
        \t\t
    \r\n    \t\t\t    \t\t\t    \t\t\t\t
    \r\n    \t\t\t\t\tmysqldump -h'server_name' -u'login_sql' -pmotdepassedelabase_name > \/directory\/my_dump.sql    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div>\r\n    \t\t<\/p>\n
      \n
    • Restoration of base(s)<\/li>\n<\/ul>\n
          \t\t
      \r\n    \t\t\t    \t\t\t    \t\t\t\t
      \r\n    \t\t\t\t\tmysql -h'server_name' -u'login_sql' -base_passwordbase_name < \/path\/my_dump.sql    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div>\r\n    \t\t<\/p>\n
        \n
      • Export\/import database(s) with on-the-fly file compression\/decompression<\/span><\/li>\n<\/ul>\n
        Compress .sql files on the fly in gunzip (.gz) to save space you can use at dump time:
        \n    \t\t
        \r\n    \t\t\t    \t\t\t    \t\t\t\t
        \r\n    \t\t\t\t\tmysqldump -hlocalhost -uloginsql -pmotdepassedelabase -databases base1 base2 | gzip > \/repertoiredesdump\/dump.sql.gz    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div>\r\n    \t\t<\/p>\n
        And to directly re-import these compressed dumps:
        \n    \t\t
        \r\n    \t\t\t    \t\t\t    \t\t\t\t
        \r\n    \t\t\t\t\tgunzip < \/repertoiredesdump\/dump.sql.gz | mysql -uloginsql -pmotdepassedelabase -hlocalhost    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div>\r\n    \t\t<\/p>","protected":false},"excerpt":{"rendered":"
        In this guide we will see how to import your MySQL database and place it on our servers. Importing my MySQL database You need to start by going to your Magic Online or Nuxit client interface. Then click on Hostings. If you have a standard shared package, go to MANAGEMENT...<\/p>","protected":false},"author":52,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[734,1246,733,727],"ht-kb-tag":[1141,1133,1136,1138,1137,1135,1140,1132],"class_list":["post-8607","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-mutualise-standard","ht_kb_category-hebergements-cloud-evolution","ht_kb_category-performance","ht_kb_category-mysql-prive","ht_kb_tag-apploader-ma-base-de-donnees","ht_kb_tag-bdd-mysql-import","ht_kb_tag-fichier-sql","ht_kb_tag-fichier-sql-bdd-mysql","ht_kb_tag-fichier-sql-gz","ht_kb_tag-import-mysql","ht_kb_tag-importer-ma-base","ht_kb_tag-importer-une-base-de-donnees"],"_links":{"self":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/8607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/users\/52"}],"replies":[{"embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/comments?post=8607"}],"version-history":[{"count":4,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/8607\/revisions"}],"predecessor-version":[{"id":11286,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/8607\/revisions\/11286"}],"wp:attachment":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/media?parent=8607"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb-category?post=8607"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=8607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}