Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

On 2/7/2014 9:07 AM, Ian Whitfield wrote:
Sorry All

I'm running PClinuxOS (latest) and LO 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


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.