I would really appreciate any form of help with a importing pickle that I can't seem to shake.
I recently converted a Microsoft Access database into .sql format using the Bullzip program for Windows OS. (After first trying to use 'mdb tools', and then a different conversion wizard which produced corrupted data). Now I'm trying to import the dump.sql file into MySQL from Ubuntu. Every time I try to use the code
shell> MySQL -u root -p database < dumpfile.sql
There shows an error 1064 (42000)in your SQL syntax blah blah blah near '-------------------------------------------------------
CREATE DATABASE "database"' at line 1
To fix this, I open up the dump.sql file and comment out the CREATE DATABASE " " command. What happens then is same error 1064 (42000)in your SQL syntax blah blah blah near '-------------------------------------------------------
CREATE TABLE at line 1
appears!
So while the script all looks good in the .sql file, I just can't seem to get it into a MySQL database. At this point I am considering hand-coding every table of the database into MYSQL (this would take days)!
-For a second I thought that the bullzip program was the problem, but the file seems to check out----
Thank you kindly in advance.
Bookmarks