Re: adding automatic alert

--- Roger Baklund <[EMAIL PROTECTED]> wrote: > Aji Andri wrote: > > Hi all, > > I'm make an inventory goods database, in one of my > > table I need to make an automatic alert when my > stock > > reach it's limit (say for tires it's limit is 4), > can > > I make an automatic alert for it so when i

BIG INNODB Problems solved.. I think

A few days ago I did the following: Turned off MySQL. Installed 4.1.8a, then I went into the directory where all of the database files are located. I moved everything having to do with INNODB tables and logs into another location for safekeeping. Then I started up the new version of MySQL. I

Re: Trouble w/ mysqldump (images attached)

Hi Dr. The avatars still show fine on 4.18a -- but the problem occurs when I actually do a dump and reimport the dump file. That's when something goes array.. Kinda weird if you ask me.. I wish that vBulletin wouldn't actually hard code the binary in a table, lol.. It's got me totally baffled

RE: Trouble w/ mysqldump (images attached)

I have reinstalled the v3 RPM again to my system, and used one of my original backups from that same version. In 3.23 there is no 'collation' field.. I wonder if that is the problem?? I am going to change it to latein1_bin to see what happens next.. Thanks! I'll let you know! In a messag

GRANT can't grant with a password?

I've read the sections on GRANT's and permissions, and done some googling, and still haven't found what I'm looking for. I have a user that has USAGE and GRANT global privs and all privs and GRANT on database rubric. However, when they try to run this query: GRANT SELECT, INSERT, UPDATE, DELET

''Lost connection to MySQL server during query'' on Stored Procedure

Hello, I just installed MySQL 5.0.2 (on Debian Sarge) and started to do some experimets with "Stored Procedures". I very often get the error "Lost connection to MySQL server during query" when executing such a self created Procedure. Sometimes the same Precedure works fine, sometimes it result

Re: insert

> insert/select has a different syntax than what you are trying to use. > > try > > insert into table_name (place, address, number) select "stuff", > "stuff2", this from that where one=two aha... this is it. thank you... and you can sellect more then one things from 'that': insert into table_n

Re: insert

insert/select has a different syntax than what you are trying to use. try insert into table_name (place, address, number) select "stuff", "stuff2", this from that where one=two i may yet have the syntax wrong, but its close. kalin mintchev wrote: hi all... i need some help. can somebody explain w

insert

hi all... i need some help. can somebody explain why is this insert/select not working? insert into the_db (place,address,number) values("stuff","stuff2",select this from that where one=two); i tried ()s around the 'select' too but it didn't work. thanks. -- -- MySQL General Mailing Li

RE: Slow queries, need advice on how to improve; key_buffer - zen -cart?

[snip] # Time: 050107 17:40:41 # [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx] # Query_time: 13 Lock_time: 0 Rows_sent: 148 Rows_examined: 1567270 use zencarttest; select distinct m.manufacturers_id, m.manufacturers_name from zen_manufacturers m left join

Re: logical OR query problem

Richard Reina <[EMAIL PROTECTED]> wrote on 01/07/2005 03:31:26 PM: > I am having trouble with a query that gives me > activities that have not been "written up" but if > these activities are a party they whould only appear > in the query if they have been held, hence date will > not='-00-00' >

FW: Slow queries, need advice on how to improve; key_buffer - zen-cart?

Hi Tom, Here's the query log - mysqld.slow.log... /usr/libexec/mysqld, Version: 3.23.58-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument # Time: 050107 17:40:27 # [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]

Re: Fixing "the worst InnoDB corruption bug in 3 years" - when

Bruce Dembecki wrote: At the 2004 Users Conference in Orlando in April there were two sessions on optimizing MySQL hosted by a MySQL staffer who's name eludes me for the moment. Peter Zaitsev I believe. He did some InnoDB performance tuning sessions. He told the assembled masses that in benchmark

RE: Slow queries, need advice on how to improve; key_buffer - zen -cart?

[snip] The application I am using for the site is www.zen-cart.com so I'm not sure I can do anything about changing the table indexes because it is a pre written php-MySQL open source freeware script. I'm getting the query times directly from the application and not MySQL. [/snip] You could turn

logical OR query problem

I am having trouble with a query that gives me activities that have not been "written up" but if these activities are a party they whould only appear in the query if they have been held, hence date will not='-00-00' If I write the query as so, no non-party activities will show up because the f

Re: Unique IDs

When I saw this message a few weeks ago, I *knew* MySQL had something for this, but I couldn't remember where I saw it, and I couldn't find it. Today I found it. Take a look at: http://dev.mysql.com/doc/mysql/en/Miscellaneous_functions.html and scroll down to UUID() Returns a Universal Unique

Re: weird syntax error

How about removing the comma before the close parenthesis at the end of the statement - or adding a Primary Key clause after the comma but before the close parenthesis? Rhino - Original Message - From: "B Wiley Snyder" <[EMAIL PROTECTED]> To: Sent: Friday, January 07, 2005 3:28 PM Subje

weird syntax error

When I use 4.0 on windows I don't get this error but now that i'm using 4.1.x I'm getting error 1064 , is BLOB depricated or something ??? Please help ! thanks in advance === Your MySQL connection id is 97 to server version: 4.1.8-standard Type 'help;'

Re: Help with MySQL 4.1.8 Not starting under Fedora Core3

Permission problem: [EMAIL PROTECTED] santino]$ perror 13 Error code 13: Permission denied Check /tmp permission and check /usr/local/mysql/data/ user and group of this directory must be mysql:mysql if not: chown -R mysql:mysql /usr/local/mysql/data/ Santino PS: /usr/local/mysql is a symbolic lin

