From: Dominic R. <dl...@ed...> - 2010-02-26 04:33:52
|
hmm, yes I think so. First find your current [or previous, if you already made the change in setup and restarted mysqld] mysql database (i.e. directory) location, and make a note of it: /etc/init.d/mysqld stop Now make the change in setup, when this is done (and saved), and assuming that the previous mysql database location was /var: mv /var/mysql /home If you had already previously restarted mysqld after changing setup, then the above line may throw an error, if you really want to recover the pre-existing database I think mv -f should overwrite the newer /home database. Lastly do: /etc/init.d/mysqld start Dominic On 25/02/2010 22:26, Chris Grove wrote: > Thanks for that Dominic. > Just one question though, will I need to recreate the database after adding > the command?? > Thanks, Chris. > > -------------------------------------------------- > From: "Dominic Raferd"<dl...@ed...> > Sent: Thursday, February 25, 2010 6:35 PM > To:<dev...@li...> > Subject: Re: [Devil-Linux-discuss] Problem With MySQL > >> Hi Chris >> >> Run setup, choose Other / MySQL, put in settings like: >> >> --user=mysql --pid-file=/var/run/mysql.pid --datadir=/home/mysql >> >> as you see, this specifies a datadir which is in /home, which is (for >> me, and probably for you) a permanent (hard disk) location. >> >> Do: >> >> save-config -q >> /etc/init.d/mysqld restart >> >> Dominic >> >> On 25/02/2010 17:28, Chris Grove wrote: >>> Hi guys. I've got a bit of a noob problem here. I've got my DL server >>> running just nice, I've managed to get postfix and dovecot to play nice >>> too >>> and work. The problem is, when the system restarts the MySQL database >>> disappears and I have to set it all up again. Is there any way of moving >>> the >>> database so it gets backed up by the save-config command?? Either that or >>> is >>> there any way of writing a script to recreate the db after a reboot? >>> Thanks, Chris. >>> >>> >>> ------------------------------------------------------------------------------ >>> Download Intel® Parallel Studio Eval >>> Try the new software tools for yourself. Speed compiling, find bugs >>> proactively, and fine-tune applications for parallel performance. >>> See why Intel Parallel Studio got high marks during beta. >>> http://p.sf.net/sfu/intel-sw-dev >>> _______________________________________________ >>> Devil-linux-discuss mailing list >>> Dev...@li... >>> https://lists.sourceforge.net/lists/listinfo/devil-linux-discuss >> >> ------------------------------------------------------------------------------ >> Download Intel® Parallel Studio Eval >> Try the new software tools for yourself. Speed compiling, find bugs >> proactively, and fine-tune applications for parallel performance. >> See why Intel Parallel Studio got high marks during beta. >> http://p.sf.net/sfu/intel-sw-dev >> _______________________________________________ >> Devil-linux-discuss mailing list >> Dev...@li... >> https://lists.sourceforge.net/lists/listinfo/devil-linux-discuss > > > >> >> No virus found in this incoming message. >> Checked by AVG - www.avg.com >> Version: 9.0.733 / Virus Database: 271.1.1/2709 - Release Date: 02/25/10 >> 07:34:00 >> > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Devil-linux-discuss mailing list > Dev...@li... > https://lists.sourceforge.net/lists/listinfo/devil-linux-discuss |