Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Wed Apr 24, 2024 10:01 pm
Hosted Voice Broadcast


All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: size of backup file
PostPosted: Thu Dec 13, 2007 10:04 am 
Offline

Joined: Wed Dec 06, 2006 8:52 am
Posts: 8
Hi There,
I have been using a2b 1.2.X for a couple of months. I have to do the backup regularly. I see the size of databse backup is in increase. now
abut 700k.

As I am new to mySQL. my questions are:
1. Is there any limit of size of backup file ?
2. more and more card numbers expired,
how i can delete them?

Thanks a lot

Jan


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jan 03, 2008 7:15 am 
Offline
User avatar

Joined: Mon Apr 30, 2007 6:43 am
Posts: 1060
Location: Canada
There should not be any limit to the size of the file that will be generated by the backup procedure. Well, actually there is, but it is configurable. And if necessary, the code can be modified to allow bigger files if the default max file size is not enough.

Here is an example with MySQL:

Code:
mysqldump  -q --quick --user=your_db_user --password=your_password a2billing-1.3 -O max_allowed_packet=2048M  > a2billing-1.3.sql


This will be able to handle a backup file of up to 2 Gigabytes.

Usually, you will simply go in the admin UI and click on backup. So far, I have not seen anyone needing to increase the size of the backup size limit, but it is possible. If you wish to delete you backups, then you can do it right from the Admin UI. I recommend burning them on a CD or DVD before removing them permanently from your server.

For the cards that have expired, I don't know any easier way than deleting them one by one. The other way would be to add some fields in the SEARCH CARDS form that can be used to search expired card and batch delete them.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 
VoIP Billing solution


All times are UTC


Who is online

Users browsing this forum: No registered users and 10 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group