Help with MySQL 4.1.8 Not starting under Fedora Core3

OK I am running Fedora Core3, Kernel kernel-2.6.9-1.724_FC3 along with MySQL-server 4.1.8-0.i386. No matter what I do MySQL the process will not start. This happens to me on a couple of boxes. One of the boxes which was upgraded from Fedora Core2 to Core3 does work with the exact same versions of

grrting MySQL to play nice with selinux

I got MySQL on RH Fedora Core 3 ... Used the MySQL on the default install and recently updated via yum to 3.23.58-14... I found it odd that off the install I could connect to mysql via command line client, but PHP and perl and other ways did not work.. I figured out that it was selinux doing thi

RE: Displaying Data for Each Day of the Year/Week

Thanks - that works great! --- Jay Blanchard <[EMAIL PROTECTED]> wrote: > [snip] > > Cal_ID | Cal_Date | Cal_Event > 1 | 1972-01-01 | A new species of whale was > discovered. > 7 | 1898-01-07 | The dodo was declared extinct. > 8 | 1972-01-08 | The first Earth Day was observed. > > Then I used t

Re: Does it matter?

click this http://lists.mysql.com/[EMAIL PROTECTED] Steven Grosch schrieb: NO. Best Regards, Steven Grosch -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 8:41 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: Does it matter? {sn

RE: Does it matter?

NO. Best Regards, Steven Grosch -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 8:41 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: Does it matter? {snip] Please remove me from your email distribution. [/snip] Do you not s

RE: Slow queries, need advice on how to improve; key_buffer - zen-cart?

OK thanks Tom, The application I am using for the site is www.zen-cart.com so I'm not sure I can do anything about changing the table indexes because it is a pre written php-MySQL open source freeware script. I'm getting the query times directly from the application and not MySQL. However I coul

Re: Slave integrity.

Hey, I have some code that does a bunch of tests. I keep saying I'm going to release it, but I don't get around to it. My code does the following: - checks that the schema matches - check that keys match - check that foreign keys match - check that row counts match - checksums the whole table in

RE: Slow queries, need advice on how to improve; key_buffer?

[snip] The problem now is, this did not do anything to improve the query and parse times. I'm testing out an on line store which has about 12,000 product entries in it and about 300 product categories. Both the parse and query times are running over 12 seconds [/snip] This is probably related to

RE: Slow queries, need advice on how to improve; key_buffer?

Hi Tom, OK thanks I just added the set-variable = key_buffer = 64M line to my my.cnf file and at least I got no errors and the MySQL server restarted OK and I got my test site running. The problem now is, this did not do anything to improve the query and parse times. I'm testing out an on line st

Re: Full text Searching on C#, C++

Brent Baisley <[EMAIL PROTECTED]> wrote on 07/01/2005 17:03:36: > I'm having a lot of trouble trying to get this to work. I've set the > minimum word length to 2, restarted MySQL and rebuilt the indexes, but > can't seem to get this to work. Is it because MySQL is not indexing # > and ++? I can

RE: Slow queries, need advice on how to improve; key_buffer?

[snip] I tried to improve MySQL speed/performance by adding key_buffer=50M to my my.cnf file for [mysqld]. When I restarted MySQL, I'm getting a "0 DB_ERROR_NOT_CONNECTED" error when visiting my php-MySQL web application via http. When I removed above and then restarted MySQL the error goes away.

_blank

http://lists.mysql.com/[EMAIL PROTECTED] --- iBestMail, agora com POP3/SMTP e 120MB de espaço! Experimente: http://www.ibestmail.com.br -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Full text Searching on C#, C++

I'm having a lot of trouble trying to get this to work. I've set the minimum word length to 2, restarted MySQL and rebuilt the indexes, but can't seem to get this to work. Is it because MySQL is not indexing # and ++? I can't seem to find a setting to alter this behavior. The only other thing I

RE: Slow queries, need advice on how to improve; key_buffer?

