Re: Altering database size to add more space

by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Altering database size to add more space

information_schema.tables GROUP BY table_schema ; Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: list rows with no recent updates

'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 How can I list rows with no recent updates ( or the once where the above updates were not done) or say with no updates in last 2 hours? Thank you. -- Jim Lyons Web developer / Database administrator http

Re: Geting current user pasword.

comprobado este mensaje. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com -- MySQL General

Re: Using RAND to get a unique ID that has not been used yet

General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:    http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com -- MySQL General Mailing List For list archives: http

Re: Analysis of a weeks worth of general log

...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: How to corrupt a database please???

To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: MySQL Slave is almost 1 day behind

For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Remove - Foreign key constraint in innodb

you VIKRAM A The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Garbage collecting/trimming ibdata1

Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: max() can't work

...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: max() can't work

The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Selecting Dates

of these work. What am I missing? -ML -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com Sent from BlackBerry® on Airtel -- Jim Lyons Web developer / Database administrator http

Re: How to purposely corrupt a table

/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Exporting the result of a Query into excel

and do a select on the data you want, redirecting it into an output file. On Tue, Jan 5, 2010 at 7:17 AM, ishaq gbola ishaq...@yahoo.co.uk wrote: Hi all, I would like to know if there is a tool or command in mySQL that allows one to export the result of query into excel formart -- Jim

Re: Exporting the result of a Query into excel

/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=ishaq...@yahoo.co.uk -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Exporting the result of a Query into excel

, 2010 at 1:50 PM, Carsten Pedersen cars...@bitbybit.dkwrote: Is there any particular reason not to use the MySQL ODBC driver to import the data directly into Excel? / Carsten Jim Lyons skrev: A command to convert the table mytab in database mydb into a tab-delimited file mytab.txt might

Re: Render row without duplicates

mail, Am not sure, but i guess this union solves my problem, But let me check it, give me a time..plz On Sat, Jan 2, 2010 at 7:24 PM, Jim Lyons jlyons4...@gmail.com wrote: Your table structure makes the SQL a little inelegant, but I'd say this would give you what you seem to want: select

Re: Render row without duplicates

the field are hospital1,hosptial2,hospital3, i know , i can display all hospital code with unique , but i dont in the single column , with unique record, Can you tell me how to do this ? Thanks -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Aborted_connects is incresing repidly

in PHP code and have tried below command mysqladmin flush-hosts but still the value is same. Thanks Jeetendra Ranjan -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Optimization suggestions

ready to learn, although I do not always like being taught The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?

:-) -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: error creating table

://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Is a view efficient in joins?

on a CentOS VPS for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http

Re: Rename Database - Why Would This Not Work?

To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Odd select question

or is my dotage coming upon me Thanks in advance, Bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Correct way to start new .MYD .MYI files

that will allow me to archive these files and Then start new ones so I can get my disk space back? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer

Re: Anyone using LVM for backing up?

To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Call a routine on mysqld startup

options in mysqld --help --verbose. Is there a way to achieve this, without modifying the startup script ? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons

Re: MAC address as primary key - BIGINT or CHAR(12)

a table: 1. MAC address defined as BIGINT 2. MAC address set as primary key Should I consider changing it to CHAR(12)? Replies will be appreciated. Ilia -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: MAC address as primary key - BIGINT or CHAR(12)

Wilson http://www.pwilson.net/ --- On Thu, 5/14/09, Jim Lyons jlyons4...@gmail.com wrote: From: Jim Lyons jlyons4...@gmail.com Subject: Re: MAC address as primary key - BIGINT or CHAR(12) To: Ilia KATZ ik...@dane-elec.co.il Cc: mysql@lists.mysql.com Date: Thursday, May 14, 2009, 11

Re: Help with mysql query, multiple list

). Clearly above query accepts only one item in the list. Is there a way to do this for multiple items in the list ??? I can't think of anything at this moment. Thanks, -Abhi -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Help with mysql query, multiple list

, 2009 at 11:45 AM, Abhishek Pratap abhishek@gmail.comwrote: Hi Jim Unfortunately I have thousands of such points. So explicit statement calling will be very expensive both computationally and in terms of writing.. Thanks, -Abhi On Fri, May 8, 2009 at 12:37 PM, Jim Lyons jlyons4

Re: grant user create privilege

' to database 'testdb' Can someone point out the error of my ways? Many thanks, jc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database

Re: Creation date

http://www.the-infoshop.com www.the-infoshop.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: How to generate unique primary key in MySQL?

NOT NULL, current_timestamp TIMESTAMP, primary key (id) ); I will not use auto_increment Is there other way to generate unique primary key in MySQL? Thank you -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

/ -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: mysqldump syntax - dumping only specific tables starting with a certain character. (e.g. z*)

://windowslive.msn.co.kr/wlm/messenger/ -- Jim Lyons Web developer / Database administrator http://www.weblyons.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Cant get TRIM to work?

archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: MySQL replication status plugin

