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 but the size it doesn't match. I do a diff between myDB_restored.sql and db.sql and all match. Then why my db in production it's more heavy of my restored db? Orginal size 3.1 MB the new size 2.7 MB. any idea? many thanks in advance. regards Lorenzo -- "Il fatto che un'opinione sia condivisa ampiamente non prova che non sia completamente assurda" *Bertrand Russell -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
