On Wed, 2024-10-30 at 17:43 +0100, Robert Großkopf wrote:
> Hi Harvey,
> >
> > Interestingly, exporting the 'virgin' report file as pdf retains
> > the
> > 'tick'/blank/minus symbols.
>
> You could also add UTF-8-Symbols. I do this in forms for Buttons.
> Something like ✅ (U+2705)🛑 (U+1F6D1) …
>
You will need to research documentation for mariadb syntax / functions,
I'm not familiar with it.
Base query editor will complain on SQL that is non-compliant to hsqldb,
but there is a "Passthrough" (or maybe "Native SQL") option on the query
editor that you can use to silence the Base parser and
Hi Harvey,
Interestingly, exporting the 'virgin' report file as pdf retains the
'tick'/blank/minus symbols.
You could also add UTF-8-Symbols. I do this in forms for Buttons.
Something like ✅ (U+2705)🛑 (U+1F6D1) …
Regards
Robert
--
Homepage: http://www.familiegrosskopf.de/robert
--
To unsub
Per my experience the - signs are likely null value. A boolean control
cycles through True / False / Null unless you specifically disable null.
On 10/30/24 11:25, Harvey Nimmo wrote:
Interestingly, exporting the 'virgin' report file as pdf retains the
'tick'/blank/minus symbols.
--
To unsubsc
On Wed, 2024-10-30 at 15:08 +0100, Robert Großkopf wrote:
> Hi Harvey,
>
> do ist this way:
>
> IF([myBitField];"yes";"no")
>
> OR
>
> IF([myBitField];"☒";IF(ISBLANK([myBitField]);"-";"□"))
>
> Add this code in Data → Datafield. Write the name of the field inside
> the brackets []
>
> Regards
On Wed, 2024-10-30 at 15:13 +0100, Robert Großkopf wrote:
> Hi Harvey,
>
> for using AutoGrow:
>
> 1. All fields in one row should have the same height and the same
> y-start. So it will become a row in the table, which will be created
> by
> ReportBuilder in Writer. Default height for every fi
Hi Harvey,
for using AutoGrow:
1. All fields in one row should have the same height and the same
y-start. So it will become a row in the table, which will be created by
ReportBuilder in Writer. Default height for every field is 0.5 cm here.
2. Mark the first field in the row as AutoGrow → Ye
Hi Harvey,
do ist this way:
IF([myBitField];"yes";"no")
OR
IF([myBitField];"☒";IF(ISBLANK([myBitField]);"-";"□"))
Add this code in Data → Datafield. Write the name of the field inside
the brackets []
Regards
Robert
--
Homepage: http://www.familiegrosskopf.de/robert
--
To unsubscribe e-m
Thanks! I suspected it might be be something like that.
I am using LOBase with a mariadb backend, so I an not sure how that
should be handled. In any case, the Query GUI does not like my formula
as is.
Cheers
Harvey
On Wed, 2024-10-30 at 08:13 -0400, Java Joe wrote:
> I have not tested, but wou
I have a report field that contains the following data Value
=[Ort1]&IF(NOT(ISBLANK([Ort2]));UNICHAR(13)&UNICHAR(10)&[Ort2];"")&IF(N
OT(ISBLANK([Ort3]));UNICHAR(13)&UNICHAR(10)&[Ort3];"")&IF(NOT(ISBLANK([
Staat]));UNICHAR(13)&UNICHAR(10)&[Staat];"")
As the field from the attached database query m
I have not tested, but would suspect it is evaluating the length of the
formula rather then the length of the content the formula produces.
If your data source is a query it should be possible to produce the
string you want in the query, then just reference the field instead of
using a formula.
I have a table in LO Base containing a number of fields of type
Yes/No[BIT]. A value entered in such a field appears as a 'tick',
(toggling between blank and 'tick') (By the way, 'minus' sign seems
also to be alternatively equivalent to a blank)
A report containing these tick values appears, as wa
Yes that works, too. I notice that Base strips off the 'AS' keywords.
Cheers
Harvey
On Tue, 2022-08-16 at 16:02 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
> tested this:
>
> SELECT COALESCE ( `User`, 'Empty' ) AS `User`, COUNT( `ID` ) FROM
> `test`.`User` AS `User` GROUP BY `User`
>
> You
Hi Harvey,
tested this:
SELECT COALESCE ( `User`, 'Empty' ) AS `User`, COUNT( `ID` ) FROM
`test`.`User` AS `User` GROUP BY `User`
You don't need to change the alias for `Location` to `Loc`.
I could save this, open this to edit in GUI, execute it - no Problem
with direct connection on MariaDB
Just one remark on this, though. The GUI and SQL Edit views seem not to
be consistent with each other. Just opening the Query to Edit GUI,
adjusting the pane size (say) and saving the result, destroys the
query.
Cheers
Harvey
On Tue, 2022-08-16 at 10:54 +0200, Harvey Nimmo wrote:
> Thank you, R
Thank you, Robert! As always on target.
This is better than filling the Location fields with some unneeded
value. Great stuff. Man lernt nie aus!
Cheers
Harvey
On Tue, 2022-08-16 at 10:15 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > SELECT `Location`, COUNT( `Location` ) FROM
> > `Item
Hi Harvey,
SELECT `Location`, COUNT( `Location` ) FROM `Item_Management`.`Items`
`Items` GROUP BY `Location`
The result is correct for all LOCATIONS that are not empty, but
surpisingly the blank field for the empty locations is accompanied by
the value 0. How can I get the right count for the
I have a table consisting of (unique) ITEMS and with a column LOCATION
for the land of origin of the ITEMS. Some LOCATION fields are still
empty.
A query counts the number entries in the LOCATION column for each
country present. Essentially the GUI just shows the functions LOCATION
'group' and LOC
Hi John,
...
MySQL/MariaDB with different drivers will be a new thread - or
shouldn't we try it per private mail?
...
Robert, I have only been following this thread as a lurker, not
contributor, but if I may offer a view on that question: I'm surely not
the only person finding this thread e
On 2022-08-12 12:44, Robert Großkopf wrote:
...
MySQL/MariaDB with different drivers will be a new thread - or shouldn't we try
it per private mail?
...
Robert, I have only been following this thread as a lurker, not contributor,
but if I may offer a view on that question: I'm surely not the
Hi Harvey,
MySQL/MariaDB with different drivers will be a new thread - or shouldn't
we try it per private mail?
Which connector do you use? (MySQL or MariaDB? If MySQL: which version?)
Regards
Robert
--
Homepage: http://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+unsu
Hi Robert,
I have chosen the configuration LO-Base front ent to Mariadb backend
becuase of the advantage of database server with Terrabytes of disk
space.
But I am wondering seriously whether I have made a good choice. There
seem to be serious compatibilty problems between them in spite of the
Hi Harvey,
OK. Thanks, Robert. That is more or less the conclusion that I had come
to. Not very user-friendly, but it works.
Reason for this behavior might be you are using a server database for
many users. Have had a look with PHPMyAdmin. Couldn't edit the view
there also.
Regards
Robert
OK. Thanks, Robert. That is more or less the conclusion that I had come
to. Not very user-friendly, but it works.
Cheers
Harvey
On Fri, 2022-08-12 at 08:36 +0200, Robert Großkopf wrote:
> Hi Harvey,
> >
> > I cannot confirm the Firebird icon. My database backend is
> > MySQL(JDBC),
> > (actually
Hi Harvey,
I cannot confirm the Firebird icon. My database backend is MySQL(JDBC),
(actually Mariadb). I prefer to continue for the time being with the
OpenSUSE packages delivered with my Linux Leap 15.4.
Editing views with external databases won't work. It's the same behavior
for every other
Hi Robert,
I cannot confirm the Firebird icon. My database backend is MySQL(JDBC),
(actually Mariadb). I prefer to continue for the time being with the
OpenSUSE packages delivered with my Linux Leap 15.4.
Cheers
Harvey
On Thu, 2022-08-11 at 18:06 +0200, Robert Großkopf wrote:
> Hi Harvey,
>
>
Hi Harvey,
LO won't be installed without internal HSQLDB. But with that behavior
you reported you are using internal Firebird. Will be shown at the
bottom of the window in statusbar.
You are using packages from your distribution, not from LO directly.
Have tested the same version you are usi
Hi Robert,
Thanks, so far...;-) I understand that a View would be more efficient
in execution than the equivalent query. And this seems to be more or
less the practical extent of justification for view over query.
My version:
Version: 7.3.4.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU thre
Hi Harvey,
I'm unsure of the practical implications of the difference between Base
implementation of Views and Queries. Perhaps someone can enlighten me.
One thing, however, does hit me.
Views will be executed in the database. The content will look for Base
like a non-writable table. You coul
I'm unsure of the practical implications of the difference between Base
implementation of Views and Queries. Perhaps someone can enlighten me.
One thing, however, does hit me.
Initial design of a View with the GUI, is done similar to a Query,
which is OK. However, when the View is stored, then fur
On Thu, 2019-12-12 at 20:28 +0100, Robert Großkopf wrote:
> Hi Harvey
> >
> > I was just about to answer that I had tried that and it did not
> > work,
> > until I noticed your square brackets []. That did the trick!! You
> > are
> > wonderful.
> >
> > But where is that documented?
>
> Don't kno
Hi Harvey
>
> I was just about to answer that I had tried that and it did not work,
> until I noticed your square brackets []. That did the trick!! You are
> wonderful.
>
> But where is that documented?
Don't know wher I found it, when I created the Base-Handbook. But have a
lokk for the English
On Thu, 2019-12-12 at 19:46 +0100, Robert Großkopf wrote:
> Hi Harvey,
>
> try this:
> Write into Data > Data field
>
> IF([NameOfBoolField];"y";"n")
>
> Regards
>
> Robert
> --
> Homepage: http://www.familiegrosskopf.de/robert
Hi Robert,
I was just about to answer that I had tried that and
Hi Harvey,
try this:
Write into Data > Data field
IF([NameOfBoolField];"y";"n")
Regards
Robert
--
Homepage: http://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubs
I wonder if anyone knows how to solve this little problem?
I am trying to construct a report from a Table/Query in Base. Amongst
other data there are five boolean flags (Type Yes/No[BIT] to be printed
from each record.
Thinking that it would take up too much space on the paper together
with the l
Hi Noel,
> I am transferring an H2 database from a Windows PC to a late model Apple
> Mac, (Capitan 10.11.6). On the main Base window, the Tables are all
> displaying normally, but nothing shows up under Queries, Forms or Reports.
Did you create queries, forms and reports for the database in a
B
I am transferring an H2 database from a Windows PC to a late model Apple
Mac, (Capitan 10.11.6). On the main Base window, the Tables are all
displaying normally, but nothing shows up under Queries, Forms or Reports.
I've hunted through all LO's options, but I can't find any setting that
might be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Dave,
>
> I'm involved in a project that will produce a dataset as its
> product. I'm considering using LO base so as to avoid vendor
> lock-in. I've found a base document from 2014 that seems promising,
> is there a more up-to-date place to start
Hi,
I'm involved in a project that will produce a dataset as its product.
I'm considering using LO base so as to avoid vendor lock-in. I've
found a base document from 2014 that seems promising, is there a more
up-to-date place to start reading?
Also the dataset is likely to be subsequentl
> I have recently read that Open Office no longer uses HSQL. Is that also
true of LO?
If a new Base is created in LO 5.1.x it will be default is "HSQLDB
Embedded" to store the data.
> is it really necessary to have another database product to do database
work in LO Base?
Not necessarily, but this
I have a question about Base:
I used to work with standalone HSQLDB using Java on the OS/2 (eCS)
platform. During that time, it was announced that Sun's upcoming
release of Open Office would include HSQL as the builtin database
engine. I have recently read that Open Office no longer uses HSQ
Hi :)
Sorry you have not had any responses so far. Hopefully someone might be
able to help in a while. Sometimes it is a good idea to "bump the thread"
(which my reply here will do) in order to get your question back to the top
of the mailing list.
Regards from
Tom :)
On 26 June 2016 at 15:20,
Hi all
I'm trying to use LO Base - linked to a Spreadsheet and so far all is
going well.
However I don't seem to be able to get Dropdown Boxes to work. On my
'User Form' they are greyed out and do not react when clicked. I have
set them to be Dropdown, entered the list of options and set the d
Hello list,
me too would like to have a reconnect:
When LO-Base the first connection to a dBase
database (directory) has made, all the existing *.dbf files in that directory
are recognized and shown as tables in *.odb.
However, if you add manually or by a third party program another *.dbf, it
Hello,
Thanks for the quick replies. Some points...
Disconnecting/Reconnecting the MySQL server from LO-DB is not really a
work-around. Essentially confirming the displayed message mentioned (i.e.
"The last package sent to the server...") with just one click is in my
opinion more efficient, althou
Hi :)
That might be another neat work-around, perhaps as a 'temporary' system
while waiting for more devs to join in with working on Base.
Regards from
Tom :)
On Wednesday, 27 January 2016, Dries Feys wrote:
> Hello Heinrich,
>
> I never used Base, though for other projects I use MySQL and oth
Hi :)
If you haven't already done so then posting this idea as a "feature
request" would be a really good way forwards. Unfortunately not many devs
dare take on the challenge of working with Base. So the next step might be
to promote it somewhere, preferably in a few different places. This
maili
Hello Heinrich,
I never used Base, though for other projects I use MySQL and other db's.
As a workaround, I wonder whether it is possible to disconnect the
database from within LO after each query? Then, you should be able to
reconnect when a new query is requested. This also has the advantage
you
Hello,
I have been an avid user of LO/OO-Base for years, using it to connect to a
MySQL database for everyday work --- couldn't do without it. I am convinced
that a good connection to a DB-backend like MySQL/MariaDB is essential for
LO to be successful in a "real" business environment.
As I have m
Hello,
I have been using OO/LO for more than a decade now and have liked it most of the
time. At the moment I have to print labels from a MySQL database connected
through
JDBC. My system is Linux-Mint 17.2 and LO 5.0.2. I also use the same LO version
on a Debian 8 and Windows 7 system. I have the
On 18/02/2015 15:23, Ian Whitfield wrote:
*Hi All*
I have been rebuilding/revamping my Database over the past few weeks
and everything has been going great.
I'm using LO 4.3.5.2 and MySQL 5.1.73 on PClinuxOS (latest).
Yesterday I found I had not set my Keyfield (RecordID) to Auto
Increment
*Hi All*
I have been rebuilding/revamping my Database over the past few weeks and
everything has been going great.
I'm using LO 4.3.5.2 and MySQL 5.1.73 on PClinuxOS (latest).
Yesterday I found I had not set my Keyfield (RecordID) to Auto Increment
so I set a new field with phpMyAdmin called
Hey Y'all,
I'm following directions in GS40-GettingStartedLO Chapter 8. I created
a new database, and then created the Fuel table per the instructions.
I saved the table and the database, then closed the database.
When I open the database, and click on the Tables icon I get this error:
The con
On 2/10/2014 9:20 AM, Andrew Douglas Pitonyak wrote:
I have seen nothing that indicates that you cannot use Maria DB as a
drop-in replacement for MySQL at this point.
Last I tried it was with Drupal 7. It just worked. I expect the same for
Base, if it is not so, file a bug report against Maria D
I have seen nothing that indicates that you cannot use Maria DB as a
drop-in replacement for MySQL at this point.
Last I tried it was with Drupal 7. It just worked. I expect the same for
Base, if it is not so, file a bug report against Maria DB.
--
Andrew Pitonyak
My Macro Document: http://ww
Hi,
MariaDB is compatible with MySQL, the MySQL connectors, and MySQL API
and is designed to be a drop-in replacement for MySQL. I have connected
to MariaDB using the LO provided MySQL connector on earlier versions of
LO. I have not done so with 4.1.X yet.
Jay
On 02/09/2014 03:16 PM, Tom Dav
Hi :)
I think we have heard from people who have tried it. I think Ian or
someone started with MySql and then swapped it out replacing it with
MariaDb. I'm not sure but i think there might be a problem with
MariaDb on Mac but if you are not using a Mac then it should be fine.
Regards from
Tom :)
On 02/09/2014 12:00 PM, Joel Madero wrote:
On 02/09/2014 11:38 AM, Harvey Nimmo wrote:
Can I use Mariadb as back-end for LO Base or must it be MySQL? For
example, are the connectors compatible or is there a Mariadb-specific
connector?
Cheers
Harvey
Looks like it's possible -
http://ask.libr
On 02/09/2014 11:38 AM, Harvey Nimmo wrote:
> Can I use Mariadb as back-end for LO Base or must it be MySQL? For
> example, are the connectors compatible or is there a Mariadb-specific
> connector?
>
> Cheers
> Harvey
>
>
Looks like it's possible -
http://ask.libreoffice.org/en/question/18521/how-t
Can I use Mariadb as back-end for LO Base or must it be MySQL? For
example, are the connectors compatible or is there a Mariadb-specific
connector?
Cheers
Harvey
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how
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 confi
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
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:
- compati
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
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 conf
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"
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 wi
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 def
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 sho
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
droppe
Hi All
I've had some success at last!!
Using Shane Piper's Tutorial at
http://www.youtube.com/watch?v=TcudVETPePY I have got my sub-Forms
working fine.
My last problem was with Opening a Form with a Button and again Shane
has a Tutorial on this at http://www.youtube.com/watch?v=9Zmd-zidIvg
I would suggest you study an application that uses a main and sub form.
I used the Business Cards example from
http://forum.openoffice.org/en/forum/viewforum.php?f=100
Good luck
On Tuesday 15 Oct 2013 14:09:59 Ian Whitfield wrote:
> Hi All
>
> I'm still stuck with LO Base Sub Forms!! I'v
On 15/10/13 22:41, Andrew Douglas Pitonyak wrote:
If I remember correctly (and I have not looked at this in a while), I
think that you need to link the "master and slave fields".
So, if you open your form in edit mode, load the form navigator, right
click on your sub-form and choose propertie
If I remember correctly (and I have not looked at this in a while), I
think that you need to link the "master and slave fields".
So, if you open your form in edit mode, load the form navigator, right
click on your sub-form and choose properties, navigate to the Data tab,
do the values in the
Hi All
I'm still stuck with LO Base Sub Forms!! I've been at this for some
time, off and on, but over the past few months I have been very busy
converting, editing and checking/updating my DB to now run on MySQL.
I must say it is a GREAT improvement!!
OK - My OpSys is PClinuxOS 2012-10. LO 4
In short the message you get tells you that the macro that the button is
linked to cannot be found. Then it tells you where it is looking for the
macro. If you look closer at this it is looking for the macro that is
located within the document and has the path Standard.Story.OpenForm. Is
the ma
Hi All
After some time working on other aspects of my Database I'm back to
trying to get a Pushbutton working to open a SubForm.
PClinuxOS 2013.08; LO Base 4.1.1.2; MySQL 5.1.55
My Database - "FSNew"
Tables - "Members" & "Story"
Forms - "FSNew.Members" & "FSNew.Story"
The Pushbutton on the M
Thanks to Andrew and Mark for their input
I thought about this over the past few days and did not want to wind
back to the earlier version of LO and have the problem of getting the
"link" to my SQL Database working again.
So yesterday afternoon I came up with a Workround!! I converted all the
On 09/06/2013 02:16 AM, Ian Whitfield wrote:
> Hi Andrew
>
> On 05/09/13 23:09, Andrew Douglas Pitonyak wrote:
>> Is it possible that the form is in edit mode? As in, you are editing
>> the control? It is a long shot guess...
>>
>> On 09/05/2013 04:47 AM, Ian Whitfield wrote:
>>> Hi All
>>>
>>> I
Hi Andrew
On 05/09/13 23:09, Andrew Douglas Pitonyak wrote:
Is it possible that the form is in edit mode? As in, you are editing
the control? It is a long shot guess...
On 09/05/2013 04:47 AM, Ian Whitfield wrote:
Hi All
I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just
up
Is it possible that the form is in edit mode? As in, you are editing the
control? It is a long shot guess...
On 09/05/2013 04:47 AM, Ian Whitfield wrote:
Hi All
I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just
upgraded my LO Office to 4.1.2.
Everything seems to be fine
EX
FIRST POST DID NOT SEEM TO GET THROUGH - RE-SENDING ...
Hi All
I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just
upgraded my LO Office to 4.1.2.
Everything seems to be fine
EXCEPT
The Check Boxes in my LO Form no longer work - you can not edit them or
add to them. If yo
Hi All
I use here PClinuxOS 2013 (up-to-date), My SQL 5.1.55 and have just
upgraded my LO Office to 4.1.2.
Everything seems to be fine
EXCEPT
The Check Boxes in my LO Form no longer work - you can not edit them or
add to them. If you click on one a tick appears in the box but as you
select S
Hi Ian,
Ive been reading the posts concerning the security of your database using
mysqldump. Are you using a remote server for your MySQL, or is it on your
own computer?
I've completed a database using LO Base with embedded HSQL. I guess I can
use a MySQL server on my own machine to which I can con
dmonds ; Wolfgang Keller <
> felip...@gmx.net>; "users@global.libreoffice.org" <
> users@global.libreoffice.org>
> >Sent: Thursday, 30 May 2013, 18:47
> >Subject: Re: [libreoffice-users] LO Base/MySQL Backup??
> >
> >
> >Sajan & Steve,
> >
. Some valuable
insights there! :)
Thanks and regards from
Tom :)
>
> From: Girvin R. Herr
>To: Sajan Parikh
>Cc: Steve Edmonds ; Wolfgang Keller
>; "users@global.libreoffice.org"
>
>Sent: Thursday, 30 May 2013, 18:47
&
Sajan & Steve,
Thanks. I will have to look at this as an alternate possibility.
I didn't mean to criticize, but I take computer security seriously and
when I see a vulnerability, I tend to bring it to the person's
attention. There are far too many people out there who take computer
security n
I don't see the security issue in mysqldump using a cron. You can throw
your password in a mysqldump.cnf file and make it only readable by your
user. You can combine that with what Steve said and use a special MySQL
user as well.
--
*Sajan Parikh*
*Web Consultant, Noppix LLC*
*Work* - 563.7
Hi Girvin.
For security I created a mysql user 'backup' with read only access for
backup.
I make the cron script readable by root only
-rwxr-x--- 1 root root 586 2012-12-05 16:19 /etc/cron.backup/dailytmp.bu
MYSQL_PWD="***" mysqldump -ubackup --all-databases
--add-drop-database | gzip -9
Sajan,
The only problem I see with a cron job is a security issue. I assume
you are putting your MySQL password(s) in your cron job script, since
mysqldump requires it. I would not recommend doing that. I have a
system backup script which I manually run monthly. It does not include
the pas
Someone mentioned mysqldump, this is definitely the way to go. Set it up
on a cron and have it dump files to a backup directory.
--
*Sajan Parikh*
*Web Consultant, Noppix LLC*
*Work* - 563.726.0371
*Cell *- 563.447.0822
*Fax* - 563.726.0122
*Email *- sa...@noppix.com
On Tue, May 28, 2013
> My question now is - Where does MySQL store the Database and how do I
> track it down to make a backup??
You'll have to use the MySQL administration tool for that. LO only sees
a server running at an IP address listening to a specific port. It has
no means to know where the data is.
And I stil
mysqldump database name > filename (with authentication) is the best backup
method. You can look up the details in the docs.
On Monday, May 27, 2013, Ian Whitfield wrote:
> Hi All
>
> I'm now using the MySQL back-end (5.1.55) with LO Base (3.6.5.2) as my
> front-end - all on PCLOS 2013.
>
> I've
On 05/27/2013 07:27 AM, Ian Whitfield wrote:
Hi All
I'm now using the MySQL back-end (5.1.55) with LO Base (3.6.5.2) as my
front-end - all on PCLOS 2013.
I've been "messing" around since late last year getting this all
right, (with lots of GREAT help from the Forum!!)
My question now is -
Hi All
I'm now using the MySQL back-end (5.1.55) with LO Base (3.6.5.2) as my
front-end - all on PCLOS 2013.
I've been "messing" around since late last year getting this all right,
(with lots of GREAT help from the Forum!!)
My question now is - Where does MySQL store the Database and how do
On 05/25/2013 08:37 AM, Dan Lewis wrote:
On 05/25/2013 07:10 AM, Ian Whitfield wrote:
Thanks Noel !!!
On 25/05/13 11:58, Marion & Noel Lodge wrote:
Assuming your field is 'Country', try this -
SELECT Country, Count(Country) AS 'Count'
FROM
GROUP BY Country
ORDER BY Country
I
On 05/25/2013 07:10 AM, Ian Whitfield wrote:
Thanks Noel !!!
On 25/05/13 11:58, Marion & Noel Lodge wrote:
Assuming your field is 'Country', try this -
SELECT Country, Count(Country) AS 'Count'
FROM
GROUP BY Country
ORDER BY Country
I had a problem, at first - as I always seem
Hi Ian,
Glad you got it working - there are often subtle differences between
different flavours of SQL.
If you would like to track down the two blank records, you could try -
SELECT *
FROM `FedSaintsNew`.`Members` `Members`
WHERE `Members`.`Country` = ' '
Not sure what your syntax might be in t
Thanks Noel !!!
On 25/05/13 11:58, Marion & Noel Lodge wrote:
Assuming your field is 'Country', try this -
SELECT Country, Count(Country) AS 'Count'
FROM
GROUP BY Country
ORDER BY Country
I had a problem, at first - as I always seem to do - with 'Syntax
Error'!! So I created i
Hi Ian,
Assuming your field is 'Country', try this -
SELECT Country, Count(Country) AS 'Count'
FROM
GROUP BY Country
ORDER BY Country
Noel
--
Noel Lodge
lodg...@gmail.com
On 25 May 2013 19:09, Ian Whitfield wrote:
> Hi All
>
> I have a Database with about 3000 addresses in it an
1 - 100 of 139 matches
Mail list logo
