Title: Missing tables Last modified: August 19, 2016 --- # Missing tables * Resolved [mrarrow](https://wordpress.org/support/users/mrarrow/) * (@mrarrow) * [15 years, 8 months ago](https://wordpress.org/support/topic/missing-tables/) * I recently migrated theme and content from a WPMU 2.8.6 site (which I’ve had since about WPMU 1.5) from one server to a fresh install of WP 3.0.1 Multisite on another server. So I created the subsites (sub domain) and imported in all the posts from the old WPMU sites. Everything is working fine. * EXCEPT, when I now come to create a new subsite, a whole load of tables don’t get created in the database for that new subsite! And when I view the front end subsite it comes back saying ‘Error establishing database connection’. * Looking in PHPMyAdmin, the top level, right up to wp_9_etc is fine (links, options, postmeta tables etc etc). However, there’s no tables been created for wp_10_posts, wp_10_options etc etc. * Any ideas!?!?! Viewing 7 replies - 1 through 7 (of 7 total) * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [15 years, 8 months ago](https://wordpress.org/support/topic/missing-tables/#post-1661751) * Can you manually create a table in that db via phpMyAdmin? Maybe your host has some limit… * Thread Starter [mrarrow](https://wordpress.org/support/users/mrarrow/) * (@mrarrow) * [15 years, 8 months ago](https://wordpress.org/support/topic/missing-tables/#post-1661767) * Yes, i can create tables manually. I run my own vps so i set any restrictions and there aren’t any on that account. * As i say it all set up correctly. Just not new subsites * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [15 years, 8 months ago](https://wordpress.org/support/topic/missing-tables/#post-1661778) * You run your own VPS or you host your VPS on someone else? * Are you logged in with the same ID used by WordPress? I generally log in as my admin account to cPanel, but WordPress uses a special SQL account for access. Maybe that account ‘lost’ access to create new tables? (Remember: The ability to create tables in SQL is different from writing to tables and adding rows!) * Thread Starter [mrarrow](https://wordpress.org/support/users/mrarrow/) * (@mrarrow) * [15 years, 8 months ago](https://wordpress.org/support/topic/missing-tables/#post-1661791) * I manage my own vps. * I log in as admin to wp and this wp account quite happily creates new posts etc. So i don’t think its a mysql permissions thing. * I’d been reading about define Charset needing to be utf rather than latin etc. I’ve compared wp config on both old and new installs as well as the databases themselves and they both look to be the same – utf 8. * I’m puzzled and slightly alarmed. * Moderator [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [15 years, 8 months ago](https://wordpress.org/support/topic/missing-tables/#post-1661816) * > I log in as admin to wp and this wp account quite happily creates new posts > etc. So i don’t think its a mysql permissions thing. * NOT the same thing 🙂 * Your WordPress ID is not the same as the ID you login to your server with, and that isn’t the same (normally) as the ID you use for SQL. * In your wp-config.php file, where it says what the SQL user ID is, THAT is the ID used to create new tables. And THAT is the ID, I think, that is somehow to do so. * So when you log into phpMyAdmin, are you doing so as the server admin or as the SQL account for your WordPress install? * > I manage my own vps. * I’ll ask differently. Who is your webhost? * I manage my own VPS, but the server is owned by my WebHost and they give me access to it 🙂 It’s semantics and technicalities, but it matters since you may need to ask your ISP for help fixing your SQL user ID permissions if you get stumped. * (Don’t worry about UTF-8/Latin-1 – If you’re on UTF-8, you’re fine). * Thread Starter [mrarrow](https://wordpress.org/support/users/mrarrow/) * (@mrarrow) * [15 years, 8 months ago](https://wordpress.org/support/topic/missing-tables/#post-1662010) * OK, well it seems I’ve now bottomed-out this issue. * When I have Defensio 2.5.8 network activated, new sites don’t create the required tables. If I network DEACTIVATE Defensio, I can then create a new site and everything behaves as expected. I then simply reactivate Defensio and all works well. Errrmmm…… * I have noticed that in PHPMyAdmin, all of the Defensio entries (e.g. wp_2_defensio, signature, status, classification etc) are all latin_swedish_ci in the collation field. Whereas everything else in the d/b is utf8_general_ci * So I’m wondering if this is the cause. Needless to say, I’ll be getting in touch with Defensio again (2.5.9 was partly because of me!) * [Andrea Rennick](https://wordpress.org/support/users/andrea_r/) * (@andrea_r) * [15 years, 8 months ago](https://wordpress.org/support/topic/missing-tables/#post-1662019) * Yep, that would be the issue. Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘Missing tables’ is closed to new replies. ## Tags * [missing tables](https://wordpress.org/support/topic-tag/missing-tables/) * [multisite](https://wordpress.org/support/topic-tag/multisite/) * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/) * 7 replies * 3 participants * Last reply from: [Andrea Rennick](https://wordpress.org/support/users/andrea_r/) * Last activity: [15 years, 8 months ago](https://wordpress.org/support/topic/missing-tables/#post-1662019) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics