I was wondering if someone could help me with the syntax to import a .dmp file into my mysql db? I am using the version of mysql 4.0.20ant.
I use the syntax below:
mysqlimport --no-defaults -u root -p mydb mfile.dmp
and I get the error:
mysqlimport: Error: Table 'database.table' doesn't exist, when using table: table
Sean - thanks in advance