From Support Center

Return to Support FAQ Categories

---

Table of contents

1 Databases 1.1 What kind of database do you offer? 1.2 How do I create my first MySQL database? 1.3 Do you have a separate server for databases? 1.4 How do I use the database import tool? 1.5 How do I use the database export tool? 1.6 Why has Globat.com introduced its own tool when PHPMYAdmin exports and imports MySQL databases? 1.7 What database types are supported? 1.8 Which versions of MySQL does Globat.com support? 1.9 Where can I find the database import/export tool? 1.10 My backup file is located on remote server; can I import it from there? 1.11 I cannot create a database to import that backup into! 1.12 What are the limits with regards to backup sizes? 1.13 I have received an error when importing or exporting a database! 1.14 What is PHP? 1.15 How can I learn more about phpMyAdmin? 1.16 How do I install forum software like PHP Nuke? 1.17 What is MySQL? 1.18 How often do you backup your servers? 1.19 Can I access my MySQL database from command line? 1.20 Can I access my MySQL database from an outside connection? 1.21 How can I kill hung MySQL processes? 1.22 How can I upload my Excel file into a database? 1.23 Is there a size limit (MB or GB) for my databases?

Databases

What kind of database do you offer?

Globat offers mySQL 4.x databases and allows you to run Unix based berkley databases and flat file databases.

How do I create my first MySQL database?

Creating MySQL databases with Globat is done through the GCC. You can read about it in the Databases tutorial.

Do you have a separate server for databases?

Yes, Globat runs separate, optimized database servers which have more memory and faster disks than web servers.

How do I use the database import tool?

Globat.com Large Database Import/Export Tool (April 2006)

At Globat.com, we recognize the changes on the Internet. Over the past year, the use of databases to run interactive sites has increased. Free downloadable Web site systems or applications are now used by most people.

On seeing this change, Globat.com decided to take action and assist you with making backups and imports of your database driven Web applications.

The tool is as easy as a few clicks.

The tool can be accessed at:

https://login.globat.com/cp2/db_import_export.php

You may have to enter your GCC Control Panel Login Details.

Import Guide

The import tool allows you to restore a current database with a few clicks.

Preparation

• Before carrying out the database import, make sure you have created a database to import into, along with a user for that database. If not, information on how to do this can be found at: http://support.globat.com/sc/Databases

• The SQL database backup file must be located on your Web space.

The Steps

1. Click the “Database Import” Link

2. At the next screen, you should be presented with the following options:

• Location: Using the provided tree, guide yourself to your SQL database backup file. An example can be seen below where the file desired to import is ‘stream.sql’.

On clicking the database backup file, you will see in the field below the path and filename is visible. Check this is correct before continuing.

• Database: Click the arrow to list all the databases under your account. Just click to confirm the database you want.

• Database User: On clicking the arrow, the menu should list all users associated with that database. Choose the user that has the privileges to add items to the database.

• Ignore All Errors: This option is of a personal preference. If you wish to ignore any errors there might be whilst importing the database, check the box. Otherwise, if you need to know that the database has not been created to 100% accuracy of the backup, leave the box unchecked.

• Drop All Tables in the Database: This option only needs to be checked when the database has data currently stored within it. The example of this is if you are importing a backup after the current database has become corrupt. In all other instances, this box does not need to be checked. 3. Once all the options have been completely filled out, click the “Start Importing” button.

4. You may now be asked for confirmation for the actions to be carried out. Please check these carefully, as any changes made cannot be reversed.

5. The Import will now take place. You will see a confirmation message when the import is completed.

How do I use the database export tool?

Export Guide

1. Click the “Database Export” link.

2.

• Location: Use the tree to navigate to a suitable place to export your database to. The final location will be confirmed in the field below.

• Filename: Choose a filename you want to call you backup file. Make sure you do not specify any extensions on this filename. For example, backup.sql, backup.sql.gz etc…

• Database: Click the arrow to bring up the list of databases under your account. To choose a database just click it.

• Database User: Click the arrow and choose the relevant user to export the database under.

• Format: It is recommended that you choose 4.1 for your backups. This option should only be changed if you are confident with MySQL and you know it is required.

• Compression: Unless you are sure that you need zip or gzip compression it is recommend you choose no compression.

• Insert Type: It is recommended you choose Complete Insert unless you are confident with MySQL and you know Extended is needed.

