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