From: Reindl Harald Date: November 30 2011 1:03pm Subject: Re: help needed restoring crashed mysql List-Archive: http://lists.mysql.com/mysql/226401 Message-Id: <4ED629A5.1020004@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig7D61445CAA70705493A63E55" --------------enig7D61445CAA70705493A63E55 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Am 30.11.2011 07:02, schrieb Hal?sz S?ndor: >>>>> 2011/11/29 23:19 +0100, Reindl Harald >>>> > MY only luck is that i recognized this years ago after PLAYING > with innodb and so i started with "innodb_file_per_table=3D1" from > the begin with the first production database > <<<<<<<< > And are then the table-files in the directories with "....frm", or in t= he directory where "ibdata1" is? >=20 > If the latter, one problem is exchanged for another. they are in the db-folder but even if not it is a hughe differene if "optimize table tablename" free space on disk or not [root@mail:/mysql_data]$ ls insgesamt 3,0G drwx------ 2 mysql mysql 4,0K 2011-11-25 10:27 dbmail drwx------ 2 mysql mysql 4,0K 2011-11-20 17:46 mysql drwx------ 2 mysql mysql 4,0K 2011-11-20 17:46 performance_schema drwx------ 2 mysql mysql 4,0K 2011-11-30 04:00 syslog -rw-rw---- 1 mysql mysql 354M 2011-11-30 14:01 ibdata1 -rw-rw---- 1 mysql mysql 512M 2011-11-30 14:01 ib_logfile0 -rw-rw---- 1 mysql mysql 512M 2011-11-30 02:21 ib_logfile1 -rw-rw---- 1 mysql mysql 6 2011-11-20 17:46 mysql_upgrade_info -rw-rw---- 1 mysql mysql 1,1G 2011-11-29 15:21 bin.000137 -rw-rw---- 1 mysql mysql 617M 2011-11-30 14:01 bin.000138 -rw-rw---- 1 mysql mysql 72 2011-11-29 15:21 bin.index [root@mail:/mysql_data]$ ls dbmail/ insgesamt 9,5G -rw-rw---- 1 mysql mysql 8,5K 2011-09-18 08:18 cms1_config.frm -rw-rw---- 1 mysql mysql 8,7K 2011-09-18 08:18 cms1_global_cache.frm -rw-rw---- 1 mysql mysql 9,4K 2011-09-18 08:18 cms1_haupt.frm -rw-rw---- 1 mysql mysql 8,6K 2011-09-18 08:18 cms1_locks.frm -rw-rw---- 1 mysql mysql 9,8K 2011-09-18 08:18 cms1_meta.frm -rw-rw---- 1 mysql mysql 8,5K 2011-09-18 08:18 cms1_snippets.frm -rw-rw---- 1 mysql mysql 11K 2011-09-18 08:18 cms1_sub2.frm -rw-rw---- 1 mysql mysql 11K 2011-09-18 08:18 cms1_sub.frm -rw-rw---- 1 mysql mysql 8,5K 2011-09-18 08:18 cms1_user_group_permission= s.frm -rw-rw---- 1 mysql mysql 8,6K 2011-09-18 08:18 cms1_user_login.frm -rw-rw---- 1 mysql mysql 9,6K 2011-09-18 08:18 cms1_user_modules.frm -rw-rw---- 1 mysql mysql 8,5K 2011-09-14 09:32 cms1_user_online.frm -rw-rw---- 1 mysql mysql 9,3K 2011-09-18 08:18 cms1_users.frm -rw-rw---- 1 mysql mysql 8,4K 2011-09-18 08:18 dbma_aliases.frm -rw-rw---- 1 mysql mysql 8,4K 2011-09-18 08:18 dbma_aliases_global.frm -rw-rw---- 1 mysql mysql 8,4K 2011-09-18 08:18 dbma_allowed_hosts.frm -rw-rw---- 1 mysql mysql 8,5K 2011-09-18 08:18 dbma_client_admins.frm -rw-rw---- 1 mysql mysql 8,5K 2011-09-18 08:18 dbma_clients.frm -rw-rw---- 1 mysql mysql 8,8K 2011-10-22 20:18 dbmail_acl.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:18 dbmail_aliases.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:18 dbmail_auto_notifications.= frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:18 dbmail_auto_replies.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:18 dbmail_ccfield.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:18 dbmail_datefield.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:19 dbmail_envelope.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:19 dbmail_fromfield.frm -rw-rw---- 1 mysql mysql 8,4K 2011-10-22 20:19 dbmail_headername.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:19 dbmail_headervalue.frm -rw-rw---- 1 mysql mysql 8,9K 2011-10-22 20:20 dbmail_mailboxes.frm -rw-rw---- 1 mysql mysql 8,6K 2011-07-24 12:17 dbmail_messageblks.frm -rw-rw---- 1 mysql mysql 8,9K 2011-10-22 20:20 dbmail_messages.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:21 dbmail_pbsp.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:21 dbmail_physmessage.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:21 dbmail_referencesfield.frm= -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:21 dbmail_replycache.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:21 dbmail_replytofield.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:21 dbmail_sievescripts.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:21 dbmail_subjectfield.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:21 dbmail_subscription.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:21 dbmail_tofield.frm -rw-rw---- 1 mysql mysql 8,5K 2011-10-22 20:21 dbmail_usermap.frm -rw-rw---- 1 mysql mysql 8,9K 2011-10-22 20:21 dbmail_users.frm -rw-rw---- 1 mysql mysql 8,5K 2011-09-18 08:18 dbma_mta.frm -rw-rw---- 1 mysql mysql 8,5K 2011-09-18 08:18 dbma_recipient_relay.frm -rw-rw---- 1 mysql mysql 1,8K 2011-11-25 10:27 dbma_recipients.frm -rw-rw---- 1 mysql mysql 8,5K 2011-09-18 08:18 dbma_reply_groups.frm -rw-rw---- 1 mysql mysql 8,4K 2011-09-18 08:18 dbma_rewrite_domains.frm -rw-rw---- 1 mysql mysql 8,4K 2011-09-18 08:18 dbma_rewrite_senders.frm -rw-rw---- 1 mysql mysql 8,5K 2011-09-18 08:18 dbma_sender_relay.frm -rw-rw---- 1 mysql mysql 8,4K 2011-09-18 08:18 dbma_spamfilter.frm -rw-rw---- 1 mysql mysql 1,7K 2011-07-24 11:49 dbma_stats.frm -rw-rw---- 1 mysql mysql 8,5K 2011-08-27 22:39 dbma_transports_error.frm -rw-rw---- 1 mysql mysql 1,5K 2011-07-24 11:49 dbma_transports.frm -rw-rw---- 1 mysql mysql 8,4K 2011-07-24 11:49 #sql2-704-271.frm -rw-rw---- 1 mysql mysql 64K 2011-09-18 08:18 cms1_config.ibd -rw-rw---- 1 mysql mysql 64K 2011-11-30 04:01 cms1_global_cache.ibd -rw-rw---- 1 mysql mysql 64K 2011-09-18 08:18 cms1_haupt.ibd -rw-rw---- 1 mysql mysql 64K 2011-09-18 08:18 cms1_locks.ibd -rw-rw---- 1 mysql mysql 64K 2011-11-20 21:51 cms1_meta.ibd -rw-rw---- 1 mysql mysql 64K 2011-09-18 08:18 cms1_snippets.ibd -rw-rw---- 1 mysql mysql 64K 2011-09-18 08:18 cms1_sub2.ibd -rw-rw---- 1 mysql mysql 64K 2011-09-18 08:18 cms1_sub.ibd -rw-rw---- 1 mysql mysql 64K 2011-09-18 08:18 cms1_user_group_permission= s.ibd -rw-rw---- 1 mysql mysql 64K 2011-11-20 21:51 cms1_user_login.ibd -rw-rw---- 1 mysql mysql 64K 2011-09-18 08:18 cms1_user_modules.ibd -rw-rw---- 1 mysql mysql 64K 2011-11-20 21:51 cms1_users.ibd -rw-rw---- 1 mysql mysql 72K 2011-11-25 10:12 dbma_aliases_global.ibd -rw-rw---- 1 mysql mysql 64K 2011-09-18 08:18 dbma_aliases.ibd -rw-rw---- 1 mysql mysql 64K 2011-11-16 02:08 dbma_allowed_hosts.ibd -rw-rw---- 1 mysql mysql 64K 2011-09-18 08:18 dbma_client_admins.ibd -rw-rw---- 1 mysql mysql 64K 2011-11-21 15:28 dbma_clients.ibd -rw-rw---- 1 mysql mysql 64K 2011-10-22 20:19 dbmail_acl.ibd -rw-rw---- 1 mysql mysql 112K 2011-11-29 00:11 dbmail_aliases.ibd -rw-rw---- 1 mysql mysql 64K 2011-10-22 20:19 dbmail_auto_notifications.= ibd -rw-rw---- 1 mysql mysql 80K 2011-11-28 23:14 dbmail_auto_replies.ibd -rw-rw---- 1 mysql mysql 7,0M 2011-11-30 14:00 dbmail_ccfield.ibd -rw-rw---- 1 mysql mysql 9,0M 2011-11-30 14:00 dbmail_datefield.ibd -rw-rw---- 1 mysql mysql 29M 2011-11-30 14:00 dbmail_envelope.ibd -rw-rw---- 1 mysql mysql 14M 2011-11-30 14:00 dbmail_fromfield.ibd -rw-rw---- 1 mysql mysql 416K 2011-11-29 10:43 dbmail_headername.ibd -rw-rw---- 1 mysql mysql 332M 2011-11-30 14:00 dbmail_headervalue.ibd -rw-rw---- 1 mysql mysql 152K 2011-11-29 09:55 dbmail_mailboxes.ibd -rw-rw---- 1 mysql mysql 9,1G 2011-11-30 14:00 dbmail_messageblks.ibd -rw-rw---- 1 mysql mysql 21M 2011-11-30 14:01 dbmail_messages.ibd -rw-rw---- 1 mysql mysql 64K 2011-10-22 20:21 dbmail_pbsp.ibd -rw-rw---- 1 mysql mysql 7,0M 2011-11-30 14:00 dbmail_physmessage.ibd -rw-rw---- 1 mysql mysql 11M 2011-11-30 13:58 dbmail_referencesfield.ibd= -rw-rw---- 1 mysql mysql 64K 2011-11-30 02:25 dbmail_replycache.ibd -rw-rw---- 1 mysql mysql 6,0M 2011-11-30 14:00 dbmail_replytofield.ibd -rw-rw---- 1 mysql mysql 128K 2011-11-23 15:59 dbmail_sievescripts.ibd -rw-rw---- 1 mysql mysql 12M 2011-11-30 14:00 dbmail_subjectfield.ibd -rw-rw---- 1 mysql mysql 80K 2011-11-29 09:55 dbmail_subscription.ibd -rw-rw---- 1 mysql mysql 17M 2011-11-30 14:00 dbmail_tofield.ibd -rw-rw---- 1 mysql mysql 64K 2011-10-22 20:21 dbmail_usermap.ibd -rw-rw---- 1 mysql mysql 80K 2011-11-30 14:01 dbmail_users.ibd -rw-rw---- 1 mysql mysql 64K 2011-11-25 14:51 dbma_mta.ibd -rw-rw---- 1 mysql mysql 64K 2011-09-18 08:18 dbma_recipient_relay.ibd -rw-rw---- 1 mysql mysql 64K 2011-09-18 08:18 dbma_reply_groups.ibd -rw-rw---- 1 mysql mysql 64K 2011-09-18 08:18 dbma_rewrite_domains.ibd -rw-rw---- 1 mysql mysql 64K 2011-09-18 08:18 dbma_rewrite_senders.ibd -rw-rw---- 1 mysql mysql 64K 2011-10-31 10:15 dbma_sender_relay.ibd -rw-rw---- 1 mysql mysql 64K 2011-11-21 15:28 dbma_spamfilter.ibd -rw-rw---- 1 mysql mysql 160K 2011-11-25 10:55 dbma_transports_error.ibd -rw-rw---- 1 mysql mysql 44 2011-11-20 21:51 cms1_user_online.MYD -rw-rw---- 1 mysql mysql 5,0K 2011-11-20 22:44 cms1_user_online.MYI -rw-rw---- 1 mysql mysql 61 2011-07-24 11:49 db.opt --------------enig7D61445CAA70705493A63E55 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk7WKaUACgkQhmBjz394AnnemwCeISSB8Le8qFVwrjTBjQp/d8Rd S3wAn2+Zc/QFrKrO+J/n0hIs2ZwuUAmm =zQg6 -----END PGP SIGNATURE----- --------------enig7D61445CAA70705493A63E55--