mr_yakimonoI'm moving my host from GoDaddy to Fatcow and am having problems moving the MySQL db to Fatcow. They say they can't help -- it's a wp issue.
Lots of impossible-for-me-to-understand error messages when I try to upload my backup .sql file to Fatcow.
I read the wp help doc on this but it doesn't help:
http://codex.wordpress.org/Moving_WordPress
- I backed up the MySQL db on the old godaddy site using "Simple WordPress Backup" which generated a .sql file
- I set up a new db, db username, and db password in Fatcow
- I edited the following 4 lines in my wp-config.php file to match the info I set up in Fatcow admin and FTP'd it to my /wordpress/ dir on fatcow:
define('DB_NAME', '***I put the new name here***');
/** MySQL database username */
define('DB_USER', ''***I put the new name here***');
/** MySQL database password */
define('DB_PASSWORD', ''***I put the new name password here***');
/** MySQL hostname */
define('DB_HOST', ''***I put new the hostname here, copied from fatcow admin***');
When I try to upload my .sql backup file in fatcow I get the following error message:
---------------
Error
SQL query:
-- MySQL dump 10.11
--
-- Host: jam1100310172889.db.7079818.hostedresource.com Database: jam1100310172889
-- ------------------------------------------------------
-- Server version 5.0.91-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table phpmysqlautobackup
--
DROP TABLE IF EXISTS phpmysqlautobackup ;
---------
Help!
James
