Title: Database error when migrating
Last modified: August 31, 2016

---

# Database error when migrating

 *  Resolved [vaughancavca](https://wordpress.org/support/users/vaughanwalton/)
 * (@vaughanwalton)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/database-error-when-migrating/)
 * I’ve been migrating a couple of my websites to a new host, but two of them are
   coming up with errors when I try and import the database, which are all related
   to the All-In-One Event Calendar plugin.
 * Here’s the errors I’ve been getting:
 *     ```
       --
       -- Database: akmjvyoe_wp320
       --
   
       -- --------------------------------------------------------
   
       --
       -- Table structure for table <code>wp_ai1ec_events</code>
       --
   
       CREATE TABLE IF NOT EXISTS <code>wp_ai1ec_events</code> (
         <code>post_id</code> bigint(20) NOT NULL,
         <code>start</code> int(10) unsigned NOT NULL,
         <code>end</code> int(10) unsigned DEFAULT NULL,
         <code>timezone_name</code> varchar(50) DEFAULT NULL,
         <code>allday</code> tinyint(1) NOT NULL,
         <code>instant_event</code> tinyint(1) NOT NULL DEFAULT '0',
         <code>recurrence_rules</code> longtext,
         <code>exception_rules</code> longtext,
         <code>recurrence_dates</code> longtext,
         <code>exception_dates</code> longtext,
         <code>venue</code> varchar(255) DEFAULT NULL,
         <code>country</code> varchar(255) DEFAULT NULL,
         <code>address</code> varchar(255) DEFAULT NULL,
         <code>city</code> varchar(255) DEFAULT NULL,
         <code>province</code> varchar(255) DEFAULT NULL,
         <code>postal_code</code> varchar(32) DEFAULT NULL,
         <code>show_map</code> tinyint(1) DEFAULT NULL,
         <code>contact_name</code> varchar(255) DEFAULT NULL,
         <code>contact_phone</code> varchar(32) DEFAULT NULL,
         <code>contact_email</code> varchar(128) DEFAULT NULL,
         <code>contact_url</code> varchar(255) DEFAULT NU[...]
       ```
   
 * [https://wordpress.org/plugins/all-in-one-event-calendar/](https://wordpress.org/plugins/all-in-one-event-calendar/)

The topic ‘Database error when migrating’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/all-in-one-event-calendar.svg)
 * [Timely All-in-One Events Calendar](https://wordpress.org/plugins/all-in-one-event-calendar/)
 * [Support Threads](https://wordpress.org/support/plugin/all-in-one-event-calendar/)
 * [Active Topics](https://wordpress.org/support/plugin/all-in-one-event-calendar/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/all-in-one-event-calendar/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/all-in-one-event-calendar/reviews/)

## Tags

 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)
 * [importing](https://wordpress.org/support/topic-tag/importing/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * 0 replies
 * 1 participant
 * Last reply from: [vaughancavca](https://wordpress.org/support/users/vaughanwalton/)
 * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/database-error-when-migrating/)
 * Status: resolved