Page 1 of 1
(SOLVED) database dump and restore
Posted: Sun Feb 10, 2008 4:29 pm
by 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
Re: database dump and restore
Posted: Sun Feb 10, 2008 4:31 pm
by 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.
Re: database dump and restore
Posted: Sun Feb 10, 2008 4:39 pm
by 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?
Re: database dump and restore
Posted: Sun Feb 10, 2008 4:46 pm
by 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
Re: database dump and restore
Posted: Mon Feb 11, 2008 3:45 pm
by 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
Re: database dump and restore
Posted: Tue Feb 19, 2008 12:15 am
by thoneter
Looks like I've shown my ignorance. You can not modify a sql dump, you can only backup and restore!