sportsfanaticsgifts Posted February 9, 2013 Share Posted February 9, 2013 Hello I accidentally deleted some links on my website and want to restore them. I found the last database file I backed up yesterday. How do I upload that file to my current website to restore these Link to comment Share on other sites More sharing options...
Bill Dalton Posted February 9, 2013 Share Posted February 9, 2013 (edited) In PS 1.4X go to BO > Tools > DB Backup In PS 1.5X go to BO > Advanced Parameters > DB Backup Make another backup! How-to restore a database Backup Ask your hosting provider for a "phpMyAdmin" access to your database Turn off the "Enable Shop" option in the "Preferences" tab 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 Edited February 9, 2013 by Bill Dalton (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted February 9, 2013 Share Posted February 9, 2013 hi @sportsfanaticsgifts does @Bill Dalton solution works for you? I hope so! His know-how is the best way to restore databases Link to comment Share on other sites More sharing options...
sportsfanaticsgifts Posted February 9, 2013 Author Share Posted February 9, 2013 On 2/9/2013 at 5:06 AM, Bill Dalton said: In PS 1.4X go to BO > Tools > DB Backup In PS 1.5X go to BO > Advanced Parameters > DB Backup Make another backup! How-to restore a database Backup Ask your hosting provider for a "phpMyAdmin" access to your database Turn off the "Enable Shop" option in the "Preferences" tab 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 Hello I tried your option and received the following error message Error SQL query: /* Scheme for table ps_access */ CREATE TABLE `ps_access` ( `id_profile` INT( 10 ) UNSIGNED NOT NULL , `id_tab` INT( 10 ) UNSIGNED NOT NULL , `view` INT( 11 ) NOT NULL , `add` INT( 11 ) NOT NULL , `edit` INT( 11 ) NOT NULL , `delete` INT( 11 ) NOT NULL , PRIMARY KEY ( `id_profile` , `id_tab` ) )ENGINE=MYISAMDEFAULTCHARSET=utf8; MySQL said: #1046 - No database selected Link to comment Share on other sites More sharing options...
sportsfanaticsgifts Posted February 10, 2013 Author Share Posted February 10, 2013 On 2/9/2013 at 3:12 PM, vekia said: hi @sportsfanaticsgifts does @Bill Dalton solution works for you? I hope so! His know-how is the best way to restore databases Everything worked ok until I hot go and recieved the following error message SQL query: /* Scheme for table ps_access */ CREATE TABLE `ps_access` ( `id_profile` INT( 10 ) UNSIGNED NOT NULL , `id_tab` INT( 10 ) UNSIGNED NOT NULL , `view` INT( 11 ) NOT NULL , `add` INT( 11 ) NOT NULL , `edit` INT( 11 ) NOT NULL , `delete` INT( 11 ) NOT NULL , PRIMARY KEY ( `id_profile` , `id_tab` ) )ENGINE=MYISAMDEFAULTCHARSET=utf8; MySQL said: #1046 - No database selected Link to comment Share on other sites More sharing options...
Bill Dalton Posted February 10, 2013 Share Posted February 10, 2013 Try using phpadmin to drop your tables first. Alternativly delete the database and create a new database of the same name prior to running the import. Hope this helps. You do have a couple of backups, so hopefully you are ok. Link to comment Share on other sites More sharing options...
toninovak66 Posted April 10, 2013 Share Posted April 10, 2013 Be careful depending on Prestashop to do your DB backups for you. I did that and now I can't restore it because I get this error message: Error There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem ERROR: Unknown Punctuation String @ 5 STR: /> SQL: <br /> <b>Notice</b>: ob_clean() [<a href='ref.outcontrol'>ref.outcontrol</a>]: failed to delete buffer. No buffer to delete. in <b>/home/bestbuyuniforms/bestbuyuniforms.com/18admin_hb/backup.php</b> on line <b>68</b><br /> BZh91AY&SYǠ�l ________________________________________ q"_�p0{�����������c`�H��ύ����﮹�^t% ׅ]���1�;���3��N��[i�iB}��o �:� [1]��@ ________________________________________ Nl � ________________________________________ � �@ � � [1]�� ________________________________________ ��h�sb�����)4�P�x ________________________________________ � 1ah� �"��� �5U�n@32�(ِ�[1]�}e0MU �l` *���H ���E �`Y�4 6Q�T ________________________________________ % V)@[1]T���; SQL query: <br /> <b>Notice</b>: ob_clean() [<a href='ref.outcontrol'>ref.outcontrol</a>]: failed to delete buffer. No buffer to delete. in <b>/home/bestbuyuniforms/bestbuyuniforms.com/18admin_hb/backup.php</b> on line <b>68</b><br /> BZh91AY&SYǠ�l ________________________________________ q"_�p0{�����������c`�H��ύ����﮹�^t% ׅ]���1�;���3��N��[i�iB}��o �:� [1]��@ ________________________________________ Nl � ________________________________________ � �@ � � [1]�� ________________________________________ ��h�sb�����)4�P�x ________________________________________ � 1ah� �"��� �5U�n@32�(ِ�[1]�}e0MU �l` *���H ���E �`Y�4 6Q�T ________________________________________ % V)@[1]T���; MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<br /> <b>Notice</b>: ob_clean() [<a href='ref.outcontrol'>ref.outcontrol</a>]:' at line 1 My DB guy said that the error message is actually embedded into the SQL. He tried to extract the SQL file but that didn't work so we are basically out of luck with restoring from either of the backup files I did. It would be best to use phpmyadmin or SSH to create the backup DB. Link to comment Share on other sites More sharing options...
Recommended Posts