extreme problems, need help!

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.

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
I tried to import using phpMyAdmin and I get all kinds of compatibility errors.

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

FAILED ATTEMPT #3
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
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

> # 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.

alright, I will go looking for an sql converter/translator then ... thanks

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.