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

Source: Internet
Author: User
Tags php language phpmyadmin what is phpmyadmin

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 ...)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.