Hi,
We're running MySQL 3.23.49 under Debian Linux with a 2.4.19
kernel.
I've got a 2-part question about tmp_table_size.
1) I've tried setting 'tmp_table_size' from the MySQL command
interpreter, and I keep getting told that I have an SQL syntax
error. The command is :
set tmp_table
Hi all,
I've been trying to install version 4.0.3 of the new MySQL branch 4.0
but got a problem that I cannot seem to solve.
Installing MySQL 4.0.3, both in binary and source compilation, yields
always the following error when I try to visit a website written in PHP:
020912 09:46:19 mysqld rest
Hi!
I've a very dirty bug costing me hours uptill now; maybe it is related
with the AND/OR-behavior described in the releasenote of 3.23.52/53;
A query once runs with release 3.23.53 (my own PC); same query don't
work with release 3.23.51 (my Host-Provider).
Here is the Query:
SELECT * FRO
This get asked every couple of days. Check the archives.
FWIW, I host with Experhost.com
Justin
on 12/09/02 3:34 PM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
> Hello All,
> Can any one suggest a good company to host a MySQL+PHP website ?
>
> Thanks
>
> --
Hello All,
Can any one suggest a good company to host a MySQL+PHP website ?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
T
×𾴵Ŀͻ§£º
ÄúºÃ£¡Ê±´´ÍøÂçÇ¿Á¦ÍƳöASP.NET¸ß¼¶ÐéÄâÖ÷»ú£¬ÊÊÓÃÓÚ´óÐ͵ÄÆóÒµ¡¢´óÐÍ
µç×ÓÉÌÎñÍøÕ¾¡¢´óÐ͸öÈËÍøÕ¾£¨´øÂÛ̳ ÉçÇøµÈ£©¡£
ÒÔÏÂΪÐéÄâרÓÃÐÍCµÄÏêϸÅäÖÃ×ÊÁÏ£º
½Å±¾Ö§³Ö£ºASP ASP.NET CGI Active Perl Front Page 2000 À©Õ¹
Êý¾Ý¿âÖ§³Ö£ºACCESS SQLSERVER 2000£¨MS SQL£©Êý¾Ý¿â
¿Õ¼äÈÝÁ¿£ºÍøÕ¾¿Õ¼ä3G£¬Ê
In the last episode (Sep 11), Paul DuBois said:
> At 23:51 +0100 9/11/02, nick gatsis wrote:
> >In win98 mysql keep configuration in my.ini.
> >Which is the same file in RH Linux 7.2?
>
> /etc/my.cnf, or the my.cnf file in the server's data directory.
A quick way to find out is to run "mysqld --
Dan,
I've got 4.0.3, and I compiled it from the source rpm. Seems that (at least
with 4.0.3) mysql is statically linked, hence the lack of libmysqlclient. What
you might want to do is make a soft line from libmysqlclient.so.11 to
libmysqlclient.so.10 and see if that works.
Ed
Quoting Danie
Stephen Sokalski wrote:
>
>
> Stephen Sokalski wrote:
>
>> I'm running this on a RAQ.
>>
>> Here is the problem. Something very strange has happened to my older
>> version of mysql (3.23.37).
>>
>> Not only can I not get it to shut down with
>> "/usr/share/mysql/mysql.server stop" but even if
So far as I can tell the mysql files included in the CD set are:
mysql-3.23.49-3.i386.rpm
mysqlclient9-3.23.22-6.i386.rpm
mysql-devil-3.23.49-3.i386.rpm
mysql-server-3.23.49-3.i386.rpm
Do these files include Innodb support?
Are they sufficient to install mysql?
I would be grateful for any advi
Stephen Sokalski wrote:
> I'm running this on a RAQ.
>
> Here is the problem. Something very strange has happened to my older
> version of mysql (3.23.37).
>
> Not only can I not get it to shut down with
> "/usr/share/mysql/mysql.server stop" but even if I do a "ps -ef | grep
> mysql" and do
I'm running this on a RAQ.
Here is the problem. Something very strange has happened to my older
version of mysql (3.23.37).
Not only can I not get it to shut down with
"/usr/share/mysql/mysql.server stop" but even if I do a "ps -ef | grep
mysql" and do a kill -9 on the pid, if I try to res
Hi,
AFAIK, all versions are affected since I reproduced the bug with 4.0.4-beta
under linux.
Regards,
Jocelyn
- Original Message -
From: "PR" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 12, 2002 1:53 AM
Subject: Re: MySql/InnoDB crashes after a Select...order
Heikki, does this bug affect all versions or just the -max windows
versions... we just installed 4.0.3-beta (unix-freebsd) to do some
benchmarking/testing tonite on innodb and this would impact us. Thx.
>Rafa,
>
>- Original Message -
>From: <[EMAIL PROTECTED]>
>Newsgroups: mailing.datab
Hello mysql users:
Would appreciate some advice on data types for a column. The value for the
field would be a number that would never exceed 1000 but would have two
decimal points limited to .25 increments e.g 5.25 or 7.75
There may be some simple calculations such as totals etc. What would be
At 23:51 +0100 9/11/02, nick gatsis wrote:
>In win98 mysql keep configuration in my.ini.
>Which is the same file in RH Linux 7.2?
/etc/my.cnf, or the my.cnf file in the server's data directory.
-
Before posting, please check:
Have a look at urSQL - http://www.urbanresearch.com/ursql
On Wed, 11 Sep 2002, [iso-8859-2] Jêdrzej Kolesiñski wrote:
>
>
> Hi
>
> I'm looking for some software (under windows) that will connect to a sql -
> mysql base
> and make some drop of structure and data of a database
>
> Do you kno
In win98 mysql keep configuration in my.ini.
Which is the same file in RH Linux 7.2?
Thanx
Do You Yahoo!?
&Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&th
hi rene,
thanks for your reply.
yes, i do it being root:
mysql -u root -p
and in phpMyAdmin i see that the grant option for root is enabled.
and i am loged into phpMyAdmin as root also.
i really wonder what's going on...
i mean, am i missing the point in some way or another?
cheers,
phil
>
Maybe the code is horrendous.
-mike
> -Original Message-
> From: Gabriele Carioli [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 11, 2002 3:22 PM
> To: MySQL
> Subject: Re: MySQL-Front Discontinued
>
>
> Hi.
>
> > Too bad ... Ansgar Becker developed a truly useful,
>
I share in that, Ansgar developed a very commercially sound product that he
shared with the community.
Thank-you Ansgar,
[EMAIL PROTECTED]
Patrick Sherrill
And avid MySQLFront fan and user.
CocoNet Corporation
- Original Message -
From: "Manuel Villasante" <[EMAIL PROTECTED]>
To: "'Ger
Yuri,
ADD COLUMN should not affect a SELECT concurrently running on the table. I
tested this with a 3 million row InnoDB table.
Can you repeat that unexpected behavior?
Regards,
Heikki
Innobase Oy
Copied message:
...
Subject: Schema changes affect regular select?
From: Yuri
Date: Tue,
Hi all!
I want to try out the demo version of Rekall (
http://www.thekompany.com/products/rekall/ ) but it is linked against
libmysqlclient.so.10.
I have libmysqlclient.so.11 from MySQL-4.0.2, and for some reason I
don't even have any libmysqlclient.so.x from MySQL-4.0.3, but anyway I
need th
Hi.
> Too bad ... Ansgar Becker developed a truly useful,
> powerful MySQL database management tool for us Windoze
> users.
The support forum is still active:
http://mysqlfront.venturemedia.de/
According to the moderator, Ansgar is neither going to make it
commercial nor willing to make it ope
Mediumint refers to the fact that it is three bytes long rather than a
regular 4 byte, 32 bit integer. It's range is like +/- 8,000,000 or so
(look it up for sure)
The 6 just has to do with how many digits will be displayed when you invoke
the MySQL client for the row - spacing will be a minimum
I second that opinion.
-Original Message-
From: Gerald Jensen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 3:02 PM
To: [EMAIL PROTECTED]
Subject: MySQL-Front Discontinued
I went to http://www.anse.de/mysqlfront/ today ... the notice posted on the
site says "MySQL-Front
I went to http://www.anse.de/mysqlfront/ today ... the notice posted on the
site says "MySQL-Front - This project has been discontinued".
Too bad ... Ansgar Becker developed a truly useful, powerful MySQL database
management tool for us Windoze users.
---
At 23:05 +0200 9/11/02, Jan Kudrman wrote:
>Hi all,
>
>I have a small problem - I have the following table with numetic type. In my
>table is mediumint(6), but I can to insert value 11223344. I thougth the
>maximum value for mediumint(6) is 99.
Why?
>
>Do you have some idea what I should to
Rafa,
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, September 10, 2002 1:46 PM
Subject: MySql/InnoDB crashes after a Select...order by DESC... LIMIT...
> Hello,
>
> I am working with mysqld-max-nt under windows 2000 and unsing I
Hi all,
I have a small problem - I have the following table with numetic type. In my
table is mediumint(6), but I can to insert value 11223344. I thougth the
maximum value for mediumint(6) is 99.
Do you have some idea what I should to do to be able insert value 99 as
a maximum for my fie
At 01:55 PM 9/11/2002, you wrote:
>Version: MySQL.3.22.32-log
>
>Does this problem ring a bell with anyone?
>I'm seeing two undesired behaviors, both, *I think*
>seem to be because I'm pounding a lot of connections
>against the same server/table, all from the same
>remote host. The workload that r
Eric Lamendola wrote:
>
> If you are using PHP,
>
> Then download phpMyAdmin from the website of the same name. It is the best
> PHP/Web based utility for connecting to a MySQL database.
>
> At 12:48 PM 9/11/02 -0400, Amer Neely wrote:
> >Is there a MySQL command that will return the amount of
hi all,
I have a strange behaviour of a mysql 3.23.51 installation on a rh7.3
box in connection with connects from windows 2000 clients (no idea, if
the windows version matters).
Everytime I try to connect to the server (odbc, mysqlc-commandline-tool)
I receive "ERROR 2013: Lost connection ...".
I've used dbtools http://www.dbtools.com.br/ However I'm using 1.0.12
rather than 1.0.15 since the newer version appears to have a few bugs.
there is of cours mysqlgui from mysql (see their site).
On Wed, 11 Sep 2002, =?iso-8859-2?Q?J=EAdrzej_Kolesi=F1ski?= wrote:
> Date: Wed, 11 Sep 2002 21
Hi
I'm looking for some software (under windows) that will connect to a sql -
mysql base
and make some drop of structure and data of a database
Do you know any small free program like this ?
TeQ
-
Before posting,
Version: MySQL.3.22.32-log
Does this problem ring a bell with anyone?
I'm seeing two undesired behaviors, both, *I think*
seem to be because I'm pounding a lot of connections
against the same server/table, all from the same
remote host. The workload that reaches MySQL is
a succession of CONNECT
On Wed, 11 Sep 2002, Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
> On Wed, Sep 11, 2002 at 02:55:01PM -0400, Kent Hoover wrote:
> > Version: MySQL.3.22.32-log
> >
> > Does this problem ring a bell with anyone?
> > I'm seeing two undesired behaviors, both, *I think*
> > seem to be because I
On Wed, Sep 11, 2002 at 02:55:01PM -0400, Kent Hoover wrote:
> Version: MySQL.3.22.32-log
>
> Does this problem ring a bell with anyone?
> I'm seeing two undesired behaviors, both, *I think*
> seem to be because I'm pounding a lot of connections
> against the same server/table, all from the same
Hi,
we have an application that connect to MySQL via MyODBC.
Sometimes, we have this error:
[TCX][MyODBC] Got error 5 from table handler
and MySQL drops.
When it comes back up, it first gives an error with BDB tables (the type we
use):
020911 15:10:17 bdb: page 0: illegal page type or format
020
I have done some small tests here and indeed InnoDB seems to be faster than
BerkeleyDB.
Thanks guys for your help!
;)
==>MySQL List
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
A problem on installation of 4.0.3.
First, I tried with rpm -U and when I try to uninstall it says not installed
when I try to install or upgrade it says already installed
I looked at the rpm package files and try to erase them manually
and they are not there
So I tried the tarball
Hi,
we have an application that connect to MySQL via MyODBC.
Sometimes, we have this error:
[TCX][MyODBC] Got error 5 from table handler
and MySQL drops.
When it comes back up, it first gives an error with BDB tables (the type we
use):
020911 15:10:17 bdb: page 0: illegal page type or format
020
Paul DuBois wrote:
> At 13:02 -0500 9/11/02, Mike Gohlke wrote:
>
>> From: [EMAIL PROTECTED]
>> To: [EMAIL PROTECTED]
>> Subject: 4.0.3 datadir mangle bug
>>
>>> Description:
>>
>>mysqld is mangling the datadir. Fed in "/mysql" and it
>> produces ". ysql"
>
>
> It's only changing the
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with END-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in <' and >').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: ld flag cause make error
>Description:
After running CC=gcc CFLAGS="-O3" \
C
At 13:02 -0500 9/11/02, Mike Gohlke wrote:
>From: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: 4.0.3 datadir mangle bug
>
>>Description:
>mysqld is mangling the datadir. Fed in "/mysql" and it
>produces ". ysql"
It's only changing the command line parameters viewable with ps.
If y
Have you done a 'mysqladmin reload' to reload the new grant tables
into the server process? Any modifications you make to the permissions
table won't take until until after a 'reload'.
Rene
philipp ringli wrote:
> hi all,
>
> i am running OS X 10.2 and
> this version of mysql:
>
> m
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: 4.0.3 datadir mangle bug
>Description:
mysqld is mangling the datadir. Fed in "/mysql" and it produces
". ysql"
>How-To-Repeat:
Upgrade from 3.23.52 to 4.0.3
>Fix:
Unknown at this time. Tried to feed parameters t
On Wed, 11 Sep 2002, Guilherme Orcutt wrote:
> Which one would be the best with MySQL thinking in reliability and
> performance?
> Thanks a lot for your thoughts!
InnoDB scales *MUCH* better than BerkeleyDB. While it did fine in our
benchmarks consisting of a small number of records, in some be
hi list,
have got an error in trying to install MySQL-bench-3.23.52-1
rpm says, that the file MySQL-DBI-perl-bin is reqired, but
MySQL-DBI-perl-bin-1.1825-1 is installed. and so I could see in rpmfind.org,
this file is the last one.
would it be possible, that there should be another version
Maybe a simple
mysqladmin flush-logs
would have done it.
Mark Dieterich wrote:
>Jeremy,
>
>What would I do without the internet??? I restarted mysql by hand and
>the discrepency immediately went away. I should have thought about
>that.
>
>Thanks!
>
>Mark
>
>On Wed, Sep 11, 2002 at 12:01:29PM -
hi all,
i am running OS X 10.2 and
this version of mysql:
mysql> status
--
./bin/mysql Ver 11.18 Distrib 3.23.51, for apple-darwin6.0 (powerpc)
Connection id: 117
Current database: mysql
Current user: root@localhost
Current pager: stdout
Using outf
Jeremy,
What would I do without the internet??? I restarted mysql by hand and
the discrepency immediately went away. I should have thought about
that.
Thanks!
Mark
On Wed, Sep 11, 2002 at 12:01:29PM -0500, Jeremy Tinley wrote:
> Are you deleting any logs and not restarting the server after d
Folks,
I'm experiencing some strange behavior with our mysql server and I'm
curious to see if anybody else has had this problem. Over about a 3
month period, I noticed that the /var partition of our linux server
claims to fill up. The server is well into it's 3 month cycle now and I
have a shor
Is there a MySQL command that will return the amount of disk space used
by a particular database? I find lots of references to size limits on
tables / databases etc. but nothing on the actual 'disk usage'. This
would be nice to have I think, since without access to the data
directory on the server
At 10:12 -0600 9/11/02, [EMAIL PROTECTED] wrote:
>I can't add a new user or I don't know the proper way to log into the
>server. I added a user; call him webley. Ran my sql statement to insert into
>the user and db tables. Granted all rights because I was unsure how many
>rights my cgi script woul
Well, I finally figured out the problem, it was a corrupt installation
package. Funny thing is I downloaded three different times from different
sites. Working now, thanks.
-=Bryan=-
> -Original Message-
> From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, Septembe
EMS HiTech company is announcing the next version (1.9) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
EMS HiTech is announcing the special offer as we ha
I can't add a new user or I don't know the proper way to log into the
server. I added a user; call him webley. Ran my sql statement to insert into
the user and db tables. Granted all rights because I was unsure how many
rights my cgi script would need. It does need to create new tables and
populat
Toni,
Wednesday, September 11, 2002, 10:06:14 AM, you wrote:
TS> REALFROM: Toni Strandell <[EMAIL PROTECTED]>
TS> I am interested in the internal join algorithms, not the join types that
TS> can be found in the manual. My question is how the join types in the
TS> manual are processed internall
ant,
Tuesday, September 10, 2002, 10:28:13 PM, you wrote:
aasdn> Apparently in 4.0.3 does not like if statements in it's
aasdn> SELECT query... A query that once worked now returns 0 when I use
aasdn> an IF, rather than the proper value
>How-To-Repeat:
aasdn> This is a simple example o
>Description:
I have downloaded the binary mysql-3.23.52-hp-hpux10.20-hppa1.1.tar.gz grom mysql.com.
After unzipping it and create the symbolic link in /usr/local/, I executed the script
mysql_install_db. I receive the following message :
Preparing db table
Preparing host table
Preparing user tab
At 8:46 -0500 9/11/02, Dizzy Myope wrote:
>hi all:)
>
> int main(void)
> {
> .
> rs=mysql_store_result(&connection);//get result to rs
> ..
> mysql_free_result(rs);// it is necessary ???
> rs=mysql_store_result(&connection);// ge
Hi all.
Is the compiler advisory at mysql source donwload web page still valid?
The web page is http://www.mysql.com/downloads/mysql-3.23.html
I've seen it some monts ago and I want to know if I could compiler the
source with an gcc 3.0 compiler.
These are the notes:
Compiler Advisory: Severa
mysql, query speed up
_
Sorry I may be bothering you but I was thinking (gosh! this is so bizarre on
me) that may be we can make MySQL SGML compatible. I agree that MYSQL cannot
be manipulated to handle jerarquical information because this is not
Carsten
Thank you very much for pointing me in that direction, that nearly
solved the issue but I still get a duplicate for each record that is
in the second table (if WishListItems has 5 records for a Visitor, I
get 5 duplicates in the result).
I tried using GROUP BY to eliminate the duplicates
: i have one table with 4 fields
(nik,name,child_name,child_number)
i wan to query that the result will be like this
+--+---++++ +
| nik | name | child1 | child2 | child3 | child4 |
+--+---++++ +
| 1 | pai | mai | NUL
Which one would be the best with MySQL thinking in reliability and
performance?
Thanks a lot for your thoughts!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Put an index on password.
That should speed it up for you.
Kristian Koehntopp wrote:
>Am Mittwoch, 11. September 2002 15:19 schrieb Toni Strandell:
>
>>If you have proper indexes on alias, the optimizer should not
>>make a table scan. You can try to add an index on pw too. Or
>>you could combine
Am Mittwoch, 11. September 2002 15:19 schrieb Toni Strandell:
> If you have proper indexes on alias, the optimizer should not
> make a table scan. You can try to add an index on pw too. Or
> you could combine the two queries with an UNION.
Sorry, UNION is not available, as it is implemented only
I do:
slave stop
mysqlhotcopy
slave start
Martin Waite wrote:
>Mysql, sql, etc.
>
>
>Hi,
>
>I am using a slave to perform backups using mysqlhotcopy.
>This locks all tables in my database for 10 minutes.
>
>Sometimes the replication is aborted during the period
>that the tables are locked. The e
Stephen, mysqlcheck works while the server is running. P.
Gerald Clark wrote:
> Do not run myisamchk with the server running.
>
> Stephen Sokalski wrote:
>
> > version: 3.23.37 running on an RAQ
> > Problem: I can not log into MySql as root - it hangs after I give it
> > a pas
I am using a win2000 server where mysql is installed under phptriad.
I am trying to access the mysql databases from my machine by using the
winmysqladmintool.
This winmysqladmintool works on the server but on my machine the light is
constantly red and it says the service is not installed or runn
If you have proper indexes on alias, the optimizer should not make a table
scan. You can try to add an index on pw too. Or you could combine the two
queries with an UNION.
But beside this point you have a possible problem with the basic design.
It is possible that someone adds an alias that i
Do not run myisamchk with the server running.
Stephen Sokalski wrote:
> version: 3.23.37 running on an RAQ
> Problem: I can not log into MySql as root - it hangs after I give it
> a password.
> Background: MySql was running fine for a year and then just stopped
> running.
>
> Symptoms: 1)
I am using
mysql> select version() as version;
+-+
| version |
+-+
| 3.23.48-log |
+-+
1 row in set (0.00 sec)
on Suse Linux 8.0 and Solaris 8. The problem exists on both platforms.
I have
mysql> select count(*) from auth_kn;
+--+
| count(*) |
+
fpaul,
Wednesday, September 11, 2002, 11:00:56 AM, you wrote:
faadn> I have a problem with the command ALTER TABLE.
faadn> For example, this simple table "test" :
faadn> +-+---+--+-+-++
faadn> | Field | Type | Null | Key | Default | E
m,
Wednesday, September 11, 2002, 11:11:13 AM, you wrote:
mdwdnatodd> I have had this very strange problem with Mysql, it seems to start eating
mdwdnatodd> diskspace untill the disk is full, restarting the mysql process seems to
free
mdwdnatodd> all the used space again.
mdwdnatodd> Any idea w
Robert,
Friday, July 12, 2002, 12:51:41 PM, you wrote:
RB> I have unzipped mysql-3.23.51-win-src.zip but cannot find the setup.exe file
RB> anywhere.
You downloaded the source distribution :-)
RB> What do I do next?
Compile MySQL from source or download Win binary distribution.
--
For techn
Thanks Stephan for your answer but the error message would be : "ERROR 1062:
Duplicate entry '255' for key 1".
I tried to drop the key : "ALTER TABLE test DROP PRIMARY KEY" but I had this
message : "ERROR 1075: Incorrect table definition; There can only be one auto
column and it must be one auto
anand,
Wednesday, September 11, 2002, 8:05:48 AM, you wrote:
av> I have redhat linux 7.1 and I have downloaded mysql-3.23.52
av> and followed all the instructions as to how to install and how
av> to bring up the database the scripts/mysql_install_db worked
av> fine and then I did ./bin/safe_m
BRACHET,STEPHAN (Non-HP-France,ex1) wrote:
> Hello,
>
> I need to do an update on a table :
>
> * Something like this : *
> UPDATE my_table mt
> SET mt.field1 = mt.field1 + 1
> WHERE mt.id = 100
> *
>
> And there can have concurrent updates on this record
Hello,
I need to do an update on a table :
* Something like this : *
UPDATE my_table mt
SET mt.field1 = mt.field1 + 1
WHERE mt.id = 100
*
And there can have concurrent updates on this record. is there a risk of 2
(or more) updates done at the same time an
Maybe it is because some of your id are bigger than 127 wich is the limit
for the Tinyint and when it is converted to this type, "127" is replacing
all your id bigger than 127. Then you have multiple id with 127.
Regards,
Stephan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Mysql, sql, etc.
Hi,
I am using a slave to perform backups using mysqlhotcopy.
This locks all tables in my database for 10 minutes.
Sometimes the replication is aborted during the period
that the tables are locked. The error message in the slave's
log is:
ERROR: 1053 Server shutdown in progr
You have downoladed the source zip file, and so you have to compile it
or
download the binary version.
Danilo
-Messaggio originale-
Da: Robert Barbaro [mailto:[EMAIL PROTECTED]]
Inviato: venerdì 12 luglio 2002 11.52
A: [EMAIL PROTECTED]
Oggetto: installing
I have unzipped mysql-3.23.5
I have unzipped mysql-3.23.51-win-src.zip but cannot find the setup.exe file
anywhere.
What do I do next?
Robert
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello everybody !!
I am a Chinese!! So my English is not very good.
I hope someone can understand my question!!
my question is :
The MySQL-3.x.x and MySQL-4.x.x can use BerkeleyDB.
But the version OF BerkeleyDB is V3.2.9,
How can I use BerkeleyDB-4.0.14 in MySQL
Thanks !!
Hi people,
Is there any way I can see how much space each database is using from the
innodb data file? Something showing how the space is divided among
the databases. Thanks.
sql,query
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
-
Yes, this is correct. But the thing is that I don't want to find out how
a certain query is processed but instead how the processing is done when
the query type is determined by the join optimizer. When the optimizer has
decided to do a full table scan, does it do it as a nested loop join, a
b
That is why you need to use the EXPLAIN command. As I understand it, MySQL
has a number of different ways of doing a JOIN, and it attempts to optimise
those dynamically by inspecting not only which indexes it has available but
the sizes of the tables involved (e.g. to try to use the brute-force s
How-To-Repeat:
1. Use: JDK 1.1.8
2. Use: mysql-connector-java-2.0.14-bin.jar
3. Run testsuite file Transaction.java/class
Problem in ResultSet.getDouble() when testing testsuite Transaction.java
file:
>java Transaction
java.lang.NoSuchMethodError: java.lang.Double: method
parseDouble(Ljav
Hi all.
Anybody knows how to obtain the server's ip number in MySQL?
Is there any variable or function?
Thanks in advance.
Iago
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
Hi Peter.
You should download the max version of mysql binaries from www.mysql.com. It
has innodb support.
Also you could download the source files and compile mysql with innnodb
support.
Iago
-Mensaje original-
De: Peter Goggin [mailto:[EMAIL PROTECTED]]
Enviado el: miércoles 11 de se
> I did the normal default install. It seems to start up the mySQL server
> automatically when I start up Windows. Hence my question:
>
> Is there a standard way to change that so the server only runs when
> explicitly invoked?
I think the WinMySQLAdmin program automatically installs MySQL as
Hello everyone.
I have had this very strange problem with Mysql, it seems to start eating
diskspace untill the disk is full, restarting the mysql process seems to free
all the used space again.
Any idea what could be wrong?
Kind regards
Michael Wulff Nielsen
--
Hello,
I have a problem with the command ALTER TABLE.
For example, this simple table "test" :
+-+---+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+---+--+-+-+
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
97 matches
Mail list logo
