> Hi,
>
> I'm trying to create a table using the commands below, and everything
seems
> to work and the table is there - I just can's access any of the fields.
This
> happens on both my Windows and Linux versions of MySQL. Any help is
> appreciated. Note, I have 8 other databases that I created wit
Hi,
Last week, the all tables in one database had been deleted, which is
second times since I upgrade my operation system from NT 4.0 to Server
2003. Before that, they had been deleted many times.
I just copied all table files to one database(one directory). They
will work normally. I don't know
Just some updated info on this. It appears everything is there and working.
I can update the table, do queries on the table, etc. - the only thing I
can't do is a 'desc whatever' I still get the 1146 error.
Thanks
-Original Message-
From: Beauford [mailto:[EMAIL PROTECTED]
Sent: Sep
Hi,
Is there any way AUTO_INCREMENT column cann't me Primary key ?
One table has one column auto_increment which I want to convert into non primary key
but I also want to maintain the column.How to do that? thanks
-
Do you Yahoo!?
vote.yahoo.c
Hi,
I'm trying to create a table using the commands below, and everything seems
to work and the table is there - I just can's access any of the fields. This
happens on both my Windows and Linux versions of MySQL. Any help is
appreciated. Note, I have 8 other databases that I created with no proble
They should return the same values, but possibly in a different order.
SELECT foo, bar, baz FROM table GROUP BY foo, bar, baz;
returns the values of foo, bar, and baz, once for each unique combination,
ordered by foo, bar, baz. That is, GROUP BY does a free ORDER BY.
SELECT DISTINCT foo, bar,
Does the mysql server return to the client (DBI in this case) the query
execution time? If so, how do I retrieve it?
Thanks,
Joe
--
Joe McGuckin
ViaNet Communications
994 San Antonio Road
Palo Alto, CA 94303
Phone: 650-213-1302
Cell: 650-207-0372
Fax: 650-969-2124
--
MySQL General Mai
- Original Message -
From: "Scott Haneda" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 15, 2004 8:12 PM
Subject: Group by and results
> Are these 2 statements the same?
>
> tSql1 = select distinct foo, bar, baz from table
> tSql2 = select foo, bar, baz from tab
Are these 2 statements the same?
tSql1 = select distinct foo, bar, baz from table
tSql2 = select foo, bar, baz from table group by foo, bar, baz
Why would I get different results?
--
-
Scott HanedaTel: 41
On Wed, Sep 15, 2004 at 01:44:21PM -0700, Sanjeev Sagar wrote:
> Thanks !
>
> I am trying to run make test but it's giving me following error
>
> [EMAIL PROTECTED] DBIx-DWIW-0.41]# make test
> PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
> 1..1
> # Running under perl version
Thanks !
I am trying to run make test but it's giving me following error
[EMAIL PROTECTED] DBIx-DWIW-0.41]# make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl
1..1
# Running under perl version 5.008 for linux
# Current time local: Wed Sep 15 13:42:27 2004
# Current time
On Wed, Sep 15, 2004 at 01:10:35PM -0700, Sanjeev Sagar wrote:
> I am trying on cpan.yahoo.com and it's giving me following error
>
> The requested URL /authors/id/J/JZ/JZAWODNY/DBIx-DWIW-0.41.tar.gz was not found on
> this server.
Hmm.
wget http://cpan.yahoo.com/authors/id/J/JZ/JZAWODNY/DBIx-D
I am trying on cpan.yahoo.com and it's giving me following error
The requested URL /authors/id/J/JZ/JZAWODNY/DBIx-DWIW-0.41.tar.gz was not found on
this server.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Wed 9/15/2004 1:05 PM
To: Sanjeev Sagar
Cc: [EMAIL PR
On Wed, Sep 15, 2004 at 11:27:55AM -0700, Sanjeev Sagar wrote:
>
> Hello All,
>
> I am trying to install DBIx::DWIW but giving me following error.
>
> No such file `DBIx-DWIW-0.41.tar.gz'
>
> I am trying to install from CPAN
>
> cpan> install DBIx::DWIW
>
> Could not fetch authors/id/J/JZ/JZ
On Wed, 15 Sep 2004 11:27:55 -0700, Sanjeev Sagar
<[EMAIL PROTECTED]> wrote:
>
> Hello All,
>
> I am trying to install DBIx::DWIW but giving me following error.
>
> No such file `DBIx-DWIW-0.41.tar.gz'
>
> I am trying to install from CPAN
>
> cpan> install DBIx::DWIW
>
> Could not fetch autho
Hello
I am trying to drop a database but I have the following: ERROR 1016: Can't open file:
'Alias.InnoDB' (errno: 1)
In fact it looks like the synchro is lost between FRM and IBD. (I use a multiple
tablespace configuration) according to
http://www.innodb.com/ibman.php section 15.1.
Wh
> I compiled mysql w/o this option. Is there any file that I can modify and
> bounce the server to take this? I modified:
>
> my-path/share/mysql
>
> -rw-r--r-- 1 root other 4938 Jul 23 10:32 my-huge.cnf
> -rw-r--r-- 1 root other 4914 Jul 23 10:33 my-large.cnf
> -rw-r--r--
Hello All,
I am trying to install DBIx::DWIW but giving me following error.
No such file `DBIx-DWIW-0.41.tar.gz'
I am trying to install from CPAN
cpan> install DBIx::DWIW
Could not fetch authors/id/J/JZ/JZAWODNY/DBIx-DWIW-0.41.tar.gz
Giving up on '/root/.cpan/sources/authors/id/J/JZ/JZAWODNY
Thanks to all for your replies!
Installing myodbc fixed the problem.
Thanks again!
Eve Atley wrote:
This is also very useful:
Getting PHP 5 to work with MySQL
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10246585
- Eve
-Original Message-
From: Greg Donald [mailto:[EMAIL PROTE
> Another question related to server start:
>
> Can I configure mysql.sock to some other dir, since /tmp/mysql.sock might
> easiely being deleted by someone?
>
>
> Thanks!
> Annie
>
>
Yes, you can - and I'd make that recommendation on shared systems.
configure option:
--with-unix-socket-path=/pat
> Hello,
>
> >>Is gamme the last step
> >>until the 4.1.4 will be released?
> >
> > Yes.
> >
> >>Or will rc's follow before?
> >
> > No.
>
> that's nice to hear. So when will the final version be released? 2 days?
> 2 weeks?
>
> Regards
> Marten
>
Wishful thinking :-)
As far as I'm aware there is
This is also very useful:
Getting PHP 5 to work with MySQL
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10246585
- Eve
-Original Message-
From: Greg Donald [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 15, 2004 11:10 AM
To: nestor(earth)
Cc: [EMAIL PROTECTED]
Subj
Afternoon all
The problem: I am doing a simple query on a table, comparing 2 columns to
constants. The table is indexed with a compound index on these 2 columns.
The join optimizer only seems to notice that the first column is indexed,
and ignored the second column. The table is large (16M rows),
In the last episode (Sep 15), Marten Lehmann said:
> >>Is gamme the last step
> >>until the 4.1.4 will be released?
> >
> >Yes.
> >
> >>Or will rc's follow before?
> >
> >No.
>
> that's nice to hear. So when will the final version be released? 2
> days? 2 weeks?
Previous history (3.23 and 4.0 t
At 18:13 +0200 9/15/04, Marten Lehmann wrote:
Hello,
in 4.0.20 I was happy that German Umlauts are
sorted correctly (ä -> ae, ö -> oe, ü -> ue).
With 4.1.4 the configuration stops:
checking "character sets"... configure: error:
Charset 'latin1_de' not available. (Available
are: binary ascii ar
On Wed, 15 Sep 2004, Chris Blackwell wrote:
> slightly off topic, but you can sort of build apache with mysql support.
>
> mod_auth_mysql allows you to authenticate users and groups against a DB
>
> http://sourceforge.net/projects/modauthmysql/
That's actually the reason I originally said I compi
On Wed, 15 Sep 2004 17:48:50 +0200, Marten Lehmann <[EMAIL PROTECTED]> wrote:
> I don't want to allow either. That's why I'm asking. From outside, noone
> can connect as root directly. And as noone has access to localhost
> through ssh or whatever, noone except me can login as root. My question
> w
Hello,
in 4.0.20 I was happy that German Umlauts are sorted correctly (ä -> ae,
ö -> oe, ü -> ue). With 4.1.4 the configuration stops:
checking "character sets"... configure: error: Charset 'latin1_de' not
available. (Available are: binary ascii armscii8 ascii big5 cp1250
cp1251 cp1256 cp1257 c
slightly off topic, but you can sort of build apache with mysql support.
mod_auth_mysql allows you to authenticate users and groups against a DB
http://sourceforge.net/projects/modauthmysql/
chris
-Original Message-
From: andy thomas [mailto:[EMAIL PROTECTED]
Sent: 15 September 2004 16
Hello,
Is gamme the last step
until the 4.1.4 will be released?
Yes.
Or will rc's follow before?
No.
that's nice to hear. So when will the final version be released? 2 days?
2 weeks?
Regards
Marten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This one has to be easy, but it seems to be hidden in the documentation
(translation: I'm too dense to find it ).
When doing an insert, there is the feedback line "1 Row Inserted". When
reloading a database from a backup, this can drastically slow d
Hi,
I would never allow anyone except myself to connect to my MySQL server
as the root MySQL user.
I don't want to allow either. That's why I'm asking. From outside, noone
can connect as root directly. And as noone has access to localhost
through ssh or whatever, noone except me can login as root
You have to rebuild PHP against the new MySQL libraries.
Curtis
Greg Donald said:
> On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth)
> <[EMAIL PROTECTED]> wrote:
>> This more of a php mysql question. I have installed PHP ( 5.01) with
>> Apache(1.31) and it runs.
>> I have install Mysql (the l
On Wed, 15 Sep 2004 17:10:27 +0200, Marten Lehmann <[EMAIL PROTECTED]> wrote:
> imagine the following setup:
>
> - a mysql-server
> - a client on a different host
>
> Privileges on the mysql-server are setup in a manner, that users can
> connect from every host, but not from localhost (and they d
On Wed, 15 Sep 2004, Greg Donald wrote:
> On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas <[EMAIL PROTECTED]> wrote:
> > Did you build both php and apache with MySQL support?
>
> I wasn't aware you could build Apache with MySQL support. How is that done?
Apologies - I should have said just
You will likely want to read this:
http://us4.php.net/mysql
"In PHP 5, MySQL is no longer enabled by default, nor is the MySQL library
bundled with PHP. Read this FAQ for details on why. Because of this,
Windows users will need to enable php_mysql.dll inside of php.ini and either
copy libmysql.d
> People,
>
> This more of a php mysql question. I have installed PHP ( 5.01) with
> Apache(1.31) and it runs.
> I have install Mysql (the latest as of last night) and it runs. My
> problem is that PHP does not see
> Mysql. Now I have done this installation 4 or 5 times but th elast time
> was
On Wed, 15 Sep 2004 16:02:45 +0100 (BST), andy thomas <[EMAIL PROTECTED]> wrote:
> Did you build both php and apache with MySQL support?
I wasn't aware you could build Apache with MySQL support. How is that done?
--
Greg Donald
http://gdconsultants.com/
http://destiney.com/
--
MySQL General
Mine is owned by root:root and has its sticky bit set.
Does not allow a normal user to delete.
- Original Message -
From: "Annie Xie" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, September 15, 2004 9:57 AM
Su
http://www.catb.org/~esr/faqs/smart-questions.html
Stop repeating the same question or you will never get an answer. Try again
please.
> Hi
>
>
> I have installed some software on aix5.2 .
> the list of software:
> apache-1.3.29-1.aix4.3.ppc.rpm
> php-4.0.6-5.aix4.3.ppc.rpm
> MySQL-3.23.47-3.aix
Hello,
imagine the following setup:
- a mysql-server
- a client on a different host
Privileges on the mysql-server are setup in a manner, that users can
connect from every host, but not from localhost (and they don't even
have access to localhost). root on the other hand is allowed to connect
fr
On Wed, 15 Sep 2004 08:04:08 -0700, nestor(earth)
<[EMAIL PROTECTED]> wrote:
> This more of a php mysql question. I have installed PHP ( 5.01) with
> Apache(1.31) and it runs.
> I have install Mysql (the latest as of last night) and it runs. My
> problem is that PHP does not see
> Mysql. Now I
On Wed, 15 Sep 2004, nestor(earth) wrote:
> People,
>
> This more of a php mysql question. I have installed PHP ( 5.01) with
> Apache(1.31) and it runs.
> I have install Mysql (the latest as of last night) and it runs. My
> problem is that PHP does not see
> Mysql. Now I have done this instal
Does anyone know if I can construct my insert/select statement this way
instead:
INSERT INTO wow.resume_erp
( field1, field2, etc)
INSERT INTO wow.candidate_erp
( field1, field2, etc)
SELECT SQL_CALC_FOUND_ROWS *
FROM wow.resume r
INNER JOIN wow.candidate c
WHERE r.Section_ID = '1'
AND MATCH (r.S
OS is W2K.
-Original Message-
From: "nestor(earth)" <[EMAIL PROTECTED]>
Sent: Sep 15, 2004 8:04 AM
To:
Cc: [EMAIL PROTECTED]
Subject: Mysql and PHP
People,
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest
People,
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest as of last night) and it runs. My
problem is that PHP does not see
Mysql. Now I have done this installation 4 or 5 times but th elast time
was over a year
- Original Message -
From: "æé" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, September 15, 2004 9:25 AM
Subject: mysql still can't start up
> when I used the command "safe_mysqld start" the system told me "
> Starting mysqld daemon with databases from /var/lib/my
- Original Message -
From: "Juan Alvarado" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 15, 2004 8:56 AM
Subject: Windows specific characters
> Hello:
>
> I have some data in a spreadsheet that I need to load into a database. The
data in the excel spreadsheet a
Hi
I have installed some software on aix5.2 .
the list of software:
apache-1.3.29-1.aix4.3.ppc.rpm
php-4.0.6-5.aix4.3.ppc.rpm
MySQL-3.23.47-3.aix4.3.ppc.rpm
MySQL-client-3.23.47-3.aix4.3.ppc.rpm
All of them was installed by using the command : rpm -i *.*
then
Apache and php can work
but
Is it possible to configure MySQL to have different max_connections
limit based on either user or host which is connecting to server?
I mean, suppose we have max_connections=500, is it possible to say that
from all external clients there could be at max 490 connections, while a
single host or u
If you simply Google on "MySQL for Dummies", you will find what you want.
You'll have to pay for it though. For example:
http://www.dummies.com/WileyCDA/DummiesTitle/productCd-0764516507,subcat-PROGRAMMING.html
If you want the standard MySQL manual in PDF format, you can find it at
http://dev.mysq
Hallo Everyone,
Well can someone please get me some Mysql for Dummies sort of pdf files;
Thanx in Advance
Regards
Shiva
ps:-
The problem is I'm not able to execute any of the commands after installing
Mysql in Windows 2000 P,
In short there is only this "Red Sign" which it is showing in the tas
Sorry last e-mail didnt contain all text for whatever reason it should be like
this:
--
Hello MC,
any results yet by any chance ? What conclusion did you get out of your
test ?
There is another threat going on with the subject line "Re: best-performing
CPU + platform for MySQL now?
Hello:
I have some data in a spreadsheet that I need to load into a database. The data in the
excel spreadsheet apparently contains windows specific characters. Whenever I import
the data into my database, those special characters remain and since my database runs
on an unix platform, I am get
Hello MC,
any results yet by any chance ? What conclusion did you get out of your test ?
There is another threat going on with the subject line "Re: best-performing
CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?"
Best regards
Nils Valentin
Tokyo/Japan
On Tuesday 27 July 2004 12:39,
On Wed, 15 Sep 2004, [GB2312] ÀîÈñ wrote:
> Hi
>
>
> I have installed some software on aix5.2 .
> the list of software:
> apache-1.3.29-1.aix4.3.ppc.rpm
> php-4.0.6-5.aix4.3.ppc.rpm
> MySQL-3.23.47-3.aix4.3.ppc.rpm
> MySQL-client-3.23.47-3.aix4.3.ppc.rpm
>
> All of them was installed by using the
> >
> > I have tried different URL's, including trying the ftp URL at Oakland,
> > USA, and the Australian URL previously cited. I get the same problem -
> > instead of getting a dialogue box giving me the option of saving the
> > file to disk (and, in what path), the browser commences downloading
Thanks, but already have innodb_buffer_pool_size=160M
and I've raised innodb_additional_mem_pool_size from 2M to 10M
And the problem remains the same.
Any sugestions?
Thanks
Mauricio
On Tue, 2004-09-14 at 18:05, Nickolai Nielsen wrote:
> Hi
>
> Try setting these variables in you conf:
> s
Hi
I have installed some software on aix5.2 .
the list of software:
apache-1.3.29-1.aix4.3.ppc.rpm
php-4.0.6-5.aix4.3.ppc.rpm
MySQL-3.23.47-3.aix4.3.ppc.rpm
MySQL-client-3.23.47-3.aix4.3.ppc.rpm
All of them was installed by using the command : rpm -i *.*
then
Apache and php can work
but
Are there any variables here I can tune to try and increase the the query?
mysql> show variables like '%buff%';
+-+---+
| Variable_name | Value |
+-+---+
| bdb_log_buffer_size | 262144|
| bulk_insert_buffer_size |
Hello,
I have two interfaces on my slave:
ppp0 80.80.80.8 ( -> Internet )
eth0 10.10.10.1 ( -> LAN )
and remote master host 192.168.168.168 available by 80.80.80.8.
How can I force mysql to start slave processes using 10.10.10.1
and not 80.80.80.8, which is he choosing by defualt.
I need similia
On Wed, 15 Sep 2004, [GB2312] ÀîÈñ wrote:
> Hi
>
>
> I have installed some software on aix5.2 .
> the list of software:
> apache-1.3.29-1.aix4.3.ppc.rpm
> php-4.0.6-5.aix4.3.ppc.rpm
> MySQL-3.23.47-3.aix4.3.ppc.rpm
> MySQL-client-3.23.47-3.aix4.3.ppc.rpm
>
> All of them was installed by using the
Hi
I have installed some software on aix5.2 .
the list of software:
apache-1.3.29-1.aix4.3.ppc.rpm
php-4.0.6-5.aix4.3.ppc.rpm
MySQL-3.23.47-3.aix4.3.ppc.rpm
MySQL-client-3.23.47-3.aix4.3.ppc.rpm
All of them was installed by using the command : rpm -i *.*
then
Apache and php can work
but
i solved the problem...
for the ones, who wants to know:
only creating an index on artikelnummer on both tables made the query
beeing ready after 2 seconds again :-)
Oliver
On Wed, 15 Sep 2004 00:38:59 +0200, Oliver Schiessl
<[EMAIL PROTECTED]> wrote:
MySQL 3.23.58:
ive got 2 tables with ca.
64 matches
Mail list logo
