scottrotton Posted September 5, 2012 Share Posted September 5, 2012 Hi Guys im new to presta shop but im trying to restore my DB to a new site. im using these instructions How-to restore a database Backup in 10 easy steps Turn off the "Enable Shop" option in the "Preferences" tab. Download the Backup from the list below or from your FTP server (in the folder "admin/backups"). Check the Backup integrity: look for errors, incomplete file. Verify all your data. Ask your hosting provider for a "phpMyAdmin" access to your database Connect to "phpMyAdmin" and select your current database Unless you enabled the "Drop existing tables" option, you must delete all tables from your current database. At the top of the screen select the tab "Import" Click on the "Browse..." button and select the Backup file from your hard drive Check the max. allowed filesize (ie. Max: 16Mb) If your Backup file exceeds this limit, contact your hosting provider Click on the "Go" button and wait during the import, the process can take several minutes im getting this error when trying to restore SQL query: /* Scheme for table ps_emailmaster */ DROP TABLE IF EXISTS `ps_emailmaster` ; MySQL said: #1217 - Cannot delete or update a parent row: a foreign key constraint fails am i doing something wrong? Link to comment Share on other sites More sharing options...
scottrotton Posted September 6, 2012 Author Share Posted September 6, 2012 anyone had this issue at all? or is there a module backup I can buy? Link to comment Share on other sites More sharing options...
itcwebman Posted September 6, 2012 Share Posted September 6, 2012 scotttrotton I would do this via phpMyAdmin, it's easier and less chance of anything going wrong. Save your database as SQL and then you can import into your new one. This may help: http://doc.prestashop.com/display/PS14/Updating+PrestaShop see about 1/4 of the way down for details on backing up Link to comment Share on other sites More sharing options...
Rhapsody Posted September 6, 2012 Share Posted September 6, 2012 Yes I had this too, but Phasespot the developer of Emailmaster posted a fix in this post. That should fix your problem. Link to comment Share on other sites More sharing options...
scottrotton Posted September 7, 2012 Author Share Posted September 7, 2012 Thanks everyone I will try this now, and come back if it doesnt work, thanks again one other though, does anyone know of a way to create a cron job that backups up using phpmyadmin each night? Link to comment Share on other sites More sharing options...
itcwebman Posted September 7, 2012 Share Posted September 7, 2012 Can't say I do, it would be useful to know as well. I guess google must have something, I will look Link to comment Share on other sites More sharing options...
Recommended Posts