(SOLVED) database dump and restore

[thoneter]

Using GoDaddy for my host.  I am attemting to move my site to a new domain but staying with GoDaddy for the hosting.  I am using cuteftp to download the dump and upload using binary as the transfer type both ways.  I've done this before using import and export but the file is 2.8 megs.

The backup goes well but the restore gives me this error. 

"ERROR 1064 (42000) at line 1: 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 '
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at line 1"

I can post line one of the database if requested.  A sincere thanks for having this forum for us guys that know enough to be dangerous!  TT

[calguy1000]

This is not a CMS specific issue..... You're trying to import a SQL file that the new host doesn't like....

your best bet would be working with google and your new host.

[thoneter]

From what I've read GoDaddy isn't the best host for cmsms.  Unfortunately I let the $ signs make my decisions.  I have been trying to work this out with GoDaddy but as you probably know they don't offer any help when it comes to databases which is really frustrating.  What is a good host for cmsms? 

[nivekiam]

First I found a ton of results by searching google for:
SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT

http://www.google.com/search?q=SET+%40O ... SET_CLIENT

Here are a few options that I know work fine with CMSms:

www.dreamhost.com
www.hostway.com
www.pair.com

Don't know how well these two work, but they are listed on this site.  I also don't know if they pay to be listed there or what the criteria are for being listed there:
http://www.cmsmadesimple.org/support/cm ... le-hosting

[thoneter]

The problem is that if I attempt to modify the host address in the dump or the database name the file gets corrupted.  If I transfer the dump directily to the new server it works fine but the host and database name are incorrect!

Is there a way to go into the database and change that through the phpadmin?  TT

[thoneter]

Looks like I've shown my ignorance.  You can not modify a sql dump, you can only backup and restore!