#1  
Old 29th August 2008, 02:53
dayjahone dayjahone is offline
Senior Member
 
Join Date: Jan 2007
Posts: 421
Thanks: 31
Thanked 0 Times in 0 Posts
Default Moving databases

To give you a more complete picture, I am trying to transfer websites from server A to server B with the following info:

SERVER A:
SuSe 9.2
ISPConfig 2.2.9

SERVER B:
Ubuntu 8
ISPConfig 2.2.24

I am not sure which version of MySQL I am running. How do I check? How do I upgrade?

Because just about everything that can be different probably is and I have relatively few sites to transfer over, I was going to just recreate them on the new server. The problem with this is some of the websites use databases for blogs and such. Is there a simple way to copy the db from a website on the old server and add it to a website on the new server?
Reply With Quote
Sponsored Links
  #2  
Old 29th August 2008, 09:33
topdog topdog is offline
Senior Member
 
Join Date: Jan 2008
Location: South Africa
Posts: 1,352
Thanks: 0
Thanked 153 Times in 150 Posts
 
Default

To check the version use

Code:
select version();
To migrate the databases, just do a mysql dump then import on the other end.
__________________
----
http://www.topdog.za.net - Got Linux problems ? - I can help.
http://www.baruwa.org - Try it.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
moving ispconfig and databases aqua Installation/Configuration 3 24th April 2008 17:33
question about backing up two databases cruz Installation/Configuration 0 17th November 2007 20:50
Moving existing customer databases - rename issue catdude General 2 15th October 2007 23:35
site - databases trueshanti Installation/Configuration 20 26th May 2006 01:28
Recovering unlinked mysql databases and users... Dave Lane Installation/Configuration 2 10th May 2006 19:45


All times are GMT +2. The time now is 07:51.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.