[libreoffice-users] Re: LO Base/MySQL Backup??

Le 27/05/13 13:27, Ian Whitfield a écrit :

Hi Ian,

Note that if you are using InnoDB as your engine for your database,
simply copying the whole data directory to somewhere else in the hope of
being able to copy it back one day if everything goes pear shaped will
not work. InnoDB uses a binary log to watch for changes to the database,
and these need to be replayed when re-installing your database. There is
a whole set of dedicated information for the tools that mysql provides
specifically for this purpose and which are run from the command line.

If you can't install mysql workbench, which I understand is problematic
from a brief reading of the PCLinuxOS forum, you could always try
installing MySQLAdministrator if you can find a suitable RPM for your
system. Although this has been officially abandoned by mysql as
end-of-life (and replaced by Workbench), it can still be used fairly
reasonably.

According to this post, you can find your mysql data directory here :
/var/lib/mysql

http://www.pclinuxos.com/forum/index.php?topic=103953.0


Alex


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
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