Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

I have Drupal site on my local server build using pressflow

I had problems with the xammp 1.7.4 server, so I delete everything except mysql and htdocs folders.

I installed the server again, but the drupal site didn't work again.

There are 186 tables in my Drupal database, but phpmyadmin shows only 119 InnoDB tables

The rest of the tables are MyISAM, but they didn't show in phpmyadmin and it looks like Drupal can't find them too

I don't know where is the actual problem and how to fix it. Help me please.

share|improve this question
Please run this query and post it in your question: SELECT engine,COUNT(1) EngineTableCount FROM information_schema.tables WHERE table_schema NOT IN ('information_schema','mysql') GROUP BY engine; – RolandoMySQLDBA Jun 22 '11 at 15:19
Please run this as well and post it in your question : SELECT IFNULL(table_schema,'Total') DB,COUNT(1) DBTableCount FROM information_schema.tables GROUP BY table_schema WITH ROLLUP; – RolandoMySQLDBA Jun 22 '11 at 15:27
the first comment query returns InnoDB MyISAM PERFORMANCE_SCHEMA – M.B.Asfoor Jun 22 '11 at 15:37
Please show the counts from the second query – RolandoMySQLDBA Jun 22 '11 at 15:39
186 tables in the database – M.B.Asfoor Jun 22 '11 at 15:40
show 3 more comments

1 Answer

up vote 2 down vote accepted

You may need to check out the configuration of InnoDB.

You can start by running 

SHOW VARIABLES LIKE 'have_innodb';
SHOW ENGINES;

These will indicate whether or not InnoDB is running properly.

If InnoDB is disabled, it is more than likely that the log files need to be recreated.

As long as you keep ibdata, delete ib_logfile0, delete ib_logfile1, and set innodb_log_file_size to 170M in my.ini, you should be able to start mysql and have mysql rebuild new ib_logfile0 and ib_logfile0 to 170M each as suggested by the article you mentioned in the chat room.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.