[Solved] After backup database, if I want to us the backup one, what do I need to do?

[seldon.paul2]

We have to move the server, so we backup the DB, myShopBackup.sql.gz.

With that backup, we need to put into the new server and run, right?
What do I need to do and how can I do it?

Mega-Thanks in Advance -

[rocky]

PrestaShop doesn't have the option to restore a backup. You must manually log in to phpMyAdmin and choose the Import option. Make sure you've backed up your entire database first, in case anything goes wrong.

[presta-dyr]

For some shops the database is just too big to use the PrestaShop backup and/or phpMyAdmin. If your server supports remote access to the SQL service (not all do) you can use the mysql command directly. On Windows you can install the Cygwin package to get the mysql commands. On Linux you probably have the commands installed already. You can find examples of how to use the commands here.

/Kjeld

[tomerg3]

I have created a backup module for Prestashop that lets you

* Create a back of the Database and Files
* Send a copy of the backup to an email address and/or keep it on the server
* Set times for automatic backup.
* Restore the database with 1 click

Read more at http://www.prestashop.com/forums/viewthread/55766/

[theme_designer]

Just go to you admin Cpanel. Use their "backup" wizard to backup your site. Then move it to other hosting.

[seldon.paul2]

Super mega thanks -