Jeff Gannaway wrote:
> mysqldump -uUSERNAME -pPASSWORD database > dbBackup.sql
> and it created the dump file. I transferred it to the new server then
> tried to load it into my new database using the following command:
>
> mysqldump -uUSERNAME -pMILLER31 database < dbBackup.sql
Don't take "mysqldump" for the import into the new database,
try
mysql -uUSERNAME -pMILLER31 database < dbBackup.sql
on the new mySQL server instead!
Günther Pewny
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
