Re: Restore command line options

2004-03-10 Thread 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
 
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: Restore command line options

2004-03-10 Thread Gary W. Swearingen
Grant Peel [EMAIL PROTECTED] writes:

 Have I missed some command line options here to avoide having to answer the
 perms and volume questions?

I don't know, but the lang/expect port has one solution to running
interactive programs non-interactively.  See http://expect.nist.gov;.
I think you can buy a paper book about expect.  
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]