I got SQL dump of website, and I find out that he was probably did by HeidiSQL because of "-- --------------------------------------------------------
-- Host: 127.0.0.1
-- Server version: 5.6.16 - Source distribution
-- Server OS: Linux
-- HeidiSQL Version: 8.3.0.4694
-- --------------------------------------------------------"
of header SQL dump.
I'm trying to import this file and I get mysql errors like:
Error at the line 23: ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin
or
Error at the line 179: (153, 'u_blog_css', 1, 0, 0);
All errors looks absolutetly ridicilous because SQL code itself is right. Why I get this errors?
Import SQL dump which was exported with HeidiSQL
code which initiate error
CREATE TABLE IF NOT EXISTS `phpbb_acl_users` (
`user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`auth_role_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`auth_setting` tinyint(2) NOT NULL DEFAULT '0',
KEY `user_id` (`user_id`),
KEY `auth_option_id` (`auth_option_id`),
KEY `auth_role_id` (`auth_role_id`);
CREATE TABLE IF NOT EXISTS `phpbb_acl_users` (
`user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`forum_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`auth_option_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`auth_role_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`auth_setting` tinyint(2) NOT NULL DEFAULT '0',
KEY `user_id` (`user_id`),
KEY `auth_option_id` (`auth_option_id`),
KEY `auth_role_id` (`auth_role_id`);
Please login to leave a reply, or register at first.