Re: [libreoffice-users] LO Base/MySQL questions
On 02/07/2014 09:07 AM, Ian Whitfield wrote: Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 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 I had a lot of trouble a while back, so I stopped using it and started writing my own program in C++. Of course, this is time consuming, but it is something I enjoy doing. That said, I did write some things through MySQL with no problems. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] LO Base/MySQL questions
Hi All I've been using the Base/MySQL combination since mid-last year now and it is fantastic!! It is much faster, never crashes or freezes and just works the way it is supposed to. I can definitely recommend it to anyone!! (In my opinion this should be the standard and HSQL should be dropped) Now I have a couple of questions... 1) Where does MySQL store the Database? (I think it's in the root somewhere) 2) Is it easy to move it into the /home directory? 3) Where do I find the LO front-end form? 4) If I copy these two files to another machine will I be able to get the Database running on this second machine? Side question I have a couple of graphics/photos in each record - Is it possible to 'Link' these instead of embedding them so that if you up-date a photo it will automatically update in the Database? If this is possible will it effect Base at all? (faster, slower etc) Thanks for any help IanW Pretoria RSA. -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] LO Base/MySQL questions
On 02/07/2014 02:38 AM, Ian Whitfield wrote: Hi All I've been using the Base/MySQL combination since mid-last year now and it is fantastic!! It is much faster, never crashes or freezes and just works the way it is supposed to. I can definitely recommend it to anyone!! (In my opinion this should be the standard and HSQL should be dropped) The advantage of HSQL is that it creates a single file and you do not need to run a database daemon in the background (I am assuming that the MySQL connector uses that rather than knowing how to read the MySQL files directly). In other words, it does serve a need. The disadvantage of HSQL, (speculation, so assume half of what I am about to say is wrong) is that it sounds less stable, if you crash Base, it is more likely to lose data, and everything stays in memory. Now I have a couple of questions... 1) Where does MySQL store the Database? (I think it's in the root somewhere) Are you using Windows or Linux? Try looking under something like: C:\Program Files\MySQL\MySQL Server #.#\my.ini Look in that file for the basedir and datadir variables. And now I see I need to run. 2) Is it easy to move it into the /home directory? 3) Where do I find the LO front-end form? 4) If I copy these two files to another machine will I be able to get the Database running on this second machine? Side question I have a couple of graphics/photos in each record - Is it possible to 'Link' these instead of embedding them so that if you up-date a photo it will automatically update in the Database? If this is possible will it effect Base at all? (faster, slower etc) Thanks for any help IanW Pretoria RSA. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] LO Base/MySQL questions
On 02/07/2014 08:40 AM, Andrew Douglas Pitonyak wrote: On 02/07/2014 02:38 AM, Ian Whitfield wrote: Hi All I've been using the Base/MySQL combination since mid-last year now and it is fantastic!! It is much faster, never crashes or freezes and just works the way it is supposed to. I can definitely recommend it to anyone!! (In my opinion this should be the standard and HSQL should be dropped) The advantage of HSQL is that it creates a single file and you do not need to run a database daemon in the background (I am assuming that the MySQL connector uses that rather than knowing how to read the MySQL files directly). In other words, it does serve a need. The disadvantage of HSQL, (speculation, so assume half of what I am about to say is wrong) is that it sounds less stable, if you crash Base, it is more likely to lose data, and everything stays in memory. I think the other reason for using HSQL is it is easier to use as an embedded database while MySQL/MariaDB, PostgreSQL, etc. require the separate install of the database. The others are designed as stand-alone databases that one can connect to using a variety of tools. Now I have a couple of questions... 1) Where does MySQL store the Database? (I think it's in the root somewhere) Are you using Windows or Linux? Try looking under something like: C:\Program Files\MySQL\MySQL Server #.#\my.ini Look in that file for the basedir and datadir variables. And now I see I need to run. 2) Is it easy to move it into the /home directory? 3) Where do I find the LO front-end form? 4) If I copy these two files to another machine will I be able to get the Database running on this second machine? Side question I have a couple of graphics/photos in each record - Is it possible to 'Link' these instead of embedding them so that if you up-date a photo it will automatically update in the Database? If this is possible will it effect Base at all? (faster, slower etc) Storing the link to the photo should make the database query run faster because the text string is orders of magnitude smaller than the photo. One problem is one must be very carefully about naming the photos. Thanks for any help IanW Pretoria RSA. -- Jay Lozier jsloz...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] LO Base/MySQL questions
Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 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: users+unsubscr...@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
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.o...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] LO Base/MySQL questions
On 02/07/2014 09:07 AM, Ian Whitfield wrote: Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 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 Ian, I do not know if HSQL is only intended for prototyping and thus is not suitable for production work. I would say as a MySQL/MariaDB user is that HSQL is probably intended for lighter production work where a small office needs a database. In this scenario the data requirements are modest, maybe a couple GB of data, but their data is complex enough to need the querying features of a relational database. -- Jay Lozier jsloz...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] LO Base/MySQL questions
Hello, This instability of HSQL is worrying when using the same database year after year, e.g. an address or a bibliographic database. For my part, all my data remain in separate external tables in dbf format, linked to Base. Reasons are: - compatibility with many programmes and readability of old archives, even in case of change of database program ; - stability in the long run; - format compatible with GIS software; - when the tables are not merged in one file, the loss is limited when one of the tables gets corrupted. The main drawback is the impossibility to make a relational database. In fact, the good integration of the office suite with a database was one of the main reason's why I began to use OO in 2007 or 2008. To my great satisfaction indeed: it works very well, except for two instances, several years ago, where the dbf file got corrupted (luckily, recovery from backups was easy). Since then it works fine without any failure (except, rarely, for some data in memo fields, which can lose the right connection with other data (dbt file connection to dbf file)). Nevertheless, the impossibility of making relations between tables is rather frustrating. One solution is to migrate to a mySQL/Base or preferably Postgresql (because of PostGIS). It's my intention but I fear to waste a lot of time in migrating. What is the best combination for a single user, relational database, stable in the long run, using Base as the front end? Paul Lens Le 7/02/2014 15:07, Ian Whitfield a écrit : Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 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: users+unsubscr...@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
Re: [libreoffice-users] LO Base/MySQL questions
On 02/07/2014 10:29 AM, Lens Paul wrote: Hello, This instability of HSQL is worrying when using the same database year after year, e.g. an address or a bibliographic database. For my part, all my data remain in separate external tables in dbf format, linked to Base. Reasons are: - compatibility with many programmes and readability of old archives, even in case of change of database program ; - stability in the long run; - format compatible with GIS software; - when the tables are not merged in one file, the loss is limited when one of the tables gets corrupted. The main drawback is the impossibility to make a relational database. In fact, the good integration of the office suite with a database was one of the main reason's why I began to use OO in 2007 or 2008. To my great satisfaction indeed: it works very well, except for two instances, several years ago, where the dbf file got corrupted (luckily, recovery from backups was easy). Since then it works fine without any failure (except, rarely, for some data in memo fields, which can lose the right connection with other data (dbt file connection to dbf file)). Nevertheless, the impossibility of making relations between tables is rather frustrating. One solution is to migrate to a mySQL/Base or preferably Postgresql (because of PostGIS). It's my intention but I fear to waste a lot of time in migrating. What is the best combination for a single user, relational database, stable in the long run, using Base as the front end? Paul Lens Paul PostgreSQL and MySQL/MariaDB are good alternatives. MariaDB is a fork of MySQL and many Linux distros install it instead of MySQL. Both can be used as a single user database. IMHO MariaDB is easier to use in a single user environment. With both you can use Base or database specific GUI (pgAdmin, MySQL Workbench). If the data can be exported to csv files migrating should not be difficult, only time consuming. Jay Le 7/02/2014 15:07, Ian Whitfield a écrit : Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 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 -- Jay Lozier jsloz...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] LO Base/MySQL questions
Hi :) A quick back of an envelope risk-analysis might suggest that although the effects can be fairly devastating the likelihood of that occurring is fairly low so it might be acceptable. It might be something like that which led Ian's MySql expert to say it was fine only for proto-typing, or it might be that the expert needs people to all move to MySql and has a sales-pitch against each different type of other non-MySql program. The argument against MariaDb might be that it doesn't work on Macs. The LO marketing team keep insisting on pretending that the internal database is ok. Most of the rest of us seem to have to pick up the pieces when/if that goes wrong so we seem to generally advise people to move to an external back-end asap (within reason). However it's very rare that people do run into the problem so maybe it is being over-stated. Plus, how hard can it be to back-up a single file! On the other hand the effects are TOO devastating and far beyond what most of us on this list would find acceptable Just to add 2 extra layers of complexity 1. the internal (embedded) database 'back-end' is apparently likely to be switched from Hsql to something else 'soon'. 2. Hsql is a separate 3rd party project and it's possible to download and install their latest version on 'your computer' (or server or anything) and use that in much the same way you use any other external back-end. Apparently the only reason the the internal back-end is sometimes unstable is because Sun paid-devs insisted on locking in a now ancient version and they heavily tweaked it. Apparently this was fine back in the day but nowadays means that the internal back-end is. Also apparently when the neweruntweaked versions of Hsql are being used as an external back-end then it's quite excellent and very stable. So i don't think it's really fair to blame Hsql. It's be a bit like saying that OOo 1.0 is a bit ancient and not great nowadays. Regards from Tom :) On 7 February 2014 15:44, Jay Lozier jsloz...@gmail.com wrote: On 02/07/2014 10:29 AM, Lens Paul wrote: Hello, This instability of HSQL is worrying when using the same database year after year, e.g. an address or a bibliographic database. For my part, all my data remain in separate external tables in dbf format, linked to Base. Reasons are: - compatibility with many programmes and readability of old archives, even in case of change of database program ; - stability in the long run; - format compatible with GIS software; - when the tables are not merged in one file, the loss is limited when one of the tables gets corrupted. The main drawback is the impossibility to make a relational database. In fact, the good integration of the office suite with a database was one of the main reason's why I began to use OO in 2007 or 2008. To my great satisfaction indeed: it works very well, except for two instances, several years ago, where the dbf file got corrupted (luckily, recovery from backups was easy). Since then it works fine without any failure (except, rarely, for some data in memo fields, which can lose the right connection with other data (dbt file connection to dbf file)). Nevertheless, the impossibility of making relations between tables is rather frustrating. One solution is to migrate to a mySQL/Base or preferably Postgresql (because of PostGIS). It's my intention but I fear to waste a lot of time in migrating. What is the best combination for a single user, relational database, stable in the long run, using Base as the front end? Paul Lens Paul PostgreSQL and MySQL/MariaDB are good alternatives. MariaDB is a fork of MySQL and many Linux distros install it instead of MySQL. Both can be used as a single user database. IMHO MariaDB is easier to use in a single user environment. With both you can use Base or database specific GUI (pgAdmin, MySQL Workbench). If the data can be exported to csv files migrating should not be difficult, only time consuming. Jay Le 7/02/2014 15:07, Ian Whitfield a écrit : Sorry All I'm running PClinuxOS (latest) and LO 4.1.2.3 and MySQL 5.1.55 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 -- Jay Lozier jsloz...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?
