Re: restore db from mysqldump I get different databases size

2005-10-01 Thread Pooly
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

restore db from mysqldump I get different databases size

2005-10-01 Thread Lorenzo Sicilia
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