If your store Prestashop installed locally, you seem ready to venture into the jungle of online shops.
If you have refined your catalog and photos, installed a theme that looks good and that your modules are working properly. Then you can consider the transfer line.
For this you need an accommodation with php5 and MySQL database.
The procedure is quite simple to perform.
Procedure to run for versions of Prestashop> 1.4 (only).
You must go on the site you want to move in the administration, Preferences tab> & SEO URLs.
At the bottom of this tab, you must enter your new domain name (ex: www.maboutique.com). Do the same for the SSL domain name (usually the two fields are equal).
If you have forgotten to do so, you can change them in the table "config" in your database. The names of keys are PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL.
File transfer
At first, you need to transfer all your files in the folder Prestashop included in your local server (According to our tutorials, c: \ xampp \ htdocs \ prestashop) to a folder on your server.
For this you must use an FTP client and set so that it can connect to your server. If you do not have a client, you can download the excellent Filezilla .
Once installed, launch it and configure it so that it can connect to. Click on the icon in the upper left (circled in red on the picture), click on new site, and fill in the various fields with the FTP login to your accommodation (hotel, authentication type: Normal, User, Password ).
Then click connection (for connecting later, simply click on the arrow next to the icon and choose your server).
Once you are logged on your server, on it, create a new folder that will store your content. Note the path to this folder (if it is at the root or in subdirectory, pointing in red on the picture below), it will be necessary later.
Now you can transfer all the files in that folder Prestashop newly created (this may take several minutes, you can continue the tutorial during the transfer).
Transfer of the database
We will discuss the second step of our tutorial: the transfer of the database.
Login first on your local database with phpMyAdmin.
If you use Xampp, navigate to http://127.0.0.1/phpmyadmin , then click your database in the left tab (if you followed our tutorial created, the database is called "maboutiqueprestashop").
Then in the tabs at the top on the right panel click export. Finally select "Submit" bottom of the page, then click Run. You will just save the file.
You must now send this file to your database online.
So you have to create with your hosting a database. (Ask us for advice in the comments if you do not succeed). After appointments in the administration of it and then click the tab at the top "SQL". At the bottom, in the "Location of text file or" Select the file we created earlier by clicking on "browse" and then click Run.
You should get this screen, confirming that the operation was completed successfully.
Changing the configuration files
Your store is online, your new database as well, so you must provide the two sets.
For this you must edit the file "settings.inc.php" contained in the "config" folder of your prestashop. Consider making a copy of it before making any changes to your local shop can still walk.
When copying is completed, edit the file by entering the server address of your database, user name, password, and the name of the database (corresponding to red writing below below).
Your file should look like this:
<? Php
define ('_DB_SERVER_', 'The address of the database');
define ('_DB_TYPE_', 'MySQL');
define ('_DB_NAME_', 'the name of the database');
define ('_DB_USER_', 'user name of the database');
define ('_DB_PASSWD_', 'password of the database');
define ('_DB_PREFIX_', 'ps_');
define ('__PS_BASE_URI__', 'path, eg: Magavenue / prestashop /');
define ('_THEME_NAME_', 'prestashop');
define ('_COOKIE_KEY_', 'jvWTG927f36aEBKNup.aw3SgK7KpqsovInE96FjxCiATop8cQJ0cGisN');
define ('_COOKIE_IV_', 'esx2tyg4');
define ('_PS_CREATION_DATE_', '2008-00-21 ');
define ('_PS_VERSION_', '1 .0.0.3 ');
?>
The last thing to change in this file is the path to the folder on your hosting prestashop. Remember earlier in this tutorial, we asked you to remember. Then insert the line 8 (instead of the text in green)
Now that your file is changed, save it and then you just have to send it to your server. Connect to it with your FTP client (like Filezilla) then go to the folder Prestashop then in the sub folder "config". Send your new software and if prompted, choose to replace the two files.
Solving common problems:
You try to access your online store , but you come across a page with no "design", like the one below. Your connection to the database is correct, but the path is not valid against. Change the then as said before, if you still have a problem, contact us in the comments.
- Nothing appears Ormis an error message (like: The database selection or Link Can not Be Made to database Can not Be established), it means that your file settings.inc.php is known about the details of your database given. So check with your host the various parameters, and modify the file as mentioned above. If you still can not connect, contact us via the comments.
Conclusion:
- When you try to access the site, you are redirected to localhost or an address other than your domain name. Make sure you have done well to change domain name in Preferences> & SEO Urls. If you have forgotten to do so, you can change them in the table "config" in your database. The names of keys are PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL.
Your shop is now online. If you have addresses of shops to show us, you can send in comments below. Finally we will be happy to assist any person who has failed to follow this tutorial.
Our team also provides care for your PrestaShop installation on your server. More information on this page.
- Magento: Transfer your shop on your online server from a local installation Feel free to sign up for RSS to not miss any article.Dans our previous tutorial we showed you how to install Magento on your computer using Xampp, we'll explain how to transfer your shop here on ...
- How to prepare for creating your online store with Magento or Prestashop Feel free to sign up for RSS to not miss any article.Vous want to engage in and develop an ecommerce online store, two possibilities you: You already have a business and want to develop your ...
- Prestashop v1.1: Importing an entire catalog in your store from a file. Csv (Excel, Calc ...) Feel free to subscribe to the RSS feed to not miss any article.Comment import many products, many Prestashop categories in my catalog. Thanks to CSV (Comma Separated Values), you have the ability to import large quantities of ...
Articles on this topic:
Keywords:
accommodation , Prestashop , transfer , database transfer , Xampp
606 comments why not leave yours?
We will not support for comments for a technical problem with one of our modules. Thank you contact us directly with our contact form !
- "
- 122
- 121
- 120
- 119
- 118
- 117
- 116
- 115
- 114
- 113
- 112
- 111
- 110
- 109
- 108
- 107
- 106
- 105
- 104
- 103
- 102
- 101
- 100
- 99
- 98
- 97
- 96
- 95
- 94
- 93
- 92
- 91
- 90
- 89
- 88
- 87
- 86
- 85
- 84
- 83
- 82
- 81
- 80
- 79
- 78
- 77
- 76
- 75
- 74
- 73
- 72
- 71
- 70
- 69
- 68
- 67
- 66
- 65
- 64
- 63
- 62
- 61
- 60
- 59
- 58
- 57
- 56
- 55
- 54
- 53
- 52
- 51
- 50
- 49
- 48
- 47
- 46
- 45
- 44
- 43
- 42
- 41
- 40
- 39
- 38
- 37
- 36
- 35
- 34
- 33
- 32
- 31
- 30
- 29
- 28
- 27
- 26
- 25
- 24
- 23
- 22
- 21
- 20
- 19
- 18
- 17
- 16
- 15
- 14
- 13
- 12
- 11
- 10
- 9
- 8
- 7
- 6
- 5
- 4
- 3
- 2
- A
- "
- "
- 122
- 121
- 120
- 119
- 118
- 117
- 116
- 115
- 114
- 113
- 112
- 111
- 110
- 109
- 108
- 107
- 106
- 105
- 104
- 103
- 102
- 101
- 100
- 99
- 98
- 97
- 96
- 95
- 94
- 93
- 92
- 91
- 90
- 89
- 88
- 87
- 86
- 85
- 84
- 83
- 82
- 81
- 80
- 79
- 78
- 77
- 76
- 75
- 74
- 73
- 72
- 71
- 70
- 69
- 68
- 67
- 66
- 65
- 64
- 63
- 62
- 61
- 60
- 59
- 58
- 57
- 56
- 55
- 54
- 53
- 52
- 51
- 50
- 49
- 48
- 47
- 46
- 45
- 44
- 43
- 42
- 41
- 40
- 39
- 38
- 37
- 36
- 35
- 34
- 33
- 32
- 31
- 30
- 29
- 28
- 27
- 26
- 25
- 24
- 23
- 22
- 21
- 20
- 19
- 18
- 17
- 16
- 15
- 14
- 13
- 12
- 11
- 10
- 9
- 8
- 7
- 6
- 5
- 4
- 3
- 2
- A
- "



















