MySQL

How do I import a .sql file via phpMyAdmin?

You can use phpMyAdmin to import an .SQL file with your database information. To do this:

  • Log in to your database via phpMyAdmin (GigoCP > Manage Hosting > [select package] > phpMyAdmin)

  • Choose the database you want to import your .SQL file to from the left hand side.

  • Click the Import tab at the top of the page.

  • Select Choose File and locate the .SQL file on your device or computer.

  • Click Go

The .SQL file will be uploaded and imported to the database you've selected.

How do I check MySQL Database sizes across packages in GigoWeb?

GigoWeb provides an easy way to monitor and view all MySQL database sizes across all packages in your GigoCP account.

To access the MySQL Database Size Reports:

  1. Login to GigoCP

  2. Head to the Reporting section on the home page and select MySQL Database Sizes.

MySQL Database Usage Report

You’ll see a full list of all the databases under your GigoWeb account and their sizes. You’re also shown which domain they are associated-with so that you can manage the MySQL database, should you need-to.

How do I import a .sql file via the command-line?

If you've set up SSH access for a package then you can run the following command-line instructions to import a MySQL database:

mysql -h hostname -u username -p username < databasefile.sql

The above command connects to your database with the -h (hostname) -u (username) -p (database name in this case) then the unzipped file < databasefile.sql

You will then be prompted to enter a password for the database. Input the password and press enter.

Compressed files

If the database file is zipped then you will need to unzip it first, then you can use one of the following commands:

For a .zip file you can use the unzip command:

  • unzip databasefile.sql.zip

  • mysql -h hostname -u username -p username < databasefile.sql

For a .gz file you can use the gunzip command:

  • gunzip databasefile.sql.gz

  • mysql -h hostname -u username -p username < databasefile.sql

Can I set my database hostname as ‘localhost’?

No, you would need to set the database hostname as the server that it's on at GigoWeb.

You can find this by going to the MySQL Databases icon within a package. The hostname you’ll need to use will be something similiar to ‘shareddb1b.hosting.stackcp.net’ although it's likely the database name on your package will be different.

'localhost' generally means the MySQL databases are hosted on the same server as the websites, which is quite common in the web hosting industry with hosts that have a 'single-server' approach where all services run from the same machine.

It's different at GigoWeb as we split all services and have a strict 'one server, one rule' policy.

At the GigoWeb data centres, web traffic, MySQL traffic and storage are all physically different machines, so 'localhost' doesn't work.

How do I download or back up my MySQL Database?

There are various ways to export your MySQL databases for safe keeping or transfer. The first method allows you to back up multiple databases via your GigoWeb control panel and the second on a 'per database' basis via phpMyAdmin.

Backup/Restore

The control panel provides an easy way to download all databases associated with your hosting package. To access this page:

  • Access the Backup/Restore page: GigoCP > Manage Hosting > [select package] > Backup/Restore

  • Ensure Databases is checked under Backup Type

  • Click Create Backup

A backup task will then be queued by our system. Once finished, a download link will be provided; this usually takes 1-2 minutes, dependent on the size of the database. You can then download a zip file containing all your MySQL databases.

The phpMyAdmin management software lets you import and export your databases.

  • Login to your database via phpMyAdmin (GigoCP > Manage Hosting > [select package] > phpMyAdmin)

  • Choose the database you want to back up down the left hand side

  • Click the Export tab at the top of your page

  • Leave Quick selected under Export Method

  • Select your desired format - we recommend “SQL” for most cases

  • Click Go

Within a few seconds a download should begin in your browser.

How do I create a MySQL database in GigoCP?

You can create MySQL databases in seconds directly from your GigoWeb control panel.

This option is unavailable for packages hosted on our WordPress platform due to its WP-optimised nature. If you need to create a MySQL database, you'll need to carry out a Platform Transfer to move the website to our Linux web hosting platform.

Starter Hosting packages are limited to one MySQL database. For more databases, you can upgrade your hosting package through GigoWeb, or purchase an additional hosting plan. To create new MySQL databases:

1. Log in to GigoCP and select Manage Hosting. 2. Choose Manage next to the hosting package you wish to create a MySQL database for. 3. Under Web Tools, select MySQL Databases. Here you can complete the following actions:

  • Create new MySQL databases. Each MySQL database has a maximum size of 1024MB (1GB).

  • Manage existing databases.

  • Add additional MySQL users to databases.

  • Manage your additional MySQL users.

4. Under Add a new MySQL Database, choose a name for your database. Database names must be between 6 and 20 characters long, and we automatically add a suffix to avoid name collisions with other users.

5. Once you have chosen a name, click Create Database. Your new MySQL database will automatically appear in the Manage MySQL Databases section underneath.

From here you can change the automatically generated password, monitor usage, remove your MySQL database, or log in to your database.

What’s the maximum MySQL database size allowed?

At GigoWeb, each MySQL database you create can store up to 1024 MB (1 GB) of data. As databases comprise of only text, this is a lot of space in real terms; to put it into perspective, a GigoWeb customer’s average database size is just 10 MB.

In the rare event that you need more than 1024 MB, you'll need to add an additional database. You aren't able to add more MySQL databases to websites hosted on our WordPress hosting platform; you will need to complete a Platform Transfer first.

If you have a Home, Business, or Reseller Hosting package with us, there’s no limit to the number of additional databases you can add. If you have a Starter Hosting package, you are limited to one MySQL database but you can upgrade your hosting package through GigoCP, or purchase an additional hosting plan.