Regarding replication

Hi, Is replication of database is possible in MySQL 4.0.21?. If not from which version it is available?. Could any one of you please provide some helpful information about how to do the replication?. Thanks, Narasimha Confidentiality Notice The information contained in this e

Re: ? MySql Server on Suse Linux & XP Workstations?

Hi Eric, Thanks for you reply. You said this PC Setup works. Can ask you to be my correspondence on this subject? If that is okay with you! Regards, Teddy At 04:29 PM 18/01/2005, Eric Bergen wrote: On Tue, 18 Jan 2005 07:51:18 +1100, Teddy Apostol <[EMAIL PROTECTED]> wrote: > Hi Lists, > > Question

Setup question on mysql under Linux

I'm having trouble getting myslqd to run as a user other than root when it is started by mysqld_safe. I folowed the steps in the manual but mysqld continues to run as root, mysqld_safe runs as the changed user. I check my.conf and the user statement is in the mysqld section as outlined. If I m

Re: "How do I ..." SQL question

> > Return only four rows beginning at second row: > > > > SELECT count(*) AS count, name, year FROM a > > GROUP BY name, year > > ORDER BY count DESC, name ASC > > LIMIT 4 OFFSET 1; > > > > count name year > > --- -- -- > >3 joe2004 s,e,e > >2 bob20

Re: allowMultQueries for Connector-J breaks replication from master.

Mark Matthews wrote: <>Kevin, 4.0.12 doesn't have the feature, so you should've gotten a 'syntax error' when you tried it ;) Hm.. Maybe you're right... Now that you mention it I did test it against 4.1.7. -- Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an invite! Also s

RE: Doubt about Performance

