导出数据库
$mysqldump dbName > dbName.sql -u user -p
- v5.6/5.7
$mysqldump --no-defaults dbName > dbName.sql -u user -p
导入数据库
mysql>CREATE DATABASE `dbName` CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql>USE dbName;
- win
mysql>SOURCE C:/Users/xiaobin/dbName.sql;
- Linux
mysql>SOURCE /home/xiaobin/dbName.sql;
upload
win10
scp D:\progFiles\carnumber.sql tdtc@192.168.0.151:/home/tdtc/
create user
mysql> CREATE USER 'DBAdmin'@'localhost' IDENTIFIED BY 'xbfirst';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'DBAdmin'@'localhost' WITH GRANT OPTION;
mysql> flush privileges;