What is the name of my database ?
When you create a database, your username is pre-pended to the database name.
For example, when the database "test" is created on cablan.net (username "Cablan" ), the database is actually called "Cablan_test".
This also goes for database usernames.
How do I create a MySQL database ?Here is a step by step guide on how to create a MySQL database.
 | Step 3 : enter a name for the new database, using the "add db" button : |
| Step 4 : click on the add db button. The database will be created. |
| Step 5 : if you have not created a MySQL user yet, create one, by choosing a username and password : |
| Step 6 : click on the add user button. The user will be created. |
| Step 7 : you now need to associate the user to the database : Select the user and the database from the drop down list.. |
| Step 8 : click on add user to db. |
How do I connect to my database using PHP/Perl ? In the SQL section of CPanel, all your databases are listed, along with sample code to connect to the database with PHP and Perl.
|
|
Click to view in full size
|
2 options are available.
1 - Thru CPanel
2 - Thru PhpMyAdmin
CPanel Backup/Restore guide
Step 1 : Login to
Cpanel.
Step 2 : Click on the backup icon.
Step 3 : Right click on the database you wish to download and select "save as".
Step 4 : Save on your hardisk.
To restore a backup, simply upload the file using.
PhpMyAdmin Restore/Backup
Step 1 : Go to
PhpMyAdmin.
Step 2 : Select your database.
Step 3 : Click on export.
Step 4 : Select the options for the export.
To restore the backup, click on SQL
And select the file to upload