> -Original Message- > From: Ronan Lucio [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 18, 2005 10:13 AM > To: mysql@lists.mysql.com > Subject: Doubt about Performance > > Hello, > > Trying to keep the database and the application fast, I´d > like to clearify my mind about it

RE: I seem to have lost a table somehow :-(

Somehow your table was zero'ed out, i.e. TRUNCATE / DROP-CREATE. MYD - data of the table MYI - index of the table Frm - TABLE definition I hope you have a backup. > -Original Message- > From: Vicki Brown [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 18, 2005 3:15 PM > To: mysql@li

I seem to have lost a table somehow :-(

I have a Movable Type weblog at http://www.technofile.org/AverageJoe/ I am using MySQL to store the data for this weblog; mysql Ver 14.7 Distrib 4.1.7, for unknown-freebsd4.7 (i386) when I go to the MT Main Menu page, the weblog is not listed as existing. When I go to the mysql database dire

Replication fails to resume after master crash

Master: mysqld 3.23.58 on FreeBSD 4.10-R Runs two masters via mysqld_multi Rotation #1: 10x mysqld 4.0.22 on FreeBSD 4.9-R, 4.10-R 1x mysqld 4.1.8a on FreeBSD 4.10-R Rotation #2 2x mysqld 4.0.22 on FreeBSD 4.9-R We have had the following happen twice in the past

Re: Listing all connected users?

sol beach wrote: How do I see who is currently connected to MYSQL & from where they originate? Use the SHOW PROCESSLIST command: http://dev.mysql.com/doc/mysql/en/SHOW_PROCESSLIST.html > -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:

RE: Listing all connected users?

Issue SHOW [FULL] PROCESSLIST as the super user > -Original Message- > From: sol beach [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 18, 2005 3:01 PM > To: mysql@lists.mysql.com > Subject: Listing all connected users? > > How do I see who is currently connected to MYSQL & from wh

Listing all connected users?

How do I see who is currently connected to MYSQL & from where they originate? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

getting error with mysql_fix_privilege_tables

When I run mysql_fix_privilege_tables it tells me to ignore a lot of errors. But it doesn't tell me about this error: ERROR 1061 at line 5: Duplicate key name 'Grantor' Can I ignore this? What is it from? Thanks, Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

Re: Like statement help

Craig Hoffman <[EMAIL PROTECTED]> wrote on 01/18/2005 04:17:30 PM: > Hi There, > I have web form where a user can search certain fields and then have > them displayed aggregated. For example, find all the routes I climbed > with partner A in area(s) ALL (% - wildcard) between date1 and date2 --

Like statement help

Hi There, I have web form where a user can search certain fields and then have them displayed aggregated. For example, find all the routes I climbed with partner A in area(s) ALL (% - wildcard) between date1 and date2 -- so on. See below for the complete query. I'm using pull down menu's and

bind-address question

Hi everyone, I would like to bind mysqld to more than one IP address (localhost and my private unrouted interface). Is there a way to get --bind-address to bind to more than one IP? I have been unsucessfull when trying comma/space delimited arguments to bind-address, etc. Thanks, -Cere -- M

Re: Doubt about Performance

"Ronan Lucio" <[EMAIL PROTECTED]> wrote on 01/18/2005 02:53:39 PM: > Shawn, > > Your tips are realy good but I can´t use cache neither for > queries nor for pages because our site serves hundreds of > clients, each one with your own code make a different > query, returning different rows. > > It

RE: Logging Data: Should I use MyIsam or InnoDB?

Jeremy, Thanks a million, this makes perfect sense, I will test this out asap. In theory it sounds like the plan, I just need to see if it will work here. I really appreciate the help . . . Regards, Thomas. -Original Message- From: Jeremy Cole [mailto:[EMAIL PROTECTED] Sent: Tuesda

Re: Logging Data: Should I use MyIsam or InnoDB?

Hi Thomas, Thanks, this is what I was originally thinking of, but how I am getting rid of the data in log_view_today? OR, are you saying that log_view_today is a merge table for only the current day? That table def is defined every night? Then I would go about dropping everything in whatever fas

Re: allowMultQueries for Connector-J breaks replication from master.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin A. Burton wrote: > Kevin A. Burton wrote: > > >>Not sure which list this should go to ... seems like a bad bug so I >>sent it to the java and mysql lists to prevent it from hitting anyone >>else. (I also searched bugs.mysql.com which doesn't

JOIN with a ndbcluster engine

I am having an issue with a JOIN on two tables that are in a two node cluster. What happens is that the columns in the joined table are all null. students left outer join members on students.student_key = members.student_key I should get something like this: +--+--

Re: allowMultQueries for Connector-J breaks replication from master.

Kevin A. Burton wrote: Not sure which list this should go to ... seems like a bad bug so I sent it to the java and mysql lists to prevent it from hitting anyone else. (I also searched bugs.mysql.com which doesn't seem to show anything). Actually... one more note The last time I tested this w

Re: Doubt about Performance

Sasha, > I assume you mean "has serious performance impact" when you say "weight". If > this is not what you meant, please correct/clarify. Yes, you´re right. >> >> 1) Is a SELECT DISTINCT over 5,000 records a weight >> query? (Supposing it has about 20 different option the the >> DISTIN

RE: Logging Data: Should I use MyIsam or InnoDB?

Jeremy, Thanks, this is what I was originally thinking of, but how I am getting rid of the data in log_view_today? OR, are you saying that log_view_today is a merge table for only the current day? That table def is defined every night? Then I would go about dropping everything in whatever fa

Re: Doubt about Performance

"Ronan Lucio" <[EMAIL PROTECTED]> wrote on 01/18/2005 01:13:10 PM: > Hello, > > Trying to keep the database and the application fast, > I´d like to clearify my mind about it. > > 1) Is a SELECT DISTINCT over 5,000 records a weight > query? (Supposing it has about 20 different option the the

allowMultQueries for Connector-J breaks replication from master.

Not sure which list this should go to ... seems like a bad bug so I sent it to the java and mysql lists to prevent it from hitting anyone else. (I also searched bugs.mysql.com which doesn't seem to show anything). We're playing with the allowMultiQueries feature in Connector-J 3.1.7 which allow

Re: Logging Data: Should I use MyIsam or InnoDB?

Hi Thomas, I have a curious issue here, maybe someone can help. I have a single process that inserts data into tables that contain purely logging information. This table is then searched by our Care department to troubleshoot issues. I am looking for the best way to store this data, and the struc

Re: Indizes für große Datenbank

Hi Jigal, Jigal van Hemert schrieb: From: "Andreas Brandl" ich stehe gerade vor dem Problem, dass ich eine große Datenbank (ca. 2 Mio. Datensätze) optimieren muss. Since this list is in English I'll answer you in English, so the others can join the fun! Well, I didnt notice the list is in English

Re: Doubt about Performance

Ronan Lucio wrote: Hello, Trying to keep the database and the application fast, I´d like to clearify my mind about it. Ronan: I assume you mean "has serious performance impact" when you say "weight". If this is not what you meant, please correct/clarify. 1) Is a SELECT DISTINCT over 5,000 records

Logging Data: Should I use MyIsam or InnoDB?

I have a curious issue here, maybe someone can help. I have a single process that inserts data into tables that contain purely logging information. This table is then searched by our Care department to troubleshoot issues. I am looking for the best way to store this data, and the structure on

RE: Replication Slave I/O Thread won't start on 4.1.8

> > - make sure log-bin is enabled on both master and slave > (looks like it is not present in the slave config) > > Why is log-bin needed on the slave? I thought the master logs changes > and the slave reads those changes and updates it's copy. Why should > the slave also log changes it is makin

Re: Doubt about Performance

Greg, Thank you very much for your help. > An index the full size of the distinct key is probably very quick especially > if it only has 20 distinct values. OTOH, if you already know you have a > small number of distinct values, could you just store them normalized in a > different table? Actua

Re: processes and threads question

I appear to be running kernel 2.4.x ps -ax only shows one mysqld thread John McCaskey wrote: Did you upgrade to a 2.6.x linux kernel as well? Threads get hidden in a normal ps aux command starting in 2.6 and show as a single process. If this is the case do ps aux -L and you will see the threads as

Re: processes and threads question

Did you upgrade to a 2.6.x linux kernel as well? Threads get hidden in a normal ps aux command starting in 2.6 and show as a single process. If this is the case do ps aux -L and you will see the threads as well. On Tue, 2005-01-18 at 13:15 -0500, Eben Goodman wrote: > I used to run mysql 3.x on R

processes and threads question

I used to run mysql 3.x on Redhat, and would on any given day have anywhere from 5 to 30 mysqld process/threads going depending on traffic. I upgraded to mysql 4.0.17 on a dedicated redhat box, and now it only ever shows 1 mysqld process/thread that uses max cpu and consumes a good deal of mem

Doubt about Performance

Hello, Trying to keep the database and the application fast, I´d like to clearify my mind about it. 1) Is a SELECT DISTINCT over 5,000 records a weight query? (Supposing it has about 20 different option the the DISTINCT key). 2) Is SELECT ORDER BY RAND() over 1,500 records a weight q

Re: Replication Slave I/O Thread won't start on 4.1.8

> - make sure log-bin is enabled on both master and slave (looks like it is not > present in the slave config) Why is log-bin needed on the slave? I thought the master logs changes and the slave reads those changes and updates it's copy. Why should the slave also log changes it is making? There w

Re: I'd like to know SQL query for table description.

Hello. See: http://dev.mysql.com/doc/mysql/en/SHOW_CREATE_TABLE.html ninjajs <[EMAIL PROTECTED]> wrote: > Hi. ALL > > i have a database in MySQL. > > A middleware request to MySQL DB server. > > and then, result is table description. > > ex) > dbms_type,table_name,column_nam

Re: 'TYPE = InnoDB'

Hello. You can change the default storage engine by using the --default-storage-engine or --default-table-type server startup option, or by setting the storage_engine or table_type system variable. "Paul Wallace" <[EMAIL PROTECTED]> wrote: > Hi, >I need to obtain FK data from

Re: backup of database

Hello. > how to take a backup of database? See: http://dev.mysql.com/doc/mysql/en/Backup.html "N. Kavithashree" <[EMAIL PROTECTED]> wrote: > > hello, > > > how to take a backup of database? > i have a database with name1 now i want to move all the tables into > another da

Re: create view not working on mysql 4.1.8

Hello. Views (including updatable views) are being implemented in the 5.0 version of MySQL Server. They are already available in binary releases from 5.0.1 and up. sirisha gnvg <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 8bit, charset: iso-8859-1, 18 lines --] > > we are w

Re: lost data

Hello. > I've run a safe recover on a table after I had to recreate the index file: If you had to recreate the index file after upgrading, this could be a character set issue. I mean that data is ok, but you see it after converting to another character set. myisamchk in this case doesn't ha

Re: create view not working on mysql 4.1.8

I believe CREATE VIEW came in with 5.01, not 4.1.x. PB sirisha gnvg wrote: we are working on mysql 4.1.8 and windows XP platform. This version supports views.We created a view like this mysql>use sample mysql>create view v1 as select * from sam2; sam2 is a table We got an error errror 1024(42000)

RE: Replication Slave I/O Thread won't start on 4.1.8

- make sure log-bin is enabled on both master and slave (looks like it is not present in the slave config) - check replication account permissions on the master. I don't remember details, but you can find required permissions in the docs on mysql web site, or doc file in mysql installation direc

Re: what permissions are necessary in 4.1.x to allow a user to change their own password

Gleb Paharenko wrote: Hello. Use SET PASSWORD=password('youpassword'). On 4.1.9 such queries works fine: mysql> show grants for current_user(); ++ | Grants for [EMAIL PROTECTED]

RE: MySQL 4.1.8 and storing east characters

Hi Daniel, I apologise on my ignorance on the matter of Romanian being a Cyrillic, my English is bad enough, any comment I make about languages should be ignored ;-) On the matter of Japanese symbols I'm puzzled; something must be altering the character code somehow on the way to being inserted i

Re: Replication Slave I/O Thread won't start on 4.1.8

One thing I left out is that we are running 4.1.8-Max-log not 4.1.8-standard-log Could that have anything to do with it? Thanks for any insight, Frank On Mon, 17 Jan 2005 15:55:06 -0500, Frank Febbraro <[EMAIL PROTECTED]> wrote: > Hey all, > > I have setup replication in the past on 4.0.x se

Re: "How do I ..." SQL question

[EMAIL PROTECTED] wrote on 01/17/2005 06:45:22 PM: > Hi there: > > I have a "How do I..." SQL question regarding selecting > distinct values from a field not included in an aggregated > query when LIMIT is in effect, illustrated by the > following example: > > Table a contains the names of indiv

Re: Ask for input during SQL script execution

[EMAIL PROTECTED] wrote: All, Can someone point me in the right direction ? I am trying to right sql scripts for queries that will prompt for information. Here is the gist of it, I have a sql script that will query a database however I need the script to ask the user for IP address, and other in

Re: Error - #1251

Thanks - I got it working. On Jan 18, 2005, at 12:35 AM, Mattias J wrote: At 2005-01-18 04:53, Craig Hoffman wrote: I upgrade to 4.1.9 last night and I keep getting this error in PhpMyAdmin after I changed the root password (yes I changed both pw's). Does anyone have a solution on how to fix thi

Re: MySQL Losing database information

[EMAIL PROTECTED] wrote: ALL, I have an issue where MySQL has lost all of the table information for an existing database, I do not know of anything that has changed and there was no maintenance being done in MySQL. Below you will find the error message as I receive it from MySQL. ANY ideas or su

Re: "How do I ..." SQL question

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] writes: > SELECT DISTINCT place FROM a ; > place > --- > south > west > east > Note that the place north does not appear in the last result > because north was only visited by bob in 2005 and kim in 2004, > records which are not i

Re: get field name

Chenri wrote: how do i get field name from this table Time Stat1 Stat2 Stat3 0905 1 1 1 0906 1 0 1 i want to get the field name Stat1 & Stat 3 from the 0906 row which have 1 as value I expect the result to be STAT1 STAT3 This is not easily done, if I understand you cor

RE: I'd like to know SQL query for table description.

[snip] and then, result is table description. ex) dbms_type,table_name,column_name,data_type,data_size,constraint_type What SQL query can I get this information ? [/snip] DESCRIBE `tablename`; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: Trouble with Virus checkers

Hi Alec, Of course it is an acceptable solution to tell your virus checker to ignore the data files. Another application than the database engine itself should never manipulate the data files of any database engine. And yes, you are right... :-) Running the database server separate from the pc

Re: SHOW COLUMNS Syntax Using 3.23.54 Please!

shaun thornburgh wrote: I am trying to get all field names from my table that begin with letter X or Y, however the following statement and many variations I have tried produce an error: SHOW COLUMNS FROM TABLE LIKE "X%" OR LIKE "Y%" According to the manual, the pattern for SHOW COLUMNS is: SHOW

Re: I'd like to know SQL query for table description.

Try this query - show table status from YourDatabaseName; ninjajs wrote: Hi. ALL i have a database in MySQL. A middleware request to MySQL DB server. and then, result is table description. ex) dbms_type,table_name,column_name,data_type,data_size,constraint_type What SQL query can I get this infor

