Re: [libreoffice-users] Base Compact and Shutdown
Even if it existed, I would be quite surprised if such a thing is necessary for MySQL. Looking through the (5.1) manual, the only references to compact (as a verb) as to do with dumping data and a storage structure option. There is nothing (that I can see) listed for it as a shutdown option. It's the difference between an embedded database file and a database engine. MySQL is a database engine. You only need to send it requests and get answers back from it. Otherwise it does all its own housekeeping and management. You don't tell it to compact its data. Regards Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@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] the Ultimate Safe Computing Environment or not ; -)
Hi :) It's a classic reinventing the wheel. Customised LiveCds have the same functionality except the reinvention appears to have stripped out anything useful and then put back only 1 or 2 things you might need. Almost every distro nowadays has a LiveCd session that you can run either from a special Cd/Dvd or from the installer Cd/Dvd. Typically a LiveCd (or Dvd) has a full range of useful programs rather than just 1 or 2. The bit at the end of the article made me laugh. LiveCds are not noted for their speed. Cd/Dvd drives typically run about 1,000 times slower than a hard-drive. Typically they mitigate against that by loading as much as possible into Ram, assuming the machine has enough Ram. Some distros are so stripped down that they can entirely run from Ram and after booting the LiveCd you can take the Cd out. That's one reason i like SliTaz (a French distro) and Trinity Rescue Kit (although that is 'just' for repairing broken Windows and stuff (actually it does some other pretty cool things such as backups and networking things and stuff)) LiveUsbs are MUCH faster and they are easier if you want to have a persistent image that remembers settings and configurations from one session to the next. Of course using the persistent image slightly decreases the security aspect because it can remember stuff. Regards from Tom :) - Original Message - From: anne-ology lagin...@gmail.com To: users@global.libreoffice.org Cc: Sent: Monday, 31 December 2012, 3:18 Subject: [libreoffice-users] the Ultimate Safe Computing Environment or not ;-) seems to have more cons than pros - http://www.techsupportalert.com/content/brilliant-tool-could-be-ultimate-safe-computing-environment.htm?utm_source=feedburnerutm_medium=emailutm_campaign=Feed%3A+gizmosbest+%28Gizmo%27s+Best-ever+Freeware%29 Just wondering what your thoughts were ;-) -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Base Compact and Shutdown
On 12/31/2012 03:26 AM, Mark Stanton wrote: Even if it existed, I would be quite surprised if such a thing is necessary for MySQL. Looking through the (5.1) manual, the only references to compact (as a verb) as to do with dumping data and a storage structure option. There is nothing (that I can see) listed for it as a shutdown option. It's the difference between an embedded database file and a database engine. MySQL is a database engine. You only need to send it requests and get answers back from it. Otherwise it does all its own housekeeping and management. You don't tell it to compact its data. Regards Mark Stanton One small step for mankind...compact From the MySQL Reference Manual 5.1: InnoDB tables use a compact storage format. In versions of MySQL earlier than 5.0.3, InnoDB rows contain some redundant information, such as the number of columns and the length of each column, even for fixed-size columns. By default, tables are created in the compact format (ROW_FORMAT=COMPACT). If you wish to downgrade to older versions of MySQL, you can request the old format with ROW_FORMAT=REDUNDANT. I also noticed that mysqldump--compact is used on the command line. There are some known bugs when using this to backup the database that are also listed in the reference manual. Personally, I would use MySQL Administrator for the administrative duties databases require when using MySQL 5.1. For MySQL 5.6 which is also available, MySQL Workbench serves the same purpose. (MySQL Navigator 5.6 can perform some duties such as create new databases and their tables.) --Dan -- For unsubscribe instructions e-mail to: users+h...@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] Calc moves charts to top left corner
try to change the 'anchor' attribute; click out of the graph, then right click on the graph and choose 'anchor'; try to change and move, otherwise report a bug. From: Freezer suppor...@ex-fathers.org To: users@global.libreoffice.org Sent: Monday, December 31, 2012 4:03 PM Subject: [libreoffice-users] Calc moves charts to top left corner I set up charts so they're all nicely spread out on the sheet. However, when I save the file and then reopen it the charts all end up on top of each other in the top left corner of the sheet. This even happens if I set the position to fixed. It also happens regardless of whether the charts are on the same sheet as the data or on a separate sheet. Any idea of why my charts are moving or how I can stabilize them? -- View this message in context: http://nabble.documentfoundation.org/Calc-moves-charts-to-top-left-corner-tp4026704.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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] Re: Calc moves charts to top left corner
Solved. Thanks Paolo for the quick response. 'Anchored' to 'page' works nicely. -- View this message in context: http://nabble.documentfoundation.org/Calc-moves-charts-to-top-left-corner-tp4026704p4026716.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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] the Ultimate Safe Computing Environment or not ;-)
Thank you for the detailed reasons behind this; makes me feel slightly smarter as to these 'glorified typewriters' ;-) On Mon, Dec 31, 2012 at 5:22 AM, Tom Davies tomdavie...@yahoo.co.uk wrote: Hi :) It's a classic reinventing the wheel. Customised LiveCds have the same functionality except the reinvention appears to have stripped out anything useful and then put back only 1 or 2 things you might need. Almost every distro nowadays has a LiveCd session that you can run either from a special Cd/Dvd or from the installer Cd/Dvd. Typically a LiveCd (or Dvd) has a full range of useful programs rather than just 1 or 2. The bit at the end of the article made me laugh. LiveCds are not noted for their speed. Cd/Dvd drives typically run about 1,000 times slower than a hard-drive. Typically they mitigate against that by loading as much as possible into Ram, assuming the machine has enough Ram. Some distros are so stripped down that they can entirely run from Ram and after booting the LiveCd you can take the Cd out. That's one reason i like SliTaz (a French distro) and Trinity Rescue Kit (although that is 'just' for repairing broken Windows and stuff (actually it does some other pretty cool things such as backups and networking things and stuff)) LiveUsbs are MUCH faster and they are easier if you want to have a persistent image that remembers settings and configurations from one session to the next. Of course using the persistent image slightly decreases the security aspect because it can remember stuff. Regards from Tom :) From: anne-ology lagin...@gmail.com To: users@global.libreoffice.org Sent: Monday, 31 December 2012, 3:18 Subject: [libreoffice-users] the Ultimate Safe Computing Environment or not ;-) seems to have more cons than pros - http://www.techsupportalert.com/content/brilliant-tool-could-be-ultimate-safe-computing-environment.htm?utm_source=feedburnerutm_medium=emailutm_campaign=Feed%3A+gizmosbest+%28Gizmo%27s+Best-ever+Freeware%29 Just wondering what your thoughts were ;-) -- For unsubscribe instructions e-mail to: users+h...@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] the Ultimate Safe Computing Environment or not ;-)
Thanks for your comments; so I'm assuming that with Linux, this is a good system ;-) On Mon, Dec 31, 2012 at 7:10 AM, James Knott james.kn...@rogers.com wrote: anne-ology wrote: seems to have more cons than pros - http://www.techsupportalert.**com/content/brilliant-tool-** could-be-ultimate-safe-**computing-environment.htm?utm_** source=feedburnerutm_medium=**emailutm_campaign=Feed%3A+** gizmosbest+%28Gizmo%27s+Best-**ever+Freeware%29http://www.techsupportalert.com/content/brilliant-tool-could-be-ultimate-safe-computing-environment.htm?utm_source=feedburnerutm_medium=emailutm_campaign=Feed%3A+gizmosbest+%28Gizmo%27s+Best-ever+Freeware%29 Just wondering what your thoughts were ;-) Live Linux CDs have been around for quite a while and are often used for just this purpose. It means you have a known good system, that's free of malware. As mentioned in the article, you can also install on a USB pen drive. -- For unsubscribe instructions e-mail to: users+h...@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] calculating time differences
Hi there I need to calculate several videos duration having initial and final time in hh:mm:ss.000 format. But even if such format is set as a custom one just got a #VALUE! message. Is possible to achieve that task or need to look for an alternative way to find out? Regards in advance and wish you all have a very nice 2013 beggining. -- For unsubscribe instructions e-mail to: users+h...@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] calculating time differences
On 12/31/2012 02:20 PM, Daniel A. Rodriguez wrote: Hi there I need to calculate several videos duration having initial and final time in hh:mm:ss.000 format. But even if such format is set as a custom one just got a #VALUE! message. Is possible to achieve that task or need to look for an alternative way to find out? Regards in advance and wish you all have a very nice 2013 beggining. Are you using Calc to do this? If not what are you using? How are you setting up your calculations? When you created the time format, how did you do it? (I need a step by step description.) I opened Calc and formated column A with HH:MM:SS.000 in the Format code box. Then I clicked the green check. What I saw in the Format list was 13:37:46.000. Then I entered times in A1 and A2. Finally I entered =A1-A2 in A3. I got an answer in the format I had created for column A. --Dan -- For unsubscribe instructions e-mail to: users+h...@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] calculating time differences
Hi there I need to calculate several videos duration having initial and final time in hh:mm:ss.000 format. But even if such format is set as a custom one just got a #VALUE! message. Is possible to achieve that task or need to look for an alternative way to find out? Regards in advance and wish you all have a very nice 2013 beggining. Are you using Calc to do this? If not what are you using? How are you setting up your calculations? When you created the time format, how did you do it? (I need a step by step description.) I opened Calc and formated column A with HH:MM:SS.000 in the Format code box. Then I clicked the green check. What I saw in the Format list was 13:37:46.000. Then I entered times in A1 and A2. Finally I entered =A1-A2 in A3. I got an answer in the format I had created for column A. Hi Dan, thanks for the quick response I found the problem, my locale setting does not recognize the '.' as decimal separator. So, replacing it witch a ',' did the trick. :-) -- For unsubscribe instructions e-mail to: users+h...@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