Backup and Restore your Database using MyPHp Admin

[bjones]

Here is a little tip on how to backup and restore your PrestaShop database. This worked for me, and is meant for those that are not too savvy with PrestaShop. Some of you may already know how to do this.

Is simple windows file management. Please backup your database before proceeding.

Follow these Steps

1. In the Admin Panel Select > Tools > DB backup
2. The DB backup screen will come up. Click the green icon "Create new backup"
3. A backup will be created. LOG OFF from your admin.
4. In Windows Explorer, go to your Admin directory and find the Backups Directory. There you will find files with the .gz extension. These are nothing more than zipped files.
5. Sort them according to date so you can unzip the latest backup. I use Winrar. Extract the file in the same directory.
6. Go to your PhpAdmin and under the Databases tab select the prestashop DB and drop it. (Delete it)
7. A confirmation will appear. Once you select OK it will be gone for ever.
8. While in the same Tab, create a new database.
9. Select the Imports Tab and select the Browse button to select the DB to import. Find it where you extracted the .sql file.
10. Select the file and hit the Go button.
11. Wala! The old database is imported into your new one.
12. Log back in to your shop and all of your items are there!

If this doesn't work for you or something is missing or wrong please let me know.

I hope I was able to help someone.

PS This is for a database that has not been uploaded to your server! I'm using my localhost in my computer. But I don't see why it wouldn't work on a live server.

[FireHawk]

I maybe just being thick here but i need some help.

Tried updating to the latest release and all went wrong.
Deleted all files and re-uploaded my back-up copy i had made beforehand.
Now all my products are gone.

Tried your plan to restore database and i just get lost.

I have extracted the sql file and within the BO uploaded it.
But i have to then import it right?
Well, what option do i choose? "Select which entity to import: " ie, product or catagory etc.
Just doesnt make sence to me anymore.

Please, anyone who can help as i am losing the will to live now

[FireHawk]

Phew!
Finally restored the database.
Not quite sure what i did as when i was uploading the .sql file it failed as the connection was reset.
Checked my store and everything was there again.

Just wish i knew exactly what it did so i could comment to help any others that were struggling too.

[malcek]

Hi,
I have a problem after importing in local (TESTING) DATABASE. I cant log in to admin section. When I look in MYPHPadmin under employee I see users with e-mail and on field password there is only (f71a441e408b2ae05663d1c3547793a4). How can I solve this?

Martin