Re: upgrading mysql on RHEL4

Hi ! perl pra schrieb: > [[...]] > > Also please tell me where can i get mysql5.1 enterprise edition. 5.1 is currently labeled "rc" (current version is 5.1.22-rc), so there is no enterprise edition yet. When there will be one, it will be for paying customers, and they have got (or will receive)

another slave loading question

i have this State when I start a slave: Has read all relay log; waiting for the slave I/O thread to update it mysql> show processlist; ++-+---+---+-+--+---+--+ | Id | User

Re: turn a slave back into its own master

I believe you would have been ok with stop slave and reset master. Saravanan wrote: i am ok with this mysql> change master to master_host=''; Query OK, 0 rows affected (0.01 sec) mysql> show slave status\G Empty set (0.01 sec) Saravanan --- On Sat, 1/19/08, Paul Berry <[EMAIL PROTECTED]> w

Re: another slave loading question

did you check time in master and slave servers? saravanan --- On Sat, 1/19/08, Paul Berry <[EMAIL PROTECTED]> wrote: > From: Paul Berry <[EMAIL PROTECTED]> > Subject: another slave loading question > To: "MySql" > Date: Saturday, January 19, 2008, 7:56 AM > i have this State when I start a sl

Re: another slave loading question

Hi, I am new to MySQL. I am not sure how to set timezones. But your slave status and slave processlist doesn't show any problem. It replicated correctly and wait for I/O thread to update the relay log. use '\G' instead of ';' Saravanan --- On Sat, 1/19/08, Paul Berry <[EMAIL PROTECTED]> wro

Re: another slave loading question

hi thanks for the quick answer ! these 2 servers are in different timezones - do i need to set the slave server to the master slave's timezone? i'm giong to research implementing that right away - in the meantime i thought this might help show some information i have this on the master: mysql> s

Re: turn a slave back into its own master

i am ok with this mysql> change master to master_host=''; Query OK, 0 rows affected (0.01 sec) mysql> show slave status\G Empty set (0.01 sec) Saravanan --- On Sat, 1/19/08, Paul Berry <[EMAIL PROTECTED]> wrote: > From: Paul Berry <[EMAIL PROTECTED]> > Subject: Re: turn a slave back into its

Re: turn a slave back into its own master

thanks - i think i'm ok because i get these results mysql> show slave status; Empty set (0.00 sec) On 1/18/08, Saravanan <[EMAIL PROTECTED]> wrote: > > Hi, > > will removing the master.info help instead of executing change master? > > or > >stop slave; > >reset master; > > > --- On Sat, 1/19/08,

Re: turn a slave back into its own master

Hi, will removing the master.info help instead of executing change master? or >stop slave; >reset master; --- On Sat, 1/19/08, Paul Berry <[EMAIL PROTECTED]> wrote: > From: Paul Berry <[EMAIL PROTECTED]> > Subject: Re: turn a slave back into its own master > To: "MySql" > Date: Saturday, Janu

turn a slave back into its own master

hi guys, quick question how do i undo a CHANGE MASTER TO command and make it a master of itself again? thanks

Re: turn a slave back into its own master

i ended up doing this - it seems to have worked fine STOP SLAVE; SHOW SLAVE STATUS; CHANGE MASTER TO MASTER_HOST='', MASTER_PORT=0, MASTER_USER='', MASTER_PASSWORD=''; RESET MASTER; On 1/18/08, Paul Berry <[EMAIL PROTECTED]> wrote: > > hi guys, quick question > > how do i undo a CHANGE

Re: creating temp file, modifying data and putting into other table

the default DB is mysql to verify execute mysql client and then show the databases mysql> show databases; ++ | Database | ++ | information_schema | | catalog| | mysql | | petclinic | | test | +---

Re: Select statement help

Hi, On Jan 18, 2008 2:59 PM, RoryGRen <[EMAIL PROTECTED]> wrote: > > Hi all > > I am quite new to mySQL and have the following question I hope someone can > help me with: > > I have a database table imported directly from MS Access with two of the > field names having brackets - F(1) and S(1). I d

