extreme problems, need help!
| User, date | Message |
|---|---|
|
Written by helpme
4 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.  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 |
|
Written by ansgar
4 years ago 4025 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
4 years ago 14 posts since Wed, 08 Jul 09 |
alright, I will go looking for an sql converter/translator then ... thanks |
|
Written by ansgar
4 years ago 4025 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. |