distal-attribute
distal-attribute
distal-attribute
distal-attribute

extreme problems, need help!

User, date Message
Written by helpme
5 years ago
Category: Import/Export
14 posts since Wed, 08 Jul 09
Hi, I created an SQL file from Heidi, it is 300 MB in size, and I'm having the darndest time restoring it to a new server. surprised

My dilemma is that I no longer have the original database to create a new export, all I have is this SQL file.

FAILED ATTEMPT #1 unhappy
I tried to import using phpMyAdmin and I get all kinds of compatibility errors.

FAILED ATTEMPT #2 unhappy
I tried to import using bigdump.php- same thing, compatibility errors.

FAILED ATTEMPT #3 unhappy
I tried to import directly with SSH "mysql -u username -p database_name <file.sql" and I also get compatibility errors right off the bat.

FAILED ATTEMPT #4 unhappy
I tried importing with HeidiSQL, but it can't seem to handle a big 300 MB file.

---------------------------------------------
This is what the SQL file says:
# Target compatibility: ANSI SQL
# HeidiSQL version: 4.0 RC3
---------------------------------------------

Do I need to use a special text editor like UltraEdit and break this into many 5 MB files (tedious) and then use HeidiSQL to import each one separately?

I have also read on this forum that I can "SSH into the host, and then you tunnel in putty/whatever and import with HeidiSQL directly." That sounds pretty good too, but I don't understand the details of how to do that, if it's even possible.

Or maybe there is a program that would make the SQL format compatible??

Need some advice!!

Thanks,

Matt
Written by ansgar
5 years ago
4940 posts since Fri, 07 Apr 06
> # Target compatibility: ANSI SQL

Why the heck did you select ANSI in your export options? That's most probably the reason for why you get compatibility problems in mysql.
Written by helpme
5 years ago
14 posts since Wed, 08 Jul 09
alright, I will go looking for an sql converter/translator then ... thanks
Written by ansgar
5 years ago
4940 posts since Fri, 07 Apr 06
ANSI SQL output basically means you have doublequotes instead of backticks for identifiers and conditional comments are slightly differently formatted. Should not be too hard to search/replace with some editor.
 

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