MySQL-Front

Hi All, Does anyone know what happened to the MySQL-Front project, which was at http://www.anse.de/mysqlfront/ ? Thanks, Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: MySQL-Front

Hello, As they say on the site, it is discontinued. My guess is that there were no active developers. Quite a shame, though, as MySQLFront was simply the best frontend for MySQL. I _really_ hope that someone will pick up the development from where it was left off and continue the development of

RE: MySQL-Front

Hrm, I wouldn't mind taking this over, or at the very least, taking over the website and releasing the current version. I have quite a bit of Windows programming experience as it is so I should be able to make patches etc. where needed. Anyone know where I can find more info? I can host it at

RE: MySQL-Front

Interesting, http://mysqlfront.sstienemann.de/ Still works. Stuart --- Perlboy.org - Professional Perl Programming Services Carpet-Head.com - Sally's Blog -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Iikka Meriläinen Sent: Sunday, 22 September

Re: Fractions

From: MySQL [EMAIL PROTECTED] From: Madscientist [EMAIL PROTECTED] You might also consider using two integer type fields - one for the numerator and another for the denominator. This way storage and recovery are easy and the mathematics are wide open. _M I suspect that a float

Multiple concurrent MySQL question?

I desire to configure MySQL in such a way that it will permit me to have two different PHP/MySQL e-commerce applications running concurrently on my development system. The table names and table structure are the same on both applications(and databases). I have received a SQL backup from the new

ERROR 1146

