[SQL] Import database - Error

[Liley]

When you import the base, it gives me an error:

SQL query:

-

MySQL returned: Documentation

#1064 - 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 1

 

[dchampag]

What are you using to import your database?

I recommend MySQL workbench as the best free software. If you want to pay Navicat is very very convenient and easy to use.

 

[Liley]

This happens when Loading a file sql phpmyadmin. I need specific help.

 

[dchampag]

If you have temaviewer, you can Private Message me the information. I will show you MySQL Workbench, it's a great program.

 

[klepacz]

I don't wanna make another topic for another sql problem, so im gonna post it there

CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `limit` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


#1005 - Can't create table 'znote.znote_guild_wars' (errno: 150)

 

[Codex NG]

try this

CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
  `id` int NOT NULL AUTO_INCREMENT,
  `limit` int NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB;

 

[klepacz]

I've fixed it by adding guild_wars table before, but thanks