Results 1 to 2 of 2
Thread: Import 20GB sql file
Feb 13, 2008, 00:40 #1
- Join Date
- Sep 2007
- 0 Post(s)
- 0 Thread(s)
Import 20GB sql file
I am importing 20GB sql file to a MySQL database but receiving an error. I am executing the following command on dos prompt
mysql -uroot -p database_name < e:\data.sql
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)