[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • 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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

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