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.

Related posts

HOW TO INSTALL WORDPRESS MANUALLY

HOW TO INSTALL WORDPRESS MANUALLY -. It is different with HOW TO INSTALL WORDPRESS WITHIN ONE MINUTE USING SOFTACULOUS, the users must download wordpress then upload the file into hosting. There is only one difference between two methods to install wordpress, you can use unique codes that is different...

Read More

HOW TO CREATE EMAIL ACCOUNTS AND USE THE WEBMAIL

Dear customers. Please follow this instruction below to create email accounts;. Login cPanel web hosting. Select email accounts. Enter the username and password of email address. Select the create button. The history has recorded if email is already used on 1960 before the internet created and begin to be used...

Read More

HOW TO USE FILE MANAGER FTP CLIENT AND CREATE FTP ACCOUNTS

HOW TO USE FILE MANAGER FTP CLIENT AND CREATE FTP ACCOUNTS blog. File Transfer Protocol or called as FTP is a standard communications protocol used for transfer the file between server and local computer that called as client. The FTP can also be used for transfer the file from a server to...

Read More