Im importing my heidi sql to mysql 5.1 community server

[expired user #10934]'s profile image [expired user #10934] posted 7 years ago in Import/Export Permalink

Hi all,

I'm importing heidi sql to mysql 5.1 community server and having an error. This is the error: "the dump file was not created by MySQL Administrator and could contain unsupport hence we cannot restore its content."

if i ignore errors and proceed the import stage. some tables on my heidi are gone.

any one encounter this.

Cause im new in this field.

Thanks

[expired user #10934]'s profile image [expired user #10934] posted 7 years ago Permalink

Hi all,

Need your help please.

Thanks

kalvaro's profile image kalvaro posted 7 years ago Permalink

SQL is plain text. You can open it with any text editor (even with HeidiSQL) and inspect it.

Also note that HeidiSQL can run SQL code just fine. If you have problems with other programs you might get better support in that other program's forums.

endo64's profile image endo64 posted 7 years ago Permalink

"the dump file was not created by MySQL Administrator and could contain unsupport hence we cannot restore its content." doesn't look like HeidiSQL error, please examine the SQL file you are trying to import.

[expired user #10934]'s profile image [expired user #10934] posted 7 years ago Permalink

Hi all,

@endo64 we are trying to import my database made in heidi sql to mysql 5.1 community server. while we are importing it."the dump file was not created by MySQL Administrator and could contain unsupport hence we cannot restore its content." this shows before the import process.

Thanks

endo64's profile image endo64 posted 7 years ago Permalink

I think you are trying to import the database dump exported using MySQL Administrator NOT mysqldump which has a bit different.

Please check this: https://bugs.mysql.com/bug.php?id=24704

The backup files created by MySQL Administrator are similar but not identical to those
created by mysqldump. A consequence of the differences is that MySQL Administrator
cannot read dump files created by mysqldump.

Please export / dump your DB using HeidiSQL or mysqldump then you should be able to import using HeidiSQL.

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