Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Reinstalled WAMP, Wordpress Tables Not Found BUT Are in PHPMYADMIN

OK strange situation and I hope I am not just out of luck. I upgraded from Windows 7 to 8 and when I did WAMP would not work. I reinstalled WAMP not thinking and followed instructions online to get WAMP working.

Now though my Wordpress site redirets me to the install page. When I go into phpmyadmin it looks like all of my tables are there but when I click on the wordpress database is says "No tables found in database". If I click on one of the tables listed under wordpress it gives me the error "Table 'wordpress.wp_postmeta' doesn't exist"

I check my database files and they obviously contain data by the file sizes.

See the screenshots. Any help would be greatly appreciated. I was redoing our business website and would prefer not to have to start from scratch.

Wordpress Database

Clicking on wp_posts table

enter image description here

like image 355
Todd Welch Avatar asked Oct 01 '22 06:10

Todd Welch


1 Answers

Yes, the problem were the old files:

ib_logfile0, ib_logfile1, ibdata1.

One should also backup them, close WAMP, copy, paste and remove the ones generated by the installation. After that phpMyAdmin recognises the tables we had prior to the reinstallation of WAMP!

like image 81
Agustín Avatar answered Oct 07 '22 18:10

Agustín