Fw: moving a database

>I am going to move a database off my webserver and to a dedicated DB Server
> box.
>
> Both of the boxes are identical software wise. From what I understand I
> should be able to simply detach the database from being active, move all
> of
> the datafiles to the DB server, restart the DB Server's mysql instance,
> point the website to the new DB location and be done with it.
>
> Am I correct in this statement or is it more complicated?
>
> Thanks.
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Fw: moving a database

If its the same MySQL version, the same environment, you would have no
problems doying that, but I advice everyone to always test it before
doying it, copy the files, run the new server, TEST it for a week,
than you'll be able to retire the old server from MySQL tasks. Always
backup, you won't regret it...

Good luck,

On 6/15/05, Greg Quinn wrote:
> >I am going to move a database off my webserver and to a dedicated DB Ser=
ver
> > box.
> >
> > Both of the boxes are identical software wise. From what I understand =
I
> > should be able to simply detach the database from being active, move al=
l
> > of
> > the datafiles to the DB server, restart the DB Server's mysql instance,
> > point the website to the new DB location and be done with it.
> >
> > Am I correct in this statement or is it more complicated?
> >
> > Thanks.
> >
>=20
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: moving a database

That might work but it might not. A more reliable way to do this would
be to use mysqldump utility to dump the databases you want to move,
then use the mysql client to load the data from the dump file. This
would also accomodate for version differences (to an extent -- se the
mysql site for info on switching between versions) so this is good
practice for future upgrades from mysql 3.2 to 4, from 4 to 4.1, or
from 4 to 5.

Hope that helps!
Corey

On Jun 15, 2005, at 4:06 PM, Greg Quinn wrote:

>> I am going to move a database off my webserver and to a dedicated DB
>> Server
>> box.
>>
>> Both of the boxes are identical software wise. From what I
>> understand I
>> should be able to simply detach the database from being active, move
>> all of
>> the datafiles to the DB server, restart the DB Server's mysql
>> instance,
>> point the website to the new DB location and be done with it.
>>
>> Am I correct in this statement or is it more complicated?
>>
>> Thanks.
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=corey@bbqguys.com
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Fw: moving a database

Hi Greg;

Assuming that you are running identical MySQL versions on both machines, and
that you have a matching underlying OS (not required but makes things easier),
then yes, shut down the old machine's MySQL instance, copy the data folder to
the new machine, and start MySQL on the new machine (with a matching config
file). Restart the old machine's MySQL instance to minimize downtime if you do
not expect updates.

Start the MySQL instance on the new machine and test it. If all is well
reconfigure your application to connect to the new machine.

Greg Quinn wrote:
>> I am going to move a database off my webserver and to a dedicated DB
>> Server
>> box.
>>
>> Both of the boxes are identical software wise. From what I understand I
>> should be able to simply detach the database from being active, move
>> all of
>> the datafiles to the DB server, restart the DB Server's mysql instance,
>> point the website to the new DB location and be done with it.
>>
>> Am I correct in this statement or is it more complicated?
>>
>> Thanks.
>>
>
>

--
Mike Hillyer, Technical Writer
Lethbridge, Alberta, Canada
MySQL AB, www.mysql.com


"The Open Source movement has become a major force across the software industry,
and MySQL is the world's most popular open source database."
--Fortune Magazine

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org