Database issues

[Waste]

I decided to day after having HDD issues on my webserver, that I was going to get an online host.
So, I upload all the files of the forum to the server, then I get on phpMyAdmin.
I then try to upload the database and I get this error:

Koodi [Valitse] Laajenna

#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 29

What can be done about this, as it is a dump from my existing forum.
Better yet, is there a better way of switching hosts?

[Daevien]

Hmm only thing that comes to mind would be if you used a newer versoin on your old server than what your new server has though with mysql the table, etc data would be the same I would think in general.

Maybe if you could open up the sql file and see what that line is, maybe paste line 29 here and we can see what it's trying to do. Could be a corrupt file also as you said you had HDD issues.

For moving large databases that phpMyAdmin says are too large, you can try BigDump from http://www.ozerov.de/bigdump.php [nofollow] which I used to move an 80mb or so phpBB database a while back before I converted to SMF and it works just fine (and my web provider used it to convert another forum for someone when he had issues with the size and asked me how I did it).

Though the file size shouldn't be an issue at only line 29

Try copying the db again perhaps and see if the first one was just corrupted somehow as well.

Hope this helps a bit or you can post the line so we can see what it might be.

[Waste]

Well, what happened is that SMF didn't dump the database correctly.
I dumped it from phpMyAdmin from my home server and manually copy pasted everything in and ran it all.
Took awhile but I got I got it working.

Now I am having issues with the themes using the templates from the default theme when they should be using thier own.
And the DNS hasn't yet propagated in my area so I have to go through a proxy to even get on my site.