Try looking in mysql\data\mysql.err or running mysqld --standalone, it may
provide more information.
> Hello everyone,
> I have mysql-3.23.39 installed on a Win2k Pro box (not sure why!). It had
> been running just fine, then all of a sudden stopped working.
> When I try a
> 'NET START mysql', I
MySQL provides three transaction-safe tables including Berkeley_DB, GEMINI
and InnoDB Tables, I have some queries on them:
1. What are the differences between these three type of transaction-safe
table types?
2. Which type should be used for the E-Commerce web site?
3. Is true that BDB is free
Hello everyone,
I have mysql-3.23.39 installed on a Win2k Pro box (not sure why!). It had
been running just fine, then all of a sudden stopped working. When I try a
'NET START mysql', I get the below error:
---Begin Error
The MySql service is starting.
The MySql service could
On Fri, 29 Jun 2001, @maury wrote:
> Greetings to all.
> I am new in the list. I need to know like I can consent with Code PHP to a
> database in MYSQL.
> Thank you for the Help that you can offer me.
> Amaury
there are many mysql function in php, mysql_query, mysql_connect, etc. PHP
manual wi
Well, the order in which the queries are made doesn't matter. The query with
LIMIT is always slower than the one
without it. When I used EXPLAIN SELECT... I actually
found that MySQL uses temporary table for the query with
the DISTINCT / LIMIT combination. I presume this slows it down.
Be well :
Duplicate entry for 'x' for key y means that there exists a unique key (key
1) on a certain column that already contains the entry '4'.. You are trying
to insert something with '4' and hence it complains since that key says it
must be unique.
In order to find out what line is #46... its the 46th
Actually I'm not trying to create a table I'm trying to create a record in
that table and instead of having to type in all 49 fields into the "insert
into table" command I was hoping you could copy a record that already exists
and just change the necessary fields.
-Original Message-
From
Hi;
I'm trying to learn MySQL, having some difficulties:
mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)
for pc-linux-gnu (i686)
Getting the following error:
ERROR 1062 at line 46: Duplicate entry '4' for key 1
What I did was:
mysqldump -u jimjones -p XxXJimmy > lovingdata-Db-test
John Wythe/SCO:sysdev:root wrote:
> Thanks for the Reply Gerald.
>
> I tried your suggestion, but it does not make any difference.
>
> Should there not be an implied ORDER BY when using an index?
>
> John
>
> Gerald Clark wrote:
>
> > First of all, there is no NEXT record without an ORDER BY.
> >
My host has set the max_allowed_packet to only 16384, so I'm unable to do
large queries, such as submitting large text files into the database.
Is there a way to increase the max_allowed_packet? Keeping in mind I'm on a
shared host.
Thanks in advance!
Jez
__
This was sent to me, and it should've gone to the list instead.
Original Message
Subject: Re: message traffic
Date: Fri, 29 Jun 2001 11:17:57 -0700
From: "Michael Tam" <[EMAIL PROTECTED]>
To: "Ashley M. Kirchner" <[EMAIL PROTECTED]>
References:
<[EMAIL PROTECTED]>
<[EM
Hi All..
I created a table ..
create table A (
A1 int(4) auto_increment,
A2 varchar(16),
primary key (A1))
password='password';
'mysql --vesion' returns the following line on my system:
mysql Ver 11.15 Distrib 3.23.39, for pc-linux-gnu (i686)
My question is ... How the password option work on
At 3:40 PM -0400 6/29/01, Web Mailing List wrote:
>Hi, everybody here,
>
>Anybody can help with
>telnet to Linux and login to mySQL, show information about current mysql
>setting,
>create new DB, and table?
>
>Since, I am using MSSQL under NT platform, it is pretty much different..
Why? You can
Greetings to all.
I am new in the list. I need to know like I can consent with Code PHP to a
database in MYSQL.
Thank you for the Help that you can offer me.
Amaury
-
Before posting, please check:
http://www.mysql.com/man
Greetings to all.
I am new in the list. I need to know like I can consent with Code PHP to a
database in MYSQL.
Thank you for the Help that you can offer me.
Amaury
-
Before posting, please check:
http://www.mysql.com/manual
I was trying to install Mysql in win 98 and after several attempts all I
got was:
(using mysqld command)
(I also send you the my.cnf file I had to edit several times)
Please help
InnoDB: a new database to be created!
InnoDB: Setting file c:\ibdata\ibdata1 size to 20971520
InnoDB: Database phys
flush privileges.
Julia A. Case wrote:
> When I create a database for a customer I normally just use the following command
>
> grant all on database.* to user;
>
> And this works fine... But one customer on one of his databases can't use the alter
> command... So I went in and did a "grant
On 29-Jun-01 Sönke Tesch wrote:
> Hi!
>
> The CASE statement doesn't seem to work, even the three examples given in
> the
> docs (7.4.8 Control Flow Functions) return errors:
>
> mysql> select case 1 when 1 then "one" when 2 then "two" else "more" end;
> ERROR 1064: You have an error in your SQ
Hi, everybody here,
Anybody can help with
telnet to Linux and login to mySQL, show information about current mysql
setting,
create new DB, and table?
Since, I am using MSSQL under NT platform, it is pretty much different..
Thanks lot
Amy
Hi, everybody here,
Anybody can help with
telnet to Linux and login to mySQL, show information about current mysql
setting,
create new DB, and table?
Since, I am using MSSQL under NT platform, it is pretty much different..
Thanks lot
Amy
- Original Message -
From: "Kelsey Cummings" <[
I'm sure this is been covered before but I couldn't find any
list archives. I've just aquired a pair of clustered NetApp
740's for a steal of a deal and now I'm trying to figure out
what I can migrate to them. The thought occured to me that
since Oracle performs so well on NetApps over NFS that
Because it wasn't in system cache yet?
X Gogo wrote:
> Hi,
>
> I've tried the folowing query:
> SELECT DISTINCT column1 FROM table1 LIMIT 10;
> and got the result for 0.23 sec.
> Then I've tried the same query without limit:
> SELECT DISTINCT column1 FROM table1;
> and got the result fo
At 12:08 29/06/2001 -0300, Marcio - ProgMar wrote:
Hi!
Are you using PHP or Apache ? Because this behavior was already
reported only for Win98 and until now I wasn't be able to repeat
the same behavior on my machine.
The possible cause should be an environment situation that make
MySQL to loss, m
When I create a database for a customer I normally just use the following command
grant all on database.* to user;
And this works fine... But one customer on one of his databases can't use the alter
command... So I went in and did a "grant alter on database.* to user" and that
didn't fix it.
Hi,
I am running mysql 3.23.38-log with the my-huge.cnf and I saw that one table was
getting pretty close to the 2gb's so I decided to recompile the mysql with the
--with-raid parameter. And I do so, the compile goes fine and when I tried to run up
the server it did this:
root 15677 1.0
Hi, MySQL seems to really under perform when using joins.
Am I doing something wrong?
I have the following query:
SELECT DISTINCT Product.ProductID, Product.Title, ProductFormat.Price,
ProductFormat.TradePrice, ProductFormat.ProductCode, ProductFormat.Format,
ShoppingCart.Quantity
FRO
Hi,
I have radacct.ISD and radacct.frm files, but I don't have
radacct.ISM file. How can I rebuild this file ?
Thanks
Mucahit
I am use the MySQl Win 32 in win98 version 3.23.27-beta and too in 3.23.39. After 5
minutes the server stop, but MySqlAdmin don't show it stopped, then I stop it in
MySqlAdmin and restart, again I have more 5 minutes.
This is only for developer, no my server, but this problem is annoying. This
Hi!
Error number 3 in Windows is
3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND
Did you create a directory for log files before starting MySQL?
In the second printout you probably have created the directory.
But because database creation failed the first time, you have
Hi!
Was UPDATE/REPLACE command implemented?
I mean, a command which does update and if it
updated to record to match an already existing
unique index then the old record is killed and the
new stays.
Example ( UPPLACE - UPDATE/REPLACE command):
table: ids
ID (primary key) NAME
1 a
2 b
3 c
4
Hi
Also Nusphere have just released GEMINI tables which support row
locking.Been on their beta team since day one and the commercial product is
very good. Easy to setup with their install procedure and all round worth
every penny. Their support staff have been fantastic, never once letting me
dow
From: Bhartendu Maheshwari
Date: Saturday, June
30, 2001 07:21:08 AM
To: [EMAIL PROTECTED]
Subject: Re: Problem in
initializing mySQL on Windows Plateform
Thanx for yr help
Hi,
I've tried the folowing query:
SELECT DISTINCT column1 FROM table1 LIMIT 10;
and got the result for 0.23 sec.
Then I've tried the same query without limit:
SELECT DISTINCT column1 FROM table1;
and got the result for 0.01 sec. which is some 23 times
faster. There are about 1 rows i
Either put
datadir=/home/mydatadir
in the [mysqld] paragraph of the my.cnf file,
or move the data directory and create a symbolic link pointing the new
to the old.
Either way, shut down the server first.
tpchan wrote:
> Dear all,
>
> I installed mysql version 3.22.32 on Red Hat 6.2 using th
Hi,
I have a PIII 800MHz 2GB RAM Linux (Suse 6.4) server running mysql version
3.23.28
I also have 2 Solaris machines a E440R with 2x450MHz CPUs and 512MB of RAM
(this is results 2 & 3)
and a E4500 with 4x450MHz 4MB cache CPUs and 2GB of RAM with a 12 disk SCSI
array connected via fibre.
But but
I have a table with an autoincrement primary key, and a I hold list of the
keys of a number of records which I want to UPDATE. How can I most
efficiently write an UPDATE command which will update all the record whose
keys are on my list?
I thought I could put the keys I have into a temporary ram
On Fri, 29 Jun 2001 15:29:08 +0200, Gerlinde Fischer
<[EMAIL PROTECTED]> wrote:
I don't believe BDB table handler support row-locking. I suggest looking at
using Innobase tables handlers.
>>Hi,
>>I have the following configuration
>>
>>I have Linux
>>I have compile mysql with the following co
I believe BDB uses page locking, so you will likely need more than one
record before you can avoid the lock.
Gerlinde Fischer wrote:
> Hi,
> I have the following configuration
>
> I have Linux
> I have compile mysql with the following configure parameters:
> ./configure --enable-shared --with
On Fri, 29 Jun 2001, Krzysztof Kowalski wrote:
> Hi, I'm a new user, and I have question: I have 2 tables
> info (table1)
> -
> id | data | naglowek | kto | link
>
> news (table2)
> -
> id | data | naglowek | kto | link | email | tresc | inne
>
> and I want to ge
First of all, there is no NEXT record without an ORDER BY.
LIMIT returns a subset of the selected rows of the result set.
The result set must be selected and ordered before it can be limited.
you probably want:
SELECT * from wk004.slsf01 where ___RecNo > 3000 order by ___RecNo limit 1;
[EMAIL P
maybe you got the id-field as tinyint??
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 29, 2001 3:13 PM
Subject: Re: Loading Textfile into DB
> Right now, you pretty much have to compare the input to your
You did not put the line
[mysqld]
before the server options so the server knows which lines belong to it.
Bhartendu Maheshwari wrote:
> Hello
>
> I had installing mySQL as well myODBC, but when I run mysqld it has given an
> error
>
> C:\>mysqld
> error: Found option without preceding group
If you run a query with a ( possibly malformed ) join that produces a
very large output table, you may run out of disk space. At this point
that thread will sleep until space becomes available.
Next time you run out of space, check your /tmp ( or whatever you may
have set the MySQL temp dire
I have this table definition:
table_1
+--+-+--+-+-++
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-++
| id | int(15) | | PRI | NULL| auto_inc
Hi, I'm a new user, and I have question: I have 2 tables
info (table1)
-
id | data | naglowek | kto | link
news (table2)
-
id | data | naglowek | kto | link | email | tresc | inne
and I want to generate one big tabele contains those 2 (table1 and
table2). It's so
Hi,
I have the following configuration
I have Linux
I have compile mysql with the following configure parameters:
./configure --enable-shared --with-berkeley-db
--with-mysqld-ldflags='-all-static'
I have created a BerkleyDB-table.
After that I have
set autocommit=0 and I have inserted one row
Right now, you pretty much have to compare the input to your loaded
table and see which records are missing. Check the input file to see
what is wrong with them.
Dominic Brander wrote:
> Hi
>
> I'm trying to load data from a tab deliminated textfile into my table
> named blick_test:
> load
MySQL doen not yet support nested queries.
Jawad Khan wrote:
> server version 3.23.35
>
>
>> -Original Message-
>> From:Khan, Jawad [COLE:6S34:EXCH]
>> Sent:Thursday, June 28, 2001 1:13 PM
>> To: '[EMAIL PROTECTED]'
>> Subject: I get SYNTAX ERROR 1064 with mySQL
Hi Karl,
native threads on FreeBSD does not yet support multi processor,
however you can try using the ports collection, cvsup the latest
ports, then
cd /usr/ports/databases/mysql323-server
DB_DIR=/usr/local/var WITH_LINUXTHREADS=yes make
make install
Change the DB_DIR to where you want you da
Hi Katy,
The problem you are having is related to a bug in the Fbsd4.2
release. There was a bug in the compiler and several in the threads
packages. I would suggest upgrading to Fbsd 4.3 ASAP, which is
excellent. There were some patches that could be applied to Fbsd 4.2,
you can look in the
This is probably not the best recommendation but if you are compiling from
the source distribution, you might locate where the comment character is
defined and change it to some other character and recompile. I have no idea
of the potential ramifications in doing this and you would need to be very
BTW, it has developed into a standard on those list companies who
have developed techniques along the lines of
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
and I assume that it has proven useful in the long run (i.e.
eGroups, OneList, now YahooGroups, ListBot and others).
Personally, I don't car
Hi,
I am getting the following errors on compilation of DBI perl module on
solaris 8.
# make
mkdir blib
mkdir blib/lib
mkdir blib/arch
mkdir blib/arch/auto
mkdir blib/arch/auto/DBI
mkdir blib/lib/auto
mkdir blib/lib/auto/DBI
mkdir blib/man1
mkdir blib/man3
cp lib/DBI/W32ODBC.pm blib/lib/DBI/W32OD
Hi,
I've come up with an interesting problem and reading the MySQL book from DuBois hasn't
helped me. I have the following scenario. A user can log in over the web to our site.
Use the internet pages he can carry out functions that are provided by the pages. The
user has access to three tables
Hi,
I am facing problems while compiling mysql server on solaris 8. I am using
the mysql source code. The problem is as folows:
./configure
loading cache ./config.cache
checking host system type... sparc-sun-solaris2.8
checking target system type... sparc-sun-solaris2.8
checking build system type.
see this :
About mysql & vb6
http://www.avukatpro.com/mysql.html
- Original Message -
From: Dennis Salguero <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 29, 2001 6:03 AM
Subject: Re: Connecting to MySQL w/VB
> - Original Message -
> From:
Joel,
I have used the MySQL.OLEDB Provider, but haven't been able to get it to
work on anything except 'localhost'.
So, I use the OLEDB provider for ODBC drivers, and then use a MySQL DSN. I
did mail the people who built the provider
a month or two ago, but no response.
If you, or anyone else, f
hi there again!
some of you may have read my posting from yesterday (thx to Benjamin Pflugmann, who
was the only one to reply...).
now my problem is half the way solved. the query looks now like:
"SELECT X, Y, Z, Name, Ruler, Size, Score, SUM(Score) AS Summe FROM Planetarion
GROUP BY X, Y H
Greger Haga writes:
> Hi friends!
> Sorry for being off topic..but what's the status of mysql++, is it in
> active development?
> Greetings!
>
> --
> Greger Haga
> Finland
> ICQ 120338800
> HTTP://www.geocities.com/gregerhaga
> http://counter.li.org/
>
>
>
Thanks for asking a question.
MyS
Hi!
The CASE statement doesn't seem to work, even the three examples given in the
docs (7.4.8 Control Flow Functions) return errors:
mysql> select case 1 when 1 then "one" when 2 then "two" else "more" end;
ERROR 1064: You have an error in your SQL syntax near '1 when 1 then "one" when
2 then "t
Dear all,
I installed mysql version 3.22.32 on Red Hat 6.2 using the rpm package.
Since mysql data directory is stay in /var/lib/, plus my database is growing
bigger day by day, my problem now is that the '/var' partition running short
of free hard disk space.
What I'm trying to do is to transfe
Hi
I'm trying to load data from a tab deliminated textfile into my table
named blick_test:
load data local infile "public_html/DB2.txt" into table blick_test
ignore 1 lines;
this works pretty fine, except I only get the first 256 records instead
of all 503!
message:
Query OK, 256 rows affected (
Hi,
has anyone used the OLEDB driver instead of ODBC for MySQL & Win32? Are
there performance improvements?
Are there any Win32 specific install/performance tweaks?
regards
Joel Hughes
[EMAIL PROTECTED]
-
Before posting, pl
I am using a DLL called MYVBQL.dll which is also on the mysql web site and
it works like a dream. Don't need no ODBC driver, and all that stuff.
Similar to ADO but also quite different. Some bugs but if you stick to SQL
statements to insert/update/delete info it works like a dream and is very
fast
I have a table in a MySQL database on a Solaris system which contains log
entries and have stupidly overflowed Solaris' 4GB file
limit. The table is unusable. isamchk reports:
error: 'log.ISD' is not a ISAM-table
I have tried making a truncated copy of the file and isamchk'ing the
shorted
Hi friends!
Sorry for being off topic..but what's the status of mysql++, is it in
active development?
Greetings!
--
Greger Haga
Finland
ICQ 120338800
HTTP://www.geocities.com/gregerhaga
http://counter.li.org/
_
Do You Yahoo!?
Get your
Give MyODBC a try, its on the mysql.com site
and its given my no problems at all in vb.
Sean
-Original Message-
From: Robert Skinner [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 29, 2001 3:45 AM
To: [EMAIL PROTECTED]
Subject: Connecting to MySQL w/VB
I am trying to connect to MySQL u
Hi everybody, your help please
I meet the well-known problem with 3.22 mysql on a 6.1 redhat linux platform.
Database error: Invalid SQL: select ..blabla
MySQL Error: 1114 (The table 'SQL54_0' is full)
Session halted.
I put the option big-tables in all the following groups in the .my.cnf fil
HI guys !
I have some problem. Let's go !
I have 3 tables. Fields are describe below:
1) table1
| id (int 3) | comment (text) | t (timestamp 14) |
she holds:
| 1 | there is my comment1 | 200010606123456 |
| 2 | there is my comment2 | 200010606123456 |
| 3 | there is my comment3 | 2000
I am having a problem under RedHat 7.1 that I didn't see under 6.2. When
trying to compile --with-libwrap the code errors with:
mysqld.cc: In function `void *handle_connections_sockets (void *)':
/usr/include/tcpd.h:131: too many arguments to function `void sock_host
()'
mysqld.cc:2252: at this
Hi,
mysql under FreeBSD has apparantly problems to distribute threads on
serveral
processors. So does it make sense to install several instances of the
mysql-server on one
machine, which perform different tasks, but use one database? In other
words, is the access to the database the performan
Can anyone give me a pointer as to whether an update query, similar to below, is
possible - and if so how?
(I've put it in caps since that's the way it is typed in mysql)
UPDATE SUBCATEGORY
SET CATID=CATEGORY.CATID
WHERE
SUBCATEGORY.ORGID=CATEGORY.ORGID
SUBCATEGORY and CATEGORY are table nam
72 matches
Mail list logo