Re: Connect MySQL from Python

2001-03-08 Thread kentj
The following URL Points to the Python MySQl interface. Also Zope is a web applications server written in python which has the ability to connect to MySQL. http://dustman.net/andy/python/MySQLdb/ iq wrote: Dear Guys, Is there any API or modules to connect MySQL from Python?? -- Best

Re: desperate for help...

2001-03-07 Thread kentj
It looks like the addition of the distinct verb should do the job if in fact your query only showed the fields on the display. From your Sql however you are selecting more fields than are displayed and some of those are different which distinct will still display. Chris Toth wrote: Ok, I've

Re: desperate for help...

2001-03-07 Thread kentj
Your query selects eight fields. Your Display shows five fields. The distinct verb works on all eight fields and apparently some of the fields not displayed are different. Limit the query for the display to the five fields displayed and the distinct verb should eliminate the duplicates from the

Re: new to Linux release of MySQL

2001-03-05 Thread kentj
An RPM installation indicates that you might be installing on some version of Linux. Could you specify the platform, the operating system, the Mysql release Number so that people with the experiece that you need will able to respond. My experiece is with SusE Linux 7.0 and release Mysql-3.23.32-1

Archive

2001-02-28 Thread kentj
Is there an archive for this mailing list? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

Re: Installing client and shared RPMs

2001-02-22 Thread kentj
If my memory serves me correctly this was solved by fixing the rpms in 3.23.32-1. You mightr try the current version. Rus Rasmussen wrote: Hello, I am trying to install the MySQL-client and MySQL-shard RPMs. I am not very bright with this stuff so go easy on me. This is the error I get

Re: Restart MySQL after rebooting Linux

2001-02-15 Thread kentj
I believe so. I was trying that and was missing something because I could not get it to work. Dave Hodgkinson wrote: kentj [EMAIL PROTECTED] writes: I have been reading the mysql book by Dubois and trying to figure out how to implement his restart methods on a SUSE Linux 7.0 Box. Has

Re: Setting up Access 2000 to work using a mySQL db...

2001-02-15 Thread kentj
I have an Access 2000 Db on a Win98 system with tables linked to a MySql23.32-1 database on Suse Linux 7.0 using the latest MyODBC with a System DSN specifying anyname.dsn, the IP of 192.168.2.5 for the host, the database name of "metrics" and port 3306. I had to setup the privileges very

Restart MySQL after rebooting Linux

2001-02-14 Thread kentj
I have been reading the mysql book by Dubois and trying to figure out how to implement his restart methods on a SUSE Linux 7.0 Box. Has anyone done this and can give me information how to do it? - Before posting, please check:

Re: mysql daemon fails to start.

2001-02-08 Thread kentj
Suse 7.0 when I ran rpm -Uhv MySql*3.23.32-1.i386.rpm against the sever, the client and the shared rpms.It ran without error and created the appropriate files on a 10 gig /var/lib/mysql. I moved the contents of mysql to /dbshare and created a symbolic link in /var/lib called mysql which

Re: Windows DSN NAme

2001-02-08 Thread kentj
Actually I got "A connection could not be made using the data source parameters entered. Save non-verified file DSN? "(Mr) Pekka Gaiser" wrote: Hi, I got no solution, just a few ideas, probably you have checked them already. - Windows DSN name doesn't matter. Type in anything you want. - I

Re: How do I Move Directories

2001-02-07 Thread kentj
irectory in /dbshare owned by mysql ? Are the permissions 775 ? Does mysql own the files in /dbshare/mysql ? kentj wrote: dbshare is owned by mysql with group deamon and I have run install_db "Gerald L. Clark" wrote: kentj wrote: Platform Suse 7.0, AMD 450 KIII

Re: Simple question

2001-02-06 Thread kentj
that first? Thanks for your time Joel - Original Message - From: kentj [EMAIL PROTECTED] To: Joel Holtzman [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 05, 2001 3:24 PM Subject: Re: Simple question A gui that works on the linux box is kmysql. Joel Holtzman

Big Time

2001-02-06 Thread kentj
I have read that IBM has concluded that Linux is ready for the big time. That may be true for Linux but I would doubt that the same could be said for MySQL. For example the missing host.frm has been in threads in the archive for a long time, I have been bitten by the beast with no success yet in

Re: How do I Move Directories

2001-02-05 Thread kentj
dbshare is owned by mysql with group deamon and I have run install_db "Gerald L. Clark" wrote: kentj wrote: Platform Suse 7.0, AMD 450 KIII+, 128MB Ram Linux on 10 Gig system harddrive with 45 Gig additional drive mounted as /dbshare. I have created a symbolic li

Re: How do I Move Directories

2001-02-05 Thread kentj
dbshare is owned by mysql with group deamon and I have run install_db "Gerald L. Clark" wrote: kentj wrote: Platform Suse 7.0, AMD 450 KIII+, 128MB Ram Linux on 10 Gig system harddrive with 45 Gig additional drive mounted as /dbshare. I have created a symbolic li

Installation Problem

2001-02-02 Thread kentj
Platform Suse 7.0, AMD 450 KIII+, 128MB Ram Linux on 10 Gig system harddrive with 45 Gig additional drive mounted as /dbshare. MySQL needs to keep its database files in dbshare but I have not been able to make it work. From what I have read in this maillist it would appear that some combination

How do I Move Directories

2001-02-02 Thread kentj
Platform Suse 7.0, AMD 450 KIII+, 128MB Ram Linux on 10 Gig system harddrive with 45 Gig additional drive mounted as /dbshare. I have created a symbolic link in /var/lib of mysql- /dbshare. then RPM -Uhv --force MySQL*-3.23.32-1.i386.rpm to install the files from MySQL-3.23.32-1.i386.rpm

host.frm

2001-02-02 Thread kentj
What is host.frm and why can host.frm not be located where I want to be? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request