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”

Read More

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

Related posts

Leave a Reply

2 comments

  1. 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!

  2. When you reinstalled WAMP you I assume put it into a new folder or you backed up the original wamp install.

    If you did then you can copy the oldwampbinmysqlmysqlx.y.zdatadatabase_name into the newwampbinmysqlmysqlx.y.zdatadatabase_name

    Assuming you installed the same version this should be all you need to do.

    For future reference or when you upgrade to Windows 8.1 all you actually needed to do, assuming the wamp folder is not destroyed by the upgade is reinstall the Apache(wampapache) and MySQL(awampmysql) services, which are messed up by the install.

    So just start wampmanager and then :-

    left click wampmanager -> Apache -> Service -> Install Service
    left click wampmanager -> MySQL -> Service -> Install Service