2005/10/1, Lorenzo Sicilia <[EMAIL PROTECTED]>:
> Hi to all,
>
> I have a database online with innodb &myisam tables. I use this option when I
> do a daily backup:
> #mysqldump -c -e -Q -u --lock-tables --flush-logs --opt myDB -u MyUser -p >
> db.sq
>
> when I restore my db with this command:
> # m
Hi to all,
I have a database online with innodb &myisam tables. I use this option when I
do a daily backup:
#mysqldump -c -e -Q -u --lock-tables --flush-logs --opt myDB -u MyUser -p >
db.sq
when I restore my db with this command:
# mysql -u root -p -D myDB_restored < db.sql
I get a new databse