Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Website Hangs On Database Backup Rate Topic   - - - - -

 
  • patroklos
  • Newbie
  • Members
  • Join Date: 13-Jun 19
  • 11 posts

Posted 30 July 2020 - 10:40 AM #1

Hi!

 

Do you have any suggestions on how to do database backups and keep cs-cart running smoothly?

 

We've tried the mysqldump suggestions here

 

 https://stackoverflo...d-on-the-server

 

but is seems it doesn't make any difference at all. (options  --single-transaction, --quick, --lock-tables)

 

The server becomes unresponsive for around 20-30 seconds

 

We are testing this on a database less that 1GB and all tables are InnoDB, the server is dedicated and quite powerful.

 

We've also tried the Backup option provided in the admin panel and the behavior is the same.

 

Thanks!



 
  • soft-solid
  • Junior Member
  • Authorized Reseller
  • Join Date: 19-Apr 10
  • 1204 posts

Posted 30 July 2020 - 04:53 PM #2

Hello

 

The best way is to log in via ssh to the server and make a mysqldump database dump. Then pack a zip and upload via ftp to a safe place.

 

Best regards

Robert


Team of SoftSolid
cs-cart.pl, marketplace

We specialize in creating the highest quality addons, safe, useful and flexible


 
  • patroklos
  • Newbie
  • Members
  • Join Date: 13-Jun 19
  • 11 posts

Posted 31 July 2020 - 08:00 AM #3

Hi,

 

thanks for the answer, but we have tried that also as I said on the previous post

and the website does not respond when making a backup.

Open requests are served after backup finishes.

 

Regards



 
  • soft-solid
  • Junior Member
  • Authorized Reseller
  • Join Date: 19-Apr 10
  • 1204 posts

Posted 31 July 2020 - 08:39 AM #4

Hello

 

It is not normal if taking a database dump (while logged in to the server) has this effect. You asked the administrator what is going on?
What kind of hosting do you have? (number of cores, RAM memory)
 
Best regards
Robert

Team of SoftSolid
cs-cart.pl, marketplace

We specialize in creating the highest quality addons, safe, useful and flexible