|
Support
Center
MySQL Related
1. What is MySQL?
2. How can I create
databases?
3. How many databases can I create?
4. How do I manage my database?
5. How do I back-up my database?
6. How do I restore the file into the MySQL database?
What is MySQL?
MySQL is a fast, easy-to-use,
multi-user SQL (Standard Query Language) database server in a standard client/server
environment. SQL is the most commonly used method of defining, manipulating,
and searching data in a database. MySQL handles graphics as well as text
data. It is frequently implemented in UNIX and LINUX platforms and is
available under a GNU Public
License.
Back
To Top
How
can I create databases?
You can create databases easily using your Server Administrator. Log-in to
your Server Administrator. Click
on Databases. Supply in a name of
your database in the New Database
field. Do not use underscores ( _ ) on your database name. Then click on Add
to the right of the field. Supply in a username
on the New User field, then
click on Add button to the
right of the field. Then supply in a password
in the New Password field, then Confirm.
You should now see a list of users
to your database.
Back
To Top
How
many databases can I create?
The number of databases you can create depends on what Hosting Plan you
have. To find out, please see our Hosting
Plan.
Back To Top
How
do I manage my Database?
Every account we have has a phpMyAdmin
pre-installed and can be accessed through the Server Administrator. Log-in to your Server Administrator and click
on Databases. Click on the
database name that you wish to manage, then click on phpMyAdmin button on to the right. You should see a pop-up window
loading your phpMyAdmin.
Back To Top
How
can I back-up my database?
Log-in to your Server Administrator, then click on Databases. Select the database name that you wish to back-up. Click
on phpMyAdmin to the right. On
your phpMyAdmin window, click on the database name on the upper left column.
You should now see the list of tables in your database. Scroll down until
you see a list box tagged "View
dump (schema) of database". Select all tables in the list box that
you wish to back-up. Select the radio button that says "Structure AND Data". Check on the checkbox that says "Save
as file", then hit "GO"
button. You will be prompted to save the file with a .sql extension. Name
your .sql file and save.
Back To Top
How
do I restore the file into the MySQL database?
Follow the steps above until you reach the phpMyAdmin
window. Open the .sql file
that you have saved using either Notepad or WordPad. Select All then Copy
and Paste
it into the box labeled "Run SQL
query/queries on database" in phpMyAdmin. Hit "GO"
button. This should recreate the tables as it was in your Database.
Back
To Top
|
