mysql - 将 mysql 转储文本文件恢复到数据库

Question

我正在使用 opencl 分析大数据。我在 mysql 转储文本文件 (dump.txt) 中获得了数据。我想将数据恢复到mysql数据库中。然后我可以连接到数据库并做其他与并行编程相关的事情来分析大数据。

我浏览了一些与此相关的教程和问题。我在这里找到了一个相关的问题。 link here .但是他们在那里提到了恢复 .sql 转储文件的方法。我们可以为转储文本文件做什么？

我的转储文本文件的摘要部分在这里

"94723605719","435035","2013-06-01 23:51:36","2013-06-01","2013","6","1","7","22 ","23","51","36","1","202","-1002409728","1005823215","50000.000",\N,"1613003749 10","50026.000","226","0","0","94723605719","34399725","0","0","0",\N "94722616878","435014","2013-06-01 23:51:52","2013-06-01","2013","6","1","7","22 ","23","51","52","1","202","-1002099361","1005511506","50000.000",\N,"1613002394 31","50127.000","157","0","0","94722616878","34438596","0","0","0",\N "94726556777","435022","2013-06-01 23:51:52","2013-06-01","2013","6","1","7","22 ","23","51","52","1","202","-1002496570","1005910182","50000.000",\N,"1614002967 42","61046.000","226","0","0","94726556777","34399744","0","0","0",\N

感谢任何帮助。提前致谢。

Answer 1

如果你有“真正的”转储，那么你可以使用:

mysql -u root -p -h local host < your_dump.sql

也就是说，您在问题中列出的示例似乎暗示您只有 CSV 文件中的值，在这种情况下，您需要先创建表格，然后将数据加载到其中:

LOAD DATA INFILE 'your_file.txt' 
 INTO TABLE your_table 
 FIELDS TERMINATED BY ',' 
 OPTIONALLY ENCLOSED BY '"';

参见 MySQL 手册 LOAD DATA INFILE了解更多详情。