search

uilibrary / Stocky-Issues-and-Feature-request

This is Repo is for Stocky-Ultimate Inventory with Pos support and issues
16 stars 6 forks source link

Can't make database backup in setting #209

Open willchan0101 opened 3 years ago

willchan0101 commented 3 years ago

Hello

I'm going to upgrade Stocky to the last version 3.2, so i go Setting > Backup Database and click Generate Backup

I can see the app has made a sql backup file, but the file size is 0 byte. I have already tried many times, the result were the same, please advise, thank you.

qooah-screenshot_2815

hamzakifani commented 3 years ago

you have a problem on the version of mysql 5.6 please try to upgrade mysql

go to your phpmyadmin and make backup of your database

I tried making a backup with phpmyadmin checked now. If you often encounter this problem, go to phpmyadmin and make a backup easily

sql

willchan0101 commented 3 years ago

you have a problem on the version of mysql 5.6 please try to upgrade mysql

go to your phpmyadmin and make backup of your database

I tried making a backup with phpmyadmin checked now. If you often encounter this problem, go to phpmyadmin and make a backup easily

sql

Thank you. So which version of MySQL that you recommend? I'll ask my web host upgrade for me, thanks.

kashifleo55 commented 3 years ago

I am also facing this issue please fix this asap MySql Ver 15.1 Distrib 10.4.19-MariaDB

hamzakifani commented 3 years ago

I am also facing this issue please fix this asap MySql Ver 15.1 Distrib 10.4.19-MariaDB

I checked this problem: sorry it's not a problem of version of mysql. problem : if database password contains '&' password was messing with mysqldump (generate backup) because it had an "&"

Solution 1: try to generate a password without "&" or Solution 2: Go to \app\Console\Commands\ and extract file DatabaseBackUp.php and replace it DatabaseBackUp.zip

we will fix this issue in next update , maybe today . thank you

hamzakifani commented 3 years ago

you have a problem on the version of mysql 5.6 please try to upgrade mysql go to your phpmyadmin and make backup of your database I tried making a backup with phpmyadmin checked now. If you often encounter this problem, go to phpmyadmin and make a backup easily sql

Thank you. So which version of MySQL that you recommend? I'll ask my web host upgrade for me, thanks.

Hi bro , I fixed this issue in your app I checked this problem: sorry it's not a problem of version of mysql. problem : if database password contains '&' password was messing with mysqldump (generate backup) because it had an "&"

Solution 1: try to generate a password without "&" or Solution 2: Go to \app\Console\Commands and extract file DatabaseBackUp.php and replace it DatabaseBackUp.zip

we will fix this issue in next update , maybe today . thank you