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
Charitha,
Monday, July 15, 2002, 8:54:03 AM, you wrote:
C> Is there any way in mysql to restore the data back after flushing off
C> all the data already present using a single command.
C> I am having backup of the db and i want to restore the data back in the
C> database by flushing off all the d
Hello all,
Is there any way in mysql to restore the data back after flushing off
all the data already present using a single command.
I am having backup of the db and i want to restore the data back in the
database by flushing off all the data already present.
Thanx in advance
Regards,
Ch
I am trying to restore my database using the binary
log. I have restored the last full backup and want to
rerun the updates from that point. I have tried
running this command (mysqlbinlog log-file | mysql -h
server_name), which is shown in the manual but it
doesn't seem to work. Any suggestions