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 <[EMAIL PROTECTED]>: > 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
