Manage site databases with phpMyAdmin (Create, import, export ...)

As a webmaster, the most important thing is the data security of the website. In this section, we will talk about how to use the phpMyAdmin management software to manage MySQL database, to achieve basic database management users, database creation, data import and export operations (site backup).

　What is phpMyAdmin?

phpMyAdmin is a database management software developed using PHP language, through the phpMyAdmin can be a graphical interface management database, avoid the command line complex operation. phpMyAdmin is typically run on a PHP-based Web site (such as WordPress) and is often used to manage MySQL databases. It can create new users, databases, update data, delete data, insert data, insert tables, import/export data, and more.

Here's how to create a user, create a database, data export, data import operations:

Create new users and databases

　1. Log in phpMyAdmin using the Administrator account and click on "users" → "Add Users":

　　

You can create a database user and a database with the same name as the administrative user by entering the appropriate parameters in the new window that pops up:

　　

At this point, the database user and database are created. You can view the information on the left side of phpMyAdmin or in the "user" or "Database" fields.

Data Recovery (Import)

An empty database has been created before, and you can then import the existing data into it:

First, click on the database you want to import the data to, click "Taitai" here:

　　

Next click "Import" → "Browse Files" → "execute" to complete the import of data.

　　

The display is successful and the corresponding data table is displayed on the left:

　　

This completes the Database data import (Restore).

Data Backup (Export)

When you need to back up the data for the database, simply export the current data and download it to save locally.

Again, go to the database you want to manipulate, and click on the "Taitai" Database here:

　　

After selecting the above options, the other options remain the default values, and finally click on the "Execute" button, in the pop-up Download message box, download its exported database file to the computer locally!

Summary of this article

To create a new user and database in PhpMyAdmin, your account must have a corresponding operation permission, otherwise it cannot be executed.

Typically, we use the import and export features of phpMyAdmin when we do a site backup, a site move (that is, a change of host space).

If it is a website backup or website move, in addition to the database data backup, but also need to back up the site source programs (such as: theme, plug-ins, etc.), this is the full site backup.

Manage site databases with phpMyAdmin (Create, import, export ...)