Skip to content

Latest commit

 

History

History
123 lines (79 loc) · 4.45 KB

guide.en-asia.md

File metadata and controls

123 lines (79 loc) · 4.45 KB
title excerpt updated
Getting started with MySQL and MariaDB
Using Your Databases
2023-07-26

Objective

Do you want to use MySQL or MariaDB for your databases?

What is a MySQL database?

MySQL is a relational database management system developed for increased read performance, unlike other systems.

This is an open-source engine, whose parent company is Oracle.

What is a MariaDB database?

MariaDB is a derivative (fork) of MySQL.

This engine is 100% compatible, and is "freer" than its sibling MySQL. All the bugs and roadmaps are freely accessible, unlike the Oracle version.

Find out how to create and manage your MySQL or MariaDB databases

Requirements

Instructions

Logging in to the database

[!primary]

Please note that this service does not give you access to the Host but to the databases hosted on the Host. Generic SQL commands work with no issues, and HeidiSQL or SQuirreL SQL software is fully compatible.

[!primary]

As MariaDB is a fork of MySQL, the different commands are the same for the 2 types of database.

To log in to your database, make sure that you have:

  • The address of your Web Cloud Databases instance
  • The port of your Web Cloud Databases instance
  • The username of your Web Cloud Databases instance
  • The password associated with the user
  • The database name

All this information is available in the OVHcloud Control Panel.

Please also read our guide on getting started with the Web Cloud Databases service.

Connect via the command line

mysql --host=server --user=user --port=port --password=password database_name

Connect from a PHP script

1. <?php
2. $db = new PDO('mysql:host=host;port=port;dbname=dbname', 'username', 'password');
3. ?>

Connect from software (SQuirreL SQL)

  • Launch SQuirreL SQL and click on Aliases{.action}, then on +{.action}.

launch SQuirreL SQL{.thumbnail}

  • Fill in the fields below and then confirm by clicking OK{.action} :
    • Name: Choose a name
    • Driver: Choose PostgreSQL
    • URL: Enter the server address and port in the following form jdbc:postgresql://server:port/database
    • User Name: Enter the username
    • Password: Enter the password

config connection{.thumbnail}

  • Confirm again by clicking the button Connect{.action}.

valid connection{.thumbnail}

You will now be connected to your database:

config connection{.thumbnail}

Connecting via phpMyAdmin

You can use phpMyAdmin to explore the contents of your database. To do this, install phpMyAdmin on your own server or web hosting plan. During this installation, make sure that the information on your Web Cloud Databases server and the database you want are correctly configured so that phpMyAdmin can connect to it.

Export and import a MySQL or MariaDB database

  • Export your database via the command line
mysqldump --host=server --user=user --port=port --password=password database_name > database_name.sql
  • Import your database via the command line
cat database_name.sql | mysql --host=server --user=user --port=port --password=password database_name

[!primary]

In some cases, the RAM available in your Web Cloud Databases instance may not be sufficient to perform the desired export or import. If this is the case, we recommend using the OVHcloud tool in the OVHcloud Control Panel. See the Getting started with Web Cloud Databases service documentation if necessary.

Go further

For specialised services (SEO, development, etc.), contact OVHcloud partners.

If you would like assistance using and configuring your OVHcloud solutions, please refer to our support offers.

Join our community of users.