|
MANAGED HOSTING > WEB SITE - MySQL (DATABASES)
How
can I create one?
Via your hosting control
panel. Once logged in, simply click on home in the upper left,
your domain name in question towards the bottom, Databases, and then Add
New Database.
What information
do I need to have my file(s) connect?
You will typically utilize "localhost" for the
name of the server that MySQL
resides on, the database name, as well as your MySQL username and password.
How can I browse data, using phpMyAdmin?
How can I export data, using phpMyAdmin?
Via your hosting control
panel. Once logged in, simply click on home in the upper left,
your domain name in question towards the bottom, Databases, the
name of the database in question, and then DB WebAdmin.
To
browse data, simply click on the icon found to the left of the table in
question.
To
export data, click on Export.
You should then see a list of all the tables in the database. You can either pick and choose which ones you would
like to export, or click on the "Select All" to export all of them. Click the type of file
format that you would
like the database downloaded in (a common format that is friendly to Excel
and for importing elsewhere is CSV). Click on the checkbox next to "save as file'. Click on the "Go" button, and then choose where to save the file.
The downloading of the tables and data in the database will begin. Exporting and providing you a copy of
data is something that can also/instead be accomplished via our backup
disc service or via an update
request.
Pebblehaven
runs my web application on MySQL. Do I need to work directly
with the database in order to administer the site?
Unless you are told otherwise,
no. In fact, you are encouraged to use the application itself
to manage your data wherever possible, instead of accessing
the database directly.
Where can I
find more information on MySQL technology?
The official MySQL website
is located here.
|