Thread: MySQL -u root -p database < dumpfile.sql

i appreciate form of importing pickle can't seem shake.

converted microsoft access database .sql format using bullzip program windows os. (after first trying use 'mdb tools', , different conversion wizard produced corrupted data). i'm trying import dump.sql file mysql ubuntu. every time try use code

shell> mysql -u root -p database < dumpfile.sql

there shows error 1064 (42000)in sql syntax blah blah blah near '-------------------------------------------------------
create database "database"' @ line 1

fix this, open dump.sql file , comment out create database " " command. happens same error 1064 (42000)in sql syntax blah blah blah near '-------------------------------------------------------
create table @ line 1
appears!

while script looks in .sql file, can't seem mysql database. @ point considering hand-coding every table of database mysql (this take days)!

-for second thought bullzip program problem, file seems check out----

thank kindly in advance.

is .sql file in dos format (with cr/lf line endings)? if try converting standard unix format (lf line endings).

Forum The Ubuntu Forum Community Ubuntu Official Flavours Support New to Ubuntu [ubuntu] MySQL -u root -p database < dumpfile.sql

Ubuntu