Proper SQL Synatx for an import

[chuckomalley]

I have done a mysqldump of my online database to my PC, where I also have MySQL
running for testing purposes. I have my local database (chuckomalley) in the
C:\mysql\data\chuckomalley\ folder. I saved the dump file
(chuckomalleydump.sql) in the same folder. I want to use the mysqlimport
function to restore the dump into my local database so that my tables are
syncronized with my live database (My host provider will now allow live
replication for security purposes.) What is the proper syntax for getting the
dump file to populate the tables? I have the dump file with drop table options
already in the file so it is a matter of using the right syntax to populate it
correctly. I checked the mysql manual (section 2.10.8) but nothing works
(keeps giving me a syntax error.) I used PHP My Admin to create the dump file
but I do not have PHP My Admin on my local PC. And to be honest, I'd rather
learn the code instead of using a GUI. Thanks in advance. Cheers Chuck

[Michael Fesser]

.oO(chuckomalley)

>What is the proper syntax for getting the
>dump file to populate the tables? I have the dump file with drop table options
>already in the file so it is a matter of using the right syntax to populate it
>correctly.

I usually do it with the 'mysql' command:

mysql -uUsername -pPassword Database < dump.sql

Micha

[chuckomalley]

BINGO! That did the trick. Thanks.

Cheers

Chuck