On Wed, Jun 18, 2003 at 03:20:17PM -0400, Adam Nelson wrote:
> Where'd you get it. I've had bad experiences with generic machines but
> I'll take a peak if you send the link?
>
> There are a couple of things I didn't mention
>
> 2U Form Factor with tool-less rails
> Redundant Power Supply
> Redu
Hello Greg,
You are much better off using a not exists clause...
delete from child c
where not exists ( select 1 from parent p
where p.id = c.id)
Regards,
Jake Johnson
[EMAIL PROTECTED]
--
Plutoid - http://
This is one quick way to get the newest records of a group if you are
grouping by the sku and stock.
select stock, sku, qty
from table
where concat(dt_tm,stock,sku) IN (
select concat(max(dt_tm), stock, sku)
from table
group by stock, sku
)
Regards,
Jake Johnson
[EMAIL PROTECTED]
-
Hi,
I have a SQL issue I cannot figure out, perhaps somebody can help / solve / input on
this ...
I have a table with stock-status transactions like ...
2003-06-17 06:00 stockA SKU1 QTY 98
2003-06-16 06:10 stockA SKU1 QTY 101
2003-06-15 04:59 stockA SKU1 QTY 111
- the time for updating the tra
At 21:31 -0400 6/18/03, activeducation wrote:
Being new to mySQL could someone kindly shed some light on how
releases are typically scheduled at mySQL AB and what the phases,
and likely time spent in each phase, i.e. what is the significance
of the alpha, gamma, etc. designator for mySQL release
At 20:37 -0400 6/18/03, Andrew Pierce wrote:
I am trying to learn to use the C API for MySQL and have a question. I
have a table that has a primary key defined as int(11). I don't know what
data type this translates to in C. I thought maybe an unsigned int or an
unsigned long. I have this little lo
Hi,
I've just download MySQL Control Center to install on Redhat 9.0 for trying it. I used
it to connect to localhost database successful. But when I manipulate on it for some
functions, the program close suddenly and appear the line "Segmentation fault". I
tried it som times. but it still do
I'd suggest a version difference, but I guess that might rule out things working
in phpMyAdmin.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Martin H.J.Smetsers" <[EMAIL PROTECTED]>
To: "'mysql'" <[EMAIL PROTECTED]>
Sent: Wednesday, 18 June, 2003 15:
I am trying to delete some orphaned records in an old database on a
website that I've recently taken over. Although the website is php
driven, I am doing this manually in a mysql client.
Mysql 3.23.54
Tables:
Items:
Items_ID
Pictures:
Picture_ID
Items_ID
I want to get
Being new to mySQL could someone kindly shed some light on how releases are
typically scheduled at mySQL AB and what the phases, and likely time spent
in each phase, i.e. what is the significance of the alpha, gamma, etc.
designator for mySQL releases.
many thanks,
Sidney
--
MySQL General Maili
I am trying to learn to use the C API for MySQL and have a question. I
have a table that has a primary key defined as int(11). I don't know what
data type this translates to in C. I thought maybe an unsigned int or an
unsigned long. I have this little loop that cycles through the results of
a query
Search for PASSWORD @ www.mysql.com
It's a really convenient function.
-->-Original Message-
-->From: Grégoire Dubois [mailto:[EMAIL PROTECTED]
-->Sent: Wednesday, June 18, 2003 5:07 PM
-->To: 'Mysql'
-->Subject: Can we crypt passwords on MySQL
-->
-->Hi all,
-->
-->Is it possible to crypt
Hi all,
Is it possible to crypt the passwords on MySQL. If yes, how does it
work, and how is it to be implemented.
Any link would be great.
Thank you.
Grégoire Dubois.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
In http://www.mysql.com/doc/en/News-4.0.6.html
* mysql_change_user() will now reset the connection to the state of a
fresh connect (Ie, ROLLBACK any active transaction, close all temporary
tables, reset all user variables etc..)
So it is in there, starting with version MySQL 4.0.6.
-steve-
-
Hello,
I was just going through mysql.h, in st_mysql. i found a variable my_bool free_me,
what is the significance of this variable ?
Another question that has been bothering me - What happens if a query has been
started with mysql_real_query() and then for some reason mysql_close() is u
Just a note on this subject. We have a field that uses 0 to mean
something special too. It was a bad idea that is on my TODO list to fix
some day. (The corresponding table used 0 to mean something special, and
then joined to the table with the autoindex. The fix is too use null in
that other table
So it's a future thing since I can see MySQL is only at 4.0.13 now.
Anyway, I do prefer (hopefully there are others too ;) inserting directly
into user, db, host,... tables instead of using GRANT, so for this case I
(still) can use PASSWORD(), right ?!
BTW, maybe I'm missing something but what cou
> And, where's the repository?
www.phpclasses.org.
If you'd checked Google first, you wouldn't have had to wait for my reply.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Lingua2001" <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EMAIL PROTECTED]>;
> A lot of table scans do to bitmasked column values.
> Such that the above query will not utilize a key.
That statement gave me a cold shiver up my spine.
You could try an inverted index or match-cache technique, or
denormalization. These type of techniques are very app specific, but can
reduce
The 'user' table in the 4.3.7 chapter is a table used by the authentication
system in MySQL :)
Jocelyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; "Grégoire Dubois"
<[EMAIL PROTECTED]>
Cc: "'Mysql'" <[EMAIL PROTECTED]>
Sent: Thursday, June 1
Hi,
> configure: error: Didn't find the mysql library dir in
I had the same problem and I've fixed it manually (just edit
configure.in file).
In this file path to MySQl library directory is
"/usr/local/mysql/lib/mysql", I changed it to "/usr/local/mysql/lib".
But I had a lot of other problems dur
Strange...
This is what the online manual says in "4.3.7 Setting up passwords":
>>>
Passwords must be encrypted when they are inserted in the user table, so the
INSERT statement should have been specified like this instead:
mysql> INSERT INTO user (Host,User,Password)
-> VALUES('%','jeff
It's not recommended because in MySQL 4.1, it returns a different result
each time PASSWORD() is used, with the same input string.
For MD5/SHA1 function, take a look here :
http://www.mysql.com/doc/en/Miscellaneous_functions.html
Jocelyn
- Original Message -
From: "development" <[E
John,
actually, you should first try
innodb_force_recovery=2
and run CHECK TABLEs.
Regards,
Heikki
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 1:25 AM
Subject: Re: Innodb error
> John,
>
> what Linux kernel ver
Jocelyn
Why is that not recommended ?
Do you have any links for how to encrypt the password with MD5 ?
Freddie
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]
Sent: Freitag, 27. Juni 2003 00:19
To: [EMAIL PROTECTED]; Grégoire Dubois
Cc: 'Mysql'
Hi,
Using PASSWOR
Jonas,
After the insert, execute
SELECT LAST_INSERT_ID();
This always gives the last auto increment value generated by your database
connection.
Andy
> -Original Message-
> From: Jonas Geiregat [mailto:[EMAIL PROTECTED]
> Sent: 18 June 2003 19:26
> To: 'Mysql'
> Subject: probably a stu
At 13:14 2003-06-17, Bernd Jagla wrote:
Sorry I forgot to mention:
We are using IRIS on an Origion2000, 7GB memory, 8 CPUs. I was thinking of
spending up to $10K.
I also wanted the redundant data for speeding up the seeks, I also need to
speed up the writes.
Bernd
I assume You mean "IRIX on O2k".
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William R. Mussatto wrote:
> I've googled, but haven't got a hit, so please excuse if this has been
> covered many times before.
>
> System: linux, (debian for what it matters)
> tomcat 4.0
> java 1.3.1
> mysql 2.23.x
>
> Cure
I am trying to install MySql++. When I issue the
./configure command all seems to go well until it
generates an error which you can see below.
The version I am trying to install is 1.7.9 from
memory. I am using Mandrake 9.1 which has MySQL as one
of the installable options, which I have chosen.
John,
what Linux kernel version you are running? Did the first crash occur because
of the same assertion failure?
The InnoDB tablespace is probably corrupt and it asserts in purge or insert
buffer merge.
You can try starting with
innodb_force_recovery=4
in the [mysqld] section of your my.cnf.
I've googled, but haven't got a hit, so please excuse if this has been
covered many times before.
System: linux, (debian for what it matters)
tomcat 4.0
java 1.3.1
mysql 2.23.x
Curently we are using the older org.gjt.mm.mysql.Driver drivers.
We support many different sit
A lot of table scans do to bitmasked column values.
So
SELECT * FROM search_table where AND colN & 4;
Such that the above query will not utilize a key.
I was told at the last convention that mySQL had some good ideas on
allowing indexes for bitwise (arithmetic) columns but they are not qui
Hi,
Using PASSWORD function to crypt password is not recommended, it's mainly
used for internal mysql password encryption.
Prefer using MD5/SHA1 functions to encrypt a password.
Regards,
Jocelyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Grégoire Dubois" <[EMAIL PROTECTED]>
There is a PASSWORD('your_clear_text_password_here') function you can use
wherever you define a new password. See the manual for more.
Lian
> -Original Message-
> From: Grégoire Dubois [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 12:55 AM
> Cc: 'Mysql'
> Subject: Can we cryp
At 23:50 +0200 6/18/03, Fernando Martins wrote:
From: Paul DuBois [mailto:[EMAIL PROTECTED]
At 21:09 +0200 6/16/03, Fernando Martins wrote:
>In AUTO_INCREMENT fields, inserting a 0 into the field requests a new
>sequence number.
>
>Is it possible to turn off this behaviour? (without messing wi
Hi all,
Is it possible to crypt the passwords on MySQL. If yes, how does it
work, and how is it to be implemented.
Any link would be great.
Thank you.
Grégoire Dubois.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
From: Paul DuBois [mailto:[EMAIL PROTECTED]
> At 21:09 +0200 6/16/03, Fernando Martins wrote:
> >In AUTO_INCREMENT fields, inserting a 0 into the field requests a new
> >sequence number.
> >
> >Is it possible to turn off this behaviour? (without messing with
> the code,
> >of course)
>
> No.
>
> >
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Luca wrote:
> Hi,
>
> with MySQL 3.23.x i was able to retrieve information about Foreign keys
> by using the JDBC's method getImportedKey.
>
> The same code running on MySQL 4.0.13 alway return a null vector.
> I'm using mysql-connector-java-3.0.8-sta
Hi,
What would happen to my_table (~70MB of indexes) and its indexes if someone kills a
an optimize table query - 'OPTIMIZE TABLE my_table' . Im wondering if i should provide
a cancel button in my application during the optimization period. It is generally more
user friendly to provide one,
I'm getting this error in my log:
--
030618 15:08:24 mysqld started
030618 15:08:24 InnoDB: Started
030618 15:08:24 /usr/sbin/mysqld: Can't create/write
to file '/var/run/mysqld/mysqld.pid' (Errcode: 2)
/usr/sbin/mysqld: ready for connections.
Version: '4.0.12'
Thank you for your reply, Edward,
And, where's the repository?
Lingua
- Original Message -
From: "Becoming Digital" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 18, 2003 1:04 AM
Subject: Re: is CREATE VIEW possible in MySQL?
> > You have to implement the view functi
i havent used php, but this following would be my guess:
mysql_last_id() most likely uses @@identity internaly. Someone mentioned
that it returns last insert id per connection, then I am guessing that it
calls select @@identity immediatly after any insert, and stores it to be
returned later in t
A German translation of MySQL, Second Edition is now (or will soon be)
available. The translation of Chapter 6 (The MySQL C API) is
available for downloading as a PDF:
http://www.kitebird.com/mysql-book/
The "translations" page there has information about the German edition.
--
Paul DuBois
htt
Don Read wrote:
On 18-Jun-2003 Jonas Geiregat wrote:
I'm using php + mysql for my project
I want to get the last insert ID.
I could use the php function mysql_last_id();
but I could aslo use @@identity.
Now some people have advised me NOT to use @@identity, cause it's not
save buggy sometimes
Hi,
with MySQL 3.23.x i was able to retrieve information about Foreign keys by
using the JDBC's method getImportedKey.
The same code running on MySQL 4.0.13 alway return a null vector.
I'm using mysql-connector-java-3.0.8-stable-bin.jar to access MySQL.
There's somthing that I must set on MySQL
I tried to copy a table and got this mesagem, but I ´ve done this several
times ago...
Got error -1 from table handler
The download bundle for MySQL Solaris SPARC 32-bit includes instructions
for installing Windows and Linux versions, but apparently not Solaris SPARC versions.
(There are notes, but not instructions)
Can anyone please point me to installation instructions for Solaris SPARC?
-Doug
--
MySQL General
2 x 2.8 GHZ Xeon
4 GB of RAM
5 15K SCSI Drives
ICP SCSCI RAID control card with 1 Gb of ram on it.
I just bought 30 of these boxes to build out my mysql farm for close to
400-600 queries a second with 60 connections a second of mix read /
writes.
What kind of queries are you doing? Our s
On 18-Jun-2003 Jonas Geiregat wrote:
> I'm using php + mysql for my project
> I want to get the last insert ID.
> I could use the php function mysql_last_id();
> but I could aslo use @@identity.
> Now some people have advised me NOT to use @@identity, cause it's not
> save buggy sometimes slow ..
Following select statement works OK on Localhost, OK within Dreamweaver
test, OK on phpmyadmin on site, BUT NOT OK on webpage.
It's the IF part where it states if(m.matchtypeid < 3, etc
Here on the webpage itself it shows the 'in-/uitschrijven' or 'gesloten'
bit on those lines where it should
> One should always use the
> LAST_INSERT_ID() or after an insert, select max(id) from myTable.
Select max(id) from myTable should never be used to get the last insert id.
On a high traffic table you are not guaranteed it will be the ID for the
record you just inserted, another could have been in
Where'd you get it. I've had bad experiences with generic machines but
I'll take a peak if you send the link?
There are a couple of things I didn't mention
2U Form Factor with tool-less rails
Redundant Power Supply
Redundant Fans (any 2 fans can go)
Battery Backed RAID for full commit even on ab
Wednesday, June 18, 2003, 2:38:53 PM, you wrote:
-->>-Original Message-
-->>From: Adam Nelson [mailto:[EMAIL PROTECTED]
-->>Sent: Tuesday, June 17, 2003 11:56 AM
-->>To: 'Bernd Jagla'; 'mysql'
-->>Subject: RE: RAID hardware suggestions/experience
-->>
-->>We recently bought a kick $%#%% ma
On Wednesday 18 June 2003 13:59, Carter, Scott wrote:
> This may not be the correct solution exactly, but what I do to ensure that
> I get the correct ID back is the following:
>
> I know what I just inserted, therefore I can use this information in a
> WHERE clause to ensure retrieving the correct
The below query is not good, due to the fact that if name and age aren't
unique, I'll be returning multiple ids with it. One should always use the
LAST_INSERT_ID() or after an insert, select max(id) from myTable.
-Original Message-
From: Carter, Scott [mailto:[EMAIL PROTECTED]
Sent: Wednes
On 18-Jun-2003 Jonas Geiregat wrote:
> I insert a new value into table A insert into a values(NULL)
> Since id is auto_incremenet and the primary key it will have an auto
> value.
> Now I want that the column A_id contains that id nr.
> I could query for the biggest id in column A and insert t
This may not be the correct solution exactly, but what I do to ensure that I
get the correct ID back is the following:
I know what I just inserted, therefore I can use this information in a WHERE
clause to ensure retrieving the correct ID.
Example: INSERT name='scott', age=20 into my
I'm using php + mysql for my project
I want to get the last insert ID.
I could use the php function mysql_last_id();
but I could aslo use @@identity.
Now some people have advised me NOT to use @@identity, cause it's not
save buggy sometimes slow ..
is this true am I better of with the php function
On 18-Jun-2003 NIPP, SCOTT V (SBCSI) wrote:
> Hello... I am currently working on a User Account Management
> system. I am actually a Unix SA who is "moonlighting" at work as a MySQL
> DBA and web developer. I am learning a lot and enjoying the work, but I
> am
> severely lacking in databa
-->-Original Message-
-->From: Adam Nelson [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, June 17, 2003 11:56 AM
-->To: 'Bernd Jagla'; 'mysql'
-->Subject: RE: RAID hardware suggestions/experience
-->
-->We recently bought a kick $%#%% machine for ~10k
-->
-->HP DL380
-->2x2.8GHz Xeon
-->1GB
Hello,
I have had problems with some of our equipment and copying the files
around if they are greater than 2gb (one of our nfs file servers is not
large file safe). Because on occasion I have had to copy InnoDB files
around and hit this problem we have been using 2gb InnoDB files.
Does using m
Check out LAST_INSERT_ID() in the manual
-Original Message-
From: Jonas Geiregat [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 12:26 PM
To: 'Mysql'
Subject: probably a stupid question
Hey,
Here is what I want to do
I have 2tables
let's say table A and B for simplicity.
in tab
This is a rather long message but I am stuck and am really in a bind so
I wanted anyone who might be willing to point me in the right direction
to have the full picture.
I recently installed MySql 4.0.13 on a Intel Linux box running Red Hat
9. I used the RPM that I found on the MySQL site. I
Hey,
Here is what I want to do
I have 2tables
let's say table A and B for simplicity.
in table A I have column id
and in table B I have column A_id
I insert a new value into table A insert into a values(NULL)
Since id is auto_incremenet and the primary key it will have an auto value.
Now I want tha
On Fri, 30 May 2003, Jeremy March wrote:
> The problem is that querying with a LIKE expression is treated case
> and accent sensitive. [...] Has anyone else experienced this with
> multibyte utf8?
Yes. mysql-standard-4.1.0-alpha-pc-linux-i686 running with
--default-character-set=utf8 gives me:
> What sort of throughput are you seeing in that setup?
God, I can't remember anymore. I can run a test again though. If you
have one you want me to run, just send it. We don't have other people's
money to spend, so all our disks are U160 18GB 15K IBM. They were less
than $100 each when we got the
Just a couple of quick notes:
1. While I use PHP CLI for a lot of things (can we say cron?), it is not
a sufficient replacement for triggers. What happens when someone is
using the Mysql command prompt to alter data? Or using a non-PHP
application?
2. While I agree that having application code ra
Try something like
select distinct S.US_FOLIO US_FOLIO
, ifnull(SD.US_FOLIO,'false') FOLIO2
from SEGUIMIENTO S LEFT OUTER JOIN SEGUIMIENTO_DETALLE
SD
on (S.US_FOLIO=SD.US_FOLIO)
-Original Message-
From: Gustavo Mejia [mai
Muazzam Siddiqui wrote:
Hi,
I am getting the error
You have an error in your SQL syntax near 'select max(news_id) from
news)' at line 1
while trying to run this query.
SELECT * FROM News where News_ID = (SELECT MAX(News_ID) FROM News);
You don't say what version of MySQL you are running.
You
On Wed, Jun 18, 2003 at 09:37:24AM -0700, Steven Roussey wrote:
>
> Don't stripe too many. More sets to stripe increase performance, but
> syncing the rotations of many drives degrades performance. So there
> are diminishing returns. For our calculations, 3-4 mirrors were
> sufficient. Most of our
Hey gang... sorry, I duped the subject of someone elses message... so I'm
going to send this again
In my dbMove application I have the following.
Ask SQL how many records I am moving-> OK
Display that amount -> OK
Delete all from corresponding MySQL tab
[snip]
> Let's say that I have users Mary, Joe, Frank, and Dan. I also have
> servers panther, cheetah, jaguar and lion. The data for each account that I
> want to maintain is UID, GID, home directory, and default shell.
> In designing a table or tables to handle this example what can I
> make
Hi,
I am trying to do something like:
select distinct S.US_FOLIO US_FOLIO
, ifnull(SD.US_FOLIO,'false') FOLIO2
from SEGUIMIENTO S
,SEGUIMIENTO_DETALLE SD
where S.US_FOLIO=SD.US_FOLIO(+)
this is using Oracle, bu
> If you're using a non-persistent connection, PHP will close the
> connection when the script terminates, and the MySQL server will roll
back
> implicitly. For a non-persistent connection, the connection remains
open
> and you may not see the rollback behavior your expect.
I thought this was fi
Hi Folks,
so there I am,
mysql server version 3.23.49-8.4
OS linux debian woody
box type i386
I've set up binlogs in my.cnf
I do get the binlog files created and rotated this with flush logs as
master reset.
I have the checkpoint and log_pos table set up.
what I do not get is that the binlog fi
# [EMAIL PROTECTED] / 2003-06-18 12:24:06 -0400:
> [psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe &
> [5] 703
> [psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases
> from /usr/local/mysql/data
> 030618 11:50:09 mysqld ended
>
>
> [5]Done
Hi,
I am getting the error
You have an error in your SQL syntax near 'select max(news_id) from news)'
at line 1
while trying to run this query.
SELECT * FROM News where News_ID = (SELECT MAX(News_ID) FROM News);
The table type is INNODB. Is it some MySQL related problem because I know
the quer
I figured it out. The between clause needs lower then upper, and I had
upper then lower. The extraneous values I found must have been
artifacts from the abs comparison, which was clearly not working anyway.
I am just going to use the between clause. It seems to return the
results I expect.
Rich
After testing a lot of different configurations (which was quite a
headache), I came up with the following. First of all, for both speed
and reliability, you will want SCSI. The list of reasons are quite long
for SCSI, and as you are doing research on the subject, it is an obvious
choice and I don'
Hello everyone,
I am unable to start the mysqld, i keep getting "mysqld ended" error.
-
[psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe &
[5] 703
[psg:/usr/local/mysql] psgarcha% Start
[EMAIL PROTECTED] wrote:
How do you DELETE or RENAME a table?
Thanks.
alter table TABLENAME rename NEWNAME;
drop table TABLENAME;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DROP TABLE tablename;
ALTER TABLE tablename RENAME newname;
http://www.mysql.com/doc/en/ALTER_TABLE.html
http://www.mysql.com/doc/en/DROP_TABLE.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 18
On Wed, Jun 18, 2003 at 12:13:16PM -0400, [EMAIL PROTECTED] wrote:
> How do you DELETE or RENAME a table?
Search the manual. The answer is there. :-)
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.13: up 15 days,
How do you DELETE or RENAME a table?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello... I am currently working on a User Account Management
system. I am actually a Unix SA who is "moonlighting" at work as a MySQL
DBA and web developer. I am learning a lot and enjoying the work, but I am
severely lacking in database design fundamentals. I have created a couple
very
The most sure way is to keep the same version of server on the same
database. If you want to test more versions make one database per server
version.
Iulian
- Original Message -
From: "Reggie Burnett" <[EMAIL PROTECTED]>
To: "'Primaria Falticeni'" <[EMAIL PROTECTED]>
Cc: "'MySQL LIST'" <[
No. It complains as well. The error I get
Can't open file: platforms.InnoDB
The funny thing is that I have never seen a file ending with Innodb. I
created this table just last night of type InnoDB and the extension was .frm
Reggie
> -Original Message-
> From: Primaria Falticeni [mai
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John R Langan wrote:
> Hi All,
> I hope someone can help with this connection problem.
[snip]
> When attempting to connect from the PC on the intranet the trace gives
> the following:
>
> java.lang.ClassNotFoundException: com.mysql.jdbc.Driverat
>
What about the mysql client? Did it report that table exists?
Test mysqlc from the all versions from your computer.
Iulian
- Original Message -
From: "Reggie Burnett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 18, 2003 6:20 PM
Subject: multiple versions of MySql
>
Pushpinder Singh Garcha wrote:
Hello everyone,
I am running MySQl and PHP on a Mac OS Jaguar. When I try to restart
my MySQL Local Server using mysqld_safe, but I keep getting this error
[psg:/usr/local/mysql] psgarcha% sudo echo
Password:
[psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_s
What problems am I going to have with 3.23, 4.0.13, and 4.1 alpha installed
on the same machine (Win XP?)
I am developing some software and wanting to test against these versions but
I am starting to have intermittent problems with MySql-Front where it
declares that a table is now missing.
Should
I need to find out why the mysqld is not starting up ? Can someone
please throw some light to the location of this file on a Mac?
Thanks in adavnce.
--Pushpinder
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE
I recently changed my kernel (as noted in another message) to one that
supports ACPI (for my laptop running RH9) and a couple other patches (I
don't know all of them, one may have been the preemptive kernel patch).
I've installed MySQL 4.0.12 from RPM's on the myslq.com site. When I
start mysql usi
Hi All,
I hope someone can help with this connection problem.
We have MySQL 4.0.12 installed on a W2K server and we are using the
Connector/J version 3.0.7 driver to connect our Java applet to the
database. The applet and the database are both on the same machine.
mysql-connector-java-3.0.7-stab
Sometime recently Zac Korpi said:
> I'm new to mysql. Currently I am using php myadmin to manage my database. I'd like
> to be able to export mysql database as xml and, in turn, import the xml into a
> filemaker pro 6.0 database. If someone else has worked on something similar, any
> advice w
Hey gang...
In my dbMove application I have the following.
Ask SQL how many records I am moving-> OK
Display that amount -> OK
Delete all from corresponding MySQL table -> OK
Long pause, get a coffee, take a nap
java.sql.SQLException: Communication l
Joanne Yow [bizfront] schrieb:
I am trying to install MySQL 3.23 to Solaris 2.8.
After the step -> scripts/mysql_install_db
I try the command -> chown -R root, error show "usage: chown [-fhR] owner[:group]
file..."
and the command -> chrgrp -R mysql, error show "chgrp [-fhR] group file..."
$ m
Hello everyone,
I am running MySQl and PHP on a Mac OS Jaguar. When I try to restart
my MySQL Local Server using mysqld_safe, but I keep getting this error
[psg:/usr/local/mysql] psgarcha% sudo echo
Password:
[psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe &
[4] 524
[psg:/usr/local/mysq
> Please note, as always that 72.83% of all statistics are made up on the
> spot.
As someone (who, specifically, is oft-disputed) once said:
There are three kinds of lies: lies, damn lies, and statistics.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From
Thanks to all. Simon's response outlines the direction I will be headed.
KC
[snip]
The argument usually used by people looking for
- triggers
- functions + procedures
- foriegn keys
is the persuit of data integrity, and encapsulating business logic
within the
database.
Whilst this goal is nob
1 - 100 of 129 matches
Mail list logo
