[sdnog] Moving ispconfig

[Daniel Shaw]

Hi Khansaa,

I don't know anything about ISPconfig. However, I can offer some generic advice on copying a MySQL database from one server to another. Basically there are 2 ways to do it. The first is like you have done: By copying the files on disk that make up the actual data. BUT. There is a catch. If you do it that way, you *must* shut down the original source database first. That is, while you scp (or tar or rsync or whatever), the database on server A must be stopped.

If you need to do this without stopping server A (as it's in production), then you need to use method number 2. Which is dumping the data to text output on the source (server A), copy that file across to the target (server B) and then import it.

You can search online for mysqldump (the command to do the dump) and things like "dump and import mysql database", and you'll find lots of practical step by step instructions.

Regards,
Daniel



-------- Original Message --------
Subject: Re: [sdnog] Moving ispconfig
Local Time: December 29 2015 11:11 am
UTC Time: December 29 2015 7:11 am
From: khansa060 at gmail.com
To: sdnog at sdnog.sd


I have already Installed a new ISPconfig,in Server B,also postfix, mysql, php, apache, and i used "scp" to
Replace he files /etc /var/lib/mysql
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sdnog.sd/pipermail/sdnog/attachments/20151229/399d6772/attachment-0001.html>