hi list, trying to do my first steps with mysql, i have done the following : mysql USE mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql INSERT INTO mysql VALUES(localhost, sample_db,

Re: Re: Build errors with 3.23.51

Yes, I now the problem with MySQL, Can anyone send me te solution? Greetings --- B. van Velzen VelzArt Mobile : +31(0)653382221 Mail : [EMAIL PROTECTED] Info : [EMAIL PROTECTED] http://www.velzart.nl

TO_DAYS() equivalent for months, hours etc.?

I'm writing a website statistics system and have been using GROUP BY TO_DAYS(time) in the sql to aggregate results for different days, however there doesn't seem to be an equivalent function for other time periods such as hours and months. Will I be able to use: GROUP BY

Duplicate key error

I am aware that this is an error of my own making, however . . . I am unable to install my sql because the scipt fails with a duplicate key error Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table

Re: Build errors with 3.23.51

Shane Allen wrote: configure:12730: checking style of gethost* routines configure:12773: gcc -c -O -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fpermissive -I/usr/local/mysql-glibc-2.2.2/include conftest.cc 5 gcc: installation problem, cannot exec `cc1plus': No such file

RE: Multiple concurrent MySQL question?

Paul, You need to run another server on a different port with a different socket path. See http://www.mysql.com/doc/en/Multiple_servers.html And http://www.mysql.com/doc/en/mysqld_multi.html to manage multiple MySQL servers. Cheers, Andrew -Original Message- From: Paul Maine

Re: Problem starting mysqld on SCO

did you run the mysql_install_db script to create the mysql database and populate it with the bare values necessary for mysql run? SK On Thursday, September 5, 2002, at 05:57 PM, Darryl Hoar wrote: Greetings, I downloaded the mysql-max-3.23.42-pc-sco3.2v5.0.6-i386 from MySQL website. I

mysqlbug

After i install the Redhat 7.3 and mysql i cannot connect to the mysql server , it shutdown automatically [root@localhost root]/usr/bin/safe_install [1]2023 [root@localhost root]Starting mysql daemon with databases from /var/lib/mysql 020923 00:36:23 mysqld ended [1]+ Done

first dbi access with perl and lost

Hi!, I am lost! I am running in win 98 and my perl code is: #!perl use strict; use DBI(); # Connect to the database. my $dbh = DBI-connect(DBI:mysql:database=club;host=localhost, jwp, x,

Re: first dbi access with perl and lost

Gerald, #!perl use strict; use DBI(); # Connect to the database. my $dbh = DBI-connect(DBI:mysql:database=club;host=localhost, jwp, x, {'RaiseError' = 1}); $drh =

Re: first dbi access with perl and lost

David, Thanks, Now I am getting the following: install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1) line 3; I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I fix this? Thanks, Jerry David

Re: first dbi access with perl and lost

Gerald, Now I am getting the following: install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1) line 3; I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I fix this? No, it's separate from the

Turn logging on or off for SQL statements

Is there an easy way to turn logging or SQL statement executions on or off without having to restart with a changed my.cnf file? Just want to log queries to try and sort out some performance problems. Thanks, O. (sql) -

What's this error mean?

What's this error mean? Warning: Wrong parameter count for mysql_query() thanks Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: mysqlbug

Hey there, That means that the MySQL server is unable to find the mysql socket. Check your error log for more info. Stuart --- Perlboy.org - Professional Perl Programming Services Carpet-Head.com - Sally's Blog -Original Message- From: Winnie Kwok [mailto:[EMAIL PROTECTED]] Sent:

Database Query Question

Hi all, I need to be able to tell what the maximum length of a char column is. Can I query the database for this information? Shaun list filter: mysql - Before posting, please check: http://www.mysql.com/manual.php (the

RE: Database Query Question

Shaun, The length can be any value between 1 and 255. (As of MySQL Version 3.23, the length of CHAR may be 0 to 255.) See http://www.mysql.com/doc/en/CHAR.html If you're looking to find the maximum length of the values in a particular column, use something like this: In table 'tablename' for

Re: What's this error mean?

On Sun, 22 Sep 2002, Randy Johnson wrote: What's this error mean? Warning: Wrong parameter count for mysql_query() Exactly what it says. You called mysql_query (PHP?) with the wrong number of parameters/arguements. Ie, it might expect 2, and you only gave it 1. -- Sapere aude My mind

Re: first dbi access with perl and lost

David, I am not getting any where.. Do I have create mysql.pm on my system or can just copy the file onto my system. I do not understand why MySQL did not create this file. Thanks, Jerry David Lloyd wrote: Gerald, Now I am getting the following: install_driver(mysql)

Re: first dbi access with perl and lost

At 13:33 -0500 9/22/02, Gerald Preston wrote: David, I am not getting any where.. Do I have create mysql.pm on my system or can just copy the file onto my system. I do not understand why MySQL did not create this file. Because it's not part of MySQL. It's part of DBD::mysql, the

Re: first dbi access with perl and lost

Paul, Thank you!! I had installed DBD, but I did not know that I had to install DBD::mysql. THANKS SO MUCH!!! Jerry Paul DuBois wrote: At 13:33 -0500 9/22/02, Gerald Preston wrote: David, I am not getting any where.. Do I have create mysql.pm on my system or can just copy

Re: first dbi access with perl and lost

At 14:24 -0500 9/22/02, Gerald Preston wrote: Paul, Thank you!! I had installed DBD, but I did not know that I had to install DBD::mysql. THANKS SO MUCH!!! I take it from your tone that your script works now? :-) DBI (I assume that's what you mean by installing DBD, because there is no DBD

Speaking of DBI -v- Net::MySQL (Was: RE: first dbi access with perl and lost)

Following this conversation myself (also a perl db newbie :) ... before always just used php) and curious if you know definitely what db vendor you are going to be using (mysql in this case), any reason to use dbi; as opposed to just using vendor specific or net::mysql; . Is it just a

Perl and mySQL and character sets.

Hello all, I am currently using perl to import some information into a mysql db. At this point in time I have two issues: 1. The text files that are being imported contain both english and french text. My text editor (textpad) gladly displays the text with all proper hyphens and accentuated

Performance while Building Indices -- how does it scale?

I have a table with a few million rows, wth 633 columns. I want to create 10 inidices on this table, six single-column and four two-column inidices. The database will be loaded once and remain static, and queried many times. Please note that this is a small prototype for the actual

Re: MySQL Gui Install and Setup for Win2K

We were told by David Axmark of MySQL AB to stop using MySQLGui and switch to MyCC. MySQLGUI is apparently dead. - Original Message - From: David Kramer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 16, 2002 12:52 PM Subject: MySQL Gui Install and Setup for Win2K Can

mysql kylix

I have a copy of Kylix 1.0, which I put on a recent RH 7.3 install. It is running MySQL 3.23.49. I therefore d/l 3.23 driver for kylix. I then did the following: *Copied the driver to the kylix\bin file *Created the symbolic link(Does it matter what dir this is executed

Re: MySQL Gui Install and Setup for Win2K

Oops... I meant Microsoft SQL Server and Oracle, not MySQL and Oracle. Matt - Original Message - From: Matt Hargraves [EMAIL PROTECTED] To: Arthur Fuller [EMAIL PROTECTED]; David Kramer [EMAIL PROTECTED] Cc: mysql mailing list [EMAIL PROTECTED] Sent: Sunday, September 22, 2002 9:14 PM

merge tables - errorno: 143 - Is there a limit on columns with mergedtables ?

Hello, I get the following error when trying to access a table created of TYPE=MERGE mysql describe yy; ERROR 1016: Can't open file: 'yy.MRG'. (errno: 143) Reducing the number of colums in the tables to be merged removed the problem. Any ideas gratefully received, Dave ( MySQL version:

Re: merge tables - errorno: 143 - Is there a limit on columns with merged tables ?

from perror 143 = Conflicting table definition between MERGE and mapped table On Sunday, Sep 22, 2002, at 18:36 America/Anchorage, David Herring wrote: Hello, I get the following error when trying to access a table created of TYPE=MERGE mysql describe yy; ERROR 1016: Can't open

Slight problem storing data with Mysql...

MySQL newbie seeking help and/or advice on storing data into a database. I have a poetry section I'm trying to add to my site that will allow users to submit some of their work for public viewing. An example is located here: http://www.nubiint.com/nuwoez/nuwoez.htm. By clicking on any one of

transactions...

I think I've already asked this before, but I will try again. Do I loose too much performance using InnoDB tables in autocommit mode instead of using MyISAM tables? Thanks. Joao sql - Before posting, please check:

Re: transactions...

Joao, I think I've already asked this before, but I will try again. Do I loose too much performance using InnoDB tables in autocommit mode instead of using MyISAM tables? Possibly, but too much is really relative on what your needs are. What are you trying to achieve and what is more

Re: transactions...

Hi! At 00:56 2002.09.23._ -0300, you wrote: Do I loose too much performance using InnoDB tables in autocommit mode instead of using MyISAM tables? The real quiestion is: Why do you want to use InnoDB tables when you don't want to use its transaction safe features? Anyway yes. I'm sure it is

Re: transactions...

On Mon, 23 Sep 2002, Daniel Kiss wrote: Hi! At 00:56 2002.09.23._ -0300, you wrote: Do I loose too much performance using InnoDB tables in autocommit mode instead of using MyISAM tables? The real quiestion is: Why do you want to use InnoDB tables when you don't want to use its

mysqlimport

Hi I can create a database called test, mysql create database test; Query OK, 1 row affected (0.03 sec) BUT I can't create any other databases??? mysql create database tem; ERROR 1044: Access denied for user: 'ddb@localhost' to database 'tem' mysql create database proj; ERROR 1044: Access