[RESOLVED] backup and restore

cupboy

You'd think this subject would be covered somewhere, but it isn't. I have a co-worker who backed up a database using mysqldump.

Having searched the web I see that you should be able to "restore" this using mysqlimport, but mysqlimport gets confused and thinks one of the parameters is a table name.

Any other ideas on how I may be able to use the mysqldump backup file?

Here is the error:

D:>restore_test.bat

D:>mysqlimport -u root -pbow test test200820.sql
mysqlimport: Error: Table 'test.test200820' doesn't exist, when using table: tes
t200820

D:>

bretticus

Well, never done this in windoze but I usually just do something like this:

$ mysql -u root -ppassword database < backupfile.sql

Or more information here.

You'd think this subject would be covered somewhere, but it isn't

google covers it quite nicely.

cupboy

bretticus;10883005 wrote:
Well, never done this in windoze but I usually just do something like this:
$ mysql -u root -ppassword database < backupfile.sql
Or more information here.

google covers it quite nicely.

That less than sign isn't used in windows. All the examples I see are for unix. I'll keep looking though.

bretticus

cupboy;10883116 wrote:
That less than sign isn't used in windows. All the examples I see are for unix. I'll keep looking though.

Not sure what version of windows you are using. Redirection has been part of command since at least windows xp.

Attached is an image from a command prompt in Windows XP in case you don't believe me.

cupboy

bretticus;10883120 wrote:
Not sure what version of windows you are using. Redirection has been part of command since at least windows xp.

Attached is an image from a command prompt in Windows XP in case you don't believe me.

"command prompt" is the key to the whole problem. I was inserting the command into a batch file. That worked ok for the backup, but not for the restore. Doing it directly using the command prompt works fine. Thanks for the reply.

illzz

cupboy;10883154 wrote:
"command prompt" is the key to the whole problem. I was inserting the command into a batch file. That worked ok for the backup, but not for the restore. Doing it directly using the command prompt works fine. Thanks for the reply.

Not sure if I'm misunderstanding you or not, but it sounds like you say it still doesn't work in a batch file. My tests show the contrary...

syntax for creating dump file

mysqldump  -h hostname -u username -ppassword test > foo.sql

foo.sql (edits to dumpfile to create and use a new database, for verification purposes)

CREATE new_test;
USE new_test;
(rest of dump file)....

bar.bat (batch file)

mysql -h hostname -u username -ppassword < foo.sql

Then launching the batch file executes every thing just fine.