Title: Importing database error
Last modified: August 30, 2016

---

# Importing database error

 *  [travelaar](https://wordpress.org/support/users/travelaar/)
 * (@travelaar)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/importing-database-error/)
 * Hello,
 * I want to import my WordPress site into Xampp for offline editing. However, when
   I want to import the sql file into my local database it generate the following
   errors:
    Using Duplicator plugin doesn’t work as my host doesn’t allow it. I 
   have looked everywhere, but its pretty hard when not familiar any of the problems.
   Anyone a clue? Thanks!
 * Error
    Static analysis:
 * 23 errors were found during analysis.
 * Unexpected character. (near “:” at position 1335)
    Unexpected character. (near“:”
   at position 1338) Unexpected character. (near “:” at position 1404) Unexpected
   character. (near “:” at position 1407) Ending quote ‘ was expected. (near “” 
   at position 1537) A comma or a closing bracket was expected (near “0000” at position
   1322) Unexpected token. (near “-00” at position 1326) Unexpected token. (near“-
   00” at position 1329) Unexpected token. (near “00” at position 1333) Unexpected
   token. (near “:” at position 1335) Unexpected token. (near “00” at position 1336)
   Unexpected token. (near “:” at position 1338) Unexpected token. (near “00” at
   position 1339) Unexpected token. (near “‘, `es_sent_endtime` datetime NOT NULL
   DEFAULT ‘” at position 1341) Unexpected token. (near “0000” at position 1391)
   Unexpected token. (near “-00” at position 1395) Unexpected token. (near “-00”
   at position 1398) Unexpected token. (near “00” at position 1402) Unexpected token.(
   near “:” at position 1404) Unexpected token. (near “00” at position 1405) Unexpected
   token. (near “:” at position 1407) Unexpected token. (near “00” at position 1408)
   Unexpected token. (near “‘, `es_sent_count` int(10) unsigned NOT NULL, `es_sent_preview`
   text ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8″ at position 1410)
   SQL query:
 * INSERT INTO `wp_es_pluginconfig` (`es_c_id`, `es_c_fromname`, `es_c_fromemail`,`
   es_c_mailtype`, `es_c_adminmailoption`, `es_c_adminemail`, `es_c_adminmailsubject`,`
   es_c_adminmailcontant`, `es_c_usermailoption`, `es_c_usermailsubject`, `es_c_usermailcontant`,`
   es_c_optinoption`, `es_c_optinsubject`, `es_c_optincontent`, `es_c_optinlink`,`
   es_c_unsublink`, `es_c_unsubtext`, `es_c_unsubhtml`, `es_c_subhtml`, `es_c_message1`,`
   es_c_message2`) VALUES (1, ‘Travelaar.nl’, ‘<<email adress>>’, ‘WP HTML MAIL’,‘
   YES’, ‘<<email adress>>’, ‘ New email subscription’, ‘Hi Admin, \r\n\r\nWe have
   received a request to subscribe new email address to receive emails from our 
   website. \r\n\r\nEmail: ###EMAIL### \r\nName : ###NAME### \r\n\r\nThank You\r\
   n’, ‘YES’, ‘ Welkom bij travelaar.nl!’, ‘Hallo ###NAME###!\r\n\r\nVanaf nu zal
   je de nieuwsbrief van travelaar.nl in je inbox krijgen..\r\n\r\nBedankt en tot
   snel!’, ‘Double Opt In’, ‘ Bevestig je email..’, ‘Hallo ###NAME###! \r\n\r\nVia
   onderstaande link kun je je emailadres bevestigen.\r\n\r\n<a href=\\” CREATE 
   TABLE IF NOT EXISTS `wp_es_sentdetails` ( `es_sent_id` int(10) unsigned NOT NULL,`
   es_sent_guid` varchar(255) NOT NULL, `es_sent_qstring` varchar(255) NOT NULL,`
   es_sent_source` varchar(255) NOT NULL, `es_sent_starttime` datetime NOT NULL 
   DEFAULT ‘0000-00-00 00:00:00’, `es_sent_endtime` datetime NOT NULL DEFAULT ‘0000-
   00-00 00:00:00’, `es_sent_count` int(10) unsigned NOT NULL, `es_sent_preview`
   text ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=utf8
 * MySQL said: Documentation
 * #1064 – You have an error in your SQL syntax; check the manual that corresponds
   to your MariaDB server version for the right syntax to use near ‘0000-00-00 00:
   00:00’,
    `es_sent_endtime` datetime NOT NULL DEFAULT ‘0000-00-00 ‘ at line 2

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

 *  [1upnate](https://wordpress.org/support/users/1upnate/)
 * (@1upnate)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/importing-database-error/#post-6726111)
 * So I see that you’re importing it into MariaDB… what database server was it exported
   from? Oracle, MySQL, MSSql, all have slightly different syntaxes here and there
   which could be causing an issue.
 *  Thread Starter [travelaar](https://wordpress.org/support/users/travelaar/)
 * (@travelaar)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/importing-database-error/#post-6726152)
 * The server it was downloaded from uses MySQL. Xampp comes with MariaDB.
    I didn’t
   know what the difference was, but is it an idea to try and install xampp with
   MySQL?
 * <edit>
 * In Xampp, the modules “Apache” and “MySQL” are running.
    Where do I specify where
   to upload the database to?

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

The topic ‘Importing database error’ is closed to new replies.

## Tags

 * [database import error](https://wordpress.org/support/topic-tag/database-import-error/)
 * [unexpected character](https://wordpress.org/support/topic-tag/unexpected-character/)
 * [unexpected token](https://wordpress.org/support/topic-tag/unexpected-token/)

 * In: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/)
 * 2 replies
 * 2 participants
 * Last reply from: [travelaar](https://wordpress.org/support/users/travelaar/)
 * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/importing-database-error/#post-6726152)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics