Safe to move database files after installation?

11/02/2008, 06h18

I recently installed MySQL along with an application that uses it and
several other components that the application uses. To get everything
working I used the default configuration settings everywhere. Now I
am cleaning things up. I would like to move the database files to a
location outside the MySQL base directory.

Can I simply shut down MySQL, move the data directory, and point the
INI file's datadir directive to the new location? Or is it more
difficult than that?

11/02/2008, 09h14

On 11/02/2008 in message <8mpvq3tf28qgjll8s4k5af65ud8mh3bugj@4ax.com>
Jonathan Sachs wrote:

>Can I simply shut down MySQL, move the data directory, and point the
>INI file's datadir directive to the new location? Or is it more
>difficult than that?

I did that with no problems when I discovered the installer seemed to
ignore the data directory I told it to use.
I would stop MySQL and copy, rather than move, the files then rename the
old directory before re-starting MySQL. Gives you another bite at it if
there's a problem :-)

--
Jeff Gaines Damerham Hampshire UK
There is no reason anyone would want a computer in their home.
(Ken Olson, president Digital Equipment, 1977)

11/02/2008, 14h13

On 11 Feb 2008 09:14:33 GMT, Jeff Gaines wrote:
> On 11/02/2008 in message <8mpvq3tf28qgjll8s4k5af65ud8mh3bugj@4ax.com>
> Jonathan Sachs wrote:
>
>>Can I simply shut down MySQL, move the data directory, and point the
>>INI file's datadir directive to the new location? Or is it more
>>difficult than that?
>
> I did that with no problems when I discovered the installer seemed to
> ignore the data directory I told it to use.
> I would stop MySQL and copy, rather than move, the files then rename the
> old directory before re-starting MySQL. Gives you another bite at it if
> there's a problem :-)

Take it a step further. Use mysqldump to take your first backup, then
restore from that.

--
Graham's First Rule of Internet Retailing:
If your 'shopping cart' site requires anything more complex than
HTML, SSL and a session , at least one of your competitors
will run a site which does not. Your competitor will get the sale.

11/02/2008, 06h18	#1
Jonathan Sachs Messages: n/a Hébergeur:	Safe to move database files after installation? I recently installed MySQL along with an application that uses it and several other components that the application uses. To get everything working I used the default configuration settings everywhere. Now I am cleaning things up. I would like to move the database files to a location outside the MySQL base directory. Can I simply shut down MySQL, move the data directory, and point the INI file's datadir directive to the new location? Or is it more difficult than that?

11/02/2008, 09h14	#2
Jeff Gaines Messages: n/a Hébergeur:	Re: Safe to move database files after installation? On 11/02/2008 in message <8mpvq3tf28qgjll8s4k5af65ud8mh3bugj@4ax.com> Jonathan Sachs wrote: >Can I simply shut down MySQL, move the data directory, and point the >INI file's datadir directive to the new location? Or is it more >difficult than that? I did that with no problems when I discovered the installer seemed to ignore the data directory I told it to use. I would stop MySQL and copy, rather than move, the files then rename the old directory before re-starting MySQL. Gives you another bite at it if there's a problem :-) -- Jeff Gaines Damerham Hampshire UK There is no reason anyone would want a computer in their home. (Ken Olson, president Digital Equipment, 1977)

11/02/2008, 14h13	#3
Peter H. Coffin Messages: n/a Hébergeur:	Re: Safe to move database files after installation? On 11 Feb 2008 09:14:33 GMT, Jeff Gaines wrote: > On 11/02/2008 in message <8mpvq3tf28qgjll8s4k5af65ud8mh3bugj@4ax.com> > Jonathan Sachs wrote: > >>Can I simply shut down MySQL, move the data directory, and point the >>INI file's datadir directive to the new location? Or is it more >>difficult than that? > > I did that with no problems when I discovered the installer seemed to > ignore the data directory I told it to use. > I would stop MySQL and copy, rather than move, the files then rename the > old directory before re-starting MySQL. Gives you another bite at it if > there's a problem :-) Take it a step further. Use mysqldump to take your first backup, then restore from that. -- Graham's First Rule of Internet Retailing: If your 'shopping cart' site requires anything more complex than HTML, SSL and a session , at least one of your competitors will run a site which does not. Your competitor will get the sale.

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email