Cant Import Saved DB from .SQL file.

[expired user #9170]'s profile image [expired user #9170] posted 9 years ago in Import/Export Permalink
I am having problems inmorting my DB from a .SQL file that I exported from HeidiSQL. It is giving me Errors.
2 attachment(s):
  • SQL-Error-1
  • SQL-Error-2
kalvaro's profile image kalvaro posted 9 years ago Permalink
"Column" is the official term for fields in relational databases. "Unknown column" means that you're running a statement that operates on a column (field) that doesn't exist on that table. The error message also mentions the name of the column so you know what the error is.
[expired user #9170]'s profile image [expired user #9170] posted 9 years ago Permalink
is there a way to have it add the column's its self via a saved SQL file?
kalvaro's profile image kalvaro posted 9 years ago Permalink
Sorry, I'm not really sure of what you'd expect HeidiSQL to do. If you cannot figure out what's wrong with your own data, how could a computer program know?

I've been dumping and loading databases with HeidiSQL for some years and the feature is pretty rock solid. I've only faced issues when migrating stuff between very different MySQL versions.

Just a guess... Are you trying to run a WoW server? We get such questions now and then and in fact HeidiSQL has nothing to with gaming or the like, it's just a database tool for programmers.
kalvaro's profile image kalvaro posted 9 years ago Permalink
Sorry, hit "Post reply" inadvertently... I mean you might have better luck if you ask in a WoW forum (assuming that's the case).
[expired user #9170]'s profile image [expired user #9170] posted 9 years ago Permalink
Nothing wrong wit my Data. I know its not HediSQL, LOVE the program. Just thought what someone would know why I was getting these Errors. Yes, I do run a WoW Server but was trying to import from a Backed up SQL file my Accounts info but it gives me the 2 Error pop ups when I do. I will try to post my problem on TrinityCore fourms as well.

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