On Friday, December 14, 2012 11:34:44 AM Girvin R. Herr wrote: > upscope wrote: > > On Thursday, December 13, 2012 06:11:01 PM Girvin R. Herr wrote: > >> upscope wrote: > >> > >> <snip> > > <snip> > > > These client libs are available from the openSUSE repo's. Maybe slackware > > has something equal. > > > > [Code] > > > > rpm -qa |grep libmysqlclient > > libmysqlclient_r18-5.5.25a-102.1.x86_64 > > libmysqlclient18-32bit-5.5.25a-102.1.x86_64 > > libmysqlclient-devel-5.5.25a-102.1.x86_64 > > libmysqlclient18-5.5.25a-102.1.x86_64 > > > > [/Code} > > > > Since I am the inly user of my database and its all on localhost, I use > > phpMyAdmin alot to reun querries and do most functions associated with > > database maintenance. > > > > My KDE apps using the dB are KMyMoney, Amarok and Digikam. I also have > > several databases with Lions Club oriented data. > > > > Russ > > Russ, > Thanks for the info. I will have to look into those. > IMHO, you can't have too many backup options. > > The advantage of Base is that I can create database (table) maintenance > gui forms that allow me to add & modify record data without the pain of > creating queries all the time. Base allows one to create & modify > tables, queries, and data entry/maintenance forms in a gui environment, > which I find more productive than a command line based client. There is > also a report generator, but in my experience the Base report generator, > actually the Oracle Report Builder plugin, is busted and I am working > with a 3rd-party report builder called DataVision. Most of my database > tables are inventories. I currently have 50 tables in one database. > Agreed, many of these tables are small tables of listbox-type data for > remote key access. That said, I found that Base does not do all of the > things a command line client does. There have been postings about Base > not making expected changes to a table, especially a key. It seems when > Base saves a table definition the first time, subsequent key definition > changes are not executed. In my experience with that type problem, I > found I had to create a MySQL query in the mysql command line tool to > perform the changes I wanted. But that process is extremely rare. In > fact, I have only needed to do it once in the 8 years or so I have been > using Base. > Girvin > I agree with you but phpAdmin allows me to fill in a form made from the tabledata,. I can add, modify and delete individual records from a phpMyAdmin GUI interface, no command line. Also allow dumping and save the table information as any nuber of ways. I use CVS, ODS and MySQL as saved backups of the stored table. I have 10 databases so large, some small.
It comes down to what individual perfers and is used to. I only use command line if all else fails. > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] -- openSUSE 12.2(Linux 3.4.11-2.16-desktop x86_64)| KDE 4.9.4 "release 1"|Intel core2duo 2.5 MHZ,|8GB DDR3|GeForce 8400GS(NVIDIA-Linux-x86_64-304.60) --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
