mysqldump database name > filename (with authentication) is the best backup method. You can look up the details in the docs.
On Monday, May 27, 2013, Ian Whitfield wrote: > Hi All > > I'm now using the MySQL back-end (5.1.55) with LO Base (3.6.5.2) as my > front-end - all on PCLOS 2013. > > I've been "messing" around since late last year getting this all right, > (with lots of GREAT help from the Forum!!) > > My question now is - Where does MySQL store the Database and how do I > track it down to make a backup?? Because of all my "messing" around I have > several different files in the system that may be the right one but I'm not > sure which is which. > > I lost my whole Database at the beginning of the year when I re-installed > my OpSys so DON'T want that to happen again and need a reliable backup > method. > > Any suggestions would be most welcome. > > Thanks a lot > > IanW > Pretoria RSA > > -- > To unsubscribe e-mail to: [email protected] > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > Posting guidelines + more: http://wiki.**documentfoundation.org/** > Netiquette <http://wiki.documentfoundation.org/Netiquette> > List archive: > http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> > All messages sent to this list will be publicly archived and cannot be > deleted > > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
