JsusSalv Posted June 11, 2008 Share Posted June 11, 2008 Hello: I've searched to forums for information regarding the Export feature. However, every post that seems to allude to an answer on how to export my catalog is in French. Matthieu, I have my French-English dictionary right next to me but it's not helping. Can anyone help point me to a tutorial on how to export my catalog? I am trying to export my current catalog from one server, install Prestashop on another server, and then re-import the catalog into the new server. Sounds simple enough but the solution alludes me for the moment. Thank you! Link to comment Share on other sites More sharing options...
JsusSalv Posted June 11, 2008 Author Share Posted June 11, 2008 I found the following information. However, it doesn't give any information pertaining to a particular "Catalog Exporting tool." I will post the information for those who may need it and perhaps someone can give me an idea on just exporting the entire catalog WITHOUT having to transfer the entire PS directory with it. I know it makes sense to transfer the entire directory with the SQL file. However, I am performing a fresh new install on a different server and I don't know if it matters that Prestashop was installed on one server (for testing purposes) which may have created tokens/session/etc... particular to that server. Does anyone know if this is the case? If not, is the recommendation to just transfer the entire directory as outlined in the following steps? For the PS Directory: http://www.prestashop.com/doc/doku.php/shop_owner_guide?s=export Migrate PrestaShop To migrate your entire PrestaShop shop to another Web server: 1. First, we advise you to go in your back office in Preferences rubric, and write your new PS directory in the appropriate field. Or you can also open the file config/settings.inc.php and write your new PrestaShop directory's path: define(_PS_BASE_URI_, 'myNewDirectory');. 2. Then, you have to move your current PS directory to its new location. For the database: http://www.prestashop.com/doc/doku.php/back_up_your_database Lots of info with images so check it out for yourself. Link to comment Share on other sites More sharing options...
Julien Breux Posted June 11, 2008 Share Posted June 11, 2008 Sorry, but i don't have time for write the post in English but you can install my backup module. The backup is in SQL syntaxe (txt file). Link : http://www.julienbreux.com/2008/06/04/module-prestashop-backup/ Link to comment Share on other sites More sharing options...
JsusSalv Posted June 11, 2008 Author Share Posted June 11, 2008 Awesome! I took a look, grabbed my Frenchy-English dictionary and will try to make it work. You rock my friend! If you're ever out my way, a cappuccino and an orange scone on me. Thank you Julien!! Link to comment Share on other sites More sharing options...
JsusSalv Posted June 11, 2008 Author Share Posted June 11, 2008 I used Google's translation service in case anyone needed a pretty good English version of Julien's info. Rock on Julien! http://translate.google.com/translate?u=http%3A%2F%2Fwww.julienbreux.com%2F2008%2F06%2F04%2Fmodule-prestashop-backup%2F&sl=fr&tl=en&hl=en&ie=UTF-8 If the link doesn't work just head over to translate.google.com and enter Julien's link in the post above. Link to comment Share on other sites More sharing options...
JsusSalv Posted June 11, 2008 Author Share Posted June 11, 2008 @Julien I just installed the module and it rocks. Quick question, was this meant to backup the entire database or just the pertinent information (e.g. catalog, customers)? I know silly questions but it's late here and I am having difficulty reading all the SQL syntax. I will into it again in the morning. Also, what is your opinion on this: If I do a fresh install on a new server, then take a db backup file (thanks to you) and import it into phpMyAdmin on the new MySQL db server, would there be any problems with any of the Prestashop settings? Thank you! Link to comment Share on other sites More sharing options...
Julien Breux Posted June 11, 2008 Share Posted June 11, 2008 This module make backup off all database and restore all database for the moment Link to comment Share on other sites More sharing options...
sdfguerreiro Posted July 4, 2008 Share Posted July 4, 2008 Hi! I installed your module sucessfuly. Made one backup of the fresh installation of prestashop rc3. After adding products and made another backup.Tried to restore the first one and it says that it worked well. went to my shop and it says there's an error. tried to enter backoffice and tell's me that :There is 1 erroremployee does not exist, or bad password .What happend? Link to comment Share on other sites More sharing options...
Julien Breux Posted July 5, 2008 Share Posted July 5, 2008 This module must be rewrite for final version. Wait a little I'm sorry for your desagrement Link to comment Share on other sites More sharing options...
sdfguerreiro Posted July 5, 2008 Share Posted July 5, 2008 By the contrary my friend! Im very pleased with this module since it doesn't existe nothing like this and in fact is so easy to operate. Listen, i went to phpmyadmin, clicked in prestashop and import one backup from the your module folder. It gave me this error:#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 ')' at line 49 Can you tell me what does it means and how to resolve it? Thanks again!! Link to comment Share on other sites More sharing options...
hujer Posted July 8, 2008 Share Posted July 8, 2008 Yes, i had exactly same problem, when i used this module to backup database its deleted all database files in my phpadmin, thats why you cant login, no data, no users etcIn the generated file is a bug, at the and of part to meet the table was always missing parenthesis-this symbol ")" So if you put it there and make backup in php admin it works fine.But if would work right, its very needed module, thanks for it Link to comment Share on other sites More sharing options...
Julien Breux Posted July 8, 2008 Share Posted July 8, 2008 This bug was fix. You can use the backup module but before you make a backup of your database (for test).http://www.julienbreux.com/fichiers/2008/06/dbbackup.tarSorry for my bad syntaxe, i'm french. Link to comment Share on other sites More sharing options...
hujer Posted July 8, 2008 Share Posted July 8, 2008 Great !No worry, i have same problem in english Link to comment Share on other sites More sharing options...
Recommended Posts