Re: Programmatic MySQL backup in Perl

2002-12-20 Thread Jeff Snoxell
Hello, I've successfully backed up my database to JeffsDB.sql using mysqldump with the -opt option. When I try to restore it using: mysql -h myhost -u myusername -ppassword JeffsDB < JeffsDB.sql I get: ERROR 1065 at line 21: Query was empty Now, line 21 of the SQL file contains: /*!4 AL

RE: Programmatic MySQL backup in Perl

2002-12-19 Thread Peter Vertes
- -Original Message- From: Jeff Snoxell [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 11:16 To: [EMAIL PROTECTED] Subject: Programmatic MySQL backup in Perl Hi, is there an easy way to programmatically backup MySQL database tables using Perl? My Perl code will be running

RE: Programmatic MySQL backup in Perl

2002-12-19 Thread Norris, Joseph
ent: Thursday, December 19, 2002 8:16 AM To: [EMAIL PROTECTED] Subject: Programmatic MySQL backup in Perl Hi, is there an easy way to programmatically backup MySQL database tables using Perl? My Perl code will be running

Programmatic MySQL backup in Perl

2002-12-19 Thread Jeff Snoxell
Hi, is there an easy way to programmatically backup MySQL database tables using Perl? My Perl code will be running on a machine remote to the MySQL server. Ta, Jeff - Before posting, please check: http://www.mysql.com/manua