Importing sql file from mysql - #1064 error

CubeOne · Mar 3, 2021

Today, after a week of every day hard work I finally made it - my ispconfig is online and all works well! But then I tried to import .sql file from my old plesk server (unfortunately does not exist anymore) and I ended up with error of #1064 and I just don't know what I need to do, so any help/advice is welcome.

--
-- Database: `db`
--

-- --------------------------------------------------------

--
-- Table structure for table `db_aiowps_events`
--

CREATE TABLE `db_aiowps_events` (
`id` bigint(20) NOT NULL,
`event_type` varchar(150) COLLATE utf8_general_ci NOT NULL DEFAULT '',
`username` varchar(150) utf8_general_ci DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
`event_date` datetime NOT NULL DEFAULT '1000-10-10 10:00:00',
`ip_or_host` varchar(100) COLLATE utf8_general_ci DEFAULT NULL,
`referer_info` varchar(255) COLLATE utf8_general_ci DEFAULT NULL,
`url` varchar(255) COLLATE utf8_general_ci DEFAULT NULL,
`country_code` varchar(50) COLLATE utf8_general_ci DEFAULT NULL,
`event_data` longtext COLLATE utf8_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ;
Click to expand...

MySQL said:

#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 'DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
`event_date` datetime NOT N' at line 14
Click to expand...

I know I will have to fix many in this database, but if someone can point me what I need to change here, later (I guess) I will be able to fix it overall .

Thanks!

Jesse Norell · Mar 3, 2021

Remove 'DEFAULT' from that column definition.

CubeOne · Mar 4, 2021

I tried that, but now another error shows up.

CREATE TABLE `db_aiowps_events` (
`id` bigint(20) NOT NULL,
`event_type` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL '',
`username` varchar(150) utf8mb4_unicode_ci NULL,
`user_id` bigint(20) NULL,
`event_date` datetime NOT NULL '1000-10-10 10:00:00',
`ip_or_host` varchar(100) COLLATE utf8mb4_unicode_ci NULL,
`referer_info` varchar(255) COLLATE utf8mb4_unicode_ci NULL,
`url` varchar(255) COLLATE utf8mb4_unicode_ci NULL,
`country_code` varchar(50) COLLATE utf8mb4_unicode_ci NULL,
`event_data` longtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB CHARSET=utf8mb4_unicode_ci COLLATE=utf8mb4_unicode_ci
MySQL said:

#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 ''',
`username` varchar(150) utf8mb4_unicode_ci NULL,
`user_id` bigint(20) ' at line 3
Click to expand...

It seems now some of the '' are too much or?

Jesse Norell · Mar 4, 2021

CubeOne said: ↑

`event_type` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL '',
Click to expand...

Remove the '' from that line.

Log in or Sign up

Importing sql file from mysql - #1064 error

CubeOne New Member

Jesse Norell Well-Known Member Staff Member Howtoforge Staff

CubeOne New Member

Jesse Norell Well-Known Member Staff Member Howtoforge Staff

Share This Page

Log in or Sign up

Importing sql file from mysql - #1064 error

CubeOne New Member

Jesse Norell Well-Known Member Staff Member Howtoforge Staff

CubeOne New Member

Jesse Norell Well-Known Member Staff Member Howtoforge Staff

Share This Page

Useful Searches