MySQL Forums
Forum List  »  Newbie

Migrate MySQL 5.5 to another Windows Server
Posted by: Jerry Lin
Date: October 06, 2016 09:09AM

Hi Everyone,

I am currently moving MySQL 5.5.25a on Server 2008R2 to a new Windows Server 2012R2 running MySql 5.5.52.

I am using the following switches.

Backup:
mysqldump -u root -p --routines --events --triggers --dump-date --all-databases d:\MySQLDB.sql

Restore:
mysql -u root -p < d:\mySQLDB.sql

The restore works well. My concern is that when I open both DBs using HeidiSQL, the Size of the Databases are different. I also checked on a few tables, and they have different size as well.

Does anyone know the reason behind this? Is this normal or am I missing some other switches to carry over all the information to the new server?

Also - seems like "--dump-date" switch does not carry over the Time Stamp.

Thanks in advance for the help!

Regards,
Jerry

Options: ReplyQuote


Subject
Written By
Posted
Migrate MySQL 5.5 to another Windows Server
October 06, 2016 09:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.