blueair Posted May 7, 2011 Share Posted May 7, 2011 There is a 'DB backup' tool in the BO (or alternatively phpMyAdmin export can be used), but there is not 'DB restore' in BO (?)So how do i import an entire db if the actual one gets corrupt ?Thanksedit:i'm trying to import a db into one (localhost) test prestashop exported from another (server) test prestashop. Link to comment Share on other sites More sharing options...
shokinro Posted May 7, 2011 Share Posted May 7, 2011 You can use the backup file exported from PrestaShop to import it into a new database via database tool, such as PhpMyAdmin.The backup file is just a bunch of SQL statement. Please make sure 1 .you have choose to back up all tables, because by default it will skip some tables.2. If you are using 1.4 and you are importing to different server. After import, you need to change two configuration records that related domain name,Check my blog here for more detail on domain name changes. Link to comment Share on other sites More sharing options...
blueair Posted May 7, 2011 Author Share Posted May 7, 2011 hmm could you please explain which steps in phpMyAdmin i should take..i want to import the db from my domain server to the ps installed on my localhost (the first has only a few test products, the second contains just original testing products from the ps installation).i went to 'mydatabase' in phpMyAdmin on the localhost, selected 'import' (selected sql file exported by phpMyAdmin of the PS from the domain server, and it stuck there..the both db'ses have the same name.thanksedit: Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\sqlparser.lib.php on line 525 maybe i should delete the old db first, but to what i import the new one then ? Link to comment Share on other sites More sharing options...
shokinro Posted May 7, 2011 Share Posted May 7, 2011 yes, you need to empty the database before run the import. Link to comment Share on other sites More sharing options...
blueair Posted May 7, 2011 Author Share Posted May 7, 2011 after emptying the db i succeeded to import the new one.i just had to copy the img/p folder too, and everything looks fine thanks a lot once again.edit:just 1 more question.can i instead of .sql file (exported by phpMyAdmin), import an sql.bz2 file (exported by PS backup tool)?i just want to save time by asking you and not trying myself Link to comment Share on other sites More sharing options...
shokinro Posted May 7, 2011 Share Posted May 7, 2011 yes, you can use zip file or bz file. It is recommended to do so. Link to comment Share on other sites More sharing options...
Recommended Posts