girodisc martin Posted January 11, 2005 Posted January 11, 2005 Hello to all, I've searched this forum many, many times for answers and have always been able to help myself along. Thank you to everyone for so much valuable information! I am not a programmer or code master by any means but I managed to start an oscommerce cart on my site and have even had many successful transactions. I use ipowerweb for my host and have recently run into issues with backing up my store. It seems there are backups within OSC and backups in the vdeck GUI of ipowerweb. I have done both and now can not seem to get my backup restored. I made a .tar.gz backup of the entire site using the vdeck backup. I can uncompress it and can see the .gif and .jpeg of all my products. I know the database is in there but when I do the restore is says it is complete but the site does not show this. Bottom line, I have many products I would rather not re-enter into the data base. Is there some way of just uploading the database again from my backup? Where is it located in the file structure? From now on I will be FTP downloading my entire site, everything, and storing it on my computer. This is the only way I can be sure of having everything. I can just delete my entire host/home directory and upload the files and presumably be online again. Do you have other suggestions? Last but not least, through all this fussing around, my login screen now appears to be jacked up!! Have a look and tell me what it could be. It still works but all the images and such are missing etc. www.girodisc.com/catalog Thank you very much to those who can help, Martin Meade
hel8itch Posted January 11, 2005 Posted January 11, 2005 when iv had to restore databases either for my forum or oscommerce if iv ever had problems i just drop the tables then re-ad them from the backup file. are you using phpmyadmin? if you backed up your files using the oscommerce admin control panel they may be in the same place as mine /public_html/admin/
hel8itch Posted January 11, 2005 Posted January 11, 2005 if you have phpmyadmin you can also try the repair to fix faulty tables,
girodisc martin Posted January 11, 2005 Author Posted January 11, 2005 Hi and thanks for your reply, I notice the backups created with OSC are in a .sql format. This is for the database. I need to know where to find the .sql file in my whole site backup so I can replace it. Don't know if it's that simple. Does the .sql contain the pictures, descriptions, prices and everything? Thanks Martin
Guest Posted January 11, 2005 Posted January 11, 2005 did you backup the original from either phpmyadmin or the admin/tools/backup?
♥Vger Posted January 11, 2005 Posted January 11, 2005 If you are scheduling whole-site backups from your web hosting control panel then this includes EVERYTHING - control panel settings, e-mail addresses, all of the website, the database etc. If you are trying to Restore from your web hosting control panel (this is a known problem with some panels) it will not restore the database, because there is already a database in existence and it won't overwrite it. So, take a backup of the database from the mysql folder of your site, and then delete it - then run the Restore from your web hosting control panel. Vger
girodisc martin Posted January 12, 2005 Author Posted January 12, 2005 I did the site backup from the web hosting control panel. If I uncompress it I can see the images at least of all the products in there. I assume the text, prices, code etc. is there as well. This is an interesting idea Vger. I will backup the existing, smaller database using the OSC backup utility and the web host control panel. I will then delete the database using the web host control panel. Finally, I'll run the whole site backup through the web host control panel and hopefully this will restore the DB as well. Fingers crossed... any thoughts on my login page issue?
♥Vger Posted January 12, 2005 Posted January 12, 2005 I meant for you to take a backup of the database by downloading a copy of it. If you back it up using the osCommerce backup facility and then you do a full site restore from your hosting control panel using a previous whole-site backup then you'll overwrite the database backup in osCommerce and lose it. Vger I did the site backup from the web hosting control panel.? If I uncompress it I can see the images at least of all the products in there.? I assume the text, prices, code etc. is there as well.? This is an interesting idea Vger.? I will backup the existing, smaller database using the OSC backup utility and the web host control panel.? I will then delete the database using the web host control panel.? Finally, I'll run? the whole site backup through the web host control panel and hopefully this will restore the DB as well.? Fingers crossed... any thoughts on my login page issue? <{POST_SNAPBACK}>
girodisc martin Posted January 12, 2005 Author Posted January 12, 2005 I did a backup using OSC and downloaded it to my computer. No problem there. I went into myphpadmin and got rid of all the database stuff. Shot myself right in the foot. I did the full site backup and everything is good for my website but the OSC stuff is gone, admin and all. I'm really lost now...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.