List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:November 30 2011 1:03pm
Subject:Re: help needed restoring crashed mysql
View as plain text  

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=1" from
> the begin with the first production database
> <<<<<<<<
> And are then the table-files in the directories with "....frm", or in the directory
> where "ibdata1" is?
> 
> 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_permissions.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_permissions.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


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
help needed restoring crashed mysqlLuis Pugoy29 Nov
  • Re: help needed restoring crashed mysqlReindl Harald29 Nov
    • Re: help needed restoring crashed mysqlKaren Abgarian29 Nov
      • Re: help needed restoring crashed mysqlClaudio Nanni29 Nov
      • Re: help needed restoring crashed mysqlReindl Harald29 Nov
        • Re: help needed restoring crashed mysqlKaren Abgarian30 Nov
          • Re: help needed restoring crashed mysqlReindl Harald30 Nov
            • Re: help needed restoring crashed mysqlKaren Abgarian30 Nov
              • [MySQL] innodb_file_per_table / apple workers and logicReindl Harald30 Nov
                • Re: [MySQL] innodb_file_per_table / apple workers and logicJohan De Meersman30 Nov
                • Re: [MySQL] innodb_file_per_table / apple workers and logicKaren Abgarian30 Nov
                  • Re: [MySQL] innodb_file_per_table / apple workers and logicReindl Harald30 Nov
                    • Re: [MySQL] innodb_file_per_table / apple workers and logicMySQL)1 Dec
                      • Re: [MySQL] innodb_file_per_table / apple workers and logicKaren Abgarian1 Dec
              • Re: help needed restoring crashed mysqlReindl Harald30 Nov
        • Re: help needed restoring crashed mysqlhsv30 Nov
          • Re: help needed restoring crashed mysqlReindl Harald30 Nov
Re: help needed restoring crashed mysqlKaren Abgarian30 Nov