CURRENT_TEST: main.alias
100420 20:11:52 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead.
100420 20:11:52 [Note] Plugin 'FEDERATED' is disabled.
100420 20:11:52 [Note] Plugin 'ndbcluster' is disabled.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100420 20:11:52  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100420 20:11:52  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...
100420 20:11:53  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
100420 20:11:54  InnoDB: Started; log sequence number 0 0
100420 20:11:54 [Note] Event Scheduler: Loaded 0 events
100420 20:11:54 [Note] /export/home2/tmp/mysql-5.1-ihb/sql/mysqld: ready for connections.
Version: '5.1.46-debug-log'  socket: '/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/tmp/mysqld.1.sock'  port: 13000  Source distribution
100420 20:12:35 [ERROR] Cannot find or open table db1/t1 from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
how you can resolve the problem.


==========================================================================
The data dir contents after mysql shutdown

 ls -laR `pwd`
/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data:
total 20540
drwxr-xr-x 5 hs221732 wheel     4096 Apr 20 19:25 .
drwxr-xr-x 3 hs221732 wheel     4096 Apr 20 19:25 ..
-rw-rw---- 1 hs221732 wheel 10485760 Apr 20 19:25 ibdata1
-rw-rw---- 1 hs221732 wheel  5242880 Apr 20 19:25 ib_logfile0
-rw-rw---- 1 hs221732 wheel  5242880 Apr 20 19:25 ib_logfile1
drwxr-xr-x 2 hs221732 wheel     4096 Apr 20 19:25 mtr
drwxr-xr-x 2 hs221732 wheel     4096 Apr 20 19:25 mysql
drwxr-xr-x 2 hs221732 wheel     4096 Apr 20 19:25 test

/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/mtr:
total 68
drwxr-xr-x 2 hs221732 wheel 4096 Apr 20 19:25 .
drwxr-xr-x 5 hs221732 wheel 4096 Apr 20 19:25 ..
-rw-r--r-- 1 hs221732 wheel   65 Apr 20 19:25 db.opt
-rw-r--r-- 1 hs221732 wheel 8566 Apr 20 19:25 global_suppressions.frm
-rw-r--r-- 1 hs221732 wheel 4440 Apr 20 19:25 global_suppressions.MYD
-rw-r--r-- 1 hs221732 wheel 1024 Apr 20 19:25 global_suppressions.MYI
-rw-r--r-- 1 hs221732 wheel  336 Apr 20 19:25 global_suppressions.TRG
-rw-r--r-- 1 hs221732 wheel   51 Apr 20 19:25 gs_insert.TRN
-rw-r--r-- 1 hs221732 wheel 8566 Apr 20 19:25 test_suppressions.frm
-rw-r--r-- 1 hs221732 wheel    0 Apr 20 19:25 test_suppressions.MYD
-rw-r--r-- 1 hs221732 wheel 1024 Apr 20 19:25 test_suppressions.MYI
-rw-r--r-- 1 hs221732 wheel  334 Apr 20 19:25 test_suppressions.TRG
-rw-r--r-- 1 hs221732 wheel   49 Apr 20 19:25 ts_insert.TRN

=============================================================================

The datadir contents after restart of server,

ls -laR `pwd`
/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data:
total 20552
drwxr-xr-x 7 hs221732 wheel     4096 Apr 20 19:12 .
drwxr-xr-x 3 hs221732 wheel     4096 Apr 20 19:22 ..
drwxr-xr-x 2 hs221732 wheel     4096 Apr 20 19:12 db1
drwxr-xr-x 2 hs221732 wheel     4096 Apr 20 19:12 db2
-rw-r--r-- 1 hs221732 wheel        1 Apr 20 17:35 ibbackup_binlog_info
-rw-r----- 1 hs221732 wheel 10485760 Apr 20 17:47 ibdata1
-rw-r----- 1 hs221732 wheel  5242880 Apr 20 17:47 ib_logfile0
-rw-r----- 1 hs221732 wheel  5242880 Apr 20 17:47 ib_logfile1
drwxr-xr-x 2 hs221732 wheel     4096 Apr 20 19:11 mtr
drwxr-xr-x 2 hs221732 wheel     4096 Apr 20 19:12 mysql
drwxr-xr-x 2 hs221732 wheel     4096 Apr 20 19:11 test

/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/db1:
total 124
drwxr-xr-x 2 hs221732 wheel  4096 Apr 20 19:12 .
drwxr-xr-x 7 hs221732 wheel  4096 Apr 20 19:12 ..
-rw-rw---- 1 hs221732 wheel    65 Apr 20 17:22 db.opt
-rw-rw---- 1 hs221732 wheel  8556 Apr 20 17:24 t1.frm
-rw-r----- 1 hs221732 wheel 98304 Apr 20 17:34 t1.ibd

/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/db2:
total 124
drwxr-xr-x 2 hs221732 wheel  4096 Apr 20 19:12 .
drwxr-xr-x 7 hs221732 wheel  4096 Apr 20 19:12 ..
-rw-rw---- 1 hs221732 wheel    65 Apr 20 17:23 db.opt
-rw-rw---- 1 hs221732 wheel  8554 Apr 20 17:24 t2.frm
-rw-r----- 1 hs221732 wheel 98304 Apr 20 17:34 t2.ibd

/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/mtr:
total 68
drwxr-xr-x 2 hs221732 wheel 4096 Apr 20 19:11 .
drwxr-xr-x 7 hs221732 wheel 4096 Apr 20 19:12 ..
-rw-r--r-- 1 hs221732 wheel   65 Apr 20 17:21 db.opt
-rw-r--r-- 1 hs221732 wheel 8566 Apr 20 17:21 global_suppressions.frm
-rw-r--r-- 1 hs221732 wheel 4440 Apr 20 17:21 global_suppressions.MYD
-rw-r--r-- 1 hs221732 wheel 1024 Apr 20 17:21 global_suppressions.MYI
-rw-r--r-- 1 hs221732 wheel  336 Apr 20 17:21 global_suppressions.TRG
-rw-r--r-- 1 hs221732 wheel   51 Apr 20 17:21 gs_insert.TRN
-rw-r--r-- 1 hs221732 wheel 8566 Apr 20 17:21 test_suppressions.frm
-rw-r--r-- 1 hs221732 wheel    0 Apr 20 17:21 test_suppressions.MYD
-rw-r--r-- 1 hs221732 wheel 1024 Apr 20 17:21 test_suppressions.MYI
-rw-r--r-- 1 hs221732 wheel  334 Apr 20 17:21 test_suppressions.TRG
-rw-r--r-- 1 hs221732 wheel   49 Apr 20 17:21 ts_insert.TRN
...
...
...
...
============================================================================