MySQL importing csv file by Data import wizard 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.
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 &gt; mysql_user.sql

Step2 : Restore the backup on Destination.
mysql -u user_name -p -h192.168.X.X database_name &lt; mysql_user.sql