Hi Guys,
Ahem...er, I've dropped a clanger! I tried to move my
datadirectory to another device with more room. And yes, I know NOW that I
should have created symbolic links for the databases in question
but...well, the rest is history...
*********************
First Tech info: Red Hat Linux v7.0, Intel.
Latest version of MySQL = 3.23.39
6049585 Jul 11 10:29 MySQL-3.23.39-1.i386.rpm
698022 Jul 11 13:31 MySQL-bench-3.23.39-1.i386.rpm
1772486 Jul 11 11:08 MySQL-client-3.23.39-1.i386.rpm
232649 Jul 11 11:03 MySQL-shared-3.23.39-1.i386.rpm
So:
1. Shutdown server.
2. Copied datadir (/var/lib/mysql) to new directory in its entirity (/x/mysql).
3. Edited startup script (/etc/init.d/mysql) and changed the entry
"datadir=/var/lib/mysql" to "datadir=/x/mysql"
4. Restarted server - server came up OK but I couldn't connect to it.
5. Shutdown server.
6. Edited startup script back as normal (/var/lib/mysql)
7. COULD NOT RESTART SERVER (see my error log below).
It seems that there is a file called mysql.sock which is causing the problems.
Any ideas anyone?
**** datadirectory
(/var/lib/mysql) = drwxr-xr-x 6 root root 1024 Jul 31 09:23
mysql
**** extract from /etc/init.d/mysql
# Set some defaults
datadir=/var/lib/mysql
basedir=
pid_file=
*** extract from my error log (the first bit must be when I shut down and
there was idle users connected).
010725 15:08:56 Aborted connection 311 to db: 'norasia' user: 'adminit'
host: `localhost' (Got an e
rror reading communication packets)
010731 8:52:14 Aborted connection 555 to db: 'unconnected' user: 'root'
host: `localhost' (Got an
error writing communication packets)
010731 8:52:14 /usr/sbin/mysqld: Normal shutdown
010731 8:52:14 /usr/sbin/mysqld: Shutdown Complete
010731 08:52:14 mysqld ended
010731 08:59:06 mysqld started
010731 8:59:06 /usr/sbin/mysqld: Can't create/write to file
'/x/mysql/mail.dcaliner.co.uk.pid' (Er
rcode: 13)
/usr/sbin/mysqld: ready for connections
010731 09:07:12 mysqld ended
010731 09:16:51 mysqld started
010731 9:16:51 Can't start server : Bind on unix socket: Permission denied
010731 9:16:51 Do you already have another mysqld server running on
socket: /var/lib/mysql/mysql.s
ock ?
010731 9:16:51 Aborting
010731 9:16:51 /usr/sbin/mysqld: Shutdown Complete
010731 09:16:51 mysqld ended
010731 09:19:04 mysqld started
010731 9:19:04 Can't start server : Bind on unix socket: Permission denied
010731 9:19:04 Do you already have another mysqld server running on
socket: /var/lib/mysql/mysql.s
ock ?
010731 9:19:04 Aborting
010731 9:19:04 /usr/sbin/mysqld: Shutdown Complete
010731 09:19:04 mysqld ended
Neil Barnes, Systems Manager
DCA Liner Limited
4 Pennine Way,
Saltley Business Park,
Saltley,
Birmingham B8 1JW
T: +44 121 325 7527
F: +44 121 328 2552
E: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
