Forum DataBase Upload Error

[K!nG]

Hi Everyone.

Recently someone delete my forum directory from cpanel and i requested a backup from hosting company now i had a latest backup of database that i needed to upload so when i try doing that. I am getting this error.

If someone can help me will b appreciated...

Thanks


Error
SQL query:

--
-- Dumping data for table `action`
--
INSERT INTO `action` ( `actionid` , `routeid` , `packageid` , `controller` , `useraction` , `classaction` )
VALUES ( 1, 1, 3, 'Content', 'view', 'View' ) , ( 2, 1, 3, 'Content', 'edit', 'EditPage' ) , ( 3, 1, 3, 'Content', 'editcontent', 'EditContent' ) , ( 4, 1, 3, 'Content', 'configcontent', 'ConfigContent' ) , ( 5, 1, 3, 'Content', 'addcontent', 'AddNode' ) , ( 6, 1, 3, 'Content', 'deletecontent', 'DeleteNode' ) , ( 7, 1, 3, 'Content', 'publish', 'PublishNode' ) , ( 8, 1, 3, 'Content', 'options', 'NodeOptions' ) , ( 9, 1, 3, 'Widget', 'viewwidget', 'View' ) , ( 10, 1, 3, 'Widget', 'configwidget', 'Config' ) , ( 11, 1, 3, 'Widget', 'configeditor', 'ConfigEditor' ) , ( 12, 1, 3, 'Widget', 'editwidget', 'Edit' ) , ( 13, 2, 3, 'BaseWidget', 'config', 'Config' ) , ( 14, 2, 3, 'BaseWidget', 'edit', 'Edit' ) , ( 15, 3, 3, 'Editor', 'switch', 'SwitchMode' ) , ( 16, 3, 3, 'Editor', 'tableoverlay', 'TableOverlay' ) , ( 17, 4, 3, 'List', 'list', 'List' ) , ( 18, 1, 3, 'Content', 'rate', 'Rate' ) ;


MySQL said:

#1062 - Duplicate entry '1' for key 1

[Lynne]

You need to create a new database and upload the backup into it, not upload the backup over the existing one.

[K!nG]

should i give it any name and do i have to change the database name in php aswel ? once i upload this one should i delete old one ?

[Lynne]

Give it any name your want, but you will need to put the new name in your config.php file. Also, make sure to grant the mysql user all permissions to the database.

[K!nG]

Thanks Lynne... Let me give it a shot n see if that works.

--------------- Added [DATE]1304655099[/DATE] at [TIME]1304655099[/TIME] ---------------

Hi Lynne,

I have created new database uploaded it .... & made changes in php aswel but now when i go to forum.. this is wat i get on page.

Database error
The database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www.XXXXXX.com home page, then try to open another page.
Click the Back button to try another link.
The www.XXXXXX.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

--------------- Added [DATE]1304658466[/DATE] at [TIME]1304658466[/TIME] ---------------

I figured out wat was wrong but still my forum is all scrambled and messy it doesn't show any images any clue ?? anyone ??