File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Error at  the  time  of importing sql_dump(MYSQL5.0 ) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Error at  the  time  of importing sql_dump(MYSQL5.0 )" Watch "Error at  the  time  of importing sql_dump(MYSQL5.0 )" New topic

Error at the time of importing sql_dump(MYSQL5.0 )

Seetharaman Venkatasamy
Ranch Hand

Joined: Jan 28, 2008
Posts: 5575


i am try to import sql_dump(.sql file) into my database in sqlYog

i am getting following error.the sql dump name is DDLSQL_ats.sql

is there something called DDL?.. because i already import many .sql files into DB...but this file only creating problem

Error message:
Error Code: 1064 - 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 '��U

Campbell Ritchie

Joined: Oct 13, 2005
Posts: 36453
You will have to find a tutorial about dumps in MySQL; there is something in "Beginning MySQL" by Sheldon and Moes (Wrox) which is a very nice book and not too expensive, but was printed in 2005 and could do with a new edition.

"DDL" is usually taken to mean Data Definition Language and means things like "CREATE TABLE", as opposed to INSERT, UPDATE, DELETE which are (I think) DML = Data Manipulation Language but I might be mistaken about the M and Manipulation.
I agree. Here's the link:
subject: Error at the time of importing sql_dump(MYSQL5.0 )
Similar Threads
using MySql
Embedding MySQL Database in Java Application
Create Stored Procedure
SQL Server limiting result set
restoring database using sql file