I want migrate My Mysql 5.0 windows 32 bit to Mysql 5.6 Windows 64 bit?
Please suggest me the best way to do migration, i have around 10gb of data present in Mysql 5.0.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
You use mysqldump.
Step 1. Dump your original 32 bit database. mysqldump my32bitdb [options...] > mydb.sql
Step 2. Copy the file mydb.sql to your new server
Step 3. Load the 32 bit database mysql -u root -p my64bitdb < C:\path\to\mydb.sql
With 10GB of data, it shouldn't take much more than ~ 1hr.