• From: Pakistan, Karachi
  • Registered: 03/03/2015
  • Posts: 650

Topic: How to Backup Large Files

One of my clients data file has grown up to 200 MB. The Backup routine is unable to take its backup.

Is there any alternate way except PHPMyadmin to take backup of such large databases?

www.boxygen.pk

boxygen's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: How to Backup Large Files

1. Check tables with large logs and purge them especially after changing the debug variables in the config.php.
2. Use the command line to dump the backup - mysqldump
3. Use a MySQL client like SQLyog.
4. Increase the php.ini's script timeout and max transfer size / memory limit variables
5. FA's time limit is also hardcoded at 180 seconds or so - search the wiki.

apmuthu's Website

  • From: Sudan
  • Registered: 02/11/2018
  • Posts: 11

Re: How to Backup Large Files

@apmuthu
hi, i am facing same issue as data grows in my company now the FA not backing up the data please guide me how to fix this issue with in FA
thank you

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: How to Backup Large Files

Take a data dump of your FA database from phpMyAdmin directly if you are not able to benefit from the instructions in my previous post.

apmuthu's Website

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,181

Re: How to Backup Large Files

If you have cpanel. Take backup from cpanel->backups.

If it's direct and Raw server. You can use MySQL dump for this

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website