On Thursday 24 March 2005 15:51, SOTL wrote: > > > First MySQL DB location issue > > > I just can not seem to get MySQL to work if I change > > > the location of the DB which requires changing > > > configuration settings. Strange. > > > > The databases are in /var/lib/mysql. Where are you > > changing them to and why would you wish to do this? > > Here you need to think like a novice not an expert. > > Simply placed with my luck I will do something which I do > not know how to fix that will crash the system. This > happens so regularly that I have long since realized that > any data I place in the same partition with the system I > will loose when I repair the system by re-installation. > Re installation has proved to be much easier than > attempting to solve some of my screw up which I am sure > anyone on the BB could and would fix in under 5 minutes > if and that is a big if the were unfortunate enough to > mack such an error to began with. I will give you an > example. A number of weeks ago and continuing for quite a > few weeks playing around with MySQL and OO I created a > number of MySQL and dBase DBs entitled test1,testxx, and > so on quite a simply forgot where I placed them. So, if > one forgets where a file is one searched. Opening old MC > I entered 'test*' as a search parameter. Final results > "good by HD'. It is now sitting here on my desk as a very > nice paper weight which since I have always wanted to > know what was inside I will maybe dissemble it to see > what I can see because that and a paper weight or a > spacer to balance out the cracked ledge of a bad table is > all it is good for. That is the worst one I have had > happen. Loose systems. How often do I play? Not as much > now as before as I lost my spare HD. Reality_Check, got > its Commic Book name simply because of my exploits, has a > drawer in it for HD and I had three now two drawers with > systems installed that I used for testing. The current > second draw has an old RH 7.0 system on it with a lot of > old data so it is an archive HD not a test bead HD. The > first HD as you probably guessed, the one with MySQL in > it, is a test for a planed network system so I definitely > do not play with it. > Hi Frank. This is the official way to do what you want: http://dev.mysql.com/doc/mysql/en/replication-howto.html
Or a simple cheap way is simply to copy /var/lib/mysql to a safe place on another computer. Or burn it to a CD-RW at regular intervals. Cheers, Steve. BTW, no need to send a separate copy to me as I'm on the list too! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
