1. Home
  2. Web Hosting
  3. Mutu
  4. Manage my MySQL databases

Manage my MySQL databases

IMPORTANT

This guide is dedicated only to our subscribers who have subscribed to the new shared hosting offers [START BOOST MAX PERFORMANCE]. marketed as of March 18, 2019.

Create a MySQL database

Check out this help link to learn how to create a MySQL database.

Usage policy and advice

IT IS NOT POSSIBLE TO CUSTOMIZE THE NAME OF YOUR DATABASE EXCEPT FOR SHARED OFFERS WITH THE DEDICATED SQL OPTION

IT IS NOT POSSIBLE TO CHANGE THE NAME OF A DATABASE EITHER SAME FOR SHARED OFFERS WITH THE DEDICATED SQL OPTION

IT IS NOT POSSIBLE TO CUSTOMIZE OR CHANGE THE DEFAULT USER NAME OF YOUR DATABASE

 

Limit of simultaneous connections to a database
MUTU START 5 simultaneous connections
MUTU BOOST 10 simultaneous connections
MUTU MAX 20 simultaneous connections
PERFORMANCE  You can set the limit of your choice, although it is recommended not to exceed 100 simultaneous connections because you are limited by the resources of this offer

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.

 MySQL databases - 2

 

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.
    mysqlgold databases

    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

This option is reserved for shared hosting with the MySQL Private option (SQLGOLD).

  1. Access to the management interface of your database.
  2. Click on the icon IMPORT A DATABASEEES.
     MySQL databases - 3
  3. You have two choices for importing a database.
    database - MySQL
  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.

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

     MySQL databases - 5
  6. Click on VALIDATE for the import to take place.
     MySQL databases - confirmation

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.

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 or a third party software such as MySQLFront or MySQL WorkBenchto connect to the server and create or restore the DUMP.

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

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.
    mysqlgold databases

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.
     MySQL databases - 6
  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.
    phpnet

List backups

  1. Access to the management interface of your database.
  2. Click on the button ACTIONS then on List of backups.
    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).

    list of database backups

Download a backup

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

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.

This option is reserved for shared hosting with the MySQL Private option (SQLGOLD).

list of database backups - 3

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

This option is reserved for shared hosting with the MySQL Private option (SQLGOLD).

  1. Access to the management interface of your database.
  2. Click on the button ACTIONS then List of users of this database.
     MySQL databases - 7
  3. The list of users belonging to this database will be displayed.
     MySQL databases - 8

    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

This option is reserved for shared hosting with the MySQL Private option (SQLGOLD).

  1. Access the list of users of your database
  2. Click on the icon CHANGE RIGHTS of the user in question.
     MySQL databases - 9
  3. Change the privileges as you see fit. Rely on the help of your database manager or webmaster to avoid making mistakes.
     MySQL databases - 10list of privileges

Delete user

This option is reserved for shared hosting with the MySQL Private option (SQLGOLD).

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

Copy my MySQL database

  1. Access to the management interface of your database.
  2. Click on the button ACTIONS then Copy your database.
      MySQL databases - 11
  3. Select the server to which you want to copy the database and click on the button SEND.
     MySQL databases -12

Change password

If you have installed a CMS (such as WordPress / Drupal / Joomla / prestashop / other) or if your site is running with the connection chain to the base, it is not recommended to change the database password because it will display an error message instead of your home page indicating that access to the database cannot be established.

  1. Access to the management interface of your database.
  2. Click on the button ACTIONS then on Change the password.
    change password
  3. Enter the new password twice and click on VALIDATE.
    change database password

Edit comment

The commentary helps to indicate specific information.

For example: The name of the site that uses this database / if it is a test database / if it is empty / etc.

  1. Access to the management interface of your database.
  2. Click on the button ACTIONS then on Edit comment.
    comment modification
  3. Put a short, brief, and explanatory text, then validate.
    comment modification of the database

Change the quota

This option is reserved for shared hosting with the MySQL Private option (SQLGOLD).

  1. Access to the management interface of your database.
  2. Click on the button ACTIONS then Change Quota.
    Quota change
  3. Put the new value in MB and validate.
    database quota modification

Add panel user account

This option is reserved for shared hosting with the MySQL Private option (SQLGOLD).

  1. Access to the management interface of your database.
  2. Click on the button ACTIONS then Change Quota.
    add user 
  3. Put the name of the user, the associated password, and fill in the rights you want to give to this user.
    user creation

Change password

This option is reserved for shared hosting with the MySQL Private option (SQLGOLD).

  1. Access to the management interface of your database.
  2. Go to the section YOUR MySQLGOLD USERS.
     MySQL
  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.
    MySQL data
  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.
    MySQL user

Delete my MySQL database

If you have installed a CMS (such as WordPress / Drupal / Joomla / prestashop / other) or if your site is running with the connection chain to the base, it is not recommended to delete the database because it will display an error message instead of your home page.

  1. Access to the management interface of your database.
  2. Click on the button ACTIONS then on Delete the base.
    deletion of the base
  3. Confirm the deletion if you are sure you no longer need the database in question.
    MySQL database confirmation
  4. Your database will be deleted shortly.
Updated on 12 April 2021

Was this article helpful?

Related Articles

Leave a Comment