SUPPORT - 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 datas. It is frequesntly 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 MySQL databases easily using your Control Panel. Log-in to your Control Panel. Click on MySQL icon or link. Under the Db: field, supply in the name of the database. Click on Add Db Button. 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 Control Panel. Log-in to your Control Panel and click on MySQL Databases Icon or link. Find below teh link that says phpMyAdmin, then click on it. 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 labelled "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