Thanks Tom, OK I tried this, I must be doing something wrong, I entered in: SET GLOBAL key_buffer_size = 64 * 1024 *1024; and got the error: "You have an error in your SQL syntax near 'key_buffer_size = 64 * 1024 *1024' at line 1" I must be doing something wrong. I tried both 64M and just 64

RE: Slow queries, need advice on how to improve; key_buffer?

[snip] I tried to improve MySQL speed/performance by adding key_buffer=50M to my my.cnf file for [mysqld]. When I restarted MySQL, I'm getting a "0 DB_ERROR_NOT_CONNECTED" error when visiting my php-MySQL web application via http. When I removed above and then restarted MySQL the error goes away.

Slow queries, need advice on how to improve; key_buffer?

Hi, I'm having a problem with slow query and parse times with a MySQL - PHP ecommerce application I am testing out. Also getting an error message with the key_buffer variable. I tried to improve MySQL speed/performance by adding key_buffer=50M to my my.cnf file for [mysqld]. When I restarted My

Re: creating first table

"Gerald Preston" <[EMAIL PROTECTED]> wrote on 01/07/2005 01:02:04 AM: > Hi! > Running mysql on a XP command line. Doing "dhow" databases" list the > following; > > Database > > Club > > Mysql > > Test > > I did a grant all user id; > > How can I list the rows and columns. One of these may he

MS Access OLEDB/object type to MySQL Blob

I have searched the whole wide world (www) for months and have not found a converter that properly convert a MS Access image (gif, jpeg etc) to MySQL blob. How do I solve the problem, please? I am now frustrated. I am using Java with MySQL. Ant

RE: creating first table

[snip] How can I list the rows and columns. [/snip] http://dev.mysql.com/doc/mysql/en/SELECT.html --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PRO

RE: Does it matter?

{snip] Please remove me from your email distribution. [/snip] Do you not see an unsubscribe link at the bottom of this e-amil? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Does it matter?

Please remove me from your email distribution. Best Regards, Steven Grosch [EMAIL PROTECTED] TEK LLC 610 260 9899 -Original Message- From: mysql@lists.mysql.com [mailto:[EMAIL PROTECTED] Sent: Friday, January 07, 2005 12:05 AM To: [EMAIL PROTECTED] Subject: Does it matter? You have

RE: Displaying Data for Each Day of the Year/Week

[snip] Cal_ID | Cal_Date | Cal_Event 1 | 1972-01-01 | A new species of whale was discovered. 7 | 1898-01-07 | The dodo was declared extinct. 8 | 1972-01-08 | The first Earth Day was observed. Then I used this script to try to display a sample: "); } ?> $monthDay = date("m-d"); $sql = "SELECT Ca

Slow InnoDB Delete Transaction

Hi, Since we upgraded from MySql 3.20 to 4.1 innodb seems to have become slower. I'd like to understand the innodb status a bit better. Here is a the slow innodb transaction ---TRANSACTION 0 2599083795, ACTIVE 72659 sec, process no 12324, OS thread id 1138606116 estimating records in index rang

Slave integrity.

Folks, I'm doing replication (one master, two slaves) with MySQL 4.0.23. I'm really happy with it. Although, every once in a while, the slaves get desync'ed, one at a time (the DB is 6GB large, and has 140 tables). I can't explain why this desync happens, but this wouldn't be a problem if I had a

Re: Trouble w/ mysqldump (images attached)

Hi, [EMAIL PROTECTED] schrieb: Hi Tom, Thanks for the reply! I show the following information for my DB, and shows the same for both the 3.23 DB And the 4.18a DB Field Type Collation avatardata mediumtext latin1_swedish_ci I pasted a data table from the ba

Displaying Data for Each Day of the Year/Week

I think mine is a fairly simple question. In fact, I think my script may just need a simple tweak. It's also possible that my problem relates to displaying the data with PHP, but I want to make sure I've got my MySQL table set up correctly. Anyway, I've collected historic events for every day of t

RE: Trouble w/ mysqldump (images attached)

Hi there, [EMAIL PROTECTED] wrote on Thursday, January 06, 2005 7:19 PM: > Thanks for the reply! I show the following information for my DB, > and shows the same for both the 3.23 DB And the 4.18a DB > > Field Type Collation > avatardata --

Re: big table corruption

matt_lists wrote: every few days I get one of these MySql: Can't open file: 'mrf.MYI' (errno: 145) For more information, see Help and Support Center at http://www.mysql.com. Checking table: './db/mrf' For more information, see Help and Support Center at http://www.mysql.com. Recovering table: '

Re: select datetime older than X weeks

From: "Frank Bax" > I have a table with datetime field and I would like to select all data > older than "X" weeks, where "X" is a variable in my php script. SELECT (.) WHERE `datetime_field` < NOW() - INTERVAL (7*X) DAY This way you compare the datetime field with a constant (the expression r