Import SQL dump which was exported with HeidiSQL

[expired user #8734]'s profile image [expired user #8734] posted 9 years ago in General Permalink
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?
jfalch's profile image jfalch posted 9 years ago Permalink
what is error message of line 23 ?
[expired user #8734]'s profile image [expired user #8734] posted 9 years ago Permalink
MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'db.sql' at line 1
[expired user #8734]'s profile image [expired user #8734] posted 9 years ago Permalink
or

MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 9
[expired user #8734]'s profile image [expired user #8734] posted 9 years ago Permalink
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`);
jfalch's profile image jfalch posted 9 years ago Permalink
as far as i coan see, there is no closing parenthesis for the opening one after `phpbb_acl_users`. try to insert a ) before the ;

Please login to leave a reply, or register at first.