Re: move database data folder

[Peter Kanas]

Thanks Scott - yes some privilege problems I am not surehow to resolve

2013-06-26 08:31:57 - Checked server status: Server is running.
2013-06-26 08:31:57 - Checked server status: Server is running.
2013-06-26 08:31:57 - Checked server status: Server is running.
2013-06-26 08:32:03 - Stopping server...
2013-06-26 08:32:06 - Stop server: Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql stop

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) utility, e.g. stop mysql
mysql stop/waiting

2013-06-26 08:32:07 - Checked server status: Server is stopped.
2013-06-26 08:32:07 - Server stop done.
2013-06-26 08:32:07 - Checked server status: Server is stopped.

FROM /var/log/mysql/error.log:
130626 8:32:03 [Note] /usr/sbin/mysqld: Normal shutdown
130626 8:32:03 [Note] Event Scheduler: Purging the queue. 0 events
130626 8:32:05 InnoDB: Starting shutdown...
130626 8:32:06 InnoDB: Shutdown completed; log sequence number 503574418
130626 8:32:06 [Note] /usr/sbin/mysqld: Shutdown complete
2013-06-26 08:36:45 - Checked server status: Server is stopped.
2013-06-26 08:36:45 - Starting server...
2013-06-26 08:36:51 - Start server: Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql start

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql
start: Job failed to start

2013-06-26 08:36:51 - Checked server status: Server is stopped.
2013-06-26 08:36:53 - Server start done.
2013-06-26 08:36:53 - Checked server status: Server is stopped.

FROM /var/log/mysql/error.log:
130626 8:36:46 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'plugin' is read only
130626 8:36:46 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130626 8:36:46 InnoDB: The InnoDB memory heap is disabled
130626 8:36:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130626 8:36:46 InnoDB: Compressed tables use zlib 1.2.3.4
130626 8:36:46 InnoDB: Initializing buffer pool, size = 128.0M
130626 8:36:46 InnoDB: Completed initialization of buffer pool
130626 8:36:46 InnoDB: highest supported file format is Barracuda.
130626 8:36:46 InnoDB: Waiting for the background threads to start
130626 8:36:47 InnoDB: 5.5.31 started; log sequence number 503574418
130626 8:36:47 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
130626 8:36:47 [Note] - '127.0.0.1' resolves to '127.0.0.1';
130626 8:36:47 [Note] Server socket created on IP: '127.0.0.1'.
130626 8:36:47 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'host' is read only
130626 8:36:47 [ERROR] /usr/sbin/mysqld: File '/var/run/mysqld/mysqld.pid' not found (Errcode: 13)
130626 8:36:47 [ERROR] /usr/sbin/mysqld: Error reading file 'UNKNOWN' (Errcode: 9)
130626 8:36:47 [ERROR] /usr/sbin/mysqld: Error on close of 'UNKNOWN' (Errcode: 9)
130626 8:36:48 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'plugin' is read only
130626 8:36:48 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130626 8:36:48 InnoDB: The InnoDB memory heap is disabled
130626 8:36:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130626 8:36:48 InnoDB: Compressed tables use zlib 1.2.3.4
130626 8:36:48 InnoDB: Initializing buffer pool, size = 128.0M
130626 8:36:48 InnoDB: Completed initialization of buffer pool
130626 8:36:48 InnoDB: highest supported file format is Barracuda.
130626 8:36:48 InnoDB: Waiting for the background threads to start
130626 8:36:49 InnoDB: 5.5.31 started; log sequence number 503574418
130626 8:36:49 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
130626 8:36:49 [Note] - '127.0.0.1' resolves to '127.0.0.1';
130626 8:36:49 [Note] Server socket created on IP: '127.0.0.1'.
130626 8:36:49 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'host' is read only
130626 8:36:49 [ERROR] /usr/sbin/mysqld: File '/var/run/mysqld/mysqld.pid' not found (Errcode: 13)
130626 8:36:49 [ERROR] /usr/sbin/mysqld: Error reading file 'UNKNOWN' (Errcode: 9)
130626 8:36:49 [ERROR] /usr/sbin/mysqld: Error on close of 'UNKNOWN' (Errcode: 9)
130626 8:36:50 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'plugin' is read only
130626 8:36:50 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130626 8:36:50 InnoDB: The InnoDB memory heap is disabled
130626 8:36:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130626 8:36:50 InnoDB: Compressed tables use zlib 1.2.3.4
130626 8:36:50 InnoDB: Initializing buffer pool, size = 128.0M
130626 8:36:50 InnoDB: Completed initialization of buffer pool
130626 8:36:50 InnoDB: highest supported file format is Barracuda.
130626 8:36:50 InnoDB: Waiting for the background threads to start
130626 8:36:51 InnoDB: 5.5.31 started; log sequence number 503574418
130626 8:36:51 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
130626 8:36:51 [Note] - '127.0.0.1' resolves to '127.0.0.1';
130626 8:36:51 [Note] Server socket created on IP: '127.0.0.1'.
130626 8:36:51 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'host' is read only
130626 8:36:51 [ERROR] /usr/sbin/mysqld: File '/var/run/mysqld/mysqld.pid' not found (Errcode: 13)
130626 8:36:51 [ERROR] /usr/sbin/mysqld: Error reading file 'UNKNOWN' (Errcode: 9)
130626 8:36:51 [ERROR] /usr/sbin/mysqld: Error on close of 'UNKNOWN' (Errcode: 9)