Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By Paul Iliano on
Hi,
I did a database repair + optimize in phpMyAdmin to clean her up and diminish her size. However, during this operation somehow something went wrong. The Drupal site behaves erratically now: going to any URL like node/xxx or any admin URL always brings up the frontpage (/node). So I can't even go to any admin page.
I checked and all nodes are still there - although they are not shown if you call them directly by their node/number URL. What I already tried is:
-updating the one module that was out of date (fckeditor)
-emptying al cache tables
-doing multiple repairs/optimizes
-creating a new database and importing
-connecting with mysqli
Can somebody point me to a possible solution? That would be much appreciated!
Many thanks in advance,
Paul
PS: I know, I should have a backup but the most recent one dates from Nov 13. I make them automatically with the module 'backup and migrate' but it somehow stopped creating the automatic backups on Nov 13 for some reason... which I only now remarked. And of course, lots of changes were made since :-(
Comments
Database repair?
What you mean with database repair and or optimize?
How someone optimizes the DB with phpMyAdmin ?
Please clarify what exactly you did with your database...
I 'm not sure but i think your DB is broken !
ReliabilityConsistencyFeedback ------ NeverAchivable
ReliabilityConsistencyFeedbackIn phpMyAdmin, a the bottom
In phpMyAdmin, a the bottom of the screen, you can click the 'Check all' link to select all tables, and then in the dropdown box 'With selected' you can choose 'Repair table' or 'Optimize table', etc. That's what I did.
Ohh Sorry, i was missing
Ohh Sorry, i was missing that !
Is this a common practise (to optimize - repair) ?
I checked and run an optimize - repair in my testing drupal instalation and everthing is Ok.
Sorry i can't help ...
ReliabilityConsistencyFeedback
-------NeverAchivable-------
ReliabilityConsistencyFeedbackI do a repair/optimize every
I do a repair/optimize every week. It gets rid of overhead in the tables, thus making the database smaller; it also seems to speed up the database a bit.