Title: SQL tables missing after multisite install
Last modified: August 20, 2016

---

# SQL tables missing after multisite install

 *  Resolved [Gil](https://wordpress.org/support/users/gil-jones/)
 * (@gil-jones)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/sql-tables-missing-after-multisite-install-1/)
 * I have an existing site and am converting it to multisite. Hosted on hostgator.
   I did the wp-config.php and .htaccess modifications, disabled all plugins, went
   through the steps in dashboard/tools/network.
 * Tried to log in again and got the message that a network connection could not
   be established. Wound up at the step to repair the database and got the following:
 * wp_1_posts: Table ‘capnj_wrdp1.wp_1_posts’ doesn’t exist
    wp_1_comments: Table‘
   capnj_wrdp1.wp_1_comments’ doesn’t exist wp_1_links: Table ‘capnj_wrdp1.wp_1_links’
   doesn’t exist wp_1_options: Table ‘capnj_wrdp1.wp_1_options’ doesn’t exist wp_1_postmeta:
   Table ‘capnj_wrdp1.wp_1_postmeta’ doesn’t exist wp_1_terms: Table ‘capnj_wrdp1.
   wp_1_terms’ doesn’t exist wp_1_term_taxonomy: Table ‘capnj_wrdp1.wp_1_term_taxonomy’
   doesn’t exist wp_1_term_relationships: Table ‘capnj_wrdp1.wp_1_term_relationships’
   doesn’t exist wp_1_commentmeta: Table ‘capnj_wrdp1.wp_1_commentmeta’ doesn’t 
   exist
 * Anyone have clues for me?

Viewing 4 replies - 1 through 4 (of 4 total)

 *  [Andrea Rennick](https://wordpress.org/support/users/andrea_r/)
 * (@andrea_r)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/sql-tables-missing-after-multisite-install-1/#post-2337513)
 * Did you se the One-Clikc install to make the wordpress install to begin with?
 * Look in the db – were the tables actually created?
 * (don;t look for wp_1_x ones)
 *  Thread Starter [Gil](https://wordpress.org/support/users/gil-jones/)
 * (@gil-jones)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/sql-tables-missing-after-multisite-install-1/#post-2337515)
 * Hostgator installed it originally and imported my old blog.
    The multisite tables
   are actually there, just not with the wp_1_XXX ones.
 * The WP-X directories are directly under public_html
 *  Thread Starter [Gil](https://wordpress.org/support/users/gil-jones/)
 * (@gil-jones)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/sql-tables-missing-after-multisite-install-1/#post-2337521)
 * I’ve tinkered and now can log into the site with the network enabled. I think
   I was missing
 * define( ‘MULTISITE’, true );
 * But in the dashboard there are no network settings available.
 * gil
 *  Thread Starter [Gil](https://wordpress.org/support/users/gil-jones/)
 * (@gil-jones)
 * [14 years, 8 months ago](https://wordpress.org/support/topic/sql-tables-missing-after-multisite-install-1/#post-2337522)
 * Oh, wait! Found it! I”m good to go now.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘SQL tables missing after multisite install’ is closed to new replies.

## Tags

 * [multisite](https://wordpress.org/support/topic-tag/multisite/)
 * [table doesn't exist](https://wordpress.org/support/topic-tag/table-doesnt-exist/)

 * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/)
 * 4 replies
 * 2 participants
 * Last reply from: [Gil](https://wordpress.org/support/users/gil-jones/)
 * Last activity: [14 years, 8 months ago](https://wordpress.org/support/topic/sql-tables-missing-after-multisite-install-1/#post-2337522)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics