Hello @Rainer,
I created a tutorial about that : https://www.clicshopping.org/forum/topic/473-create-a-cron-to-save-your-db-on-the-server/
It will help you to resolve your problem.
+
Hello,
This tutorial allow you to create a cron to save your db in daily.
if you want to change the delay, you can use this site to help you : https://crontab-generator.org/
Inside your server create a files : saveCronTabDb.sh with execute right (chmod 755)
#!/bin/bash
DB_USER='MyUserName'
DB_PASS='MyPassword'
DB_HOST='localhost'
DB_NAME='MyTable'
mysql -u${DB_USER} -p${DB_PASS} -h${DB_HOST} $DB_NAME < "/var/www/xxx/xxx/web8/web/myDbdirectory/myDbfilesToSave.sql"
Now you can create your crontab with this command: In this case all the 21hr everyday
* */21 * * * /var/www/xxx/xxx/web1/private/saveCronTabDb.sh > /var/www/xxx/xxx/web1/private/cron.log
To test your cron :
sh saveCronTabDb.sh
To see your cron
sudo crontab -l
Ah do not forget to protect your directory with an htaccess
# Disable directory browsing
Options -Indexes
<Files .htaccess>
Order allow,deny
Deny from all
</Files>
Hello @Mara,
look little about that. A summary I found :
1. Create relevant online consumer protection rules (GDPR)
2. Focus on personal data protection and security
3. Ready to develop a good relation with your customer, reactivity, Chat (why not), good support
4.Develop the reviews are very important
5.Allow the customer to rate your work.
6.Of course, website in SSL
7.Quality Website design