Is there anyone on this list who can point me to a link that talks about MySQL history
- how it began, original creators and vision, evolution over time to 4.x, etc?
TIA,
Vikram
-
Before posting, please check:
On Tue, Jan 07, 2003 at 11:09:15AM +0530, [EMAIL PROTECTED] wrote:
Is there anyone on this list who can point me to a link that talks about MySQL
history - how it began, original creators and vision, evolution over time to 4.x, etc?
Hello Vikram,
Linux Journal has an article from '99 that
On Mon, 6 Jan 2003, Sergei Golubchik wrote:
Does the stopword list have to be 'hardcoded' in myisam/ft_static.c?
No, of course, it has not.
The problem is, that I cannot implement something like
CREATE TABLE ... ( ... FULLTEXT (...) WITHOUT STOPWORD LIST )
or
CREATE TABLE ... ( ...
Sam,
I think now it is time to stop what you have started. If you can't answer the
question then don't waste the time of thousand of users on this list with your
personal opinions and comments on people signatures. You can communicate with
the user directly, not through the list. Other wise it
Hi, MySQL community.
I'm having a problem running MySQL as NT service on Win2000 plattform. It
works allright in manual mode (by 'mysqld' command), but refuses to run as
service. I installed the service by 'mysqld-max-nt --install' command. The
system reported NT service successfully
I have the latest version of PHP (4.3.0) as module in apache 2.0.43 and
mysql 3.23.49.
Everything is working fine, except this.
With pconnect the error is the same!
- Original Message -
From: Larry Brown [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, January 06, 2003
On Sat, Jan 04, 2003 at 03:25:00PM +0200, Victoria Reznichenko wrote:
On Saturday 04 January 2003 14:53, harm wrote:
Your order by will not use your weg_2 index because, as you stated,
weg_2 index is on (col1, col2, col3, nr) as a group so it wont be used
for the individual columns as
Bonjour,
Vous avez récemment demandé à vous inscrire au groupe
mysql-france. Comme vous êtes déjà membre de ce groupe,
votre demande ne sera pas prise en compte.
Pour toute question sur l'envoi de messages à ce groupe,
veuillez envoyer un e-mail à [EMAIL PROTECTED]
Cordialement,
L'équipe
Thank you very much! I am a first year software engineer so I'm still
learning :-)
I had a query that took 23 seconds, and now takes .01 sec.
Thanks again!
Rob Taft
-
Before posting, please check:
On Tuesday 31 December 2002 10:21, Walter Procopio wrote:
I have installed mysql max 4.0.4 beta on a Suse (ver. 8.0) linux server
and
I have created a database with this schema:
[skip]
And I try to execute this query:
SELECTecoras.rstda, ecotes.rstes, ecoras.rsart,
Hi guys..
I'm building an entire portal system, with two separate layer.
An application layer on 2000 server with ASP, and database
layer on Red Hat 8 Mysql...
I try to connect my application to mysql via MyODBC connector
2.50.39 or 3.51.05, but i faced this problem:
[TXC] [MyODBC] lost
Hiya.
I have inherited an Access database whose originator has used the # character in
field names as you can see below. I would like to replace this with a MySQL served
version. This is part of the script created by ACCESSDump.
DROP DATABASE cd2;
CREATE DATABASE if not exists cd2;
USE cd2;
Hmmm, this genereated the error message, Parse error: parse error in
/directory/connect.php on line 12 - Line twelve is the first printf...
line.
Any suggestions?
Chris
-Original Message-
From: Ferhat Can [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 7:04 AM
To: [EMAIL
Hello Jeremy,
Thanks for the help.
Regards,
Shamit Verma
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Shamit Verma [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 12:42 PM
Subject: Re: How to store maps in MySQL
On Tue, Jan 07, 2003 at
On Tue, Jan 07, 2003 at 03:24:58PM +0100, Giancarlo Baldeschi wrote:
Hi guys..
I'm building an entire portal system, with two separate layer.
An application layer on 2000 server with ASP, and database
layer on Red Hat 8 Mysql...
^^
I try to connect my
Hello world!
Every attempt I have made to find a decent way of backing up a database
ends up with tons of reading to show hundreds of ways to do database
backups.
I want to know which way to do complete backups is most commonly used by
professional users. (Windows and Linux)
I have pleasant
On Tue, Jan 07, 2003 at 12:29:31PM +0100, Chambon wrote:
The problem is that NOTHING happens on the slave I mean, when I do
insert or update something on the master, nothing happens on the
slave. The table remains still empty on the slave.
The questions are
- Does replication work with
I'm developing a web-site database. There is a form on one page where a user
can search for a student by typing in a last name and submitting it.
Sometimes there can be more than one student with the same last name, so I
want the user to be able to type in Smith, J (where normally they type
If I'm getting copying to temp table often on some big queries, I
usually increase tmp_table_size, but for innodb, is that variable used
or is it innodb_buffer_pool_size?
-
Before posting, please check:
We have a *nix network and on that network we have 2
web servers. One for development (server1) and one for
production (server2). And on each of those servers we
have MySQL installed. Is there a way we can query a
table on server2 from server1?
I know that when you are using a database from
Since nobody is jumping in to say it is some simple configuration/setting
personally my next step would be to shut down all services on the box that
aren't absolutely necessary and stop everything in the registry under run
and stop anything in the start folder of the start menu and run the same
What we have done it right a small script:
It logs on to the MySQL server.
It then locks the databases and tables we have put in a config file.
Simply copies the data files to a new directory.
Unlocks the tables.
Once this is done (copy if fast) you can tar or zip up the copied files.
Simon
How easy is it to import a CSV file into MySQL and when it is done does
MySQL or the program that does that automatically create a field to
match the fields in my CSV file? If not is this something that could be
easily implemented?
George Flatman
I have configured WAS Express 5.0 to connect to MySql
4.0, however I am unable to open any connections. I
know that the connection to the MySql server works,
because if I change any of the connection parameters
(port, database name, login), the JDBC driver returns
the appropriate error message. I
At 10:08 -0600 1/7/03, Chris Boget wrote:
We have a *nix network and on that network we have 2
web servers. One for development (server1) and one for
production (server2). And on each of those servers we
have MySQL installed. Is there a way we can query a
table on server2 from server1?
No.
At 14:28 + 1/7/03, [EMAIL PROTECTED] wrote:
Hiya.
I have inherited an Access database whose originator has used the #
character in
field names as you can see below. I would like to replace this with
a MySQL served
version. This is part of the script created by ACCESSDump.
DROP DATABASE
Is there a good way of calculating the size for
innodb_additional_mem_pool_size? I would like to calculate based on the
number of tables, rows, or whatever else I can use to pre-determine a
value so that the warning message allocating memory from the OS does
not appear.
-- Matt Solnit
[EMAIL
Our db server crashed and this was in the log. One strange thing was that when I went
to restart, the error log gave me this line:
/usr/local/mysql/bin/mysqld: unrecognized option `--innodb_log_files_in_group=2'
We have not touched /etc/my.cnf and have restarted the server many times. I had to
At 10:37 -0500 1/7/03, Lefevre, Steven wrote:
I'm developing a web-site database. There is a form on one page where a user
can search for a student by typing in a last name and submitting it.
Sometimes there can be more than one student with the same last name, so I
want the user to be able to
Refer to http://www.mysql.com/doc/en/LOAD_DATA.html for doc on LOAD DATA
INFILE command and syntax.
-Original Message-
From: Gman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 10:45 AM
To: [EMAIL PROTECTED]
Subject: Question or Wish feature
How easy is it to import a CSV
On Tue, Jan 07, 2003 at 08:45:13AM -0800, Gman wrote:
How easy is it to import a CSV file into MySQL and when it is done does
MySQL or the program that does that automatically create a field to
match the fields in my CSV file? If not is this something that could be
easily implemented?
Have
Hi,
I agree with the post... I feel there should be an inbuilt backup routine.
(maybe built into something like MySQLFRONT or MyCC.)
The shell script below, as far as I understand will not work with InnoDB only MyISAM
tables. (please correct me if I am mistaken)
It seems that MyCC is far far
I thing you are using the initial input to create a filtered dropdown
of usernames or choices to help with input??
I believe the 'worse' in the reference to the
SELECT * FROM Students WHERE concat(LastName, , , FirstName) LIKE 'Smith, J%';
is because of index usage AND user data entry error, at
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom O'Neil wrote:
I have configured WAS Express 5.0 to connect to MySql
4.0, however I am unable to open any connections. I
know that the connection to the MySql server works,
because if I change any of the connection parameters
(port, database name,
I am going to I was just hoping someone could post a quick answer.
George Flatman
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 10:04 AM
To: Gman
Cc: [EMAIL PROTECTED]
Subject: Re: Question or Wish feature
On Tue, Jan 07, 2003 at
At 12:28 -0600 1/7/03, Christensen, Dave wrote:
You can use the command line mysql with the host option, i.e.
--host=hostname, to connect to another machine. Likewise, you could set
up a data source using ODBC to look at the database on the second host
machine through which you could generate
Well, not the way you seem to be implying. You must use your web
application to create a connection to the other database. You can't
join or union tables, just create the connection and run the query.
Then your app can do what ever it wants with the data.
Ken
- Original Message -
From:
Hi!
InnoDB is a MySQL table type which supports transactions, row level locking,
foreign key constraints, and a non-free hot backup tool.
InnoDB is included in all MySQL-4.0 downloads, and in MySQL-Max-3.23
downloads at http://www.mysql.com.
The release 4.0.8 adds a small new feature that has
Adam,
in your earlier message you quoted 3 log files, but below in the printout it
says 2 log files. Best to do
SHOW VARIABLES;
and check from the current directory innodb_log_group_home_dir how many
ib_logfiles there really are.
030107 06:42:58 mysqld started
/usr/local/mysql/bin/mysqld:
@mysql_select_db(be); -- this failed
do echo mysql_error(); to see what went wrong
Nuno Lopes wrote:
I done a echo of Mysql_error and it returned:
'Nenhum banco de dados foi selecionado'
(I have the mysql server in portuguese, but the translation is something
like 'no db was selected')
Can you post this script? (Minus the passwords, etc.)
- Original Message -
From: Simon Green [EMAIL PROTECTED]
To: 'Jonas Widarsson' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 11:18 AM
Subject: RE: Backups mechanism
What we have done it right a small script:
FileMaker displays it rather quickly because it is only loading enough
names to fill the window. When you start scrolling, FileMaker then loads
another name, then another, etc. This can actually get pretty slow over
a dial up line. You've probably gotten spoiled by FileMaker's indexing
Try:
SELECT * FROM Students
WHERE CONCAT(LastName, ', ', FirstName) LIKE 'Smith, J%'
or
SELECT * FROM Students
WHERE CONCAT(LastName, ', ', SUBSTRING(FirstName,1,1))='Smith, J'
On Tue, 2003-01-07 at 15:37, Lefevre, Steven wrote:
I'm developing a web-site database. There is a form on one
- Original Message -
From: Ryan Fox [EMAIL PROTECTED]
To: Lefevre, Steven [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 11:33 AM
Subject: Re: Weird WHERE clause possible?
Backing up, is the problem that you need to uniquely identify the
student's
name after
(PHP-centric response)
Open another mySQL connection to the other server, and then use the link
identifier in the subsequent calls to identify which server to use for the
query. note that in php if you have two or more connections open, the
calls generally default the link ID to the last
Hi :
When I try running my perl scripts using DBI interface with mysql, I got this
message:Can't locate DBI.pm in @INC((@INC contain : /usr/lib/perl5/5.6.0/i386-linux
/usr/lib/perl5/5.6.0./usr/libperl5/site_perl/5.6.0/i386-linux
/usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .)
Where
Prathmesh,
I have just installed mysql and am facing problems with the
Load data local infile problem. I went through the manual and did
all that was said like including the command
--enable-local-infile and --local-infile[=1], but it does not
seem to work.
I posted the same problem a
On Tue, 7 Jan 2003, Jonas Widarsson wrote:
Hello world!
Every attempt I have made to find a decent way of backing up a database
ends up with tons of reading to show hundreds of ways to do database
backups.
I want to know which way to do complete backups is most commonly used by
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jonas --
...and then Jonas Widarsson said...
%
% Hello world!
Hi!
% Every attempt I have made to find a decent way of backing up a database
% ends up with tons of reading to show hundreds of ways to do database
% backups.
Heh :-) And you
Very complex Grouping and counting challenge
Can anyone offer guidance and suggest SQL which will assist in
resolving this complex and challenging (for me) issue? I hope that
my attempt to clearly state this problem is successful.
The Environment:
Queries and presentation using PHP Version
Matt,
- Original Message -
From: Matt Solnit [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, January 07, 2003 8:45 PM
Subject: Calculating innodb_additional_mem_pool_size?
Is there a good way of calculating the size for
innodb_additional_mem_pool_size? I would
At 18:32 + 1/7/03, Jeff Snoxell wrote:
Hello,
I've got a mysql table with a lot of fields and I'm using a map
statement to pass each of my values for a new record through the
quote system so-as to have everything nicely wrapped up. Problem is
that I can't find any way of writing a null
On Tue, Jan 07, 2003 at 10:00:12AM -0800, Gman wrote:
I am going to I was just hoping someone could post a quick answer.
And someone did. :-)
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 3.23.51: up 23 days,
I can see where it would be nice to be able to do that.
-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 4:06 PM
To: Christensen, Dave; 'Chris Boget'; [EMAIL PROTECTED]; Paul DuBois
Subject: Re: Query mysql on another
Jeff Snoxell wrote:
Hello,
I've got a mysql table with a lot of fields and I'm using a map statement
to pass each of my values for a new record through the quote system so-as
to have everything nicely wrapped up. Problem is that I can't find any way
of writing a null value to my DB when the
You can use the command line mysql with the host option, i.e.
--host=hostname, to connect to another machine. Likewise, you could set
up a data source using ODBC to look at the database on the second host
machine through which you could generate queries against the tables on the
other host's
You can use the command line mysql with the host option, i.e.
--host=hostname, to connect to another machine. Likewise, you could set
up a data source using ODBC to look at the database on the second host
machine through which you could generate queries against the tables on the
other host's
Hello,
Sorry for disturbing you.
In fact replication works fine whith Innodb
and Mysql 3.23.x or Mysql 4.x
My errors were syntax error in my.cnf like for example :
replicate-do-db=bqsql ; instead of replicate-do-db=bqsql
My only complain is that mysql give me no error at startup
I also
Richard,
I agree with the post... I feel there should be an inbuilt backup
routine.
AFAIK there's going to be a hot backup routine build into MySQL 4.1. At
this moment, my net connection has gone done, but you should find it at
http://www.mysql.com/doc/en/News-4.1.0.html.
Regards,
--
Stefan
* Try add to /etc/hosts the name and ip of DB is located
I'm using Windows 2000.
In Windows2000 make the same changes in winnt/system32/drivers/etc/hosts.
If it connects the first time and every time thereafter that you recreate
the connection it should not be anything to do with resolving the
On 7 Jan 2003, at 18:32, Jeff Snoxell wrote:
Which works fine except the \N isn't entered into my database as a null
value. I've also tried '\N' and '' and .
Null values are represented as undef in DBI.
[Filter fodder: SQL]
--
Keith C. Ivey [EMAIL PROTECTED]
Tobacco Documents Online
Paul, Dave,
If I understood the initial question correctly, your first suggestion
is not
what he wants. I think he's talking about accessing two servers from
the same
connection, which is not possible:
[snip]
You can't write a SQL statement that refers to tables hosted by
another server.
I can be no help to you at all, but I can tell you that I getting an error
message that relates to the GLibc problem that is document everyplace
although there doesn't seem to be any fix for me.. Maybe what I've gone
through to date can help you make some choices (I think my next one can only
be
I'm using Windows 2000.
- Original Message -
From: Cleber [EMAIL PROTECTED]
To: Nuno Lopes [EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 10:23 AM
Subject: Re: [PHP] Re: PHP and MySQL bug
Try add to /etc/hosts the name and ip of DB is located
- Original Message -
From:
Then go to c:\winnt\system32\drivers\etc and make the changes in the hosts
file that you will find there.
-Original Message-
From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 1:25 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP] Re: PHP and MySQL
After digging through the mysql web site and hunting on google I couldn't
find the answer to a problem that I am having.
It looks like MySQL is having problems differentiating between the ô(ascii
244) and the o characters. If you create the table from the SQL below and
then try to run the first
From: Paul DuBois
Date: Tue, 3 Dec 2002 08:31:52 -0600
At 12:16 +0100 12/3/02, Claus Reestrup wrote:
Database error: cannot use database pollo
MySQL Error: 2014 (Commands out of sync; You can't run this command
now)
Session halted.
Why?
What's the context?
Are you, for example, seeing
On Tue, Jan 07, 2003 at 10:41:07AM -0500, Adam Nelson wrote:
If I'm getting copying to temp table often on some big queries, I
usually increase tmp_table_size, but for innodb, is that variable
used or is it innodb_buffer_pool_size?
I'm 63% sure it's still tmp_table_size.
--
Jeremy D. Zawodny
My name is Konrad Lorincz, a graduate student in computer science at Harvard
University. I am doing a class project in which I am comparing the
performance of queries between MySQL, grep, and FlatSQL (an SQL like
language
that we implemented using awk and perl, that performs queries on flat
Gman wrote:
How easy is it to import a CSV file into MySQL and when it is done does
MySQL or the program that does that automatically create a field to
match the fields in my CSV file? If not is this something that could be
easily implemented?
George Flatman
If you're using Access / VB, you
Date: Wed, 8 Jan 2003 01:56:39 +0100
From: [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]
Subject: Re: Re: Using Perl DBI quote() method with NULL values?
At 17:16 -0500 1/7/03, walt wrote:
Jeff,
I'm not sure if this will help or not, but we ended up adding our
own version of
quote to
perl
How about?
MySQL is an Open Source data storage program that runs quietly in the
background of your computer (a Database). It stores data for your
programs and allows you to interface with that data using SQL commands (see
reference manual). It is also quit scallable to run as simple a program
At 15:20 -0500 1/7/03, [EMAIL PROTECTED] wrote:
From: Paul DuBois
Date: Tue, 3 Dec 2002 08:31:52 -0600
At 12:16 +0100 12/3/02, Claus Reestrup wrote:
Database error: cannot use database pollo
MySQL Error: 2014 (Commands out of sync; You can't run this command now)
Session halted.
Why?
From: Jeff Snoxell [EMAIL PROTECTED]
...I'm using a map statement...
...through the quote system...
Short answer: Don't do that.
The longer answer:
# Prepare the SQL using 'bind' operators.
$sth = $MyDatabase-prepare(qq{
INSERT INTO MyTable
(col1, col2, col3)
VALUES
(?,
Have a new years resolution, to get MySQL to run
Here are the errors that I keep getting...
I don't understand what this is telling me?
from /var/log
021214 19:13:21 mysqld started
021214 19:13:21 /usr/local/libexec/mysqld: Can't find
file: './mysql/host.frm' (er
rno: 13)
021214
Hi,
MySQL 4.0.8, a new version of the world's most popular Open Source Database,
has been released. It is now available in source and binary form for a number
of platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
Note that all mirrors may not be up to date;
yep. CLI will confuse some, unfortunately. but that's life...
quite scalable small typos
add word flavors after proprietary.
suggest last sentence to push the readers forward..
As you read on, you'll discover that MySQL and its companion
tools are quick and easy to learn.
something like that?
Hi everybody,
I have always these mysql.err.1 files not unlinked in all my
mysqlservers, and only a mysqld restart resolve these (nor reload
neither mysqladmin refresh doesn't unlink them).
Does anybody in the list encounter this problem ?
Am I obliged to add a mysql restart in my logrotate
At 15:11 Uhr +0300 07.01.2003, Do-Risika RAFIEFERANTSIARONJY wrote:
Hi everybody,
I have always these mysql.err.1 files not unlinked in all my
mysqlservers, and only a mysqld restart resolve these (nor reload
neither mysqladmin refresh doesn't unlink them).
Does anybody in the list encounter
Sorry, I've restarted mysql again and am seeing that it normally does
not only write mysql ended but a whole bunch of other lines to the
logs. So yes it is a problem.
Christian.
At 15:11 Uhr +0300 07.01.2003, Do-Risika RAFIEFERANTSIARONJY wrote:
Hi everybody,
I have always these mysql.err.1
We are using linux as out operating system in HP printers. Now one day the mysql
server crashed and was not able to restart
As the temporary socket file mysql.sock was not getting deleted and which prevented
the server from getting restarted.
However after a restart of the machine this file
Anybody else who has any idea why the index are not used as they should?
I've got same things with 3.23.xx and select query through a TCP/IP
connection.
I don't know why, but you can solve this issue using the USE INDEX syntax
for select queries ...
http://www.mysql.com/doc/en/SELECT.html
Hi!
https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=77467
Has anybody working and tested solution for this kind of
problem with MySQL ?
1) upgrade to glibc 2.3.1 from phoebe RH beta seems to be fix
problem, but I conside it to be too dangeros on prodaction machine...
Has anybody success
Hello,
I am using Mysql and Innodb tables since one year
with great success. Everything works fine.
Now I try to set up a master/slave replication architecture.
master slave
pc Linux rh 6.2 pc Linux rh 6.2
version 3.23.54 version 3.23.54
I have
On Tue, Jan 07, 2003 at 11:49:05AM +0100, David Bordas wrote:
Anybody else who has any idea why the index are not used as they should?
I've got same things with 3.23.xx and select query through a TCP/IP
connection.
I don't know why, but you can solve this issue using the USE INDEX syntax
I'm having difficulty installing MySQL 3.23.54 on a Windows 2000 server.
I downloaded the file mysql-3.23.54-win.zip. It unzipped and installed
smoothly on my Windows 2000 PC, but when I tried to install on the server
Setup failed with the Windows message: 'Cannot find file C:\...SETUP.EXE (or
Hello,
I've got a mysql table with a lot of fields and I'm using a map statement
to pass each of my values for a new record through the quote system so-as
to have everything nicely wrapped up. Problem is that I can't find any way
of writing a null value to my DB when the value has first passed
Hello.
Thanks for the reply.
I am issuing it as a command line option to the script. i.e.
mysql -u crn -p cd2.sql.
Any help?
Russ.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
88 matches
Mail list logo