How to Import Data from a existing Database In MySQL

[gilbertjia]

How to Import Data from a existing Database to a new constructed Database?

I attempted to use "mysqlimport", but it does not work.

In Winsows 2000, I want to import data from a dump file .
C:\mysql\bin>mysqlimport -u username -p database C:\temp\ImportData.txt

Error message displayed like this :
mysqlimport: Error: The used command is not allowed with this MySQL version, when using table: temp_table

MySQL version is MySQL 3.23.53 for Win32

Please give me another solution or tell me why "mysqlimport" can not work.

Many thanks,
Gilbert

[Elizabeth]

Have you tried the "LOAD DATA INFILE" command?

You can read more about it in the mySQL manual on this page here.

HTH!

-Elizabeth

[gilbertjia]

"LOAD DATA INFILE" really does work.
Thanks a lot for your help,Elizabeth!

Gilbert

[PHPGuru_2700]

you could get into mysql and type source [filename]