Shulou(Shulou.com)06/01 Report--

In this issue, the editor will bring you about the Mysql installation process in the Linux system. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

Mysql is a product of Oracle, which belongs to relational database. In terms of WEB applications, MySQL is one of the best RDBMS (relational database management system) applications.

First, export the database with the mysqldump command (pay attention to the installation path of mysql, that is, the path of this command)

1. Export data and table structure:

Syntax: mysqldump-u user name-p password database name > database name. Sql

# / usr/local/mysql/bin/ mysqldump-uroot-p abc > abc.sql

When you hit enter, you will be prompted to enter the password.

2. Export only the table structure

Syntax: mysqldump-u user name-p password-d database name > database name. Sql

# / usr/local/mysql/bin/ mysqldump-uroot-p-d abc > abc.sql

Note: / usr/local/mysql/bin/-> data directory of mysql

Second, import the database

1. First build an empty database

Mysql > create database abc

2. Import the database

Method 1:

(1) Select a database

Mysql > use abc

(2) set database coding

Mysql > set names utf8

(3) Import data (note the path of the sql file)

Mysql > source / home/abc/abc.sql

Method 2:

Syntax: mysql-u username-p password database name # mysql-uabc_f-p abc

What is Linux system Linux is a free-to-use and free-spread UNIX-like operating system, is a POSIX-based multi-user, multi-task, multi-threaded and multi-CPU operating system, using Linux can run major Unix tools, applications and network protocols.

This is how the Mysql installation process in the Linux system shared by the editor is like. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.