mickapoo Posted February 22, 2005 Share Posted February 22, 2005 I have backed up my database, and tried saving a copy both on the server and on my local hard drive. After backing up, I then made a change to one of the products. Then I went and used the 'restore' function, and went back to the product to see if it was restored back to it's original state- it wasn't. I tried this 6 or 7 times. I have no idea what can be wrong. I checked the permission on the backup dir and it's set at 777. Can anyone offer any trouble shooting tips? Thank you in advance! Link to comment Share on other sites More sharing options...
WiseWombat Posted February 22, 2005 Share Posted February 22, 2005 I have backed up my database, and tried saving a copy both on the server and on my local hard drive. After backing up, I then made a change to one of the products. Then I went and used the 'restore' function, and went back to the product to see if it was restored back to it's original state- it wasn't. I tried this 6 or 7 times. I have no idea what can be wrong. I checked the permission on the backup dir and it's set at 777. Can anyone offer any trouble shooting tips? Thank you in advance! <{POST_SNAPBACK}> Did you install the correct backup file and have you tried the back up on your localhost to see if the problem happens there as well. If you have a copy on your hard drive may be you could upload the file to the server and replace it and then try reinstalling the backup? ( WARNING ) I think I know what Im talking about. BACK UP BACK UP BACK UP BACK UP Link to comment Share on other sites More sharing options...
mickapoo Posted February 22, 2005 Author Share Posted February 22, 2005 Did you install the correct backup file and have you tried the back up on your localhost to see if the problem happens there as well.If you have a copy on your hard drive may be you could upload the file to the server and replace it and then try reinstalling the backup? <{POST_SNAPBACK}> Thanks for the response. I do have a correct backup file, but if by localhost you mean on my own pc, no, I have not. Unfortunately I don't have anything (web server, php, osCommerce) on my own computer, it's all just on the web hosting's server. I just saved a copy of the db on my hard drive so I can use that to restore it on the website. I'm not sure what you mean by "upload the file to the server and replace it and then try reinstalling the backup". ... I did use the "restore" command, and it prompted me to upload the file from my hard drive, which I did. Thank you! Link to comment Share on other sites More sharing options...
WiseWombat Posted February 22, 2005 Share Posted February 22, 2005 I'm not sure what you mean by "upload the file to the server and replace it and then try reinstalling the backupThank you! <{POST_SNAPBACK}> When you create a back up on the server it gives you an option to save your backup. as (do not store server side)* this file will be downloaded to you from the server. OR No compression Pure SQL <!--- this is the file that is stored on the server --> If you down loaded from the server to you, you can then upload the file back to the server and then run the backup. But since you dont have a back up on your hard drive you might want to select an earlier backup from the server to install but remember you might loose some data. I suggest you always save to your server and also to your self for just this type of thing it will get you out of trouble. ( WARNING ) I think I know what Im talking about. BACK UP BACK UP BACK UP BACK UP Link to comment Share on other sites More sharing options...
radders Posted February 22, 2005 Share Posted February 22, 2005 Sometimes there is a limit in the size of backup that can be restored. When creating a copy of my database on my pc I noticed that the limit was tiny - only around 16MB. If your backup is larger it may not load. I don't know if this also affect osC restore routine. I noticed it on phpmyadmin. Also it timed out after a much shorter time than was set in php.ini. There is a script around that is supposed to load larger files in chunks but I couldn't get it to work. Link to comment Share on other sites More sharing options...
mickapoo Posted February 22, 2005 Author Share Posted February 22, 2005 When you create a back up on the server it gives you an option to save your backup. as (do not store server side)* this file will be downloaded to you from the server. OR No compression Pure SQL <!--- this is the file that is stored on the server --> If you down loaded from the server to you, you can then upload the file back to the server and then run the backup. But since you dont have a back up on your hard drive you might want to select an earlier backup from the server to install but remember you might loose some data. I suggest you always save to your server and also to your self for just this type of thing it will get you out of trouble. <{POST_SNAPBACK}> Yes, I have chosen to do both. I have a backed up copy on my pc and also on the server. I tried running the 'restore' function from both my pc and the file on the server. Neither one seems to be taking. Link to comment Share on other sites More sharing options...
mickapoo Posted February 22, 2005 Author Share Posted February 22, 2005 Sometimes there is a limit in the size of backup that can be restored. When creating a copy of my database on my pc I noticed that the limit was tiny - only around 16MB. If your backup is larger it may not load. I don't know if this also affect osC restore routine. I noticed it on phpmyadmin. <{POST_SNAPBACK}> My backup was about 6 megs. Thank you. Link to comment Share on other sites More sharing options...
John Holmes Posted February 22, 2005 Share Posted February 22, 2005 My backup was about 6 megs. Thank you. <{POST_SNAPBACK}> Same there. The god damn thing won't restore. I tried both the compressed and non-compressed file to be restored and it just fails. I do notice one thing and others maybe want to look into this. *.CORE files are created ... looks like just junk or temporary files are created in the /catalog/admin/includes directory I believe or one of those directories. They are pretty big files so you may want to delete them. I think the only way to really restore your database is to copy the zipped or uncompressed files onto your local hard drive and then use phpMyAdmin to restore them. Just make sure you aren't using dial up when doing this. Link to comment Share on other sites More sharing options...
WiseWombat Posted February 23, 2005 Share Posted February 23, 2005 Yes, I have chosen to do both. I have a backed up copy on my pc and also on the server. I tried running the 'restore' function from both my pc and the file on the server. Neither one seems to be taking. <{POST_SNAPBACK}> My be you do not have full access to this function through your server??? Limited access only ?? ( WARNING ) I think I know what Im talking about. BACK UP BACK UP BACK UP BACK UP Link to comment Share on other sites More sharing options...
Guest Posted February 23, 2005 Share Posted February 23, 2005 If you have a shell account (or other ways to execute commands, like phpshell or cron support), you can also use the "mysql" command to restore the database. It's like this: mysql -u [username] -p [password] [database_to_restore] < [backupfile] (quoted from an *excellent* article on this topic at http://www.devshed.com/c/a/MySQL/Backing-u...MySQL-Database/ -jared Link to comment Share on other sites More sharing options...
mickapoo Posted February 23, 2005 Author Share Posted February 23, 2005 Thanks for all of the help everyone! I think I'll just use phpMyAdmin to restore as suggested earlier. I have full access, but it just isn't working through the osCommerce cpanel. Thanks again! Link to comment Share on other sites More sharing options...
bigbuck Posted February 23, 2005 Share Posted February 23, 2005 did you rename your ADMIN file, to something else? When i renamed mine, i forget to change one line,lol. Went to back up and what the heck... Just a suggestion, i'm by no means a programing guru mike 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.