Restore command line options

[Jerry McAllister]

> 
> How about I post this again, without the typo's :-O
> 
> Hi all,
> 
> I recently had the opertunity to restore a clients mysql db as he had
> removed a bunch of needed data from his shopping cart.
> 
> While the restore command worked OK I was wondering if there is a way to
> command line it a bit so as not to have to answer yes when asked about the
> file privledges and have to specify a '1' when asked what volume to use. (I
> am used to working with tar and doing everything in a single command).
> 
> The full backup and incremental backup files I used were in a /home/backup.
> The target files were of course in /usr/local/mysql/var/DBNAME
> 
> Here is the command I used:
> 
> restore -x -f /home/backup/usr.level-1_dump local/mysql/var/DBDIRNAMEHERE
> 
> Have I missed some command line options here to avoide having to answer the
> perms and volume questions?

I don't think you have missed anything.  It is one of the little
annoyances with dump/restore - which still do not add up to enough
to overweigh the value of using them.

You could write a wrapper script that would feed the 1 and yes(or no that
you may really want to give).

////jerry

> 
> -Grant
>