3

I tried importing a CSV file in MySQL via the data import wizard.

My CSV file has 70,000 records but only 61 are imported.

I tried checking the CSV file, recreating the file from source, and changing the location of the CSV file, but nothing works.

I even reinstalled MySQL version 8.0.25.

Please suggest a solution or any other way of importing.

John K. N.
  • 18,854
  • 14
  • 56
  • 117
Namu N
  • 31
  • 1

1 Answers1

0

Try using mysqldump command for dumping data from source to destination server.

Step1 : Take backup from Source server for particular table.

mysqldump --single-transaction  --set-gtid-purged=OFF  --force  -h 192.168.XX.XX -u user_name -p --databases database_name --tables table_name --lock-tables=false > mysql_user.sql

Step2 : Restore the backup on Destination.

mysql -u user_name -p -h192.168.X.X database_name < mysql_user.sql
JYOTI RAJAI
  • 866
  • 4
  • 11