Manage my MySQL databases

Create a MySQL database

Go to the management of my base

1. Access your customer interface, which you can find on our this link.
2. Click on Lodging in the left menu of your customer area.
3. If you have a standard mutualized offer, go to WEB MANAGEMENT.

The button ACTIONS displays a list of options for managing your database.

 

Possible actions on a database:

View the disk space quota of your database.
Access your database via the phpMyAdmin tool.
List the backups of your database.
Download a backup of your database.
Copy your database.
Change the password of your database.
Modify the comment of your database.
Delete your database.

1. If you have a MySQL Private (SQL Gold), click on the DATABASE MANAGEMENT to be redirected to MySQLGOLD.

2. The button ACTIONS displays a list of options for managing your database.

   Import a database.
   –          Alternative methods of import and export
   View the disk space quota of your database.
   Access your database via the phpMyAdmin tool.
   List the backups of your database.
   –          Download a backup of your database.
   –          Restore a backup of your database.
   List the users of your database.
   –          Change the user rights of your database
   –          Remove the user from your database
   Copy your database.
   Change the password of your database.
   Modify the comment of your database.
   Change the quota of your database.
   Add a user to your database.
   Delete your database.

Import a MySQL database

1. Access to the management interface of your database.
2. Click on the icon IMPORT A DATABASEEES.

3. You have two choices for importing a database.

4. Choice 1 : Import 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.

5. Choice 2 : Import FROM THE SAME CUSTOMER ACCOUNT.
   Choose the database to import from the list proposed by the interface.

6. Click on VALIDATE for the import to take place.

Alternative import/export methods

With PhpMyAdmin

If you want to export or import a database manually (light databases) :

1. Access to the management interface of your database.
2. Then click on the "Export" or "Import" tab and select the corresponding file on your computer.

Command line (Premium, VPS, Dedicated)

• Export of base(s) (dump)

• Restoration of base(s)

• 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:

And to directly re-import these compressed dumps:

See the disk space used

1. Access to the management interface of your database.
2. You will see the disk space quota used and the maximum value allocated for each database.

Please note: the database quota displayed on your customer area is not calculated in real time => the update of this value is done every day at midnight.

That is, if you have cleaned your base and the size remains unchanged, please wait until after midnight of the same day.

Accessing phpMyAdmin

1. Access to the management interface of your database.
2. Click on the icon ACCESS.

3. You will then be redirected to the phpMyAdmin space. Enter your database password. If you forgot it, you can change it by following this procedure.

List backups

1. Access to the management interface of your database.
2. Click on the button ACTIONS then on List of backups.

3. You will see the list of your backups as well as the size of each one and its creation date.
   The option Download the backup is available for all shared offers, while the restoration is only available for shared packages with the MySQL Private option (SQLGOLD).

Download a backup

1. Access the list of backups of your database.
2. Click on the link Download of the backup of your choice.

Restore a backup

Access the list of backups of your database.

If you do not have the menu RestoreThis means that your offer does not include this option.
In this case you can follow our documentation to import your database into PhpMyAdmin.

If you have the menu RestoreClick on the backup of your choice.

How backups work

You will find on this link the principle of operation of a backup of the MySQL database linked to your subscription.

List users

1. Access to the management interface of your database.
2. Click on the button ACTIONS then List of users of this database.

3. The list of users belonging to this database will be displayed.

   You can via this space :
   Add a user to your database
   Change the rights assigned to the user of your database
   Change the password of your database user
   Remove the user from your database

Change the rights

1. Access the list of users of your database
2. Click on the icon CHANGE RIGHTS of the user in question.

3. Change the privileges as you see fit. Rely on the help of your database manager or webmaster to avoid making mistakes.

Delete user

1. Access the list of users of your database.
2. Click on the icon DELETE of the user in question.

Copy my MySQL database

1. Access to the management interface of your database.
2. Click on the button ACTIONS then Copy your database.

3. Select the server to which you want to copy the database and click on the button SEND.

Change password

1. Access to the management interface of your database.
2. Click on the button ACTIONS then on Change the password.

3. Enter the new password twice and click on VALIDATE.

Edit comment

1. Access to the management interface of your database.
2. Click on the button ACTIONS then on Edit comment.

3. Put a short, brief, and explanatory text, then validate.

Change the quota

1. Access to the management interface of your database.
2. Click on the button ACTIONS then Change Quota.

3. Put the new value in MB and validate.

Add panel user account

1. Access to the management interface of your database.
2. Click on the button ACTIONS then Change Quota.

3. Put the name of the user, the associated password, and fill in the rights you want to give to this user.

Change password

1. Access to the management interface of your database.
2. Go to the section YOUR MySQLGOLD USERS.

3. In the line of the user in question, click on the button ACTIONS then Change password. You can use this section to Change rights of the user, Edit the variable max_user_connectionsor Delete user of your database.

4. If the link Change password does not appear is that it is not possible to delete the user because it is the default user of the database. You must therefore delete the base to be able to delete it. The interface gives you the possibility to Edit the variable max_user_connections only.

Delete my MySQL database

1. Access to the management interface of your database.
2. Click on the button ACTIONS then on Delete the base.

3. Confirm the deletion if you are sure you no longer need the database in question.

4. Your database will be deleted shortly.