Re: Rollback and INSERT_ID() or LAST_INSERT_ID()

Andre, I would recommend a table for recovering id's that are lost due to rollback. Before you actually rollback, take the generated ID and push it into this table. Then change the way you acquire id's on insert. You will want to check to see if this table has an ID before you auto_increment

SHOW COLUMNS Syntax Using 3.23.54 Please!

Hi, I am trying to get all field names from my table that begin with letter X or Y, however the following statement and many variations I have tried produce an error: SHOW COLUMNS FROM TABLE LIKE "X%" OR LIKE "Y%" Any help here would be much appreciated :) -- MySQL General Mailing List For list ar

Trouble with Virus checkers

My product has at is centre a Windows PC whose sole purpose is to run MySQL plus my middleware layer. However, it installed on a site with a large amount of heterogeneous IT department and an active IT department managing the whole corporate IT structure. This IT department insists that, if it

Re: Rollback and INSERT_ID() or LAST_INSERT_ID()

Hi! Am Di, den 18.01.2005 schrieb Paul DuBois um 3:53: > At 21:27 -0500 1/17/05, Andre Matos wrote: > >Thanks Eric, but I can let it increment because I cannot have a gave in the > >numbers. I think I will need to use MAX() in this case. > > Using MAX() won't guarantee that you won't have gaps. >

