Old 29th August 2008, 03:53
dayjahone dayjahone is offline
Senior Member
Join Date: Jan 2007
Posts: 432
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:

SuSe 9.2
ISPConfig 2.2.9

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
Old 29th August 2008, 10:33
topdog topdog is offline
Senior Member
Join Date: Jan 2008
Location: South Africa
Posts: 1,352
Thanks: 0
Thanked 154 Times in 151 Posts

To check the version use

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


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 18:33
question about backing up two databases cruz Installation/Configuration 0 17th November 2007 21:50
Moving existing customer databases - rename issue catdude General 2 16th October 2007 00:35
site - databases trueshanti Installation/Configuration 20 26th May 2006 02:28
Recovering unlinked mysql databases and users... Dave Lane Installation/Configuration 2 10th May 2006 20:45

All times are GMT +2. The time now is 20:56.

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