Solved

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

Posted on 2012-04-09
6
293 Views
Last Modified: 2012-04-21
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
Comment
Question by:EricHoma
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
6 Comments
 

Author Comment

by:EricHoma
ID: 37822661
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
 

Author Comment

by:EricHoma
ID: 37844067
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
Turn Insights into Action

Communication across every corner of your business is essential to increase the velocity of your application delivery and support pipeline. Automate, standardize, and contextualize your communication processes with xMatters.

 

Author Comment

by:EricHoma
ID: 37852689
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
 

Accepted Solution

by:
EricHoma earned 0 total points
ID: 37852852
Not sure how but I got is working using export and import.
0
 

Author Closing Comment

by:EricHoma
ID: 37875092
Got it working myself using the time proven trial and error method or some variant thereof.
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question