, recommendations, and ideas are wholly welcome! --- Kind Regards, Mr Gabriel -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

how can i determine default database within a stored procedure?

of sp's and this is the last piece I have to figure out. Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: why is this happening?

No, there's only one mysqld process running. Thanks, tho. On Thu, Mar 19, 2009 at 3:56 PM, Claudio Nanni claudio.na...@gmail.comwrote: I am afraid you have two mysql instances up on the same host. ps -ef | grep mysql ? Claudio Jim Lyons wrote: I have a rather odd problem

why is this happening?

replication has broken? Thanks -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: how can I make a stored procedure executable by public?

-- Jim Lyons Web developer / Database administrator http://www.weblyons.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: how can I make a stored procedure executable by public?

great! thanks much. On Wed, Mar 18, 2009 at 1:52 PM, Claudio Nanni claudio.na...@gmail.comwrote: Ok sorry, I did not understand at first. GRANT INSERT on mydb.audit_table to ''@'%'; should do the work. Cheers Claudio Jim Lyons wrote: Thanks, Claudio, but that's not quite it. I'm

how can I make a stored procedure executable by public?

could put it in test, but then everyone could do anything with it, which would not be particularly desirable. The table should be insert only, not readable or updateable by anyone but the owner of mydb. Is there any way I can do this? Thanks, Jim -- Jim Lyons Web developer / Database

Question about LVM snapshots and innodb tables

resides. We use LVM snapshots to move the data around, since our databases are several terabytes. Does this mean our snapshots are inconsistent? There’s no way we can get all innodb data on a single partition. Thanks, Jim Lyons -- Jim Lyons Web developer / Database administrator http

Re: Finding replicated database

General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: vs AND

-- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: catch the error

and table, I get the same error message. -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: MySQL log in issues

): Access denied for user 'root'@'localhost' (using password: YES) Can someone give me a nudge/push/drag me kicking and screaming in the right direction? Thanks everyone :) -- Tim DeBoer -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: enabling storage engine with RPM install

storage engine myism and innodb. Just verify show engines on mysql prompt. On Fri, Feb 20, 2009 at 5:25 AM, Jim Lyons jlyons4...@gmail.com wrote: We have 5.0.22 installed on a test machine and for some reason the innodb storage engine was not enabled. We install from RPMs so I'm not sure

enabling storage engine with RPM install

mysql's been installed by an RPM? How does one make the selections in the first place with RPMs? We've always just taken what we got and it was sufficient. Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Resend: enabling storage engine with RPM install

with RPMs? We've always just taken what we got and it was sufficient. Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Resend: enabling storage engine with RPM install

On Thu, Feb 19, 2009 at 6:58 PM, Jim Lyons jlyons4...@gmail.com wrote: Sorry, but I'm resending because I made a mistake in terminology and want to be clear. The problem isn't that innodb is DISABLED on the database. The innodb engine is not supported by the database. We have 5.0.22

Re: Resend: enabling storage engine with RPM install

love it, if I could, though. On Thu, Feb 19, 2009 at 10:47 PM, chaim.rie...@gmail.com wrote: Perhaps you disabled it via my.cnf Sent via BlackBerry from T-Mobile -Original Message- From: Jim Lyons jlyons4...@gmail.com Date: Thu, 19 Feb 2009 22:45:01 To: MySQLmysql@lists.mysql.com

Re: Resend: enabling storage engine with RPM install

BlackBerry from T-Mobile -- *From*: Jim Lyons *Date*: Thu, 19 Feb 2009 23:06:33 -0600 *To*: chaim.rie...@gmail.com *Subject*: Re: Resend: enabling storage engine with RPM install How does one do that in my.cnf? It is possible to disable a supported engine

what is best upgrade plan for large, replicating database?

should not depend on the size of the database, should it (unless I have to rebuild some indexes)? Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

how can trace stored procedure usage?

. Is there a way to do that? Is there a better overall way to track procedure calls? What about function calls? Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: How do you backup HUGE tables?

solutions maybe: http://www.debianhelp.co.uk/mysqlscript.htm http://mysqlbackup.phpmagazine.net/ (seems dead, but maybe it just works so well, no need to improve it?) http://www.ozerov.de/bigdump.php -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: timeout

period. TIA mosaed -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Is deleting the .FRM, .MYD and .MYI files the same as dropping table?

accidentally dumped into several databases and then replicated. I'm wondering if I can just go through with a simple command to blow these all away: find /var/lib/mysql/ -name eventum* Or is there some other magic that a DROP TABLE eventum* does? -- Jim Lyons Web developer / Database

Re: UPDATE jujitsu?

...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: [PHP] Because you guys/gals/girls/women/insert pc term here are a smart lot

List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: How many users access MySQL

, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Partial Replication

To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Replication

really this unreliable? It breaks at the slightest hiccup... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Trying to Create a Trigger

-1519) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

why is information schema so slow?

? Is there something I can do to speed up queries to IS? I know these are views, are they so complicated that it takes forever to query them. This reduces their usefulness if true. Thanks -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Need Help

on the road is not the end of the Road..., Unless you forget to make the turn -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Using Replication in mySQL version 5

should be aware of before investigating this route and putting it into practice ? Thanks, Neil -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

com_* status variables seem to reset in mysql 5

. Is this a bug in mysql 5? Is something set incorrectly in my config file that would cause this (I can't find anything)? Thanks for any help. -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: mysql dump problems, no data dumped

] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40111 SET [EMAIL PROTECTED] */; -- Dump completed on 2008-10-27 13:50:53 Can anyone help me? I need to work out why no data is written, thanks Andy. -- Jim Lyons Web developer / Database administrator http

Re: Getting more info from show full processlist

pr1, pr2 FROM someDB. Thanks Matias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Most efficient way of handling a large dataset

: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: How to count # of character occurrences in a string?

://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: MySQL Sort by Array

help. Keith No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.2/1739 - Release Date: 10/22/2008 7:23 AM -- Jim Lyons Web developer / Database

Re: SQL select basics

of group function I also tried SELECT ID_number, count( CU_number ) AS CC FROM MyTable GROUP BY ID_number WHERE CC = max( CC ); But this also causes an error, anyone able to offer some pointers am I able to use sub queries ? Thanks Dave. -- Jim Lyons Web developer

Re: access denied error

] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: mysql binlogs and their expiry times

/etc/ ? If it matters, I use mysql-server-5.0.67 on FreeBSD 7.0-Release machine. Many thanks! -- Zbigniew Szalbot -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer

Re: Question of Relationship between tables

] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Foreign Keys

OR can it also speed up JOIN queries? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: mysql binlogs and their expiry times

or bounce the server. We use Purge Master periodically. i do this from cron mysql -e PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY) perhaps not that 'clean' but it does the trick -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Complex SELECT

To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Large Query Question.

) Bringing the Internet to Life ph: 905-836-4442 ext 104 fx: 905-895-6561 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: Large Query Question.

hardware recommendations that could help us improve the speed? Would more memory help us? Any comments or recommendations are greatly appreciated. Thanks much. Jim Leavitt Developer Treefrog Interactive Inc. (www.treefrog.ca) Bringing the Internet to Life -- Jim Lyons Web developer

question about the mysql prepare/execute commands

versus prepare/execute? And why prepare/execute in the mysql commandline program is so much slower than prepare/execute in Perl? Thanks. Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: question about the mysql prepare/execute commands

:41 PM, Jim Lyons [EMAIL PROTECTED] wrote: I have a question about the prepare/execute commands provided by mysql. I devised a benchmark, comparing updating a table using a statement-at-a-time versus using a prepare/execute pair. The table had a million rows. The statement-at-a-time

Re: Impossible WHERE in explain

noticed afte -- Krishna Chandra Prajapati -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

alter merge table doesn't work as documented (?)

-- -- alter table t_merge union=(t2, t3) -- ERROR 1146 (42S02) at line 16: Table 'jlyons.t1' doesn't exist Is this a bug or expected behavior? Thanks, Jim -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: alter merge table doesn't work as documented (?)

int); create table t_merge (x int) engine=merge union=(t1,t2,t3); drop table t1; drop table t_merge; create table t_merge (x int) engine=merge union=(t2,t3); -Original Message- From: Jim Lyons [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 4:41 PM To: mysql Subject

Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

properly.. but either OS version or HW is very old. We took new powerfull server, anc we want to migrate our data to new server... onlt this i want to do it. 2008/8/22 Jim Lyons [EMAIL PROTECTED] As I said, it appears your mysqldump output is not doing a DROP TABLE before each create

Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

correction, the command that's failing evidently is the 'create table columns_priv', not a drop table. Sorry for the typo. 2008/8/24 Jim Lyons [EMAIL PROTECTED] The command that's failing evidently is the drop table columns_priv which is why you're getting the error message: *ERROR 1050

Re: multiple mysql service on the same server

that using different port, but should i use two different my.cnf files, and also, what is the procedure to stop one mysql service and keep other one running. regards anandkl -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

is running on old server but mysql-client-5.0.51a is running now what can i do regards -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

migrating database from mysql-client-4.0.20 running server(current) to mysql-client-5.0.51a running server(new) ..i ve took mysqldump and transfered to new server and restored but process broken up with this error message. On Fri, Aug 22, 2008 at 6:33 PM, Jim Lyons [EMAIL PROTECTED] wrote

Re: Replication Error

-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem. -- Krishna Chandra Prajapati -- Jim Lyons Web developer / Database administrator http

Re: can some please help me -- REPLICATION

copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jim Lyons Web

Master-to-Master replication on same server

master needs to connect to on the 3307 master. In the change master to command I can only specify the port. I did specify it as 3307 but the slave still can't connect. Has anyone done this? -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Master-to-Master replication on same server

the 3306 master needs to connect to on the 3307 master. In the change master to command I can only specify the port. I did specify it as 3307 but the slave can't connect. Has anyone done this? -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

  1   2   >