You are not logged in.
- Topics: Active | Unanswered
Announcement
Download last stable version of GLPI - What can you do for GLPI ? : Contribute
Pages: 1
Topic closed
#1 2011-10-18 08:04:33
- varunb
- Member
- Registered: 2011-10-18
- Posts: 45
to reset the tracking id to ZERO
Hi,
I am using Glpi, i need to reset the auto increment counter to ZERO which is used for tracking ID's.
Please let me know how to do it???
Offline
#2 2011-10-18 09:28:38
- yllen
- GLPI-DEV
- From: Sillery (51)
- Registered: 2008-01-14
- Posts: 15,278
Re: to reset the tracking id to ZERO
ALTER TABLE thetable AUTO_INCREMENT=0
For table's name it's depend of your version of GLPI used
CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6 - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)
Offline
#3 2011-10-18 13:56:13
- varunb
- Member
- Registered: 2011-10-18
- Posts: 45
Re: to reset the tracking id to ZERO
ALTER TABLE thetable AUTO_INCREMENT=0
For table's name it's depend of your version of GLPI used
Hi,
I droped the table and created a new table with AUTO_INCREMENT=0
Its working fine.
Anyways thanks for the reply.
Offline
#4 2011-10-19 18:26:46
- yllen
- GLPI-DEV
- From: Sillery (51)
- Registered: 2008-01-14
- Posts: 15,278
Re: to reset the tracking id to ZERO
OK. I close
CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6 - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)
Offline
Pages: 1
Topic closed