Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

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.
0
EricHoma
Asked:
EricHoma
  • 5
1 Solution
 
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
 
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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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:
Not sure how but I got is working using export and import.
0
 
EricHomaAuthor Commented:
Got it working myself using the time proven trial and error method or some variant thereof.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now