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

extreme problems, need help!

helpme posted 5 years ago in Import/Export
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
ansgar posted 5 years ago
> # 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.
helpme posted 5 years ago
alright, I will go looking for an sql converter/translator then ... thanks
ansgar posted 5 years ago
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.