Frequently Asked Questions - Pebblehaven Company

MySQL DATABASES

How do I set up a MySQL database from Pebblehaven?
What information do I need to connect to a MySQL database?
Do I need to know the SQL programming language to work with MySQL?
Where can I find software to administer MySQL?
Pebblehaven runs my web application on MySQL. Do I need to work directly with the database in order to administer the site?
Where can I find more information on MySQL technology?
How do I login to phpMyAdmin?
How can I browse data found in a MySQL database, using phpMyAdmin?
How can I export data found in a MySQL database, using phpMyAdmin?

How do I set up a MySQL database from Pebblehaven?

You can request that a MySQL database be created for your account by contacting our technical support team, or by adding one in your control panel (if applicable).

What information do I need to connect to a MySQL database?

You will need to know the name of the server that MySQL resides on, as well as your MySQL username and password. Contact Pebblehaven to obtain that information.

Please note that the server address, username and password that you use to access MySQL are not necessarily the same as the address, username and password of your FTP account.

Do I need to know the SQL programming language to work with MySQL?

While knowing SQL is a distinct advantage when doing heavy-duty database programming, it is not necessary for most users to learn the language, as most functions can be handled through a graphical frontend.

Where can I find software to administer MySQL?

There are a number of third-party graphical utilities available to administer a MySQL database. While many of these utilities are commercial products, the most stable and easy-to-use of the group is Ansgar Becker's MySQL-Front, which is available for download free of charge. Web-based interfaces are also available.

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.

How do I login to phpMyAdmin?

Depending upon what type of server you are on, simply visit http://www.yourdomain.com:88/phpMyAdmin/ or https://www.yourdomain.com:8443/. Once at a login screen simply enter your account username and your password.

How can I export data found in a MySQL database, using phpMyAdmin?

Login to phpMyAdmin. Then, select the "Export" tab at the top of the page. Next, on the left, under 'Export', you will 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 to the left of the type of file that you would like the database downloaded in (The format to export data when you wish to use within Microsoft Excel is CSV). Under 'SQL options', check off ALL of the options that are listed. 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.

If you would like our team to handle this for you, simply submit your need as an update request.

How can I browse data found in a MySQL database, using phpMyAdmin?

Login to phpMyAdmin. Then, on the left hand side of the page, click on the name of the table whose data you wish to browse. Next, click on the word "Browse" at the top of the page, in the main window.