MySQL Forums
Forum List  »  InnoDB

Re: move database data folder
Posted by: Peter Kanas
Date: July 01, 2013 06:26PM

there still appears to be a problem with mysql.plugin table after changing the permissions as indicated below. The log file indicates I should run "mysql_update" to fix this. Is this needed and if so where is this script/program?

I am still getting the same error messages when I try to restart the server.
Error connecting to MySQL: Can't connect to MySQL server on '127.0.0.1' (111)
MySQL stat graphs may be disabled.

=================================================================
2013-07-01 16:50:25 - Checked server status: Server is stopped.
2013-07-01 16:50:25 - Checked server status: Server is stopped.
2013-07-01 16:50:25 - Checked server status: Server is stopped.
2013-07-01 16:50:30 - Checked server status: Server is stopped.
2013-07-01 16:50:30 - Starting server...
2013-07-01 16:50:35 - 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-07-01 16:50:35 - Checked server status: Server is stopped.
2013-07-01 16:51:24 - Server start done.
2013-07-01 16:51:24 - Checked server status: Server is stopped.

FROM /var/log/mysql/error.log:
130701 16:50:30 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'plugin' is read only
130701 16:50:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130701 16:50:30 InnoDB: The InnoDB memory heap is disabled
130701 16:50:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130701 16:50:30 InnoDB: Compressed tables use zlib 1.2.3.4
130701 16:50:30 InnoDB: Initializing buffer pool, size = 128.0M
130701 16:50:30 InnoDB: Completed initialization of buffer pool
130701 16:50:30 InnoDB: highest supported file format is Barracuda.
130701 16:50:30 InnoDB: Waiting for the background threads to start
130701 16:50:31 InnoDB: 5.5.31 started; log sequence number 503574418
130701 16:50:31 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
130701 16:50:31 [Note] - '127.0.0.1' resolves to '127.0.0.1';
130701 16:50:31 [Note] Server socket created on IP: '127.0.0.1'.
130701 16:50:31 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'host' is read only
130701 16:50:31 [ERROR] /usr/sbin/mysqld: File '/var/run/mysqld/mysqld.pid' not found (Errcode: 13)
130701 16:50:31 [ERROR] /usr/sbin/mysqld: Error reading file 'UNKNOWN' (Errcode: 9)
130701 16:50:31 [ERROR] /usr/sbin/mysqld: Error on close of 'UNKNOWN' (Errcode: 9)
130701 16:50:32 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'plugin' is read only
130701 16:50:32 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130701 16:50:32 InnoDB: The InnoDB memory heap is disabled
130701 16:50:32 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130701 16:50:32 InnoDB: Compressed tables use zlib 1.2.3.4
130701 16:50:32 InnoDB: Initializing buffer pool, size = 128.0M
130701 16:50:32 InnoDB: Completed initialization of buffer pool
130701 16:50:32 InnoDB: highest supported file format is Barracuda.
130701 16:50:32 InnoDB: Waiting for the background threads to start
130701 16:50:33 InnoDB: 5.5.31 started; log sequence number 503574418
130701 16:50:33 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
130701 16:50:33 [Note] - '127.0.0.1' resolves to '127.0.0.1';
130701 16:50:33 [Note] Server socket created on IP: '127.0.0.1'.
130701 16:50:33 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'host' is read only
130701 16:50:33 [ERROR] /usr/sbin/mysqld: File '/var/run/mysqld/mysqld.pid' not found (Errcode: 13)
130701 16:50:33 [ERROR] /usr/sbin/mysqld: Error reading file 'UNKNOWN' (Errcode: 9)
130701 16:50:33 [ERROR] /usr/sbin/mysqld: Error on close of 'UNKNOWN' (Errcode: 9)
130701 16:50:34 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'plugin' is read only
130701 16:50:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130701 16:50:34 InnoDB: The InnoDB memory heap is disabled
130701 16:50:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130701 16:50:34 InnoDB: Compressed tables use zlib 1.2.3.4
130701 16:50:34 InnoDB: Initializing buffer pool, size = 128.0M
130701 16:50:34 InnoDB: Completed initialization of buffer pool
130701 16:50:34 InnoDB: highest supported file format is Barracuda.
130701 16:50:34 InnoDB: Waiting for the background threads to start
130701 16:50:35 InnoDB: 5.5.31 started; log sequence number 503574418
130701 16:50:35 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
130701 16:50:35 [Note] - '127.0.0.1' resolves to '127.0.0.1';
130701 16:50:35 [Note] Server socket created on IP: '127.0.0.1'.
130701 16:50:35 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'host' is read only
130701 16:50:35 [ERROR] /usr/sbin/mysqld: File '/var/run/mysqld/mysqld.pid' not found (Errcode: 13)
130701 16:50:35 [ERROR] /usr/sbin/mysqld: Error reading file 'UNKNOWN' (Errcode: 9)
130701 16:50:35 [ERROR] /usr/sbin/mysqld: Error on close of 'UNKNOWN' (Errcode: 9)
=========================================================================
pete@flashDB:/media/MySQL_Raid0$ sudo ls -la /media/MySQL_Raid0/
total 32
drwx------ 5 pete mysql 4096 Jul 1 16:44 .
drwxr-xr-x 7 root root 4096 Jul 1 16:17 ..
drwx------ 2 pete mysql 16384 Jun 24 14:36 lost+found
drwxrw-rw- 6 mysql mysql 4096 Jul 1 16:50 mysql
drwx------ 4 pete mysql 4096 Jun 24 17:10 .Trash-1000
pete@flashDB:/media/MySQL_Raid0$ sudo ls -la /media/MySQL_Raid0/mysql
total 217116
drwxrw-rw- 6 mysql mysql 4096 Jul 1 16:50 .
drwx------ 5 pete mysql 4096 Jul 1 16:44 ..
-rw-r--r-- 1 root root 0 Jun 20 03:48 debian-5.5.flag
drwx------ 2 mysql mysql 4096 Jun 21 01:39 flash
-rw-rw---- 1 mysql mysql 211812352 Jul 1 16:24 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Jul 1 16:50 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Jun 21 03:45 ib_logfile1
drwx------ 2 mysql root 4096 Jun 20 03:49 mysql
-rw-rw---- 1 root root 6 Jun 20 03:49 mysql_upgrade_info
drwx------ 2 mysql mysql 4096 Jun 20 03:49 performance_schema
drwx------ 2 mysql root 4096 Jun 20 03:48 test
pete@flashDB:/media/MySQL_Raid0$ sudo ls -la /media/MySQL_Raid0/mysql/mysql
total 1040
drwx------ 2 mysql root 4096 Jun 20 03:49 .
drwxrw-rw- 6 mysql mysql 4096 Jul 1 16:50 ..
-rw-rw---- 1 mysql mysql 8820 Jun 20 03:49 columns_priv.frm
-rw-rw---- 1 mysql mysql 0 Jun 20 03:49 columns_priv.MYD
-rw-rw---- 1 mysql mysql 4096 Jun 20 03:49 columns_priv.MYI
-rw-rw---- 1 mysql mysql 9582 Jun 20 03:49 db.frm
-rw-rw---- 1 mysql mysql 880 Jun 20 03:49 db.MYD
-rw-rw---- 1 mysql mysql 5120 Jun 20 03:49 db.MYI
-rw-rw---- 1 mysql mysql 10223 Jun 20 03:49 event.frm
-rw-rw---- 1 mysql mysql 0 Jun 20 03:49 event.MYD
-rw-rw---- 1 mysql mysql 2048 Jun 20 03:49 event.MYI
-rw-rw---- 1 mysql mysql 8665 Jun 20 03:49 func.frm
-rw-rw---- 1 mysql mysql 0 Jun 20 03:49 func.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 20 03:49 func.MYI
-rw-rw---- 1 mysql mysql 35 Jul 1 16:24 general_log.CSM
-rw-rw---- 1 mysql mysql 0 Jun 20 03:49 general_log.CSV
-rw-rw---- 1 mysql mysql 8776 Jun 20 03:49 general_log.frm
-rw-rw---- 1 mysql mysql 8700 Jun 20 03:48 help_category.frm
-rw-rw---- 1 mysql mysql 23240 Jun 20 03:49 help_category.MYD
-rw-rw---- 1 mysql mysql 3072 Jun 20 03:49 help_category.MYI
-rw-rw---- 1 mysql mysql 8612 Jun 20 03:48 help_keyword.frm
-rw-rw---- 1 mysql mysql 91999 Jun 20 03:49 help_keyword.MYD
-rw-rw---- 1 mysql mysql 17408 Jun 20 03:49 help_keyword.MYI
-rw-rw---- 1 mysql mysql 8630 Jun 20 03:48 help_relation.frm
-rw-rw---- 1 mysql mysql 9432 Jun 20 03:49 help_relation.MYD
-rw-rw---- 1 mysql mysql 18432 Jun 20 03:49 help_relation.MYI
-rw-rw---- 1 mysql mysql 8770 Jun 20 03:48 help_topic.frm
-rw-rw---- 1 mysql mysql 458748 Jun 20 03:49 help_topic.MYD
-rw-rw---- 1 mysql mysql 20480 Jun 20 03:49 help_topic.MYI
-rw-rw---- 1 mysql mysql 9510 Jun 20 03:49 host.frm
-rw-rw---- 1 mysql mysql 0 Jun 20 03:49 host.MYD
-rw-rw---- 1 mysql mysql 2048 Jun 20 03:49 host.MYI
-rw-rw---- 1 mysql mysql 8778 Jun 20 03:49 ndb_binlog_index.frm
-rw-rw---- 1 mysql mysql 0 Jun 20 03:49 ndb_binlog_index.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 20 03:49 ndb_binlog_index.MYI
-rw-rw---- 1 mysql mysql 8586 Jun 20 03:49 plugin.frm
-rw-rw---- 1 mysql mysql 0 Jun 20 03:49 plugin.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 20 03:49 plugin.MYI
-rw-rw---- 1 mysql mysql 9996 Jun 20 03:49 proc.frm
-rw-rw---- 1 mysql mysql 320 Jun 20 03:49 proc.MYD
-rw-rw---- 1 mysql mysql 4096 Jun 20 06:44 proc.MYI
-rw-rw---- 1 mysql mysql 8875 Jun 20 03:49 procs_priv.frm
-rw-rw---- 1 mysql mysql 0 Jun 20 03:49 procs_priv.MYD
-rw-rw---- 1 mysql mysql 4096 Jun 20 03:49 procs_priv.MYI
-rw-rw---- 1 mysql mysql 8800 Jun 20 03:49 proxies_priv.frm
-rw-rw---- 1 mysql mysql 1386 Jun 20 03:49 proxies_priv.MYD
-rw-rw---- 1 mysql mysql 5120 Jun 20 03:49 proxies_priv.MYI
-rw-rw---- 1 mysql mysql 8838 Jun 20 03:48 servers.frm
-rw-rw---- 1 mysql mysql 0 Jun 20 03:48 servers.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 20 03:48 servers.MYI
-rw-rw---- 1 mysql mysql 35 Jul 1 16:24 slow_log.CSM
-rw-rw---- 1 mysql mysql 0 Jun 20 03:49 slow_log.CSV
-rw-rw---- 1 mysql mysql 8976 Jun 20 03:49 slow_log.frm
-rw-rw---- 1 mysql mysql 8955 Jun 20 03:49 tables_priv.frm
-rw-rw---- 1 mysql mysql 0 Jun 20 03:49 tables_priv.MYD
-rw-rw---- 1 mysql mysql 4096 Jun 20 03:49 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8636 Jun 20 03:48 time_zone.frm
-rw-rw---- 1 mysql mysql 8624 Jun 20 03:48 time_zone_leap_second.frm
-rw-rw---- 1 mysql mysql 0 Jun 20 03:48 time_zone_leap_second.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 20 03:48 time_zone_leap_second.MYI
-rw-rw---- 1 mysql mysql 0 Jun 20 03:48 time_zone.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 20 03:48 time_zone.MYI
-rw-rw---- 1 mysql mysql 8606 Jun 20 03:48 time_zone_name.frm
-rw-rw---- 1 mysql mysql 0 Jun 20 03:48 time_zone_name.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 20 03:48 time_zone_name.MYI
-rw-rw---- 1 mysql mysql 8686 Jun 20 03:48 time_zone_transition.frm
-rw-rw---- 1 mysql mysql 0 Jun 20 03:48 time_zone_transition.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 20 03:48 time_zone_transition.MYI
-rw-rw---- 1 mysql mysql 8748 Jun 20 03:48 time_zone_transition_type.frm
-rw-rw---- 1 mysql mysql 0 Jun 20 03:48 time_zone_transition_type.MYD
-rw-rw---- 1 mysql mysql 1024 Jun 20 03:48 time_zone_transition_type.MYI
-rw-rw---- 1 mysql mysql 10630 Jun 20 03:49 user.frm
-rw-rw---- 1 mysql mysql 580 Jun 20 03:49 user.MYD
-rw-rw---- 1 mysql mysql 2048 Jun 20 03:49 user.MYI

Options: ReplyQuote


Subject
Views
Written By
Posted
3657
June 25, 2013 01:39PM
1333
June 25, 2013 03:38PM
4882
June 26, 2013 09:55AM
2162
June 26, 2013 10:04AM
2192
June 26, 2013 10:58AM
1645
June 26, 2013 01:34PM
Re: move database data folder
2076
July 01, 2013 06:26PM
1566
July 01, 2013 06:56PM
2242
July 08, 2013 02:56PM
1936
July 10, 2013 12:04PM
1762
July 10, 2013 10:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.