Moving a mysql database on a different partition on the server

Hi,

I'm looking to move an entire mysql databse from its current location
into a newly installed much larger partition on our Microsoft Small
Business 2003 server. Can anyone please explain how I could go about
doing this?
The way I am looking to do it at the moment it to backup the DB,
uninstall mysql from its current location, install it into the new
partition, and then change all existing connections to point here from
now on.......this will take me a lot of time :)
is there an easier/quicker way to do this?

Help as always is much appreciated

kunaal84@gmail.com wrote:
> Hi,
>
> I'm looking to move an entire mysql databse from its current location
> into a newly installed much larger partition on our Microsoft Small
> Business 2003 server. Can anyone please explain how I could go about
> doing this?
> The way I am looking to do it at the moment it to backup the DB,
> uninstall mysql from its current location, install it into the new
> partition, and then change all existing connections to point here from
> now on.......this will take me a lot of time :)
> is there an easier/quicker way to do this?
>
> Help as always is much appreciated
>

If you're just moving the data, and not MySQL itself, you can stop
MySQL, copy the files over to the new partition, change your my.ini file
and restart the database.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Thanks Jerry,

Appreciate that, it seems to have worked :)