...
- Memcached. A distributed caching system. Very effective, above all with multiple servers, but you need to make sure that your servers/hosts support it – most probably, if your PHP configuration features the Memcached PECL extension, you 're are good to go (you can download it here: http://pecl.php.net/package/memcache). You can add Memcached servers by clicking on the "Add server" link.
- APC. Alternative PHP Cache is free, open and robust, but only works with one server – which is the usual case when you start your online business. Again, check for the availability of the APC PECL extension on your server: http://pecl.php.net/package/APC
- Xcache. Xcache is a new cache system, which is specific to the Lighttpd server – hence, it will not work with the popular Apache server. Read more about it at http://xcache.lighttpd.net/.
- File system. The static files are simply stored as any other file, on your server.
...
In our example, we used the first row for columns indicators. Since we don't do not we these imported, enter "1" in the "Skip X lines" text-field.
...
The matching process can be a tedious task if you cannot customize your CSV file'
s columns order according to that used by the PrestaShop importer, and even more so if you have to do that repeatedly or frequently. That is why PrestaShop includes a small tool to save the current matching order that you have set up using all the headers drop-down menus
...
After each backup process, you should download the generated backup file by clicking on its "View" icon, or simply by using the link in the notification box at the top.
Your database is saved using the standard SQL format and its .sql file extension, and compressed using the BZip2 algorithm (simply put, a variant of the popular Zip format. Read more: http://en.wikipedia.org/wiki/Bzip2) and its .bz2 file extension. That gives a file archive with the .sql.bz2 file extension.
Put your backup file in a safe place, for you might need it at any given time. Furthermore, you can find these backups directly on your server, in the /backup folder, under your custom-named /admin folder.
Backup Options
At the bottom of the screen, two options are available:
- Ignore statistics tables. PrestaShop stores you site's statistics in a handful of database tables, and these can grow big quite quickly. While it can be sound to keep your stats in a safe place, they also make for huge files to download, while you are probably more interested in a backup of your products, categories, customers, orders, etc.
By default, PrestaShop backups all tables, but if you are short on disk space, change this options to "Yes". - Drop existing tables during import. When importing a backup file, the system can either overwrite the existing live tables with the content of the ones that were backed up, or delete all existing in order to replace them with the content of the back up. The first case can result in doubles, which is why this option is enabled by default.
SQL Manager
New in 1.5.
The SQL manager is a complex feature, which should be reserved to technical people who know how to explore a database using the SQL language. In return for this complexity, it can be extremely powerful and prove immensely useful to those who master it.
...
| Warning |
|---|
For security reasons, some types of queries are not allowed: UPDATE, DELETE, CREATE TABLE, DROP... In short, you can all read data (SELECT query). Also, secure keys or passwords are shown hidden (***********). |
Creating a new query
...
- Enable PrestaShop Webservice. If you don't do not want anyone to access your shop through third-party tools and applications, just keep it disabled.
- Active mode CGI for PHP. The CGI mode is a special setting for the Apache server, where you tell it to use PHP as a CGI script rather than an Apache module. While the CGI mode has a reputation of being more secure, it has been found to have a security flaw as recently as May 2012. Ask your web host for advices.
...