Database importation is usually done via phpMyAdmin.

STEP 1: Database configuration

1. Log in to your Infomaniak administration console.
2. Go to the menu: Tools → Databases.
3. Add a new database (or empty the existing database if the goal is to restore it).
4. Under List of existing users, make sure to create or assign a MySQL user with all rights on the database in question.

STEP 2: Dump file (SQL) deposit

1. Rename your dump file to match exactly the name of the target database followed by the extension .sql (example: if your database is named domainexyz, the file must be domainexyz.sql).
2. Log in to your FTP space with the administrator account (type sys_xxx).
3. Deposit the file in the root directory /data.

STEP 3: Configuration file

1. In the /data directory, create a file named .my.cnf (make sure to include the dot at the beginning of the name).
2. Important: The file must be encoded in ASCII (ANSI) and not in UTF-8.
3. This file must contain the following 5 lines (with a line break after each entry): 
   
   # .my.cnf [client] host=mysql_server_address user=mysql_username password=mysql_password You will find the server address (host) in your administration console → Databases.
4. Modify the permissions (CHMOD) of the file .my.cnf to 0600 (read/write for the owner only).

STEP 4: Importation and verification

1. The automated system regularly scans the /data directory. The import will start automatically a few minutes after the detection of valid files.
2. Once the processing is complete:
   • A log file named in the form database_name-YYYYMMDDHHMMSS.log is generated. It contains the execution report and any errors.
   • If the operation is successful, the source file is automatically renamed to nom_de_la_base.old.

Important notes and troubleshooting

• File format: The dump must be decompressed (raw .sql file). Do not rename a .zip or .gz archive, extract it first.
• SQL syntax: The file must not contain the instructions CREATE DATABASE, CONNECT or USE, otherwise it will fail.
• Table deletion: The system does not empty the database before import. If necessary, ensure that your dump contains the instructions DROP TABLE or manually delete the existing tables via the console before import.
• Source command: The SQL command source is not supported as direct access to the SQL server's file system is restricted.
• Upload tip: To prevent the system from attempting to process a file during transfer, upload your file with a temporary extension (e.g. fichier.upload), then rename it to .sql once the transfer is complete.
• Partial errors: If a query fails, the script continues importing the following lines. Always check the generated .log file.