Here's my dilemma...
I hope someone can help me with this one. I recently installed/activated the WP-DBManager plugin for the first time. This plugin was suppose to let me backup/manage/optimize/repair my database, and so on.
As instructed, I moved the htaccess.txt file from the wp-content/plugins/wp-dbmanager folder to the wp-content/backup-db folder and renamed it .htaccess.
Next, I ran the "Optimize DB" that was suppose to optimize my database. There was an issue with the MYSQL not being available so I ran the "Optimize DB" again but this time from a different browser (Safari). The first time I ran it was from the Mozilla Firefox browser.
As a result, my all my posts, pages and menu are now gone. When I try to visit my individual pages such as http://internettvdotcom.com/streamdirectmovies, I get a "404: Not Found."
I also installed/activated another plugin called "W3 Total Cache" but this issue didn't occurred until I was messing with the WP-DBManager plugin.
I deactivated both plugins and still no posts and pages. Then I found out later that there is no support for the WP-DBManager but only a forum the owner left to get help from other users -- so I left post there also.
Next, I contacted my hosting company (Hostgator) to see if they could restore my posts and pages back to me. After telling them which database I was having an issue, they told me everything looked fine on their end and even visited my site at http://internettvdotcom.com.
They saw exactly what I was experiencing and told me that I should restore my template and get back to the owner of the plugin. Instead, I activated the WordPress default template and still no posts or pages.
I managed to backup the database that have my posts and pages to the Notepad but don't know how or if I should try to restore the files on my end.
Any help is greatly appreciated!
p.s. I also reinstalled WordPress 3.1. My site is large so the last thing I want to do is start all over.