khaus Posted February 9, 2007 Share Posted February 9, 2007 What a mess. :'( I have a thousand items to add to my store and I though using EP would be smart, So i made a backup of my site and then uploaded the changes via EP - This is where I made a mess. The EP was sucessful, but i need to erase my errors and start over, now that i understand how EP works. Under the Tools section, i've chosen the backup and selected restore >>>>waiting, waiting..>>>> Well went to the store and nothing changed!!!!! So tried a different route Downloaded the backup to my computer, yes it SQL, and under Tools> Restore> navigated to the file and uploaded it>>>> waiting, waiting>>>> Went to the store and nope it's not there - Well crap. Tried the same steps with an older backup version, with NO success. If someone could point out what I'm doing wrong it would be GREATLY appreciated. Thank you. Link to comment Share on other sites More sharing options...
Velveeta Posted February 9, 2007 Share Posted February 9, 2007 What a mess. :'( I have a thousand items to add to my store and I though using EP would be smart, So i made a backup of my site and then uploaded the changes via EP - This is where I made a mess. The EP was sucessful, but i need to erase my errors and start over, now that i understand how EP works. Under the Tools section, i've chosen the backup and selected restore >>>>waiting, waiting..>>>> Well went to the store and nothing changed!!!!! So tried a different route Downloaded the backup to my computer, yes it SQL, and under Tools> Restore> navigated to the file and uploaded it>>>> waiting, waiting>>>> Went to the store and nope it's not there - Well crap. Tried the same steps with an older backup version, with NO success. If someone could point out what I'm doing wrong it would be GREATLY appreciated. Thank you. In your post, you say twice "waiting, waiting"... but you never say what happens... Does it ever complete, or do you give up prematurely and go to check the store, or do you cancel it outright and go to check the store, or what? Have you verified the contents of that sql file to make sure it looks as it should? As a last resort, you can try emptying the tables manually... If EP created the category entries for you as well as the products, then you'll want to empty both the categories* tables, and the products* tables, if you had to create the categories yourself, then just empty the products* tables... Richard. Richard Lindsey Link to comment Share on other sites More sharing options...
khaus Posted February 15, 2007 Author Share Posted February 15, 2007 Sorry, It just times out. I'll let it go for an hour/or two, then there will be an error message, saying: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Apache/1.3.37 Server at www.website.com Port 80 Is there a way to break up the SQL file and restore I've tried restoring from the back up SQL on the server and uploading locally Link to comment Share on other sites More sharing options...
Guest Posted February 15, 2007 Share Posted February 15, 2007 Sorry, It just times out. I'll let it go for an hour/or two, then there will be an error message, saying: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. Apache/1.3.37 Server at www.website.com Port 80 Is there a way to break up the SQL file and restore I've tried restoring from the back up SQL on the server and uploading locally Ask your host to restore your file using SSH. They can kick it off from the command line. $ mysql -u username -p --database=dbname < dump.sql Corrina Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.