|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: restore db from mysqldump I get different databases size
From: Pooly (pooly7
gmail.com)
Date: Sat Oct 01 2005 - 18:26:02 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
2005/10/1, Lorenzo Sicilia <arnorkemen.it>:
> 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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]