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: > # 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?
They may not be ordered in the same way, and may have empty spaces. If you optimized all tables in both database, you would then get the same size. -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
