♥Gyakutsuki Posted February 21, 2022 Posted February 21, 2022 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 Quote Regards ----------------------------------------- Loïc Contact me by skype for business Contact me @gyakutsuki for an answer on the forum
osCommerce-Official Posted February 21, 2022 Posted February 21, 2022 Hi Loic, My colleague @Ivan Holbiwill check this and post it here once Wiki has been updated. Kind regards, Vadym Gyakutsuki 1 Quote
Ivan Holbi Posted February 21, 2022 Posted February 21, 2022 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 Quote
♥Gyakutsuki Posted February 26, 2022 Author Posted February 26, 2022 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 ? Quote Regards ----------------------------------------- Loïc Contact me by skype for business Contact me @gyakutsuki for an answer on the forum
asandros Posted February 26, 2022 Posted February 26, 2022 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. Quote
♥Gyakutsuki Posted February 26, 2022 Author Posted February 26, 2022 @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 Quote Regards ----------------------------------------- Loïc Contact me by skype for business Contact me @gyakutsuki for an answer on the forum
asandros Posted February 28, 2022 Posted February 28, 2022 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 1 Quote
♥Gyakutsuki Posted February 28, 2022 Author Posted February 28, 2022 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 ! Quote Regards ----------------------------------------- Loïc Contact me by skype for business Contact me @gyakutsuki for an answer on the forum
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.