Replication Issue

I have mysql master and mysql slave on same machine running separately. I have master and slave setup. I was able to do the LOAD DATA FROM MASTER; to get the data but the data does not replicate after that. Looking at the info below can you tell why replication is not taking place. Can I

RE: Replication Issue

Randy Johnson [EMAIL PROTECTED] wrote: I have mysql master and mysql slave on same machine running separately. I have master and slave setup. I was able to do the LOAD DATA FROM MASTER; to get the data but the data does not replicate after that. =20 Looking at the info below can

RE: Replication Issue

Does this table say that mysql 3.23.33 and up is not compatible to replicate to a mysql 5.0 slave? Thanks! Randy -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 12:21 PM To: [EMAIL PROTECTED] Subject: Re: Replication Issue Randy

RE: Replication Issue

Here is the url sorry: http://dev.mysql.com/doc/mysql/en/Replication_Compatibility.html -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 2:07 PM To: [EMAIL PROTECTED] Subject: RE: Replication Issue Does this table say that mysql

Question on 2 different tables

This example is simplified. I hope you understand Each table has one field called ID which is an integer and is the primary key Table 1 List of Programs 1 2 3 4 5 6 7 8 9 10 Table 2 Programs members have joined 1 5 8 Here is the scenario. I want to compare the values in table

Re: Question on 2 different tables

SELECT * FROM tableone WHERE value NOT IN (SELECT column FROM tabletwo) ; On Wed, 2004-01-21 at 15:26, Randy Johnson wrote: This example is simplified. I hope you understand Each table has one field called ID which is an integer and is the primary key Table 1 List

What's this error mean?

What's this error mean? Warning: Wrong parameter count for mysql_query() thanks Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: mysql password ( )

so md5 would be the securest way to handle password security for a website? Randy - Original Message - From: Daniel Kiss [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 12:19 AM Subject: Re: mysql password ( ) Hi, The password() function is a one way

Join VS 2 selects

I am guessing that it is quicker to join 2 tables based than it is to do 2 selects in a php script opinions??? Randy sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: strange error in InnoDB on raw disk

in a innodb table type using mysql max is a begin statement the same as set autocommitt = 0?? Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

innob question

in a innodb table type using mysql max is a begin statement the same as set autocommitt = 0?? Randy sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Transaction Question CONFUSED

I am confused. (innodb table type) Client 1. starts transaction selects balance from table where id=1 for update update table set balance=100 #At this point from what i have read the balance could be selected by anther user. committ I have read that a select balance from table where id=1

Re: web application test tool

you grab the balance , manipulate it by adding or subtracting an amount then updating it. Randy - Original Message - From: Tod Harter [EMAIL PROTECTED] To: bin cai [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 3:35 PM Subject: Re: web application test tool On

INNODB Figured out i think

You have written the following: SET [SESSION | GLOBAL] TRANSACTION ISOLATION LEVEL [SERIALIZABLE| ...] The above statement i take it will prevent transaction 2 from selecting a value until transaction 1 committs. Is this correct? and Question 2, Does this have to be executed before every

Re: Transaction Question

Thanks for your reply, is it documented somewhere? Randy - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 19, 2002 10:07 AM Subject: Re: Transaction Question Randy, Sunday, August 18, 2002, 10:57:54 AM, you wrote: RJ I

Transaction Question

Here is an insert from the innodb reference manual Suppose you use a consistent read to read the table PARENT and indeed see the parent of the child in the table. Can you now safely add the child row to table CHILD? No, because it may happen that meanwhile some other user has deleted the parent

Transaction Question

Hello, I am using innodb tables via mysql max if i do a select * for update and then do an update statement will this unlock the record for another update or will it wait for me to do a commit? thanks, Randy query,sql

Multi Table Types

I have the latest stable mysql installed with innodb support.. is it possible to have all myisam tables but one that i need to have innodb table type for row level locking and transactions Randy - Before posting, please

POSTGRESQL VS MYSQL

Hello, I was wondering if anybody new of any articles out there that benchmarked mysql and postgresql recently.I have a few that have favored and have not seen any other ones that favor mysql accept for the benchmarks on the mysql website Thanks Randy

PHP/MYSQL Consultation

I am in need of consultation services concerning my PHP scripts and MYSQL database. if you are interested please email me at [EMAIL PROTECTED] or [EMAIL PROTECTED] with credentials and how much you charge, and whatever else I may need to know. Here is my problem. I have a web server and a

Adding a [mysql] to the subject line

I am not sure if this has been addressed before, I think it would be neat if the list admin could put a [mysql] in the subject line for messages. I get a lot of email and it would help having that in the subject line. it would also help me in filtering my mail. Please let me know your

OR in QUERY

is there any way turn the following query to all ands instead of using an or? select f1,f2,f3 from table1 where (f1 ='monday' or f2 ='monday') and f3='34'; Thanks Randy - Before posting, please check:

Update

Table 1 and table 2 data values are the same accept some of the data in table 2 was accidentally changed so I need to do an update to table 2 I need to update Table 2 values using Table 1 values based on the primary key of table 2 equaling table 1 primary key. Will This work Update Table2

OPTIMIZATION

Please give me advice on optimizing my server: Here are the system specs dual 733 Pentium 512 megs of ram 9 gig scsi -- Here is the options that I use based on the documentation for a moderate # of users: -O max_connections=1000 -O key_buffer=64M -O

FW: OPTIMIZATION

Please give me advice on optimizing my server: Here are the system specs dual 733 Pentium 512 megs of ram 9 gig scsi -- Here is the options that I use based on the documentation for a moderate # of users: -O max_connections=1000 -O key_buffer=64M -O

mysqldump

Hello, is there anyway to execute a mysqldump command via the web and have the dump stored on a file on the server. do any of the webinterfaces offer that? any scripting languages? thanks randy - Before posting, please

apostrophe ....

When a text with an apostrophe in it has a \' in it. How can I fix this? example randy's is stored in the DB as randy\'s thanks Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual)

GETTING ROWS

Here is a query: $query="Select RECEIVER from TRANS_TBL order by TRANS_ID DESC LIMIT 10" ; How do I change this query to skip rows if it already selected a row with that particular receiver in it? Thanks randy - Before

RE: Doing multiple updates

sn't locked by this thread (in which case the lock is not released), and NULL if the named lock didn't exist. The lock will not exist if it was never obtained by a call to GET_LOCK() or if it already has been released. Mark. -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED]] Se

Resource id #2

When I run any kind of query this is the value of result Resource id #2 Example $result= mysql_query (" Select * from ACCT_TBL ") or die ("Error".mysql_error()); print result; any ideas? randy - Before posting, please

Doing multiple updates

Hello, I am creating a mock site that has a money balance that people can login and pretend to pay money for stuff online via my site. I am using php with mysql to implement this. How do I make sure that a balance for a particular account is (locked) so only 1 spend for that account can