Trying to move a Word Press site and getting errors - Please look

Hi,

I'm doing a WP site for a client.

I started building it in a sub folder on one of my domains.

The site has to be moved to a folder on another one of my domains, but when I try to import the mysql db using phpadmin I receive this error:

- - - - - - - -

SQL query:

-- -- Database: `mbc1_wrdp1` -- -- -------------------------------------------------------- -- -- Table structure for table `wp_comments` -- CREATE TABLE IF NOT EXISTS `wp_comments` ( `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0', `comment_author` tinytext COLLATE utf8_unicode_ci NOT NULL, `comment_author_email` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `comment_author_url` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `comment_author_IP` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `comment_content` text COLLATE utf8_unicode_ci NOT NULL, `comment_karma` int(11) NOT NULL DEFAULT '0', `comment_approved` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '1', `comment_agent` varchar(255) COLLATE utf8_unicode_ci NOT NU[...]

MySQL said:

- - - - - - - - - - - end error

Should I be installing WP on the new domain and then importing the mysql db and files or should I just import the mysql db and files.

I really appreciate any help and I hope that my description was clear.

 

Usually you don't need to import the DB, you can just make a new database on the new domain. I'm not sure though, sorry I can't help.

 

Then how would the data get moved if I don't import the db?

 

What data do you want to transfer?

Are you just making a wordpress theme for somebody, or a total new website?

 

I want to move everything.

I started the WP site in a folder on a domain on one server and I want to move to a different domain on a different server.

 

move your entire folder. Import your database use PHPmyAdmin. And finally change your wpconfig.php on your wordpress blog.configure it to point your new database.
hope this help.

 

Thanks but when I try to import NOW i get this error instead:

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:190) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/ob.lib.php on line 83


Any suggestions?