List:General Discussion« Previous MessageNext Message »
From:mfatene Date:April 28 2005 4:43pm
Subject:Re: How to move a database to a new directory
View as plain text  
Hi,
If you want to move just one (or some) database and keep your datadir as defined
:
* stop the server
* move your database (say world) to a new directory (c:\newdir)
* in the datadir, create <world>.sym and write in a line containing "c:\newdir"
* restart

on Unix, you have symbolic links.

Mathias



Selon Dixie <dixie@stripped>:

> Andy Ford ha scritto:
>
> >I have run out of disk space in the directory where I have a mySQL database.
> >How do I go about moving it and reconfiguring mySQL to see the new location.
> >
> >Thanks
> >
> >Andy
> >
> >
> Symple... move to a different directory the data and edit the my file at:
>
> ...
> #Path to the database root
> datadir="C:/Programmi/MySQL/MySQL Server 4.1/Data/"
>
> change the datadir.
>
> That's under Win ... if you use Linux (I hope :-) ) the file, normally,
> is under /etc (my.cnf).
>
> See you
>
> Paolo
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


Thread
How to move a database to a new directoryAndy Ford28 Apr
  • Re: How to move a database to a new directoryDixie28 Apr
    • Re: How to move a database to a new directorymfatene28 Apr