Move/Restore MySQL Database to New Server with New Version of MySql

Hi, I have worked with MySql in the past and have a customer with a server running MySQL 5.0 on Window 2003 server.  I was using MySql Admin 1.2.17 and Query Browser to do work for this customer in the past.  They want me to move their database to a new Windows 2008 server on which they have installed MySql Server 5.5 and Workbench 5.2.35CE.  I know that I used to use MySql Administrator to backup the file and then I could restore it to my server locally but I can not seem to figure out how to restore the backup file to the new server using the Workbench tools.  Any help would be greatly appreciated.
EricHomaAsked:
Who is Participating?
 
EricHomaConnect With a Mentor Author Commented:
Not sure how but I got is working using export and import.
0
 
EricHomaAuthor Commented:
Thanks but not needing to move user privleges, only one database.  Hoping to use GUI tools.  Backup on old server and then restore on new server I was hoping. Can that be done?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
EricHomaAuthor Commented:
Still looking for help on this.  Anyone know if I can backup a database from a MySql 5.0 system and then restore it to a server with 5.5?  How do I restore with the Workbench GUI tool?
0
 
EricHomaAuthor Commented:
Used to be that you would get a lot of suggestions/answers on this site.  Is there another site that people are using now?
0
 
EricHomaAuthor Commented:
Got it working myself using the time proven trial and error method or some variant thereof.
0
All Courses

From novice to tech pro — start learning today.