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

1. Backup the structure and data of a single database

mysqldump -uroot -p123456 test1 > /root/test1.sql

2. Restore the structure and data of a single database

Method 1: Use the mysql command

mysql -uroot -p123456 test1

use test1; #You need to specify the database first, if there is no need to create it first

Database changed

mysql> source /root/test1.sql

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.