Guest Posted November 11, 2005 Share Posted November 11, 2005 Hi I have a very big problem! I was looking at backup up and Restore options in cPanel. I backed up one of my SQL databases, the important one and then just tried a Restore by selecting Restore my SQL Database, browsed the file I had backed up then Uploaded! Now I haven’t done this before so did expect some sort of confirmation! But it just went ahead and restored which worried me. But I didn’t think it would have done any harm! But it has. It displayed the following on opening a new browser: Restoring Database -------------- DROP TABLE IF EXISTS CubeCart_Downloads -------------- -------------- CREATE TABLE CubeCart_Downloads ( id int(11) NOT NULL auto_increment, customerId int(11) NOT NULL default '0', cart_order_id varchar(32) NOT NULL default '', noDownloads int(11) NOT NULL default '0', expire int(11) NOT NULL default '0', productId int(11) NOT NULL default '0', accessKey varchar(10) NOT NULL default '', KEY id (id) ) TYPE=MyISAM etc etc etc… -------------- Now when I run my shopping cart software and get so far through the Order process and then the following error is displayed: MySQL Error Occured 1146: Table 'shop_BlaBla.CubeCart_Modules' doesn't exist QUERY = SELECT folder FROM CubeCart_Modules WHERE module='shipping' AND status = 1 Looks like the backup or restore has missed out a table at least. My knowledge is very limited with SQL so sorry if this is a simple one but I do not no how to fix this without help? Need help urgent please??? Thanx in advance Quote Link to comment Share on other sites More sharing options...
Guest wowgold4u Posted November 12, 2005 Share Posted November 12, 2005 Hey man goto the area in the DB where it says missing file.. and do this lol its like a slackers way but reinstall Cubecart in a different folder and make a new database.. and then take this DB entry you are missing from the previous one and put it in place.. Quote Link to comment Share on other sites More sharing options...
Guest Posted November 12, 2005 Share Posted November 12, 2005 (edited) Cheers for reply man I think I'll need a bit more of a step by step as not done this before! So 1st I need to know what tools I need then do I do this via cPanel or what? Cheers Done a check in cPanel Looks like just CubeCart_Modules is missing!! Understand your advice but need some pointers on how to edit the database etc...? Cheers Edited November 12, 2005 by Jabba Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.