Hi,

I'm trying to use mysqlimport to import from a file. Here's what I'm using:

mysqlimport --local -pPASSWORD DATABASE file.sql

This always dies with:

Error: Table 'DATABASE.TABLE_NAME' doesn't exist, when using table: TABLE_NAME

When I use MySQLMan to do the import it works fine but times out so I need to use SSH.

How do I get around this error?...I searched Yahoo/MySQL but just found syntax examples and not ways of fixing this problem.

It must be an option I need to use like --force or something?

Thanks to those who respond.




Installations:http://www.wiredon.net/gt/

try:
mysql -p DATABASE-NAME < file.sql

-g


s/(\d{2})/chr($1)/ge + print if $_ = '8284703280698276687967';

Thanks. That did it.


Installations:http://www.wiredon.net/gt/