Jump to content

backup previous data base


Recommended Posts

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 by Bill Dalton (see edit history)
Link to comment
Share on other sites

  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`
(
10
)
UNSIGNED
NULL
,

`id_tab`
(
10
)
UNSIGNED
NULL
,

`view`
(
11
)
NULL
,

`add`
(
11
)
NULL
,

`edit`
(
11
)
NULL
,

`delete`
(
11
)
NULL
,

PRIMARY
KEY
(
`id_profile`
,
`id_tab`
)

)ENGINE=MYISAMDEFAULTCHARSET=utf8;

 

 

 

MySQL said:

#1046 - No database selected

Link to comment
Share on other sites

  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`
(
10
)
UNSIGNED
NULL
,

`id_tab`
(
10
)
UNSIGNED
NULL
,

`view`
(
11
)
NULL
,

`add`
(
11
)
NULL
,

`edit`
(
11
)
NULL
,

`delete`
(
11
)
NULL
,

PRIMARY
KEY
(
`id_profile`
,
`id_tab`
)

)ENGINE=MYISAMDEFAULTCHARSET=utf8;

 

 

 

MySQL said:

#1046 - No database selected

Link to comment
Share on other sites

  • 1 month later...

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

×
×
  • Create New...