Changes between Version 1 and Version 2 of howto/MysqlRepair

Timestamp:

12/10/10 13:09:02 (13 years ago)

Author:

Edwin Eefting

Comment:

--

howto/MysqlRepair

@@ -56 +56 @@
 }}}
 
+ * Nu kunt u de database dumpen zonder dat de mysql server crashed met een error. Indien de server nog steeds crashed, stel dan een hogere innodb_force_recovery in. (Zie instructies op mysql website)
+
+{{{
+# mysqldump zarafa -p`cat /etc/my.passwd ` > zarafa.sql
+# less /home/system/mysql5/darkstar.err
+}}}
+
+ * Zet de database uit en verplaats de innodb data files. '''Zorg dat u zeker weet dat er geen andere InnoDB databases zjin dan Zarafa'''
+{{{
+# svc -d /sevice/mysql
+# cd /home/system/mysql5
+# mkdir ../old
+# mv ib* ../old
+# mv zarafa ../old
+}}}
+
+ * Zet de recovery optie weer uit, start de database weer op, maak de zarafa database opnieuw aan en herimporteer de data
+{{{
+# mcedit /etc/my.cnf
+# svc -u /sevice/mysql
+# mysqladmin create zarafa -p`cat /etc/my.passwd `
+# less /home/system/mysql5/darkstar.err
+InnoDB: The first specified data file ./ibdata1 did not exist:
+InnoDB: a new database to be created!
+101210 12:47:20  InnoDB: Setting file ./ibdata1 size to 10 MB
+InnoDB: Database physically writes the file full: wait...
+101210 12:47:20  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
+InnoDB: Setting log file ./ib_logfile0 size to 5 MB
+InnoDB: Database physically writes the file full: wait...
+101210 12:47:20  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
+InnoDB: Setting log file ./ib_logfile1 size to 5 MB
+InnoDB: Database physically writes the file full: wait...
+InnoDB: Doublewrite buffer not found: creating new
+InnoDB: Doublewrite buffer created
+InnoDB: Creating foreign key constraint system tables
+InnoDB: Foreign key constraint system tables created
+101210 12:47:21  InnoDB: Started; log sequence number 0 0
+# cd /home
+# mysql -p`cat /etc/my.passwd ` zarafa <zarafa.sql
+}}}
+
+ * Nu is uw database weer normaal bruikbaar. Start zarafa op en controleer het resultaat.
 
 
+
+
+
+