Update log

i'm still using 3.23 can anyone show me how to activate update log by modifying the my.cnf/ my.ini And a question about update log, does it only record update and delete (mysql documentation), how about insert? do the log recorded those too? thanks

RE: first time accessing

Tom, I tried the following: #!/perl use warnings; use strict; use DBI; # my $dbh=DBI-connect( 'DBI:mysql:test:GJWPP88', 'Jerry', 'password' ) or die Cannot connect - gjwpp88!!br$DBI::errstr; #Local Host Name - GJWPP88 #Local User Name - Jerry #database under GJWPP88 - mysql and test my

Re: InnoDB: Error: tablespace size stored in header is 17024 pages,

Ian, - Original Message - From: Ian Grant [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Wednesday, January 05, 2005 4:47 PM Subject: Re: InnoDB: Error: tablespace size stored in header is 17024 pages, Dear Heikki Many thanks for your reply. On Mon, 3 Jan 2005 20:41:22

Re: Update log

one more question, how about when i'm using 'BEGIN' and doesn't end it with 'COMMIT' neither 'ROLLBACK' what will happen. I've tried before and nothing happen but does anyone have an opinion? --- Chenri J [EMAIL PROTECTED] wrote: i'm still using 3.23 can anyone show me how to activate

adding automatic alert

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 it reach it limit I can have an alert may be a beep ? Thanks

RE: Retrieving partial field values

This sounds like a good candidate for the two-table model: Table 1 contains an ID and the basic names. Table 2 contains the 1-many relationship of basic name entry mapped to all the variants - one record per variant. So you might have Table 1 containing ID, Prefix, GivenNames, Surname, Suffix

Re: adding automatic alert

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 it reach it limit I can have an alert may be a beep ? This is a typical

Re: adding automatic alert

Roger Baklund [EMAIL PROTECTED] wrote on 06/01/2005 12:25:31: 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

Re: adding automatic alert

- Original Message - From: Aji Andri [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, January 06, 2005 5:16 AM Subject: adding automatic alert 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

Re: Update log

Chenri J wrote: i'm still using 3.23 can anyone show me how to activate update log by modifying the my.cnf/ my.ini Show you? It is not clear what you want. Do you need help starting the editor? What OS are you using? On Windows systems Notepad can be used to edit the configuration files. Which

BEGIN...nothing? (Re: Update log)

Chenri J wrote: one more question, how about when i'm using 'BEGIN' and doesn't end it with 'COMMIT' neither 'ROLLBACK' what will happen. I've tried before and nothing happen but does anyone have an opinion? This depends on a number of things: If the table handler in question does not support

Re: big table corruption

matt_lists wrote: Raj Shekhar wrote: Mark Maggelet wrote: Hi, I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index on it. The table gets corrupted every 1 week or so and I have to repair it. I've tried upgrading to newer versions of mysql 3 times but the problem persists. I

Re: Retrieving partial field values

A full-text search won't work. Too many records -- at least 8 million. From what I've read, full-text won't pick up the individual initials or very short names, like Vu, Lee, Doe, etc. Jigal van Hemert [EMAIL PROTECTED] wrote: Example a (GivenNames): Mary Elizabeth or Marg Elizabeth Example b

RE: first time accessing

[snip] DBI connect'test:GJWPP88','Jerry' failed: Access denied for user 'Jerry'@'gjwpp88' using password: yes at line 17 [/snip] I would try your connection from a command line ie. 'mysql -u Jerry -h GJWPP88 -p'. The problem is now not with your perl, it is your mysql user permissions.

Re: Retrieving partial field values

From: Kentucky Families A full-text search won't work. Too many records -- at least 8 million. From what I've read, full-text won't pick up the individual initials or very short names, like Vu, Lee, Doe, etc. You can set the ft_min_word_len in an option file in the [mysqld] section to change

Re: Retrieving partial field values

From: Kentucky Families A full-text search won't work. Too many records -- at least 8 million. From what I've read, full-text won't pick up the individual initials or very short names, like Vu, Lee, Doe, etc. You can set the ft_min_word_len in an option file in the [mysqld] section to change

Re: Retrieving partial field values

After hearing both sides being suggested, I think I would recommend the more normalized approach of having one or more separate tables for the names (one name per row) and a mapping table that associates a name field (mother's maiden name, decedent's given name, decedent's surname, etc.) on a

Re: Retrieving partial field values

On Wed, 5 Jan 2005 08:19:07 -0800 (PST) Kentucky Families [EMAIL PROTECTED] wrote: This is a huge database so the option of using LIKE to bring up everything beginning with the search term will result in too many hits. I need a way to isolate these entries and search them on whole words. If

Re: InnoDB: Error: tablespace size stored in header is 17024 pages,

On Thu, 6 Jan 2005 11:30:33 +0200 Heikki Tuuri [EMAIL PROTECTED] wrote: innodb_data_file_path = ibdata2:7M;ibdata1:10M:autoextend You have to add new data files to the end of the line, not to the start. Please follow the instructions at

Need help with php mysql reinstall. Redhat Linux

Hi folks, A little background. Around Christmas, my Redhat linux box was hacked. I'm not sure what the hacker did other than look around and install trojans all over the place and somehow the system became unbootable. All my data files appeared to be OK and I had them backed up

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

Hi Bruce SNIP - Original Message - From: Bruce Dembecki [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, December 30, 2004 2:51 AM Subject: Re: Fixing the worst InnoDB corruption bug in 3 years - when As a side note with demonstrated performance increases when using

Data Dictionary

how do I access the Data Dictionary through SQL? What I want to do is loookup the length of a varchar for validation? Ben -- Ben Edwards - Poole, UK, England WARNING:This email contained partisan views - dont ever accuse me of using the veneer of objectivity If you have a problem emailing me

Re: in regards to merge table in MySQL 4.1.x

Hello. Have you been at: http://dev.mysql.com/doc/mysql/en/MERGE_storage_engine.html JiSang YUN [EMAIL PROTECTED] wrote: Hi, list i'd like to know about that merge table type. what i get to the best benefits, when i use this engine type? thank you. -- For

Re: Cannot create Windows service for MySql. Error: 0

Hello. While I am trying to install MySql Server 4.1, What exact version do you install? Use 4.1.8. Did you stop the previous instance of MySQL (if you have such one)? Please close all the executable files and the applications that uses MySQL's dlls. Can you start MySQL from Windows

Re: Auto Table Name Completion has stopped working?

Hello. Try 'rehash' command. Kieran Kelleher [EMAIL PROTECTED] wrote: [-- text/plain, encoding 7bit, charset: US-ASCII, 15 lines --] Normally, when you type the first few letters of a table name and press tab, the mysql client does not auto complete anymore. Can this be

Re: FLUSH syntax query

Hello. Also, from which version of MySQL LOCAL and NO_WRITE_TO_BINLOG options supported? 4.1.1 RESET MASTER and RESET SLAVE were named FLUSH MASTER and FLUSH SLAVES before MySQL 3.23.26. Karam Chand [EMAIL PROTECTED] wrote: Hello, From the MySQL docs:

Re: Trouble w/ mysqldump

Hello. Right, three is a true dump file, and I can restore the database, everything 'seems' to be there, So, as I understand, the only thing that were confusing you, was the small dump file? If you see binary files after restoring from the dump file - they are in the dump file. I think

RE: Retrieving partial field values

Hi, Full text search should be fine with 8 million records. These are short records too, so there shouldn't be any problem at all. Also, you can configure the minimum word length in the my.cnf file, so if you want it to find short words, you can. I've got it set to two in one of my

RE: Cannot create Windows service for MySql. Error: 0

I usually find that this means there is already a MySQL service defined - you can verify this in Start/Control Panel/Administrative Tools/Services. If there is a service that exists, go to your current \mysql\bin directory within a command prompt and issue mysqld-nt --remove which will delete the

Re: Trouble w/ mysqldump

I am confused over the much smaller DataBase, but also of the corrupted avatars and file attachments (I've attached examples).. I did some research using mysqladmin, and the 'attachment' and the 'customavatar' tables are exactly the same size in both databases, but the entire DB is about 10MB

Re: Trouble w/ mysqldump (images attached)

Sorry, forgot the attachments. These are the same exact two avatars from the same user, using my 3.23 backup, for the good avatar, then the 4.18 bad avatar attachment: brokenavatar.jpegattachment: goodavatar.jpeg-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Copying table to another server.

Hello, I'm having a problem with moving a database from one server to another using mysqldump. Since the servers are different platforms, some ascii characters are getting corrupted. So, my thought was to copy the table from one database to the other via the mysql interface. I found this

Re: Data Dictionary

The only way I know to access anything resembling a data dictionary in MySQL V4.* is via the Java MetaData interfaces. I use these occasionally in my programs. In your case, you want the getColumnDisplaySize() method in the ResultSetMetaData Interface. This code fragment demonstrates the

RE: Trouble w/ mysqldump (images attached)

[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote on Thursday, January 06, 2005 4:57 PM: Sorry, forgot the attachments. These are the same exact two avatars from the same user, using my 3.23 backup, for the good avatar, then the 4.18 bad avatar Looks like a character set issue - what's the

RE: Copying table to another server.

It should just exit unless you are using -p with mysql. In that case, if mysqldump got an access denied, nothing would output to stdout and mysql would be left waiting for a password. I would try the following: mysqladmin -h 'other_hostname' create db_name mysqldump --opt db_name dump.sql mysql

Re: Data Dictionary

As Rhino said, the INFORMATION_SCHEMA views (data dictionary) are coming in v5.x (so they are close but not here yet). Until then a more native alternative is to parse the results of either SHOW CREATE TABLE tablename or SHOW COLUMNS FROM tablename LIKE 'columnname' in whatever language you

mysql on OS X

Hello, I'm interested to hear peoples' experiences running mysql on OS X. I've moved the database for a fairly heaily used website (~ 2M queries a day) over to a new dual 2GHz XServe running OS X Server 10.3.7. This database has run smoothly on an aging dual PIII machine running freebsd for the

RE: first time accessing

Tom, I still get access denied. I just reinstall the latest version yesterday. What are my options now? Thanks, Jerry -Original Message- From: Tom Crimmins [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 6:28 AM To: Gerald Preston Cc: mysql@lists.mysql.com Subject: RE:

RE: Trouble w/ mysqldump (images attached)

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 bad avatar and the good avatar

RE: first time accessing

If you are using a fresh install of mysql, you need to connect with 'mysql -u root' from the local machine and then configure access for other users with the GRANT command. See http://dev.mysql.com/doc/mysql/en/GRANT.html. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa

Re: mysql on OS X

While part of the problem may be OS X, Apple is still optimizing parts of the OS, I would say the problem is that you are comparing it to an aging PIII. Some people have gotten better performance from a PIII than a P4. The reason is cache. The PIII has a larger cache, MySQL loves cache. The G5

RE: first time accessing

Tom, I am still getting access denied when I try ',mysql -u root'. Jerry -Original Message- From: Tom Crimmins [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 11:24 AM To: Gerald Preston Cc: mysql@lists.mysql.com Subject: RE: first time accessing If you are using a fresh

RE: first time accessing

Tom, I am running 'WinMySQLadmin 4.1. Can I use this tool to change anything? Jerry -Original Message- From: Tom Crimmins [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 11:24 AM To: Gerald Preston Cc: mysql@lists.mysql.com Subject: RE: first time accessing If you are

select into the same outfile repetitively

Hi, mysql Gurus, Sometimes I need to execute 'select * into outfile '/tmp/t1.out' more than 1 times before I get the right result. But once mysql succeeds in writing t1.out, it does not overwrite it if the same sql command is executed for the 2nd time unless t1.out is removed. Is there

RE: select into the same outfile repetitively

[snip] Sometimes I need to execute 'select * into outfile '/tmp/t1.out' more than 1 times before I get the right result. But once mysql succeeds in writing t1.out, it does not overwrite it if the same sql command is executed for the 2nd time unless t1.out is removed. Is there anyway to

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

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. He told the assembled masses that in benchmarks he ran that innodb_file_per_table was somewhat faster than using the large innodb table space.

SHOW SLAVE STATUS hangs while LOAD DATA FROM MASTER runs (4.0.23)

Hi! I never saw a follow-up to the post about SHOW SLAVE STATUS hanging while LOAD DATA FROM MASTER is running as of about 4.0.20 on. (http://lists.mysql.com/mysql/167238) Is this a known bug? Or a feature? thanks! chris -- MySQL General Mailing List For list archives:

select @qty1=@qty+qty from goods2 , result 0 ?

Hi, a table goods2 itemid qty 001 12.5 002100.0 field qty float(10,2) not null default 0 set @qty1=0 select qty, @[EMAIL PROTECTED] allqty from goods2 The result is 12.50 100.0 0 Why not 12.512.5 100.0 112.5 ? It seems @[EMAIL PROTECTED] not work. Best

Re: select @qty1=@qty+qty from goods2 , result 0 ?

Hi Shuming, select qty, @[EMAIL PROTECTED] allqty from goods2 That should be @qty1:[EMAIL PROTECTED] You are doing a comparison using =, which is returning false (0). Regards, Jeremy -- Jeremy Cole Technical Yahoo - MySQL (Database) Geek -- MySQL General Mailing List For list archives:

Re: mysql on OS X

Hi Scott! We use MySQL on 9 Mac OS X machines. While we are looking at moving some of that back to big Sun boxes, that's a memory access/64 bit issue, not (directly) a performance issue. Looking at the live stats one of the machines has an uptime of 55 days and has averaged 405.78 queries per

MySQL insert with PHPMyAdmin

Can using PHPMyAdmin cause problems. What I'm doing is, I'm using PHPMyAdmi as a data entry tool. I create a new record in a table and then fill in the fields with the field editing and insert abilities of PHPMyAdmin. For a remote user of course I'd escape any inserted strings with addslashes or

Fulltext search string less than 4 characters

I want to know on Solaris how I could lower the the minimum fulltext search string from 4 to 3. Right now using the FullText search any string less than 4 chars is ignored. I'm sure there's a link explaining how. Maybe UNIX help in general on his would be good as well. Thanks, Lee G. -- MySQL

Re: MySQL insert with PHPMyAdmin

As far as I know there should not be any problem but I prefer SQLyog for all my MySQL work. It even has HTTP Tunneling to access dbs that dont allow remote access. Karam --- leegold [EMAIL PROTECTED] wrote: Can using PHPMyAdmin cause problems. What I'm doing is, I'm using PHPMyAdmi as a data

Re: FLUSH syntax query

So if I use FLUSH MASTERS and FLUSH SLAVES, it will have the same effect with new versions of MySQL too. Karam --- Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. Also, from which version of MySQL LOCAL and NO_WRITE_TO_BINLOG options supported? 4.1.1 RESET MASTER and RESET SLAVE were

select datetime older than X weeks

I'm using OpenBSD 3.6 (latest version) which comes with binary packages for MySQL 4.0.20 - More recent binary packages are not yet available for this platform and installation from source is not an option. I have a table with datetime field and I would like to select all data older than X

creating first table

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. I tried alter table club add ME varchar( 3)); and get : You have an error in your SQL syntax; check

Re: Auto Table Name Completion has stopped working?

That worked. Thanks very much! Danke, Gracias, Grazie, Merci, Go raibh maith agat! On Jan 6, 2005, at 3:38 AM, Gleb Paharenko wrote: Hello. Try 'rehash' command. Kieran Kelleher [EMAIL PROTECTED] wrote: [-- text/plain, encoding 7bit, charset: US-ASCII, 15 lines --] Normally, when you type

Re: Fulltext search string less than 4 characters

Lee, establish the fulltext minimum word length system variable as follows... [mysqld] ft_min_word_len=3 reference: http://dev.mysql.com/doc/mysql/en/Fulltext_Fine-tuning.html cheers, --bemansell Brian E. Mansell MySQL Professional On Thu, 06 Jan 2005 20:59:23 -0500, leegold [EMAIL

easy way to drop a tempoary table created by Create view?

Hi, What is the easiest way to drop a table created by create view? I m using mysql 5.0. I would like to execute the drop from Unix commandline. Thanks Sam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

Hi Bruce, On Dec 28, 2004, at 2:38 PM, Bruce Dembecki wrote: As a person in the process of migrating from 4.0 to 4.1 and having already scheduled the downtime with my clients for this Friday morning, and having to do a full dump and import already as part of the migration process I'd like to