MySQL Forums
Forum List  »  Quality Assurance

MySQL data files loss after server reboot
Posted by: Anuchapong Maknuan
Date: January 24, 2013 07:54AM

Hi Expert,

I have the question about the data files on MySQL loss after server had accident reboot.

After server up, I tried to bring up the mysql instance but it couldn't because the all data files loss. During startup,

I found the message
--- clip ---
Jan 5 03:30:38 PL_2_8 mysqld: mysqld: Table 'mysql.plugin' doesn't exist
Jan 5 03:30:38 PL_2_8 mysqld: 130105 3:30:38 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.  Is it safe to run this
Jan 5 03:30:38 PL_2_8 mysqld: 130105 3:30:38 [Note] NDB: NodeID is 10, management server '10.1.1.10:2372'
Jan 5 03:30:39 PL_2_8 mysqld: 130105 3:30:39 [Note] NDB[0]: NodeID: 10, all storage nodes connected
Jan 5 03:30:39 PL_2_8 mysqld: 130105 3:30:39 [Note] Starting Cluster Binlog Thread
Jan 5 03:30:39 PL_2_8 mysqld: 130105 3:30:39 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

--- clap ---

After I saw this message, I went to look inside the data files and found it missing.

root# du -sh mysqldMaster/*
4.0M mysqldMaster/binlogs
4.0K mysqldMaster/data
4.0K mysqldMaster/tmp

root# pwd
/local/cudb/mysql/mysqldMaster/data
root# ls -al
total 8
drwxr-xr-x 2 mysql root 4096 Jan 5 03:35 .
drwxr-xr-x 5 mysql root 4096 Jan 5 03:35 ..
--- clap ---


Any one has experience similar this and any cause of this data file loss?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL data files loss after server reboot
3127
January 24, 2013 07:54AM


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.