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

. > redirect / data/ database name. Sql-path

Database recovery:

Mysql-uroot-p password + name of the database

/ etc/mysql_all.sql #-A means all

Restore all libraries

Table backup

Mysqldump-uroot-p password + name of the database table name > / data/ database name. Sql-path

Table recovery

Log in to the specified database

Mysql-uroot-p password database name # enter the database of mysql2

View database name

Select database ()

View the tables in the database

Create a new database:

Mysql-uroot-p password-e "create database mysql2" # create a mysql2 database

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.