国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂

mysql導(dǎo)入大容量SQL備份文件
大家講道理
大家講道理 2017-04-17 11:53:05
0
4
469

之前工作中遇到一個問題,就是導(dǎo)入大容量sql文件,sql文件大概有2個G,包含了表結(jié)構(gòu)和數(shù)據(jù)。當時用命令行、workbench等工具都試過了,都會出現(xiàn)各種各樣的錯誤,因為比較著急,后來實在沒辦法,就手工刪除了很多記錄,然后再導(dǎo)入了。

想問下,大家再導(dǎo)入大容量SQL文件的時候,都是通過什么方法?文件或命令行的方式都行

大家講道理
大家講道理

光陰似箭催人老,日月如移越少年。

reply all(4)
劉奇

For 6 GB sql files, I directly use source in mysl, which takes about half an hour

巴扎黑

Save the world via command line

mysql -h hostname -u username -p databasename < sqlfile.sql

Try splitting the file into several parts

巴扎黑

I handled a similar case in the first half of the year, and the SQL kept making errors.
The final solution is: convert the data into an xml or json file, and finally import it using navicat.

迷茫

I put the sql file into the server and source it in the server. As long as there are no errors in the SQL, it will be fast every time

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template