 | Add/Delete Database | |
 | To add a database:
Log into the control center.
Select "Databases" on the top menu.
Enter database name under the "Database Editor" title.
Click "Add database" button. |
|
|
| Backup/Restore MySQL Database | |
| To back up your database or tables, there are two ways to achieve this.
For advanced users - use the mysqldump command line tool.
The syntax to dump an entire database is:
mysqldump -u username -p --databases mydatabase |
|
|
| Adding Tables to a MySQL Database | |
| Log into phpMyAdmin using the login information you used to create the database and click the database name on the left menu.
Type a |
|
|
| PHP/MySQL Tutorial Pt. 1 - Introduction | |
| Definitions and MySQL setup
We provide our clients with access to some of the most powerful technologies in the world, including PHP and MySQL, plus the most popular tool for administering a MySQL database - phpMyAdmin.
This series of tutoria |
|
|
| PHP/MySQL Tutorial Pt. 2 - phpMyAdmin | |
| phpMyAdmin is software used for creating and maintaining MySQL databases.
This tutorial serves to acquaint you with the very basics of phpMyAdmin through a simple exercise.
You can access your MySQL account using phpMyAdmin via the following link, b |
|
|
| PHP/MySQL Tutorial Pt. 3 - Forms and Results Pages | |
| In our previous tutorials, we ran through the steps of creating a MySQL database through your Control Panel and also how to create |
|
|
| PHP/MySQL Tutorial Pt. 4 - Insert Record Form | |
| We're nearly there! Now to create a form where you can input information directly into the database created at the beginning of this exercise - without needing to use phpMyAdmin. If you haven't read the previous tutorials, you may wish to start at the beg |
|
|
| Where Can I Learn How To Use MySQL? | |
| We have an excellent PHP/MySQL tutorial for beginners that includes a sample exercise where you can create your first application
|
|
|
| Why You Use MySQL | |
| More specifically... why do we use MySQL as opposed to other SQL programs (Oracle, Sybase, Informix, Microsoft SQL Server, etc.)? We use MySQL because it's one of the fastest SQL servers on the market. What's more, MySQL is free of charge for those wishin |
|
|
| What is SQL? (definition) | |
| Some basic information on SQL can be found at About.com. Here is an excerpt: "The Structured Query Language (SQL) comprises one of the fundamental building blocks of modern database architecture. SQL defines the methods used to create and manipulate relat |
|
|
| Accessing MySQL From a Local Computer | |
| Unfortunately we do not allow our clients to directly access their MySQL database from their local systems. Our database server is on a private LAN, and only our servers can communicate with the database server. Our reason for doing this is to shelter the |
|
|
| Repair crashed MySQL database table | |
| If you receive an error message that a table in your MySQL database is crashed and needs to be repaired, you can repair it by doing the following:
Log into Database (phpMyAdmin) interface at http://hostingoperations.com with the database user |
|
|
