- mysql -uroot -p123123 -h127.0.0.1 < /data/workspace/myshixun/src/data.sql
- mysqldump -u root -p studb student> /student_bk.sql
- mysql -uroot -p123123 -h127.0.0.1 -e "create database studb2;"
- mysql -u root -p123123 studb2 < /student_bk.sql
-
- chmod 777 /
- vim /etc/mysql/my.cnf
- [mysqld]
- secure-file-priv="/"
- service mysql restart
- mysql -u root -p123123 studb2
- SELECT * FROM studb.student INTO OUTFILE "/student_out.txt" LINES TERMINATED BY "\n";
-
- vim /etc/mysql/my.cnf -->
- [mysqld]
- log-bin=/binlog.log
- service mysql restart
- mys