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
-
-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
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
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