Re: [libreoffice-users] LO Base/MySQL questions

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,
xmlhttprequest.open@gmail.com

--
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