Live Chat Software by Champion Consulting
Knowledgebase : MySQL
Yes, it is possible! For this, you have to allow remote access from your control panel by adding your IP to the access hosts in the mysql screen there. If you do not have a fixed IP at your end, you can use % as a wild card and allow remote access from anywhere.

Then, for remote connections you have to use the server IP or your domain IP or domain name instead of localhost in your script/program.

For example, to connect remotely via the mysql command line utility:

mysql -h x.x.x.x -u USERNAME -p DATABASE

(where x.x.x.x is your server ip, USERNAME is the db user, and DATABASE is the database name)

NOTE: Whenever an IP/Host is added or removed from the Access Host field, the privileges need to be reassigned to the database user on that database otherwise it will produce an Access Denied error.
There are two main ways to back up or restore a MySQL database on our servers: via SSH or the phpMyAdmin interface.

If you need SSH Telnet access, just send us a ticket with your request to be enabled for it. To access the phpMyAdmin interface, click on the "phpMyAdmin" icon in your control panel.


How to backup a MySQL database using SSH:

Log into your account on our server and issue the following command:

/usr/bin/mysqldump DATABASENAME -u USER -p PASSWORD > /home/user/file.sql

Enter your actual username and password where we have indicated user and password. This will create a file called "file.sql" that contains your entire database. (You can name it whatever you want as long as it ends as ".sql".)


How to restore a database using SSH :

Log into your account on our server and issue the following command:

mysql DATABASENAME -u USER -p PASSWORD < /home/user/file.sql (change file.sql to your filename)


How to backup a MySQL database using phpMyAdmin:

Click on your database name shown on the upper left.

Go to the section called "View dump (schema) of database" and choose options for backing up structure only, structure and data, or adding drop tables. To view what your backup file will look like, click on the "Go" button. When you're ready to send your back up to a file, check the send box and click "Go", then follow the prompts for how to name the file and where to send it.

How do I create/delete/edit my databases and users?

All administration of your MySQL databases and users can be done through our convenient web based control panel interface. This program is provided to all of our hosting customers.



All administration of your MySQL databases and users can be done through our convenient web based control panel interface. This program is provided to all of our hosting customers
What is MySQL?

MySQL is a very robust database server. It is often used to deliver dynamic content to sites such as forums. The languages most often used to interface with the database server are Perl and PHP, however, C, C++, and Python among others may also be used. The official MySQL Web site may be found at: http://www.mysql.com


If you need to use a newer version, you can ask Support to move your account to another server with that version or greater but make sure the queries in all your scripts/applications are compatible with the newer version.
Help Desk Software by Champion Consulting