Re: glibc & thread_stack

On Mon, Nov 29, 2004 at 11:50:20AM -0700, Sasha Pachev wrote: Hi, > >Hello, > > > >For a few servers with > 1000 concurrent connections, > >I've compiled glibc 2.3.3 with a patched STACK_SIZE in > >linuxthreads/descr.h : > > > >#ifndef STACK_SIZE > >#define STACK_SIZE (128 * 1024) > >#endif > >

RE: restoring database

> > > i have written a bat file in which the data databackup has been taken in > sql > > it runs automatically every 1 hour and sends a automatically through email > > now at the other end i have to manually restore the database can any one > give me the codes to restore the database automatically

get field name

how do i get field name from this table Time Stat1 Stat2 Stat3 0905 1 1 1 0906 1 0 1 i want to get the field name Stat1 & Stat 3 from the 0906 row which have 1 as value I expect the result to be STAT1 STAT3 Select xxx from table_time where xxx=1 and Time=0906;

RE: backup of database

> -Original Message- > From: N. Kavithashree [mailto:[EMAIL PROTECTED] > Sent: 18 January 2005 05:35 > To: mysql@lists.mysql.com > Subject: backup of database > > > > hello, > > > how to take a backup of database? > i have a database with name1 now i want to move all the tables into

Fwd: Undelivered Mail Returned to Sender

- Weitergeleitete Nachricht von Mail Delivery System <[EMAIL PROTECTED]> - Datum: Tue, 18 Jan 2005 08:09:14 +0100 (CET) Von: Mail Delivery System <[EMAIL PROTECTED]> Antwort an: Mail Delivery System <[EMAIL PROTECTED]> Betreff: Undelivered Mail Returned to Sender An: [EMAIL