cronjob78 Posted February 21, 2008 Posted February 21, 2008 Im building a new shop on a new server. The old shop was 2003 software and I have backed up and saved the database to my hardrive (I dont have access to the old server via SSH or SQL). Im trying to restore/upload the old database to the new shop but after a few minutes the restore/backup page just returns to its default state and no changes are made to the database. It might be down to some settings on my server that wont allow oscommerce to put the database on my server (other apps like uploading pictures work fine). Any help greatly appreciated. this would save me adding 400 products manually...
Jan Zonjee Posted February 21, 2008 Posted February 21, 2008 Im trying to restore/upload the old database to the new shop but after a few minutes the restore/backup page just returns to its default state and no changes are made to the database. Try Bigdump for restoring the backup. osC first reads the whole backup in memory before starting on the restore. With a reasonable sized shop this will exhaust memory and/or will get stuck on time outs.
hari_shyam Posted February 21, 2008 Posted February 21, 2008 Im building a new shop on a new server. The old shop was 2003 software and I have backed up and saved the database to my hardrive (I dont have access to the old server via SSH or SQL). Im trying to restore/upload the old database to the new shop but after a few minutes the restore/backup page just returns to its default state and no changes are made to the database. It might be down to some settings on my server that wont allow oscommerce to put the database on my server (other apps like uploading pictures work fine). Any help greatly appreciated. this would save me adding 400 products manually... how re you uploading the database ? using some server utility or using a admin-backup utility ? did you try any other ways to upload the same.. Regards Hari
cronjob78 Posted February 21, 2008 Author Posted February 21, 2008 how re you uploading the database ? using some server utility or using a admin-backup utility ? did you try any other ways to upload the same.. Regards Hari Thanks for the reply. Im trying to upload it though the 'database backup' page (clicking on restore) in admin. Ideally I'd like to get the seperate SQL files (MYI etc) from the old server but I dont have SSH access to it. Should there be a success message when a database is successfully restored? Mine just does nothing and reverts back to the default view for the 'database backup' page.
satish Posted February 21, 2008 Posted February 21, 2008 Try PhpMYAdmin to uplaod. Satish Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does.
hari_shyam Posted February 21, 2008 Posted February 21, 2008 Thanks for the reply. Im trying to upload it though the 'database backup' page (clicking on restore) in admin. Ideally I'd like to get the seperate SQL files (MYI etc) from the old server but I dont have SSH access to it. Should there be a success message when a database is successfully restored? Mine just does nothing and reverts back to the default view for the 'database backup' page. well normally it should display a message on the top when you restore the backup.. anyways to be double sure.. you can just try the phpmyadmin way too. Cheers Hari
Jan Zonjee Posted February 21, 2008 Posted February 21, 2008 Im trying to upload it though the 'database backup' page (clicking on restore) in admin. Better upload it with ftp to the backup directory and do the restore from there. There is no error catching in the restore through uploading when PHP does not read the temporary file after the upload. PHP might not let you read that temporary file.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.