Title: Error importing Database
Last modified: February 10, 2017

---

# Error importing Database

 *  [thegrrraue](https://wordpress.org/support/users/thegrrraue/)
 * (@thegrrraue)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/error-importing-database-4/)
 * I moved my site to a new host, and I can’t seem to make it work. I exported the
   database, exported the XML file from wordpress’ tools section, and moved over
   all the files.
 * I can see that some of my edits to my theme have made it over, where I went into
   the file editor and made some custom changes, but it shows all of the default
   sample data in my theme (wp-simple). In trying to trace down the problem, I noticed
   that much of the data in my tables appears incomplete or incorrect.
 * I don’t know much about sql, so forgive me, but I tried re-importing the database,
   then also deleting the database and trying again (which apparently doesn’t work
   until you install wordpress again, oops).
 * Perhaps my hint should have been the errors I get every time I try to import 
   the database. Does anyone have any ideas?
 *     ```
       Warning in ./libraries/DisplayResults.php#869
        A non-numeric value encountered
   
       Backtrace
   
       ./libraries/DisplayResults.php#4932: PMA\libraries\DisplayResults->_getTableNavigation(
       integer 0,
       integer 0,
       boolean false,
       string '<form action="sql.php" method="post" class="print_ignore"> <input type="hidden" name="db" value="the131ers_com_1" /><input type="hidden" name="table" value="wp_uuacwb_options" /><input type="hidden" name="token" value="ed602edb73e5108d9c99d5dd08e74ac8" /><input type="hidden" name="sort_by_key" value="1" />Sort by key: <select name="sql_query" class="autosubmit"> <option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> ASC">PRIMARY (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> DESC">PRIMARY (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> ASC">option_name (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> DESC">option_name (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> " selected="selected">None</option></select> </form> ',
       )
       ./libraries/DisplayResults.php#4377: PMA\libraries\DisplayResults->_getPlacedTableNavigations(
       integer 0,
       integer 0,
       string 'top_direction_dropdown',
       boolean false,
       string '<form action="sql.php" method="post" class="print_ignore"> <input type="hidden" name="db" value="the131ers_com_1" /><input type="hidden" name="table" value="wp_uuacwb_options" /><input type="hidden" name="token" value="ed602edb73e5108d9c99d5dd08e74ac8" /><input type="hidden" name="sort_by_key" value="1" />Sort by key: <select name="sql_query" class="autosubmit"> <option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> ASC">PRIMARY (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> DESC">PRIMARY (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> ASC">option_name (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> DESC">option_name (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> " selected="selected">None</option></select> </form> ',
       )
       ./libraries/sql.lib.php#1680: PMA\libraries\DisplayResults->getTable(
       ,
       array,
       array,
       boolean false,
       )
       ./libraries/sql.lib.php#1963: PMA_getHtmlForSqlQueryResultsTable(
       ,
       string './themes/pmahomme/img/',
       NULL,
       array,
       boolean true,
       integer 136,
       integer 136,
       NULL,
       ,
       array,
       )
       ./libraries/sql.lib.php#2186: PMA_getQueryResponseForResultsReturned(
       ,
       array,
       string 'the131ers_com_1',
       string 'wp_uuacwb_options',
       NULL,
       NULL,
       ,
       string './themes/pmahomme/img/',
       integer 136,
       integer 136,
       NULL,
       NULL,
       NULL,
       NULL,
       NULL,
       string 'SELECT * FROM <code>wp_uuacwb_options</code>',
       NULL,
       )
       ./libraries/sql.lib.php#2048: PMA_executeQueryAndGetQueryResponse(
       array,
       boolean true,
       string 'the131ers_com_1',
       string 'wp_uuacwb_options',
       NULL,
       NULL,
       NULL,
       NULL,
       NULL,
       NULL,
       string '',
       string './themes/pmahomme/img/',
       NULL,
       NULL,
       NULL,
       string 'SELECT * FROM <code>wp_uuacwb_options</code>',
       NULL,
       NULL,
       )
       ./sql.php#221: PMA_executeQueryAndSendQueryResponse(
       array,
       boolean true,
       string 'the131ers_com_1',
       string 'wp_uuacwb_options',
       NULL,
       NULL,
       NULL,
       NULL,
       NULL,
       NULL,
       string '',
       string './themes/pmahomme/img/',
       NULL,
       NULL,
       NULL,
       string 'SELECT * FROM <code>wp_uuacwb_options</code>',
       NULL,
       NULL,
       )
       Warning in ./libraries/DisplayResults.php#869
        A non-numeric value encountered
   
       Backtrace
   
       ./libraries/DisplayResults.php#4932: PMA\libraries\DisplayResults->_getTableNavigation(
       integer 0,
       integer 0,
       boolean false,
       string '<form action="sql.php" method="post" class="print_ignore"> <input type="hidden" name="db" value="the131ers_com_1" /><input type="hidden" name="table" value="wp_uuacwb_options" /><input type="hidden" name="token" value="ed602edb73e5108d9c99d5dd08e74ac8" /><input type="hidden" name="sort_by_key" value="1" />Sort by key: <select name="sql_query" class="autosubmit"> <option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> ASC">PRIMARY (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> DESC">PRIMARY (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> ASC">option_name (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> DESC">option_name (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> " selected="selected">None</option></select> </form> ',
       )
       ./libraries/DisplayResults.php#4460: PMA\libraries\DisplayResults->_getPlacedTableNavigations(
       integer 0,
       integer 0,
       string 'bottom_direction_dropdown',
       boolean false,
       string '<form action="sql.php" method="post" class="print_ignore"> <input type="hidden" name="db" value="the131ers_com_1" /><input type="hidden" name="table" value="wp_uuacwb_options" /><input type="hidden" name="token" value="ed602edb73e5108d9c99d5dd08e74ac8" /><input type="hidden" name="sort_by_key" value="1" />Sort by key: <select name="sql_query" class="autosubmit"> <option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> ASC">PRIMARY (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_id</code> DESC">PRIMARY (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> ASC">option_name (ASC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> ORDER BY <code>option_name</code> DESC">option_name (DESC)</option><option value="SELECT * FROM <code>wp_uuacwb_options</code> " selected="selected">None</option></select> </form> ',
       )
       ./libraries/sql.lib.php#1680: PMA\libraries\DisplayResults->getTable(
       ,
       array,
       array,
       boolean false,
       )
       ./libraries/sql.lib.php#1963: PMA_getHtmlForSqlQueryResultsTable(
       ,
       string './themes/pmahomme/img/',
       NULL,
       array,
       boolean true,
       integer 136,
       integer 136,
       NULL,
       ,
       array,
       )
       ./libraries/sql.lib.php#2186: PMA_getQueryResponseForResultsReturned(
       ,
       array,
       string 'the131ers_com_1',
       string 'wp_uuacwb_options',
       NULL,
       NULL,
       ,
       string './themes/pmahomme/img/',
       integer 136,
       integer 136,
       NULL,
       NULL,
       NULL,
       NULL,
       NULL,
       string 'SELECT * FROM <code>wp_uuacwb_options</code>',
       NULL,
       )
       ./libraries/sql.lib.php#2048: PMA_executeQueryAndGetQueryResponse(
       array,
       boolean true,
       string 'the131ers_com_1',
       string 'wp_uuacwb_options',
       NULL,
       NULL,
       NULL,
       NULL,
       NULL,
       NULL,
       string '',
       string './themes/pmahomme/img/',
       NULL,
       NULL,
       NULL,
       string 'SELECT * FROM <code>wp_uuacwb_options</code>',
       NULL,
       NULL,
       )
       ./sql.php#221: PMA_executeQueryAndSendQueryResponse(
       array,
       boolean true,
       string 'the131ers_com_1',
       string 'wp_uuacwb_options',
       NULL,
       NULL,
       NULL,
       NULL,
       NULL,
       NULL,
       string '',
       string './themes/pmahomme/img/',
       NULL,
       NULL,
       NULL,
       string 'SELECT * FROM <code>wp_uuacwb_options</code>',
       NULL,
       NULL,
       )
       ```
   

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

 *  [ProjectArmy](https://wordpress.org/support/users/supporthero/)
 * (@supporthero)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/error-importing-database-4/#post-8791385)
 * Where are you importing database? Is it phpMyAdmin? or somewhere else?
 * ^V
 *  Thread Starter [thegrrraue](https://wordpress.org/support/users/thegrrraue/)
 * (@thegrrraue)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/error-importing-database-4/#post-8791542)
 * Yes, into phpMyAdmin.
 * I’ve just gone through and rebuilt the site from scratch anyway, but I would 
   be curious to know what the issue is in case I have to do this again someday.
 * Also, did I totally just post my private key in those codeblocks? Should I edit
   that?
 *  [ProjectArmy](https://wordpress.org/support/users/supporthero/)
 * (@supporthero)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/error-importing-database-4/#post-8792019)
 * It’s hard to say what went wrong. It’s possible, based on what you mentioned,
   that your table prefix was different if you installed a new WP first. Changing
   prefix in wp-config.php will make WP think it’s a new database. So even after
   import, if prefix was different WP would’ve shown you default database.
 * ^V
    -  This reply was modified 9 years, 3 months ago by [ProjectArmy](https://wordpress.org/support/users/supporthero/).

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

The topic ‘Error importing Database’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [ProjectArmy](https://wordpress.org/support/users/supporthero/)
 * Last activity: [9 years, 3 months ago](https://wordpress.org/support/topic/error-importing-database-4/#post-8792019)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics