iGuest 3 Report post Posted February 9, 2005 When I'm trying to restore a backup on my php nuke site this comes up:Error importing backup fileDEBUG MODESQL Error : 1050 Table 'nuke_authors' already existsCREATE TABLE nuke_authors ( aid varchar(25) NOT NULL, name varchar(50), url varchar(255) NOT NULL, email varchar(255) NOT NULL, pwd varchar(40), counter int(11) DEFAULT '0' NOT NULL, radminsuper tinyint(1) DEFAULT '1' NOT NULL, admlanguage varchar(30) NOT NULL, PRIMARY KEY (aid), KEY aid (aid) )Line : 1017File : /home/roman/public_html/home/modules/Forums/admin/admin_db_utilities.php Share this post Link to post Share on other sites
iGuest 3 Report post Posted February 9, 2005 SQL Error : 1050 Table 'nuke_authors' already exists Your back-up wants to create the table nuke_authors but he alreasy existsso you open your file and remove the line that says such as: CREATE table Nuke_authors or something.I think that is the problem. Share this post Link to post Share on other sites
iGuest 3 Report post Posted February 9, 2005 Open what file..... Share this post Link to post Share on other sites
iGuest 3 Report post Posted February 10, 2005 your back-up file Share this post Link to post Share on other sites
iGuest 3 Report post Posted February 11, 2005 try this first it may help but i can never re enter a back up file with nuke. Goto your mysql then phpmyadmin. Click the database name then when it comes up click the check all button at the bottom, then drop the drop down on the right and click drop, this will clear everything in your database, then get your backup and run the sql on the database with your backup file it should work then if youve understood this, sorry i try to explain it the best i can. Share this post Link to post Share on other sites