I am importing 20GB sql file to a MySQL database but receiving an error. I am executing the following command on dos prompt
The error I get
mysql -uroot -p database_name < e:\data.sql
I have exported data on CentOS using mysqldump.
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'data.sql
39,59562,4,0),(11183,59850,4,0),(41,39376,4,0),(39,59861,4,0),(41,4884' at line 1
I did not make any change to the file except uncompressing after download from the live server.
What can I do to resolve this issue?
OS: Windows Server 2003 Enterprise Edition
MySQL Version: 5.0.51a-community-nt MySQL Community Edition (GPL)