MySQL
Do you support MySQL?
How many MySQL databases can I have?
Where is the MySQL Manual located?
How do I import my database on your server?
How to create a MySQL database?
Do you have PHPMyAdmin?
No privileges to create database? Why?
Is there a way to access my mysql database remotely? That is, using a client software (e.g., Access) on my home PC?
How do I move my database from my old hosting provider to you?
How can I download a copy of my database?
How do I access my MySQL 5 database from my PHP scripts?
How do I access my MySQL 5 database from my Perl scripts
Do you support MySQL?
Yes, we offer MySQL as a standard feature on our servers.
[MySQL Topics] - [Back to FAQ Topics Index]
How many MySQL databases can I have?
The number of databases you can have depends on the hosting plan that you are using. In a case you need more databases, you can purchase additional database slots.
You can create many tables within one MySQL database. That is, you can have several applications sharing one and the same database as long as there is no conflict in the table names.
[MySQL Topics] - [Back to FAQ Topics Index]
Where is the MySQL Manual located?
http://dev.mysql.com/doc/refman/5.0/en/index.html
[MySQL Topics] - [Back to FAQ Topics Index]
How do I import my database on your server?
We assume you already have a SQL dump/schema file with your database already on your computer or you have it uploaded on your hosting account with us.
To import the SQL dump/schema file you have two options:
- 1. Use the PhpMyAdmin program
To use the PhpMyAdmin program, please enter your Control panel -> MySQL section and click on the login link. Once logged into the PhpMyAdmin click on Databases, then click on SQL tab at top of the left pane.
On the SQL screen you have an option to upload and run commands from a SQL file. With this option the SQL file should be located on your local computer. In case the SQL file is too big (more then 2-3MB), then you should use the database Import Wizard described in the second option. - Use the Import Wizard in your Control Panel -> MYSQL section.
Click on the Import button next to the database name you wish to import that into and then either choose a file from your local computer for upload or click on the or select an uploaded file link to import a file already uploaded on your account with FTP for example.
NOTE: In case your database is very big, then you need to upload the SQL Dump file on your account at the server (using FTP) and then use the Import Wizard to import it. If you encounter any troubles, please contact our support staff, they will be glad to assist you.
[MySQL Topics] - [Back to FAQ Topics Index]
How to create a MySQL database?
You can create databases on your site at your hosting account Control Panel -> MySQL section.
To create a database you need to:
- Log into your hosting account Control Panel
- Enter the MySQL section
- Specify a name for your database
(if the database name you choose is already taken, please choose another one) - Click on the Create button
- Add MySQL user(s) to your new database.
[MySQL Topics] - [Back to FAQ Topics Index]
Do you have PHPMyAdmin?
Yes, the PHPMyAdmin program is available on the server for you to manage your database.
To log into the PHPMyAdmin program, please enter your hosting account Control Panel -> MySQL Section. There is a link for the PHPMyAdmin program available there.
[MySQL Topics] - [Back to FAQ Topics Index]
No privileges to create database? Why?
Most, probably you were trying to create a database using the PHPMyAdmin program.
You can create databases and assign MYSQL users to them ONLY at your hosting account Control Panel -> MySQL section.
GRANT and CREATE DATABASE commands are not available in the PHPMyAdmin program due to security reasons, hence the "No Privileges" message.
[MySQL Topics] - [Back to FAQ Topics Index]
Is there a way to access my mysql database remotely? That is, using a client software (e.g., Access) on my home PC?
Yes, you can enable remote access to your MySQL database from your Control -> MySQL section.
Once you have remote access enabled you may connect to your database remotely using for example MySQL Control Center or MySQL-Front applications.
[MySQL Topics] - [Back to FAQ Topics Index]
How do I move my database from my old hosting provider to you?
First you need to create a SQL dump file from your old hosting provider server. Once you have the database SQL dump file, you need to create a database on our server and import the file. (see Creating Database and Importing Database articles)
[MySQL Topics] - [Back to FAQ Topics Index]
How can I download a copy of my database?
Go to your Control Panel - > MySQL Database -> PHPMyAdmin
Once logged into the MySQL management tool, select your database from the dropdown in the left pane.
In the right frame click on the Export tab.
Select the Structure and data radio button and the Save as file checkbox. You may check the zipped or gzipped checkboxes if you wish to compress the file that will be sent to you.Click on the Go button. You will be prompted to save the backup file to your local computer.
[MySQL Topics] - [Back to FAQ Topics Index]
How do I access my MySQL 5 database from my PHP scripts?
To access your MySQL database from your PHP scripts, you need to provide the following database server name in your connection string:
localhost:/tmp/mysql5.sock
Here is a sample connection string to use with MySQL 5:
$link = mysql_connect('localhost:/tmp/mysql5.sock', 'mysql_user', 'mysql_password');
If you have troubles accessing your MySQL 5 database, you can always contact us by opening a new ticket. Our team is ready to assist you.
[MySQL Topics] - [Back to FAQ Topics Index]
How do I access my MySQL 5 database from my Perl scripts?
To access your MySQL database from your Perl scripts, you need to provide the following database server name:socket name in your connection string:
localhost:/tmp/mysql5.sock
Here is a sample Perl DBI connection string to use with MySQL 5:
DBI->connect('DBI:mysql:localhost:mysql_socket=/tmp/mysql5.sock:database=user_dbName, 'userID', 'password') or die "Database connection failed";
If you have trouble accessing your MySQL 5 database, you can always contact us by opening a new ticket. Our team is ready to assist you.
[MySQL Topics] - [Back to FAQ Topics Index]