{"id":"231","uid":"1","name":"sysfaq","title":"\u7cfb\u7edf\u8fd0\u7ef4","category_id":"275","description":"","root":"0","pid":"0","model_id":"2","type":"2","position":"0","link_id":"0","cover_id":"0","display":"1","deadline":"0","attach":"0","view":"0","comment":"0","extend":"0","level":"0","create_time":"1458911520","update_time":"1459009945","status":"1","parse":"0","content":"

\r\n\t1.\u5982\u4f55\u5907\u4efd\u6570\u636e\u5e93\uff1f<\/span> \r\n<\/p>\r\n

\r\n\t\u7b54\uff1a\u4f9d\u6b21\u6253\u5f00 \u7cfb\u7edf>\u7cfb\u7edf\u53c2\u6570>\u7cfb\u7edf\u5907\u4efd\u3002\u8fdb\u5165\u83dc\u5355\uff0c\u5982\u4e0b\u56fe\r\n<\/p>\r\n

\r\n\t\"\" \r\n<\/p>\r\n

\r\n\t\u53ef\u8bbe\u5b9a\u81ea\u52a8\u5907\u4efd\u65f6\u95f4\uff0c\u70b9\u51fb\u4e0b\u8f7d\u53ef\u5c06\u7cfb\u7edf\u5907\u4efd\u6570\u636e\u4e0b\u8f7d\u5230\u672c\u5730\u5b58\u50a8\u3002\r\n<\/p>\r\n

\r\n\t
\r\n<\/p>\r\n


\r\n

\r\n\t
\r\n<\/p>\r\n

\r\n\t2.\u5982\u4f55\u8fd8\u539f\u6570\u636e\u5e93\uff1f<\/span> \r\n<\/p>\r\n

\r\n\t\u7b54\uff1a\u8fd8\u539f\u6570\u636e\u5e93\u9700\u8981\u4e00\u5b9a\u6280\u672f\u80fd\u529b\uff0c\u5728\u7cfb\u7edf\u5185\u90e8\u6682\u4e0d\u63d0\u4f9b\u6570\u636e\u8fd8\u539f\u529f\u80fd\u3002\u4efb\u4f55\u6570\u636e\u8fd8\u539f\u64cd\u4f5c\u90fd\u662f\u975e\u5e38\u5371\u9669\u7684\uff0c\u8bf7\u63d0\u524d\u505a\u597d\u5907\u4efd\u5de5\u4f5c\u3002\u60a8\u53ef\u4ee5\u5c1d\u8bd5\u4ee5\u4e0b\u65b9\u6cd5\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u8fd8\u539f\u64cd\u4f5c\u3002<\/span> \r\n<\/p>\r\n

\r\n\tA.\u5728Windows\u4e0b\u5c06Mysql\u6570\u636e\u5e93\u5907\u4efd\u62f7\u8d1d\u5230\u78c1\u76d8\u76ee\u5f55\u5982\uff1ac:\\libnet_back.sql(\u82e5\u4e3azip\u538b\u7f29\u6587\u4ef6,\u8bf7\u5148\u89e3\u538b\u7f29)<\/span> \r\n<\/p>\r\n

\r\n\t1\u3001\u6253\u5f00cmd\u8fdb\u5165\u547d\u4ee4\u884c,\u5207\u6362\u5230.sql\u5907\u4efd\u6587\u4ef6\u6240\u5728\u7684\u76ee\u5f55\u4e0b\u3002
\r\n2\u3001\u82e5\u5c06libnet\u5b89\u88c5\u5728C\u76d8\uff0c\u5148\u4f7f\u7528\u547d\u4ee4c:\\tcsoft\\libnet\\wamp\\mysql\\bin\\mysql -uroot -p\u5bc6\u7801 \uff0croot\u5bc6\u7801\u53ef\u5728c:\\tcsoft\\libnet\\www\\libnet\\app\\Conf\\inst_pwd.php\u6587\u4ef6\u4e2d\u627e\u5230\u3002<\/span>
\r\n3\u3001\u7136\u540e\u6267\u884c\u76f8\u5173\u547d\u4ee4\u5bfc\u5165\u6570\u636e\u3002
\r\nmysql> use libnet; \/\/\u8bbe\u7f6e\u5f53\u524d\u8981\u5bfc\u5165\u6570\u636e\u7684libnet\u6570\u636e\u5e93,\u5728\u5b89\u88c5\u7cfb\u7edf\u65f6\u53ef\u80fd\u8bbe\u5b9a\u4e0e\u4e4b\u4e0d\u540c\u3002<\/span> \r\n<\/p>\r\n

\r\n\tmysql> set names utf8; \/\/\u8bbe\u7f6e\u7f16\u7801\u683c\u5f0f<\/span>
\r\nmysql> source c:\\libnet_back.sql; \/\/\u5f00\u59cb\u5bfc\u5165\u6570\u636e\uff0c\u76f4\u5230\u5bfc\u5165\u5b8c\u6bd5\u5373\u53ef\u3002<\/span> \r\n<\/p>\r\n

\r\n\t\"\"
\r\n<\/span> \r\n<\/p>\r\n

\r\n\tB.\u5728Linux\u4e0b\u8fd8\u539f\u6570\u636e\u5e93\u4e0eWindows\u64cd\u4f5c\u5927\u4f53\u4e00\u81f4\uff0c\u53ea\u662f\u8def\u5f84\u683c\u5f0f\u6709\u5dee\u5f02\u3002 
\r\n<\/span> \r\n<\/p>\r\n

\r\n\t\u5c06Mysql\u6570\u636e\u5e93\u5907\u4efd\u62f7\u8d1d\u5230\u78c1\u76d8\u76ee\u5f55\u5982\uff1a\/data\/dbbak\/libnet.sql(\u82e5\u4e3azip\u538b\u7f29\u6587\u4ef6,\u8bf7\u5148\u89e3\u538b\u7f29,\u4e0a\u4f20\u53ef\u91c7\u7528sftp)<\/span>
\r\n<\/div>\r\n
\r\n\t<\/span>\"\" \r\n<\/div>\r\n

\r\n\t1\u3001\u6253\u5f00cmd\u8fdb\u5165\u547d\u4ee4\u884c,\u5207\u6362\u5230.sql\u5907\u4efd\u6587\u4ef6\u6240\u5728\u7684\u76ee\u5f55\u4e0b\u3002
\r\n2\u3001\u5148\u4f7f\u7528\u547d\u4ee4 \/data\/lamp\/mysql\/bin\/<\/span>mysql -uroot -p\u5bc6\u7801 \uff0croot\u5bc6\u7801\u53ef\u5728 <\/span>\/data\/www\/<\/span>libnet\/app\/Conf\/nst_pwd.php\u6587\u4ef6\u4e2d\u627e\u5230\u3002
\r\n3\u3001\u7136\u540e\u6267\u884c\u76f8\u5173\u547d\u4ee4\u5bfc\u5165\u6570\u636e\u3002
\r\nmysql> use libnet; \/\/\u8bbe\u7f6e\u5f53\u524d\u8981\u5bfc\u5165\u6570\u636e\u7684libnet\u6570\u636e\u5e93\r\n<\/p>\r\n

\r\n\tmysql> set names utf8; \/\/\u8bbe\u7f6e\u7f16\u7801\u683c\u5f0f
\r\nmysql> source \/data\/dbbak\/libnet_back.sql; \/\/\u5f00\u59cb\u5bfc\u5165\u6570\u636e\uff0c\u76f4\u5230\u5bfc\u5165\u5b8c\u6bd5\u5373\u53ef\u3002<\/span> \r\n<\/p>\r\n

\r\n\t
\r\n<\/p>\r\n

\r\n\t <\/span> \r\n<\/p>\r\n


\r\n

\r\n\t
\r\n<\/p>\r\n

\r\n\t3.\u5982\u4f55\u5220\u9664\u67d0\u4e2a\u5206\u9986\u7684\u6240\u6709\u6570\u636e\uff1f<\/span> \r\n<\/p>\r\n

\r\n\t\u7b54\uff1a\u4f9d\u6b21\u6253\u5f00 \u7cfb\u7edf>\u7cfb\u7edf\u53c2\u6570>\u5206\u9986\u7ba1\u7406<\/span>\u3002\u8fdb\u5165\u83dc\u5355\uff0c\u5982\u4e0b\u56fe<\/span> \r\n<\/p>\r\n

\r\n\t\"\"
\r\n<\/span> \r\n<\/p>\r\n

\r\n\t\u5206\u9986\u5217\u8868<\/span> \r\n<\/p>\r\n

\r\n\t\"\"<\/span> \r\n<\/p>\r\n

\r\n\t\u5220\u9664\u5206\u9986
\r\n<\/span> \r\n<\/p>\r\n

\r\n\t\u7531\u4e8e\u5220\u9664\u5206\u9986\u6570\u636e\u64cd\u4f5c\u98ce\u9669\u8f83\u9ad8\uff0c\u6839\u636e\u63d0\u793a\uff0c\u8bf7\u8054\u7cfb\u672c\u516c\u53f8\u6280\u672f\u5458\uff0c\u83b7\u53d6\u76f8\u5173\u9a8c\u8bc1\u7801\uff0c\u65b9\u53ef\u7ee7\u7eed\u64cd\u4f5c\u3002
\r\n<\/span> \r\n<\/p>\r\n

\r\n\t
\r\n<\/p>\r\n

\r\n\t
\r\n<\/p>\r\n

\r\n\t
\r\n<\/p>\r\n


\r\n

\r\n\t
\r\n<\/p>\r\n

\r\n\t
\r\n<\/p>\r\n

\r\n\t
\r\n<\/p>","template":"","bookmark":"0"}