MySQL Forums
Forum List  »  Other Migration

Uploading database through Godaddy problem
Posted by: Michael lee
Date: May 31, 2011 06:16AM

Hi Guys,

My website has been down for a while now and Godaddy's support team has been awful about helping me fix the issue. I have managed to get to the final stage where i need to upload my database but i keep getting errors when i try it through Godaddy. Errors like this:

"Error

SQL query:

--
-- Database: `coo1105306140277`
--
-- --------------------------------------------------------
--
-- Table structure for table `wp_amazoncache`
--
CREATE TABLE `wp_amazoncache` (
`Cache_id` int( 10 ) NOT NULL AUTO_INCREMENT ,
`URL` text NOT NULL ,
`updated` datetime default NULL ,
`body` text,
PRIMARY KEY ( `Cache_id` ) ,
UNIQUE KEY `URL` ( `URL` ( 255 ) ) ,
KEY `Updated` ( `updated` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;

MySQL said: Documentation
#1050 - Table 'wp_amazoncache' already exists "

Godaddy told me i needed to change the name of the table? I attempted this but it still didnt work. Plus if that is the way to resolve this then i certainly dont have the patience to scan through the whole databse and edit every single name.

P.S. This happened after a failed wordpress upgrade in which i exported the database and re-installed wordpress in hope of keeping all the content of my website. Up until now Godaddy gave me quite a lot of help but have failed to help with the database.

Thanks,
-Michael

Options: ReplyQuote


Subject
Views
Written By
Posted
Uploading database through Godaddy problem
5005
May 31, 2011 06:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.