Restore any size SQL backup using phpMyAdmin

[pipsteal]

hi this is bala, when i m try to do this same procedure, it ll send some error as follows.

Error
SQL query:

INSERT INTO `newtbl_action`
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 'PRIMARY'

please give me some solution for this.. thanks
bala

[Zylantex]

Originally Posted by Zylantex

If for any reason the process does timeout simply restart the whole process and pick a smaller file size in Step 4.

That should sort it out for you as it drops an re-creates all the tables. Don't forget to make sure the forum is not in use. In particular make sure you are not using the forum yourself in another tab.