Website Backup

[♥Gyakutsuki]

Hello @VadymG,

 

Is it possible to have a tuto about the backup ?
When you install the application, it creates symlink on the theme. What are the consequences if these symlinks are not there ?
What are recommendations about backup files and DB, change hosting, upload ftp backup ... ?

If we can have a tuto about that it will great for the community.

Thank you
 

 

[osCommerce-Official]

Hi Loic, 

My colleague @Ivan Holbiwill check this and post it here once Wiki has been updated. 

Kind regards,

Vadym 

[Ivan Holbi]

Hi Loic,

Please see the link below with the manual regarding the backup.

https://wiki.oscommerce.com/index.php?title=Managing_Backups

Regarding the symlinks they are currently made for the marketing purposes only to demonstrate the possibility of using a few front ends.

Best regards,

Ivan

[♥Gyakutsuki]

Hello @Ivan Holbi,

Tk,
If I need to change a hoster or if I need to develop on my local server and export to my production, what are your recommendations? f I change my production sql database by my local db, do we have a problem to manage or it's transparent for example.
In function of your experiences, what is the size of DB in production, I suppose the DB can grow up quickly ?
In this case, do you recommend to export / import via ssh ?

 

 

[asandros]

Hello Loïc,

Quote

If I need to change a hoster or if I need to develop on my local server and export to my production, what are your recommendations? f I change my production sql database by my local db, do we have a problem to manage or it's transparent for example.

Sorry, it's not clear what recommendations do you mean.

osCommerce v4 requires at least MySQL 5.7  and higher or MariaDB 10.1 and higher. And of course database dump is compatible across these versions.

Quote

In function of your experiences, what is the size of DB in production, I suppose the DB can grow up quickly ?

By default, after setup, website may take about 0.5GB and database about 40MB of disk space. Of course if you add thousands products, products options, multiple categories, database may take several gigabytes.

Quote

In this case, do you recommend to export / import via ssh ?

If you have a knowledge to export/import MySQL dump in the command line - yes sure you can do it. Alternative method is PhpMyAdmin.

[♥Gyakutsuki]

@asandros,

Quote

Sorry, it's not clear what recommendations do you mean. 

If you change to another hoster, you must reconfigure Osc, in this case, you must take in consideration your db, config and upload the files on the new hoster.
Currently, it's not possible via the install process to update Osc, you can only install a new Db
Also, when you install for the first time, you have a zip and the process is done by the server with the good right. If you move to another hoster,  you must upload all your files on the new server but I you can not follow the original installation process.
What are your recommendations (process to do) about this new installation, the rights on the files and directories, ?

In this case,
1 - I must install  the original Osc
2 - upload my template and image
2 - Remove the DB and install my old DB

or

1 - I can upload all the files from my computer
2 - upload my db inside my new sql server
3 - Change the chmod of directories and files (witch)
2 - Try to reconfigure the setting in local directories

What do you do when you must move an Osc on the new server.

note : It's not for me but for the community to understand the complexity.

Thank you

[asandros]

Hello Loïc,

If you need to move website to another host you need to:

1) create database dump using tools provided by the current host;

2) copy website files and database dump to the new host;

3) Import database dump into the database on the new host;

4) change database connection details in the files: 

<site root>/includes/local/configure.php
<site root>/admin/includes/local/configure.php

5) In case if domain name of the website changed - login admin area and change domain for Sales channel.

[♥Gyakutsuki]

Hello @asandros,

Tk,
Suggestion

For a next release, it will be interesting if we can have an option to reconfigure the system without reinstalling the db as 2.3.4 or 2.4.
Honestly, I am tired during my test to delete the db every time and to reinstall all. 1, ok, 2 ok but 20 I am tired !