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"
on Unix, you have symbolic links.
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.
> 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
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1