HOW TO CREATE MYSQL DATABASE AND IMPOR THE DATABASE

HOW TO CREATE MYSQL DATABASE AND IMPOR THE DATABASE

MYSQL is an open source Relational Database Management System (RDBMS) by Michael Widenius (Monty). The name given in conjuction with Monthy daughter (My) and SQL, the abbreviation for Structured Query Language. MYSQL is the main component of the LAMP (Linux, Apache, MYSQL and Perl/PHP/Python). Some aplications list that use MYSQL database include:.

  1. Drupal.
  2. Joomla.
  3. MODx.
  4. MyBB and phpBB forum software.
  5. TYPO3.
  6. WordPress.
  7. Etc.

Google, Facebook, Twitter, Flickr and Youtube also use  MYSQL to operate the website.

mysql database wikipedia

MYSQL logo

CREATE MYSQL DATABASE IN CPANEL

  1. Login cPanel, you may visit web hosting guide to find the hosting password.
  2. Select the MYSQL Databases on control panel dashboard.
  3. Enter the unique code (ex:s3CuR3).
  4. Click on create database button.
  5. Go back to create new database user.
  6. Enter the unique code and secure password.
  7. Click on create user button.
  8. Go back to add user into database.
  9. Select the database name and user.
  10. Select ALL PRIVILEGES.
  11. Click on make changes button.

Now the database can be used in the file configuration.

HOW TO IMPORT THE DATABASE

The are two options to upload the database, the first is use restore wizard. This option will force to use the name of the old database, example olduser_newuser_dbname. The second option is to use phpMyAdmin. Below is how to do;.

  1. Create database and user.
  2. Select phpMyAdmin on the cPanel dashboard.
  3. Select the database name in the main sidebar.
  4. Click the import on the table.
  5. Select the database file then upload.

Make sure the database size that has been imported is right or almost the same with old database size.

Don't miss the next knowledge base by subscribing our blog.

WEB HOSTING REVIEWS

They didn’t asked for my testimonial, but i giving one of my free will. I have been impressed with their level of service from day 1. They have been very helpful, very-very helpful indeed. I have other domain hosted somewhere but here is the best service provider for web and domain hosting based on their level of support. Keep up the great work.

~ Suzearitz Suhimi