头歌数据库备份与恢复

第1关：数据库的备份和恢复

    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  
 

第2关：数据库表的导出

    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";　
 

第3关：二进制日志

    vim /etc/mysql/my.cnf -->
        [mysqld]
        log-bin=/binlog.log
    service mysql restart
    mys