Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Gyakutsuki

Website Backup

Recommended Posts

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
 

 



Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

 

Share this post


Link to post
Share on other sites

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 ?


 

 



Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

@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



Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 !



Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×