hello wanting to import the local database with OVH, I have this error
Error
SQL query:
- - Dumping data for table `prefpres_access` - INSERT INTO `prefpres_access` (`profile id`, `id_tab`, `view`, `add`, `edit`, `delete`) VALUES (1, 1, 1, 1, 1, 1), (1, 2, 1, 1, 1, 1), (1, 3, 1, 1, 1, 1), (1, 4, 1, 1, 1, 1), (1, 5, 1, 1, 1, 1), (1, 6, 1, 1, 1, 1), (1, 7, 1, 1, 1, 1), (1, 8, 1, 1, 1, 1), (1, 9, 1, 1, 1, 1), (1, 10, 1, 1, 1, 1), (1, 11, 1, 1, 1, 1), (1, 12, 1, 1, 1, 1), (1, 13, 1, 1, 1, 1), (1, 14, 1, 1, 1, 1), (1, 15, 1, 1, 1, 1) , (1, 16, 1, 1, 1, 1), (1, 17, 1, 1, 1, 1), (1, 18, 1, 1, 1, 1), (1, 19, 1, 1, 1, 1), (1, 20, 1, 1, 1, 1), (1, 21, 1, 1, 1, 1), (1, 22, 1, 1, 1, 1), ( 1, 23, 1, 1, 1, 1), (1, 24, 1, 1, 1, 1), (1, 26, 1, 1, 1, 1), (1, 27, 1, 1, 1, 1), (1, 28, 1, 1, 1, 1), (1, 29, 1, 1, 1, 1), (1, 30, 1, 1, 1, 1), (1, 31, 1, 1, 1, 1), (1, 32, 1, 1, 1, 1), (1, 33, 1, 1, 1, 1), (1, 34, 1, 1, 1, 1), (1, 35, 1, 1, 1, 1), (1, 36, 1, 1, 1, 1), (1, 37, 1, 1, 1, 1), (1, 38, 1, 1, 1, 1), (1, 39, 1, 1, 1, 1), (1, 40, 1, 1, 1, 1), (1, 41, 1, 1, 1, 1) , (1, 42, 1, 1, 1, 1), (1 ,[...]
MySQL said:
# 1062 - Duplicate entry '1 -1 'for key' PRIMARY '
thank you for giving me a hand please
Hello,
Thank you for this tutorial.
I just fell on my page design and I have not made the changes you mentioned.
I do not understand why: s
Hello,
For several days I have to block the installation of my prestashop shop online ...
I want to know the configuration of the htaccess file on HostPapa? because nothing appears for now ...
Cordially
Hello and thank you for your tutorial.
Although it is sometimes necessary to follow compile now it is a great help!
However I am having a problem importing my database. In PhpMyAdmin, the following error message appears:
Error
SQL query:
- -------------------
-
- Table structure for table `` xxxx_dateofdelivery_carrier_rule
-
CREATE TABLE IF NOT EXISTS `xxxx_dateofdelivery_carrier_rule` (
Id_carrier_rule `` INT (11) NOT NULL AUTO_INCREMENT,
Id_carrier `` INT (11) NOT NULL,
Minimal_time `` INT (11) NOT NULL,
Maximal_time `` INT (11) NOT NULL,
Delivery_saturday `` TINYINT (1) NOT NULL,
Delivery_sunday `` TINYINT (1) NOT NULL,
PRIMARY KEY (`` id_carrier_rule)
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4 AUTO_INCREMENT = 2;
MySQL said:
# 1115 - Unknown character set: 'utf8mb4'
When I type the error in our favorite search engine, I can find a hundred results, few of which are consistent ... Do you have a solution to help me import my database?
Thank you for your help
Pierrick
Response to Vincent:
In fact and to avoid problems when you import your URL test database at your host to put it online, I suggest you edit your previous SQL file, edit it with Notepad + + and search all entries 'localhost' and replace with 'www.monsite.x', which would be in your case 'www.myboxposter.com'. And to include in your SetEnv PHP_VER 5. Htaccess is not set by default at OVH. If you forget, the PHP code is ignored. Good luck