Home  >  Article  >  Database  >  What to do if Navicat imports incomplete data

What to do if Navicat imports incomplete data

爱喝马黛茶的安东尼
爱喝马黛茶的安东尼Original
2019-08-06 14:54:399871browse

What to do if Navicat imports incomplete data

When using Navicat to import data, although the database was imported, the amount of data was much less. The source database had more than 490,000 data, and only 55,000 data were imported before it stopped. And no error was reported.

Open the txt file with Notepad, then save it as another file (note that the encoding is still UTF8), save it in csv format, for example: test.txt becomes test.csv, then import it with navicat, and import it in txt format. The data can be imported successfully.

What to do if Navicat imports incomplete data

##Related recommendations: "

Navicat for mysql graphic tutorial"

Target database verification:

±---------+
| count(1) |
±---------+
| 497051 |
±---------+
1 row in set (0.16 sec)

What to do if Navicat imports incomplete data

The above is the detailed content of What to do if Navicat imports incomplete data. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn