Hi All,
I shutdown my master, took a db files backup. Copied it over to slave
machine.
I executed change master command, then when i start slave slave start, i
get the below error. I did reset slave, but still getting same error, what
could be the reason, and how to fix it.
080522 23:04:05
check permissions
On Fri, May 23, 2008 at 12:33 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I shutdown my master, took a db files backup. Copied it over to slave
machine.
I executed change master command, then when i start slave slave start,
i
get the below error. I did reset slave,
Hi Krishna,
As i said, this is a complete copy from master db to slave.
I have deleted all old files from slave and setting up from scratch, by
taking a complete backup from master, copying over to slave and using the
change master command with BIN LOG and POSITION taken before taking a backup
I don't think you need to flush your bin logs.
CHANGE MASTER TO MASTER HOST = 'hostname';
Look at this for more info at
http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html
There is a lot more you can add to the statement.
thanks but this gave me a very similar error - I
Under 5.0.41 I have having problems of CPU sitting at exactly 100% load
on a single CPU for very long periods of time, like 10 hours.
I traced this command:
mysql SHOW MUTEX STATUS;
Which returned 1281006 lines, ending with:
+-+--+--+
| File| Line | OS_waits |
Please check the ownership of the files copied on the slave.
Give permissions by chown -R mysql:mysql
On Fri, May 23, 2008 at 2:47 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Krishna,
As i said, this is a complete copy from master db to slave.
I have deleted all old files from slave and
Files is owned by mysql, but the point is, these relay-log files are not
present.
Before setting up the slave, i cleaned up all files.
regards
anandkl
On 5/23/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:
Please check the ownership of the files copied on the slave.
Give permissions
On Fri, May 23, 2008 at 8:13 AM, Ananda Kumar [EMAIL PROTECTED] wrote:
Files is owned by mysql, but the point is, these relay-log files are not
present.
Before setting up the slave, i cleaned up all files.
If you want the logs back you could use RESET MASTER maybe.
RESET MASTER...delete all the bin logs. Infact i tried this on the slave as
it also a MASTER to itself, but the error kept on coming.
regards
anandkl
On 5/23/08, Mike [EMAIL PROTECTED] wrote:
On Fri, May 23, 2008 at 8:13 AM, Ananda Kumar [EMAIL PROTECTED] wrote:
Files is owned by mysql,
Ok, since you do not have the bin log you need to start over again with the
replication and do either a
mysqldump or get the rawdata. then once you have the data then you can
start replication again.
http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-backups-mysqldump.html
Hi,
I'm running a query :
SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot';
But if there aren't any rows in radacct for the UserName of
hotspot, it returns a NULL. Is there a way to change it to return 0
instead? (I can't change the application, but I can change
I have a table that has two has two secondary keys referencing the same primary
key of another.
Table-name =Circuits
circuitID
CircuitID
A_loc
Z_loc
Table-name = Location
locationID
location
circuits.A_locreferenceslocatioin.locationID
On Fri, May 23, 2008 at 8:23 AM, Tuc at T-B-O-H.NET [EMAIL PROTECTED] wrote:
Hi,
I'm running a query :
SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot';
But if there aren't any rows in radacct for the UserName of
hotspot, it returns a NULL. Is there a way to
On Fri, May 23, 2008 at 11:27 AM, [EMAIL PROTECTED] wrote:
I have a table that has two has two secondary keys referencing the same
primary key of another.
Table-name =Circuits
circuitID
CircuitID
A_loc
Z_loc
Table-name = Location
locationID
location
On Fri, May 23, 2008 at 8:23 AM, Tuc at T-B-O-H.NET [EMAIL PROTECTED] wrote:
Hi,
I'm running a query :
SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot';
But if there aren't any rows in radacct for the UserName of
hotspot, it returns a NULL. Is
Thanks for the quick reply, however i am getting a failure on line 2.
SELECT
11.POPS AS `POPA`,
12.POPS AS `POPZ`
FROM
circuits
INNER JOIN pops.POPS as 11 WHERE circuits.popA = 11.popID
INNER JOIN pops.POPS as 12 WHERE circuits.popZ = 12.popID
Table-name = circuits
circuitID
popA (secondary
Hi Mike,
Since i have done a fresh backup from master (with master db down), and
copied over the same to slave. Then why is the slaving looking for old
relay-log. I also did the RESET SLAVE, bit still getting error.
I am wondering, why is the slave looking for old relay-logs
On 5/23/08, Mike
On Fri, May 23, 2008 at 12:04 PM, [EMAIL PROTECTED] wrote:
Thanks for the quick reply, however i am getting a failure on line 2.
SELECT
11.POPS AS `POPA`,
12.POPS AS `POPZ`
FROM
circuits
INNER JOIN pops.POPS as 11 WHERE circuits.popA = 11.popID
INNER JOIN pops.POPS as 12 WHERE
On Fri, May 23, 2008 at 12:08 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Mike,
Since i have done a fresh backup from master (with master db down), and
copied over the same to slave. Then why is the slaving looking for old
relay-log. I also did the RESET SLAVE, bit still getting error.
I
Still getting and error on the last line
SELECT
p1.POPS AS `POPA`,
p2.POPS AS `POPZ`
FROM
circuits
INNER JOIN pops.POPS as p1 WHERE circuits.popID_A =p1.popID
INNER JOIN pops.POPS as p2 WHERE circuits.pop_ID_Z =p2.popID
Table-name = circuits
circuitID
popID_A (secondary key referencing
On Fri, May 23, 2008 at 1:47 PM, [EMAIL PROTECTED] wrote:
Still getting and error on the last line
SELECT
p1.POPS AS `POPA`,
p2.POPS AS `POPZ`
FROM
circuits
INNER JOIN pops.POPS as p1 WHERE circuits.popID_A =p1.popID
INNER JOIN pops.POPS as p2 WHERE circuits.pop_ID_Z =p2.popID
I
- Original Message -
From: Rob Wultsch [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: MYSQL General List mysql@lists.mysql.com
Sent: Friday, May 23, 2008 11:10:56 AM GMT -08:00 US/Canada Pacific
Subject: Re: Query Output Issue
On Fri, May 23, 2008 at 1:47 PM, [EMAIL PROTECTED] wrote:
22 matches
Mail list logo