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.
##Related recommendations: "Navicat for mysql graphic tutorial"
Target database verification:±---------+ | count(1) | ±---------+ | 497051 | ±---------+ 1 row in set (0.16 sec)
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!