Marthatpv Posted December 25, 2014 Share Posted December 25, 2014 Need help, I need to move my web to another hosting, best way to re-use URL? and how to move orders and clients? where can I find info about? Please Assist! Link to comment Share on other sites More sharing options...
Dave! Posted December 25, 2014 Share Posted December 25, 2014 To move from one host to another one you need : 1. copy all files from oldHost to your HD 2. copy all files from HD to newHost 3. create new db on newHost 4. create db user on newHost with all needed rights 5. edit settings.inc in config directory with new parameters 6. export all mysql data from oldHost in sql format 7. import all mysql data to newHost 8. acces to newHost/adminXXXX and change Shop domain and SSL Domain to newDomain in Preferences->Seo&URLs 1 Link to comment Share on other sites More sharing options...
Marthatpv Posted December 25, 2014 Author Share Posted December 25, 2014 To move from one host to another one you need : 1. copy all files from oldHost to your HD 2. copy all files from HD to newHost 3. create new db on newHost 4. create db user on newHost with all needed rights 5. edit settings.inc in config directory with new parameters 6. export all mysql data from oldHost in sql format 7. import all mysql data to newHost 8. acces to newHost/adminXXXX and change Shop domain and SSL Domain to newDomain in Preferences->Seo&URLs Thank you is just, i just need to move data as orders, clients, category an so, not modules or customizations. Link to comment Share on other sites More sharing options...
Dave! Posted December 25, 2014 Share Posted December 25, 2014 Can you tell me exactly what you want to move, only orders,clients and category and why not all data? Link to comment Share on other sites More sharing options...
Marthatpv Posted December 25, 2014 Author Share Posted December 25, 2014 Can you tell me exactly what you want to move, only orders,clients and category and why not all data? want to try st new, if is possible? Link to comment Share on other sites More sharing options...
Dave! Posted December 25, 2014 Share Posted December 25, 2014 Everything is possible)), but I want to know what you want to do exactly to help you Link to comment Share on other sites More sharing options...
Marthatpv Posted December 25, 2014 Author Share Posted December 25, 2014 Everything is possible)), but I want to know what you want to do exactly to help you My current web is too customized, thinking on building a new web, keeping urls for seo purposes and history Link to comment Share on other sites More sharing options...
Dave! Posted December 25, 2014 Share Posted December 25, 2014 In that case you need to: 1.export from oldDB only mysql tables (clients, orders, category, products, etc..) 2. import to newDB or Do full migration (my first post) and then delete the customizations you don't need Link to comment Share on other sites More sharing options...
Marthatpv Posted December 25, 2014 Author Share Posted December 25, 2014 In that case you need to: 1.export from oldDB only mysql tables (clients, orders, category, products, etc..) 2. import to newDB or Do full migration (my first post) and then delete the customizations you don't need I try that but got many errors. and How do I export oldDB mysql tables? Link to comment Share on other sites More sharing options...
Marthatpv Posted December 25, 2014 Author Share Posted December 25, 2014 I try that but got many errors. and How do I export oldDB mysql tables? In that case you need to: 1.export from oldDB only mysql tables (clients, orders, category, products, etc..) 2. import to newDB or Do full migration (my first post) and then delete the customizations you don't need from fpt? just can´t find data Link to comment Share on other sites More sharing options...
Dave! Posted December 25, 2014 Share Posted December 25, 2014 (edited) Its not from FTP, its from phpmyadmin, You need to select the database on left, then export tab, then choose custom and select tables you want export Edited December 25, 2014 by mkdavid1 (see edit history) Link to comment Share on other sites More sharing options...
Marthatpv Posted December 25, 2014 Author Share Posted December 25, 2014 just want more question, for export you mean like copy? as my web is online Link to comment Share on other sites More sharing options...
Dave! Posted December 25, 2014 Share Posted December 25, 2014 Yes, export will copy all data from your database, no deletion or modification Link to comment Share on other sites More sharing options...
Marthatpv Posted December 25, 2014 Author Share Posted December 25, 2014 (edited) Yes, export will copy all data from your database, no deletion or modification Thank you! I think i have, when i do a back up is the same right? i can use fil Its not from FTP, its from phpmyadmin, You need to select the database on left, then export tab, then choose custom and select tables you want export il try to export, but is the same as when you do a backup? Edited December 25, 2014 by Marthatpv (see edit history) Link to comment Share on other sites More sharing options...
Dave! Posted December 25, 2014 Share Posted December 25, 2014 Yes, its almost the same, the prestashop backup is saving all database data (including modules data) Link to comment Share on other sites More sharing options...
Marthatpv Posted December 25, 2014 Author Share Posted December 25, 2014 Yes, its almost the same, the prestashop backup is saving all database data (including modules data) thank you very much your a big help! i did but it said go but go where? where is the info is saved? Sorry i really new to this. i will do a back up and see if I can get the tables i need from there. Merry Xmas!! Link to comment Share on other sites More sharing options...
Dave! Posted December 25, 2014 Share Posted December 25, 2014 (edited) What version of prestashop you have? Normally the backup is stored in the folder admin/backups/xxxxxx.sql.bz2 For your information this is what recomended by prestashop: How to restore a database backup in 10 easy steps Set "Enable Shop" to "No" in the "Maintenance" page under the "Preferences" menu. Download the backup from the list below or from your FTP server (in the folder "admin/backups"). Check the backup integrity: Look for errors, incomplete file, etc... Be sure to verify all of your data. Please ask your hosting provider for "phpMyAdmin" access to your database. 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, please select the "Import" tab Click on the "Browse" button and select the backup file from your hard drive. Check the maximum filesize allowed (e.g. Max: 16MB) If your backup file exceeds this limit, contact your hosting provider for assistance. Click on the "Go" button and please wait patiently for the import process to conclude. This may take several minutes you need to do this on the newHost thanks, merry xmas you too Edited December 25, 2014 by mkdavid1 (see edit history) Link to comment Share on other sites More sharing options...
Marthatpv Posted December 25, 2014 Author Share Posted December 25, 2014 What version of prestashop you have? Normally the backup is stored in the folder admin/backups/xxxxxx.sql.bz2 For your information this is what recomended by prestashop: How to restore a database backup in 10 easy steps Set "Enable Shop" to "No" in the "Maintenance" page under the "Preferences" menu. Download the backup from the list below or from your FTP server (in the folder "admin/backups"). Check the backup integrity: Look for errors, incomplete file, etc... Be sure to verify all of your data. Please ask your hosting provider for "phpMyAdmin" access to your database. 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, please select the "Import" tab Click on the "Browse" button and select the backup file from your hard drive. Check the maximum filesize allowed (e.g. Max: 16MB) If your backup file exceeds this limit, contact your hosting provider for assistance. Click on the "Go" button and please wait patiently for the import process to conclude. This may take several minutes you need to do this on the newHost 1.4 that´s why i need to change. when i was doing the export phpmyadmin it said go after selected tables i wanted, also if ask for option to comprised but i see no option to select where to saved it so i didn´t do it. ill wait to back up via prestashop and host to do it again in case. Link to comment Share on other sites More sharing options...
Marthatpv Posted December 26, 2014 Author Share Posted December 26, 2014 What version of prestashop you have? Normally the backup is stored in the folder admin/backups/xxxxxx.sql.bz2 For your information this is what recomended by prestashop: How to restore a database backup in 10 easy steps Set "Enable Shop" to "No" in the "Maintenance" page under the "Preferences" menu. Download the backup from the list below or from your FTP server (in the folder "admin/backups"). Check the backup integrity: Look for errors, incomplete file, etc... Be sure to verify all of your data. Please ask your hosting provider for "phpMyAdmin" access to your database. 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, please select the "Import" tab Click on the "Browse" button and select the backup file from your hard drive. Check the maximum filesize allowed (e.g. Max: 16MB) If your backup file exceeds this limit, contact your hosting provider for assistance. Click on the "Go" button and please wait patiently for the import process to conclude. This may take several minutes you need to do this on the newHost thanks, merry xmas you too Thank you again, i did all ok, just got last question, when you do import to newweb via phpmydamin do i need to create a data base? as only i want part of the info, can i upload via import cvs in the prestashop admin panel? its just not sure how it will work if i create a new data base , import table needed. But if i drop the currente table e.g ps_customer like my old version ps and the new one have different fields ? also in the orders i notice different info. what do you suggest is the best way to go. in my sql prestashop should i create a new user and database? or i will be created by default ? Link to comment Share on other sites More sharing options...
Dave! Posted December 26, 2014 Share Posted December 26, 2014 (edited) Yes off course you need to create new database otherwise you can not import If you want to upgrade from 1.4 to 1.6, there is many differences in database structure So I advise you to do antoher way: 1. You need to migrate your old website on localhost (use wampserver) 2. Download and install the prestashop's 1clic upgrade moduel 3. Delete customizations you don't need 4. Upgrade to 1.6 5. Check and fix error if any 6. Migrate to the newHost Edited December 26, 2014 by mkdavid1 (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts