将2G大的bank.sql导入本地数据库:
1.首先在phpmyadmin中建立bank库
2.进入mysql所在盘符
C:\Documents and Settings\Administrator>D:
3.进入mysql的bin目录
D:\>cd D:\wamp\bin\mysql\mysql5.0.51b\bin
4.将E盘下得bank.sql导入bank库
D:\wamp\bin\mysql\mysql5.0.51b\bin>mysql -u root -p bank < E:/bank.sql
5.提示输入数据库密码
Enter password:
6.导入成功,提示符返回bin目录
D:\wamp\bin\mysql\mysql5.0.51b\bin>
除非注明,均为湛蓝天空原创,转载请注明本文网址:http://skyhome.cn/sql/158.html