Title: Error when importing database to local server
Last modified: August 31, 2016

---

# Error when importing database to local server

 *  Resolved [alecjmccartney](https://wordpress.org/support/users/alecjmccartney/)
 * (@alecjmccartney)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/error-when-importing-database-to-local-server/)
 * Hi,
 * I’m trying to make a local copy of my WordPress site so I can demo it without
   an internet connection. I’m using Xampp to provide the Apache and MySQL services.
 * When I try to import my database into my local PHPmyAdmin, I see the following
   error:
 * CREATE TABLE IF NOT EXISTS `wp_bsearch` (
    `accessedid` int(11) NOT NULL AUTO_INCREMENT,`
   searchvar` varchar(100) NOT NULL, `cntaccess` int(11) NOT NULL, PRIMARY KEY (`
   accessedid`), KEY `IDX_searhvar` (`searchvar`) ) ENGINE=InnoDB DEFAULT CHARSET
   =utf8 AUTO_INCREMENT=35
 * I pretty sure that part of my database relates to Better Search.
 * Can you help?
 * Thanks!
 * [https://wordpress.org/plugins/better-search/](https://wordpress.org/plugins/better-search/)

Viewing 1 replies (of 1 total)

 *  Thread Starter [alecjmccartney](https://wordpress.org/support/users/alecjmccartney/)
 * (@alecjmccartney)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/error-when-importing-database-to-local-server/#post-6976971)
 * I’ve solved it.
 * I had to create a blank database first.
 * Sorry.

Viewing 1 replies (of 1 total)

The topic ‘Error when importing database to local server’ is closed to new replies.

 * ![](https://ps.w.org/better-search/assets/icon-256x256.png?rev=2988729)
 * [Better Search - Relevant search results for WordPress](https://wordpress.org/plugins/better-search/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/better-search/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/better-search/)
 * [Active Topics](https://wordpress.org/support/plugin/better-search/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/better-search/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/better-search/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [alecjmccartney](https://wordpress.org/support/users/alecjmccartney/)
 * Last activity: [10 years, 4 months ago](https://wordpress.org/support/topic/error-when-importing-database-to-local-server/#post-6976971)
 * Status: resolved