[Õª³­/¼Ç¼]MySQLµ¼Èë/µ¼³ö.sqlÎļþ

µ¼³ö.sqlÎļþ
 
1.½«Êý¾Ý¿âtransfer_server_dbµ¼³öµ½transfSRV.sqlÎļþÖУº
mysqldump -u root -p transfer_server_db > /home/eric/transfSRV.sql
2.½«Êý¾Ý¿âtransfer_server_dbÖеÄdevice_info_tableµ¼³öµ½table.sqlÎļþÖУº
mysqldump -u root -p transfer_server_db device_info_table > /home/eric/table.sql
3.½«Êý¾Ý¿âmydbµÄ½á¹¹µ¼³öµ½transfSRV.sqlÎļþÖУº
mysqldump -u root -p transfer_server_db --add-drop-table > /home/eric/transfSRV.sql
 
 
µ¼Èë.sqlÎļþ
 
1¡¢µÇ½MySQL
mysql -uroot -p;
 
2¡¢´´½¨Êý¾Ý¿â
create database transfer_server_db;
 
3¡¢µ¼ÈëÊý¾Ý¿â½á¹¹Îļþ
mysql -u root -p transfer_server_db < /home/eric/transfSRV.sql
 
¸ü¸ÄrootÔ¶³ÌȨÏÞ
1¡¢ÔÊÐírootÓû§Ê¹ÓÃÃÜÂëabc´Ó%µØÖ··¢ÆðÔ¶³Ì·ÃÎÊ
 
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'abc' WITH GRANT OPTION;
mysql>FLUSH RIVILEGES