Title: Database missing tables Last modified: August 22, 2016 --- # Database missing tables * Resolved [megignite](https://wordpress.org/support/users/megignite/) * (@megignite) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-missing-tables/) * Our server and wordpress site recently got hacked, so we’ve been working through the process of changing hosts and starting fresh. We are basically starting from scratch but would like to keep our blog posts up. We have backups of the database from a couple of months ago, but every time we back them up there are only two tables. “login” and “pages”. The pages table contains all the pages of the site but not the posts. There were no other tables to back up. Is this information lost? Will we have to start again? Viewing 9 replies - 1 through 9 (of 9 total) * Thread Starter [megignite](https://wordpress.org/support/users/megignite/) * (@megignite) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-missing-tables/#post-5317614) * Even our backups from 6 months ago only have two tables. “pages” and “login”. Posts are nowhere to be found. * [arielicas](https://wordpress.org/support/users/arielicas/) * (@arielicas) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-missing-tables/#post-5317644) * Hi [@megignite](https://wordpress.org/support/users/megignite/) , * Yes I think you need to start from scratch. Maybe the backup you made is already hacked. Even though you change hosts you need to check the weakness of your wp site. Check the logs if you have stats or error logs to check how did your site was hacked. * Thread Starter [megignite](https://wordpress.org/support/users/megignite/) * (@megignite) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-missing-tables/#post-5317645) * Thanks for your feedback [@arielicas](https://wordpress.org/support/users/arielicas/), * It’s strange as backups we have further than that only have two tables also. The posts have been working the entire time up until our server blocked our site from running. It seems like the database wasn’t set up properly to begin with( I hadn’t created the site originally), is this possible? * I will take a look at the site to check for any weaknesses. * [arielicas](https://wordpress.org/support/users/arielicas/) * (@arielicas) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-missing-tables/#post-5317646) * i think if you have the soft copy of the content. Better install the updated wordpress. This will save you time than troubleshooting error 🙂 * [catacaustic](https://wordpress.org/support/users/catacaustic/) * (@catacaustic) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-missing-tables/#post-5317652) * The tables of `login` and `pages` are both not standard WordPress tables. That’s almost a worry as any normal WordPress installation will never have two tables called that, and there will be (at least) 11 other tables, all starting with the database prefix set out in your `wp-config.php` file. * If those are the only two tables that you have, you do have a big problem. You may be able to extract the content out of the `pages` table to cut-and-paste into a new WordPress site, but we can’t be sure it would work until you tried it. * One thing to do is talk to your old hosting company, assuming you still have an active account with them, and see if they have any backups of the full account. Most hosts do keep backups for anywhere up to 30 days, so it may be worth looking at that as well. * Thread Starter [megignite](https://wordpress.org/support/users/megignite/) * (@megignite) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-missing-tables/#post-5317654) * Yeah, it has been particularly frustrating as I could see it didn’t follow the proper structure, but there were no other tables in the database to begin with. I’m not sure exactly where the posts were being stored, but it certainly wasn’t on the database. * I have been able to copy and paste content from the pages database backup, but the posts are still nowhere to be found, which is incredibly frustrating since that was our blog for the last year. I figured having a complete database backup would be enough, but obviously that didn’t work out for us. I have never encountered issues like this with databases before, and it seems strange that there are no post tables or generic wordpress structured tables anywhere to be found. * v frustrating * Thread Starter [megignite](https://wordpress.org/support/users/megignite/) * (@megignite) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-missing-tables/#post-5317655) * I have complete access to the old home directory, as well as all the old databases, as we are between hosts at this stage. But even our exceptionally old databases and full backups only have those two tables “login” and “pages”. It’s really strange. * [catacaustic](https://wordpress.org/support/users/catacaustic/) * (@catacaustic) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-missing-tables/#post-5317656) * Check your database connection details in your `wp-config.php` file and see which database it’s actually connecting to. There’s no way that a WordPress iste will work only off those two tables, so there has to be a different database _somewhere_. * Thread Starter [megignite](https://wordpress.org/support/users/megignite/) * (@megignite) * [11 years, 8 months ago](https://wordpress.org/support/topic/database-missing-tables/#post-5317658) * Curse of the phantom database. So you’re definitely right, it is _somewhere_. I have the name, the username, and the password. It is a completely different database and username that we had on file. I’m not sure how the person set the site up initially, but this brings me closer to a solution. Unfortunately as we are in between hosts, it’s a struggle to access phpmyadmin as a different user. I might get in touch with our old provider to check if he can access anything we can’t. Viewing 9 replies - 1 through 9 (of 9 total) The topic ‘Database missing tables’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [hacked](https://wordpress.org/support/topic-tag/hacked/) * [restoration](https://wordpress.org/support/topic-tag/restoration/) * [tables](https://wordpress.org/support/topic-tag/tables/) * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 9 replies * 3 participants * Last reply from: [megignite](https://wordpress.org/support/users/megignite/) * Last activity: [11 years, 8 months ago](https://wordpress.org/support/topic/database-missing-tables/#post-5317658) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics