Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 11:50 am
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: how to reset Card id?
PostPosted: Mon Dec 06, 2010 2:18 pm 
Offline

Joined: Thu Jun 10, 2010 12:02 pm
Posts: 11
Hi,

i want to reset card id, all cards has been used and i want to start from the begining again. currently the last id is 48788 and want to reset it 1.
Can any body please help me how to do this.

Any help will be highly appreciated.

Thanks
Mohammed


Top
 Profile  
 
 Post subject: Re: how to reset Card id?
PostPosted: Mon Dec 06, 2010 8:50 pm 
Offline

Joined: Sat May 10, 2008 4:19 pm
Posts: 132
Location: Wilmington, DE
Mohammed,

Backup your database before trying anything you're not very familiar with.
If you are familiar with mySQL it shouldn't be too difficult.
I'm not very clear as to how you want to achieve this.
If you are going to empty the table and insert new records, you could use this from the command line after logging in to mysql and selecting the database to use.

Code:
mysql -u root -prootpasswd (change rootpasswd to your mysqlroot password)
use mya2billing;
TRUNCATE TABLE cc_card;

This would wipe out the data then reset the auto card id back to start at 1.
When finished,
quit;

Backup your database before trying anything you're not very familiar with.


Top
 Profile  
 
 Post subject: Re: how to reset Card id?
PostPosted: Sun Dec 19, 2010 2:55 pm 
Offline

Joined: Thu Jun 10, 2010 12:02 pm
Posts: 11
Thank you ver much it was really helpful

Thanks,


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 
Predictive Dialer


All times are UTC


Who is online

Users browsing this forum: No registered users and 9 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:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group