|
|
|
As standard your account comes with the facility to support one MySQL (http://www.mysql.org) database (this can be upgraded for a fee, should you wish).
4.1 Creating a database
Before you can access your database you must first create one.
To do this log into siteadmin, as described in this tutorial, click the Databases button.
Click the Add New Database button.
Type the name for your database, and click the OK button.
Next you need to add a user for the database. Click the Add New Database User button.
The username and passwords you choose will be used later if you use any scripts to access your database.
On the subsequent screen you will be required to enter a username, and enter and re-enter a password for the user. Do this in the fields provided and select OK.
For further assistance, please refer to this flash based tutorial
For Plesk 7 see -> http://support.34sp.com/control-panel-tutorials/plesk-7/creating-a-database
For Plesk 8 see -> http://support.34sp.com/control-panel-tutorials/plesk-8/creating-a-database
4.2 Accessing your database
Assuming you have created your database accessing it is very simple. Click on the databases section of your siteadmin tool. On the following screen at the bottom you will see the name of your database. Click it, then click the DB WebAdmin button. The database admin tool will open in a new window. For more information on this tool visit http://www.phpwizards.net/.
Please note that phpMyAdmin uses a popup window so if you are using Firefox, Internet Explorer 6 under XP SP2, Internet Explorer 7, or have any form of popup blocker, you will need to allow popups for that site.
For further assistance, please refer to this flash based tutorial
For Plesk 7 see -> http://support.34sp.com/control-panel-tutorials/plesk-7/managing-a-mysql-database-with-phpmyadmin
For Plesk 8 see -> http://support.34sp.com/control-panel-tutorials/plesk-8/managing-a-mysql-database-with-phpmyadmin
Remote Access
If using command line from another remote server that you have mysql running on you can use:
mysql -h MYDOMAIN -u USER -p (where MYDOMAIN is your domain name and USER is your username)
4.3 Backing up your database
Backing up your database is very simple. In phpMyAdmin, click your domain name on the left hand side. Then click Export on the top of the right-hand side.
Then select the tables you wish to backup, and select save as file and click Go
4.4 Restoring your database
Assuming you have created your database restoring it is very simple. In phpMyAdmin, click your domain name on the left hand side. Then click SQL on the top of the right-hand side.
Then click Browse, find your database backup file on your pc, and click Go and that should then load all your tables / data from the sql file into your database.
To restore data into an existing table, using a csv or tsv file, simply login to phpMyAdmin as above, then click the table name in left column and scroll to the very bottom in the main screen and you will see "Insert data from a text file into the table". If you click that link, you can then restore your csv or tsv file
4.5 Troubleshooting
Q: When I try to add a new database I get the error "Database already exists", why is that?
A: On each of our servers every database needs to have a unique name. If this error occurs then you must choose another name for your database.
 |
|
|
|
There are no related articles
|
|
|
