Tables - DB

[kixtzz]

How can i reset(truncate) all tables from all db without affecting the game ?

[Nymphetamine]

O.o u want to clean a database without affecting the game?

Its like if u ask if u can stop ur heart without affecting your life

[filix_93]

maybe he mean the users tables , truncate them to reset the game as new without broke it xD

[Nymphetamine]

He said "all tables"

[kixtzz]

less newproject_db 

[Canton]

with Navicat... Dump SQL-File -> Structure Only...

 

alternative..

mysqldump -d -h localhost -u root -pmypassword newproject_db > newproject_db.sql

[CDWriter]

this would be a bad idea @2 .... i would go to google search for "ALTER TABLE tablename AUTO_INCREMENT = value;" our just use this.. reset all auto_increments back to 1

 

 

 

 

 

ALTER TABLE tablename AUTO_INCREMENT = 1;