• Add Drop Tables: If this backup is being made to replace existing data then you should check this box. If the backup will only be filling an empty database then it is not required to be checked.

• Ignore all Errors: This option is of a personal preference, if you wish to ignore any errors there might be whilst exporting the database check the box. Otherwise if you need to know that the backup has not been created at 100% accuracy leave the box unchecked.

• Now Check Over Your Decisions and Then if Happy Click the “Start Exporting” Button

3. You will now be asked to confirm your actions. Please take time checking this, because any changes caused by the actions of this script are not reversible.

4. Your database should now export, and tell you when it has completed.

Why has Globat.com introduced its own tool when PHPMYAdmin exports and imports MySQL databases?

PHPMyAdmin is a brilliant MySQL management tool, but it does have drawbacks with regards to importing and exporting databases. The software has a limit of 8 megabytes, which for most users is insufficient. Therefore, for users who need to backup or import large databases, this tool caters for them.

What database types are supported?

Currently, we only support MYSQL Databases.

Which versions of MySQL does Globat.com support?

Currently, we provide MySQL Import/Export support for Versions 4 and 4.1.

Where can I find the database import/export tool?

It can be found at https://login.globat.com/cp2/db_import_export.php.

You may need to login using your GCC Control Panel login details.

My backup file is located on remote server; can I import it from there?

Unfortunately, we currently only allow imports from your own personal Globat.com Web space.

I cannot create a database to import that backup into!

Before using this tool, you must have prepared and setup a database for the data to go into. More information about database management can be found at http://support.globat.com/sc/Databases.

What are the limits with regards to backup sizes?

During testing, the Globat.com Development Team achieved a 1.5 gigabyte MySQL database to be exported and imported. Therefore, we can safely say a rather large database can be exported and imported using this tool.

I have received an error when importing or exporting a database!

In this situation, if you cannot see what the problem is, you should create a support ticket explaining your problem and specifying all error messages and settings you used to try and import or export your database.

What is PHP?

PHP is a server-side, cross-platform, HTML embedded scripting language that lets you create dynamic web pages. PHP-enabled web pages are treated just like regular HTML pages and you can create and edit them the same way you normally create regular HTML pages.

How can I learn more about phpMyAdmin?

phpMyAdmin is a tool for managing databases. Globat installs this tool by default. You can read more about PhpMyAdmin in our GCC tutorials. For even more information, you can refer to the phpMyAdmin website at http://www.phpmyadmin.net.

How do I install forum software like PHP Nuke?

Globat does not provide support for PHP Nuke software as it affects the performance of our servers. Any customer who wishes to install such software can do so on their own. We do not provide any support for PHP Nuke installs although there are many installation help online.

We do, however, offer a step-by-step tutorial on installing the popular phpBB forum package.

What is MySQL?

MySQL is an open source relational database management system (RDBMS) that uses Structured Query Language (SQL), the most popular language for adding, accessing, and processing data in a database. It is downloadable from mySQL website (http://www.mysql.com) and tailor it to their needs in accordance with the general public license. MySQL is noted mainly for its speed, reliability, and flexibility.

How often do you backup your servers?

MySQL servers are backed up nightly. These backups are available to our staff in the event of a failure. We generally do not provide direct access to these backups to customers directly. To generate backups, you can do a dump from PhpMyAdmin.

Can I access my MySQL database from command line?

No, you can not. You can, however, use PhpMyAdmin to manage your tables and run queries of your choice.

Can I access my MySQL database from an outside connection?

No, Globat does not allow this. We do allow accessing your database from your hosting account only. This is done to maintain the performance, stability and integrity of all databases Globat hosts.

How can I kill hung MySQL processes?

To kill hung MySQL processes, login into the control panel and select phpMyAdmin to edit your database. Select Show processes when phpMyAdmin loads up. On the left side there should be a kill link to kill each MySQL process.

How can I upload my Excel file into a database?

Before you can upload an Excel file into a MySQL database, you need to save the excel file as a .csv (comma separated value) file. After the file has been uploaded, you can use phpMyAdmin MySQL query window to run a command such as

   MySQL> load data infile '/usr/local/psa/home/vhosts/yourdomain.com/file.csv'
       -> into table tablename
       -> fields terminated by ','
       -> optionally enclosed by '"'
       -> lines terminated by '\n';

The command will not necessarily be the same, but should be similar to the one listed above.

Is there a size limit (MB or GB) for my databases?

No, there is not. Your overall package quota, however, applies to databases.