Solved

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

Posted on 2012-04-09
6
287 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
  • 5
6 Comments
 
LVL 17

Expert Comment

by:Anuroopsundd
ID: 37822631
0
 

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

776 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