Hello,
On 2/7/2014 9:07 AM, Ian Whitfield wrote:
Sorry All
I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55
Do you know the path of the installation directory for MySQL? There
should be a my.cnf file somewhere in it. If you can't find it, you can
run "sudo find / -name my.cnf" in your terminal. Once you find the
path, open the file. You can run "sudo cat /path/to/my.cnf" (where
/path/to/my.cnf is the path you found earlier to your my.cnf file) in
your terminal. Once opened, you should find a key called "datadir,"
which has the location of the data directory for MySQL. However, MySQL
data usually has to be read by the server itself, since the data cannot
be gathered easily. You could just execute the SQL query "SELECT * FROM
database" with database being the database name.
You could move the data directory to somewhere in /home (like you asked)
and change the datadir in my.cnf. I don't know if you could move your
database to another server; maybe if the MySQL version was the same, you
could the "data" directory, but there are other files that might have to
be copied. Even transferring to a server with another operating system
could be a difficult task.
A MySQL 'expert' was telling me recently that HSQL is only meant to be
a prototyping utility and should *NEVER* be used for any "proper" work
- - interesting!!??
I can confirm that when it crashes it takes everything with it so you
have to backup every time you make change. This is what forced me to
MySQL.
Thanks again
Regards,
[email protected]
--
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