Select statement help

Hi all I am quite new to mySQL and have the following question I hope someone can help me with: I have a database table imported directly from MS Access with two of the field names having brackets - F(1) and S(1). I don't want to change the field names, as I am simply going to import again when

Re: Handling Special Characters

Jerry, On Jan 18, 2008 2:27 PM, Jerry Schwartz <[EMAIL PROTECTED]> wrote: > I am having trouble inserting special characters into a table. I am using > the MySQL client. I put the following commands into a text file (I'm on > WinXP, using Notepad), copy them, and paste them into the MySQL command

Handling Special Characters

I am having trouble inserting special characters into a table. I am using the MySQL client. I put the following commands into a text file (I'm on WinXP, using Notepad), copy them, and paste them into the MySQL command line client. SET NAMES utf8; CREATE TEMPORARY TABLE `giiexpr_db`.`eo_name_table

Re: basic style shema question

Hmm. If we're talking pure DB theory, then the whole point is to apply the DRY principle as much as possible. At the point you have multiple copies of the same data, unless your programmers are perfect (and they aren't, I promise), you *will* have stale data. Better to have only one place to

RE: creating temp file, modifying data and putting into other table

Kerry, Post the error you get. First select the database you are going to use in the right panel. execute the create table statement. update the table. execute the select statement as last. Saravanan --- On Sat, 1/19/08, Kerry Frater <[EMAIL PROTECTED]> wrote: > From: Kerry Frater <[EMAIL PR

RE: creating temp file, modifying data and putting into other table

Yes it is the mysql browser. I have tried one after the other with the same result. So it looks as though I am using the wrong testbed Kerrry -Original Message- From: Saravanan [mailto:[EMAIL PROTECTED] Sent: 18 January 2008 15:12 To: 'Sebastian Mendel'; 'MySql'; [EMAIL PROTECTED] Subje

Re: basic style shema question

Hi Kevin, Well the basic information, company description and personalized options will be selected many times (whenever a user submits a query). It will basically be show on the result page of the search engine. The user's login / password well is used to login, then the user may update the comp

Re: basic style shema question

Hi, Split frequently used columns from other non frequently used. Splitting them will improve the disk access. You don't need to separate as too many tables. You need to index all the tables if you split into many. Saravanan --- On Fri, 1/18/08, Alex K <[EMAIL PROTECTED]> wrote: > From: Ale

Re: basic style shema question

At 11:44a -0500 on 18 Jan 2008, Alex K wrote: To summarize one table vs. many tables with one to one relations? As per usual, it depends on your needs. For most flexibility, and to give the DB the best chance to give the best plan for the possible requests I might make in the future, I gener

Re: basic style shema question

Hi, Split frequently used columns from other non frequently used. Splitting them will improve the disk access. You don't need to separate as too many tables. You need to index all the tables if you split into many. Saravanan --- On Fri, 1/18/08, Alex K <[EMAIL PROTECTED]> wrote: > From: Alex

Re: Who know this strange problem

Hi, On Jan 18, 2008 3:50 AM, Moon's Father <[EMAIL PROTECTED]> wrote: > My test is as follows: > mysql> select g_id from t group by g_id order by g_id desc limit 0,1; > +--+ > | g_id | > +--+ > |6 | > +--+ > 1 row in set (0.00 sec) > > mysql> select g_id from t group by g_id orde

basic style shema question

Hi Guys, Let's suppose I have the following table: create table companies ( id int(11) not null auto_increment primary key, # user's login and password email varchar(100), passwordvarchar(100), # basic information company_namevarchar(10

Re: upgrading mysql on RHEL4

Hi, Take backup of the existing data before upgrading for safety. There is RHEL 4 specific rpm binary is existing in the downloading section. After installing run the required tools comes with mysql. Before upgrading with existing datas read the documentation carefully. http://dev.mysql.com

upgrading mysql on RHEL4

Hi Gurus, I have mysql4.x installed on REHL4. Can anybody let me know how to upgrade it to 5.1. Also please tell me where can i get mysql5.1 enterprise edition. Thanks in advance Siva

RE: creating temp file, modifying data and putting into other table

Hi, Are you using mysql browser? If yes. It will run only the current line statement. It will not execute all the three statements. So try one after the other. Saravanan --- On Fri, 1/18/08, Kerry Frater <[EMAIL PROTECTED]> wrote: > From: Kerry Frater <[EMAIL PROTECTED]> > Subject: RE: creat

RE: creating temp file, modifying data and putting into other table

I have just tried it with lowercase with the same result. To test I have opened up the query browser and typed 3 lines create temporary table ttable1 (select * from testnames where ref='ABCDE'); update ttable1 set ref='12345678'; select * from ttable1; I leave the cursor on the 3rd line and clic

Latest Development Over Nepal and World

hamropalo.com/biz/box.php?funcml=unsub2&nl=1&[EMAIL PROTECTED] -- To Unsubscribe, please click here: hamropalo.com/biz//box.php?funcml=unsub2&nl=1&[EMAIL PROTECTED]

Re: select

On Fri, 18 Jan 2008, Sebastian Mendel wrote: Hiep Nguyen schrieb: hi all, i have a table looks like this: ID sDate 1 1997-03-21 2 1997-04-30 3 1997-05-30 4 1998-01-29 5 1998-02-24 6 1998-03-21 7 1999-05-10 8 1999-07-12 9 1999-10-20 10 2000-

Re: select

Hiep Nguyen schrieb: hi all, i have a table looks like this: ID sDate 1 1997-03-21 2 1997-04-30 3 1997-05-30 4 1998-01-29 5 1998-02-24 6 1998-03-21 7 1999-05-10 8 1999-07-12 9 1999-10-20 10 2000-01-01 11 2000-02-15 12 2000-03-20 13

Re: generating numbers from other fields

Brian E Boothe schrieb: how can i join three fields Values into one field? so in three select boxes i have date : Projects type 1 - 7 and project type 1 - 6 so the third Filed would be 116200824 generated by the other three fields? please clarify! or did you mean CONCAT() or CONCAT_WS() o

Re: creating temp file, modifying data and putting into other table

Kerry Frater schrieb: Can someone please advise. I am looking to create a "multiuser" friendly way of getting a subset number of rows from a table into another whilst making a modification. I thought that this could be done using a temporary table in a batch script that is unique to that session

select

hi all, i have a table looks like this: ID sDate 1 1997-03-21 2 1997-04-30 3 1997-05-30 4 1998-01-29 5 1998-02-24 6 1998-03-21 7 1999-05-10 8 1999-07-12 9 1999-10-20 10 2000-01-01 11 2000-02-15 12 2000-03-20 13 2000-05-18 how do

Re: Storing Larger MySQL Backups

I'm curious if anyone has any thoughts on how I can handle a data retention issue I've been facing with a larger dataset. My process, roughtly is run mysqldump against the DB and gzip the output. Then I transfer it off to a different machine for archival onto optical media (yes I know the

Who know this strange problem

My test is as follows: mysql> select g_id from t group by g_id order by g_id desc limit 0,1; +--+ | g_id | +--+ |6 | +--+ 1 row in set (0.00 sec) mysql> select g_id from t group by g_id order by g_id desc limit 0,1 into @tmp_id; Query OK, 1 row affected (0.00 sec) mysql> select

Re: MySql at 100% CPU

No worries :) > Good luck with your problem! Apparently not, since no member of the MySql team wants to tell me and this mailing list what scenario's will cause a low-load MySql system lock at 100% CPU for hours on end. Another of my servers has just entered this mode about half an hour ago.

Re: creating temp file, modifying data and putting into other table

On Jan 17, 2008 9:02 PM, Kerry Frater wrote: > Thanks for the input Jochem. If you wish to ignore my code and continue with your own code that of course is fine with me. But why do you expect me to continue to help you if you ignore me anyway? Jochem -- MySQL General Mailing List For list archi