On 10/21/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote:
> On Fri, 2005-10-21 at 06:34 +0200, Dotan Cohen wrote:
> > Why would this work:
> > SELECT question, short, longa, technical FROM -snip- WHERE
> > filename='$filename'
> >
> > But this not:
> > SELECT question, short, left(longa,40), te
Olaf Faaland wrote:
Hi,
I am currently using mysql 4.0.18 as distributed with red hat Linux. I find
when I perform a select on a varchar(30) field, the index is used only if I
have quoted the value in the where clause. Otherwise, mysql performs a
table scan.
A varchar(30) field is a string,
On Fri, 2005-10-21 at 06:34 +0200, Dotan Cohen wrote:
> Why would this work:
> SELECT question, short, longa, technical FROM -snip- WHERE
> filename='$filename'
>
> But this not:
> SELECT question, short, left(longa,40), technical FROM -snip- WHERE
> filename='$filename'
If you want it to work l
Why would this work:
SELECT question, short, longa, technical FROM -snip- WHERE filename='$filename'
But this not:
SELECT question, short, left(longa,40), technical FROM -snip- WHERE
filename='$filename'
The line that looks like this:
$long =mysql_result($result, 0, "longa");
Is throwing this er
on 10/20/05 4:01 AM, Rich at [EMAIL PROTECTED] wrote:
> Hi folks.
>
> Since I installed MySQL Administrator on OS X and tried to put a schedule in
> for a backup, the thing simply won't go away. It sends an email into my
> mail app in the terminal on a daily basis and it's driving me
> mad...slo
On 10/20/05, Rich <[EMAIL PROTECTED]> wrote:
> Hi folks.
>
> Since I installed MySQL Administrator on OS X and tried to put a schedule in
> for a backup, the thing simply won't go away. It sends an email into my
> mail app in the terminal on a daily basis and it's driving me
> mad...slowly...bit b
Scott Haneda <[EMAIL PROTECTED]> wrote on 10/20/2005 08:11:27 PM:
> I dropped a field in a table, I have a backup, so is what I have done is
> imported the backup of the table to a new table, so I have table
"sessions"
> which has a empty field for "session_key"
>
> I now have sessions_backup wh
Sorry I didn't get back to you earlier today. I have had a busy day.
Comments embedded...
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote on 10/20/2005 04:35:30 PM:
> Could you please tell me should this work?
>
> CREATE TABLE categories (
> cat_id INTEGER(8) UNSIGNED NOT NULL AUTO_INCREMENT,
>
solaris box with 16 Gbytes of memory
os using 5.8, mysql at 4.0.20_64bit
with key_buffer_size set to 6144m, the mysqld crashes
and re-starts (mysql_safe) under heavy load (1day to 1week).
prior to this, key_buffer_size set to 1.5G and no crashes since
early 2004.
the process size is 2G even tho
I dropped a field in a table, I have a backup, so is what I have done is
imported the backup of the table to a new table, so I have table "sessions"
which has a empty field for "session_key"
I now have sessions_backup which has all the data, there is a pk called id
I need to run a sql update that
Hello all,
I have been working on a MySQL client which I wrote in Apple's xCode.
The client works as long as it is on my machine which has MySQL
installed, however if I send the client to another computer which does
not have MySQL installed it does not work. I am under the impression I
need t
2005/10/20, Heikki Tuuri <[EMAIL PROTECTED]>:
> Andrew,
>
> how about using triggers to recompute materialized views? A challenge is to
> write an automatic program that can compute the required triggers based on
> the view definition. The materialized view would be a normal table. Triggers
> would
Yep, now you try to build a frontend around it, then the users will tell
you what's wrong with it ("the purpose of the first solution is to
understand the problem").
PB
-
[EMAIL PROTECTED] wrote:
Somethign like this?
insert into products values (null, 'AP1520', 'Ultra Blend 50/50 Sport
I ran into a problem on a replication setup, where if you issue the
following CREATE statement on the master the table will get created and
the query entered into the binlog, however the slave ignores it silently:
CREATE TABLE `db`.`table` (a INT DEFAULT 0)
I have duplicated this exact iss
Somethign like this?
insert into products values (null, 'AP1520', 'Ultra Blend 50/50 Sport
Shirt', '5.6 ounce, 50% cotton/ 50% polyester fabric. Contoured collar
and cuffs, double-stitched seams. Clean finished placket with reinforced
box and 3 woodtone buttons. Sizes M-3X.', 'Neutrals - White
afan,
The model is progressing. The test for how well it works is what happens
when you ask it to represent all presently known types of products. What
happens when you hae to apply two 'methods' to one product?
PB
-
[EMAIL PROTECTED] wrote:
Could you please tell me should this work?
Could you please tell me should this work?
CREATE TABLE categories (
cat_id INTEGER(8) UNSIGNED NOT NULL AUTO_INCREMENT,
cat_name VARCHAR(45) NULL,
cat_description TEXT NULL,
cat_parent INTEGER(4) UNSIGNED NULL,
cat_status ENUM('0','1') NULL,
PRIMARY KEY(cat_id)
)
TYPE=InnoDB;
CREATE TABL
On 10/19/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> So... which of the many storage engines are you hoping to extend? It would
> be nice if you could do them all but I think we all anticipate that InnoDB
> will pose special challenges.
After a bit of group consultation, we've decided to
Shuming,
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html
you have to specify the right size for:
innodb_log_file_size=14M
in your my.cnf or my.ini.
Please also check from:
C:\Program Files\MySQL\MySQL Server 4.1\data
how many ib_logfiles you have. If you have more than 2, s
Andrew,
how about using triggers to recompute materialized views? A challenge is to
write an automatic program that can compute the required triggers based on
the view definition. The materialized view would be a normal table. Triggers
would update it.
Regards,
Heikki
Oracle/Innobase
-
Hi all,
I am running into a brick wall with a query that is running against a
MySQL 3x database, and the temp tables are filling up before the query
can run.
Here is the query:
SELECT
Avails.ResortID,
Inventory.ID as InventoryID,
Avails.ID as AvailabilityID,
DATE_FORMAT(Avail
Hi,
MySQL 4.1.15, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at http://dev.mysql.com/downloads/ and mirror sites.
Note that not all mir
Yemi,
For a first debugging step, have php print out the $sql variable to a
screen. Then copy and paste that to a mysql client, and make sure you
get the same error. That's good to debug any script -- make sure the
query that the script is doing can actually run. Sometimes it's in
how php parse
You could also try the mysqlhotcopy binary, if it exists in your bin/
directory. I don't remember when that came out, but you might have
it. You don't have to stop the instance for that.
-Sheeri
On 10/20/05, Clyde Lewis <[EMAIL PROTECTED]> wrote:
> You could copy the entire mysql directory stru
You could copy the entire mysql directory structure to an isolated area
on disk. This will involve stopping the instance though.
Luke Vanderfluit wrote:
Hi.
I'm using 4.0.18 and for legacy reasons I can't upgrade that.
However I'm upgrading the database to a new schema.
I want to copy the da
On Wednesday 19 October 2005 04:34 pm, Mihail Manolov wrote:
> It's the way our code is written, and I just changed the table type and
> began getting this error. We have lots of data to insert into this
> table, therefore the optimal option is to use DELAYED and insert them in
> blocks.
>
> Not s
Hi,
Our mysql 4.1 database server on win2000 was uninstalled by mistake, but
reinstalled , caused the follow errors:
InnoDB: Error: log file .\ib_logfile0 is of different size 0 14680064 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
051020 19:30:42 [ERROR] Can't init databases
0
i'm having a problem with the load data infile command...i'm actually running
the script from a php script that goes this way:
the script and the txt file movies.txt reside on the same directory. runnign
the page, i get the error: The used command is not allowed with this MySQL
version
my m
i'm having a problem with the load data infile command...i'm actually running
the script from a php script that goes this way:
the script and the txt file movies.txt reside on the same directory. runnign
the page, i get the error: The used command is not allowed with this MySQL
version
my m
Hi folks.
Since I installed MySQL Administrator on OS X and tried to put a schedule in
for a backup, the thing simply won't go away. It sends an email into my
mail app in the terminal on a daily basis and it's driving me
mad...slowly...bit by bit.
Can someone suggest how I get rid of these email
on 10/19/05 7:47 PM, Luke Vanderfluit at [EMAIL PROTECTED] wrote:
> I can't access the database as root anymore.
> Accessing as other users doesn't allow me to set any GRANT statements.
> Is there any way I can reset the root password? (Ouch).
You probably want to start it up with the skip grants
On Thursday, 20 October 2005 at 16:57:36 +0800, Hiu Yen Onn wrote:
> hi all,
>
> currently, i have a machine with raid 1 and raid 5 (backplane). in order
> to boost up the mysql performance, does it advise install /var/ (mysql
> data directory) into raid 1 or raid 5? please advise. thanks
RAID-5 o
Hi.
We have a MySQL database as backend on our 15.000 user mailserver.
This MySQL instance receives a large amount of connections, each
performing just a small amount of processing (a few SELECT:s) before
disconnecting.
Our mysql.err log is filling up with lines like the below:
051020 1
hi all,
currently, i have a machine with raid 1 and raid 5 (backplane). in order
to boost up the mysql performance, does it advise install /var/ (mysql
data directory) into raid 1 or raid 5? please advise. thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On 20 Oct 2005 10:13:56 +0200, Harald Fuchs wrote:
> Jochem van Dieten writes:
>>
>> Back in reality you don't enforce this using DDL. Apart from the fact
>> that I wouldn't know a single database that implements ASSERTIONs
>> according to the SQL standard, can you imagine having to run some
>> SEL
In article <[EMAIL PROTECTED]>,
Jochem van Dieten <[EMAIL PROTECTED]> writes:
> Back in reality you don't enforce this using DDL. Apart from the fact
> that I wouldn't know a single database that implements ASSERTIONs
> according to the SQL standard, can you imagine having to run some
> SELECT fk
On 10/19/05, Peter Brawley wrote:
>>
>> I am having problems with the following query: I am
>> trying to join Tax_Bands and Property_Types to Properties
>> but the query seems to be joning Tax_Bands to Properties.
>
> That query generates no error in 5.0.13. There have been several cascading
> join
Hello Jochem,
> >> That doesn't help: check constraints are evaluated only on insert and
> >> update, not on delete. That's why you need an assertion.
> >
> > Hmmm, would that be SQL standard? Or implementation specific?
>
> It is at the very least implied in the SQL standard.
>
>
> > From a logic
On 10/20/05, Martijn Tonies wrote:
>>
>> That doesn't help: check constraints are evaluated only on insert and
>> update, not on delete. That's why you need an assertion.
>
> Hmmm, would that be SQL standard? Or implementation specific?
It is at the very least implied in the SQL standard.
> From
can i replicating innoble tables? does the master db and the slave db
will having the same of information when they are doing replication? thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi.
I'm using 4.0.18 and for legacy reasons I can't upgrade that.
However I'm upgrading the database to a new schema.
I want to copy the database before I make changes to the schema, so that
if anything goes wrong, I can revert back.
I have a dump file of the database but that is around 5GIG,
41 matches
Mail list logo
