Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

mysqld_safe

Status
Not open for further replies.

shaylor

Programmer
Feb 21, 2006
1
US
I did something to my MySQL server. It's fallen and can't get up. Allow me to explain...

I tried setting up replication between a v3.23 master and a v5.1 slave using the instructions posted here (for the master) and here (for the slave). I made one mistake (that I know of): I turned the slave back on and started the slave thread before I'd expanded the snapshot of the database I was trying to replicate. I didn't get any command-line errors and when I realized what I did, I shut the server down and expanded the tar just like the instructions said.

My problem now is that when I try to start the slave server back up with this command:

Code:
/usr/bin/mysqld_safe --user=mysql --log --skip-slave-start &

I get this error:

Code:
[1] 11902
[adam@surrey ~]$ Starting mysqld daemon with databases from /var/lib/mysql
/usr/bin/mysqld_safe: line 332: /var/lib/mysql/surrey.err: Permission denied
/usr/bin/mysqld_safe: line 340: /var/lib/mysql/surrey.err: Permission denied
STOPPING server from pid file /var/lib/mysql/surrey.pid
tee: /var/lib/mysql/surrey.err: Permission denied
060221 17:22:29  mysqld ended
tee: /var/lib/mysql/surrey.err: Permission denied

To be honest, I'm not even sure if I'd been using mysqld_safe --user=mysql to start the server, so I'm not even 100% sure I'm using the right command and arguments. I'm a little new to Linux and I've only had occasion to start the server manually a couple times... ever.

Any ideas? Suggestions?
 
Status
Not open for further replies.

Similar threads

Part and Inventory Search

Sponsor

Back
Top