How to delete all rows in all table of a database in mysql -


i had database 500 tables , want delete records of tables. how achieve this. experts please help...

the simplest way drop , recreate database structure using these shell commands:

mysqldump -d dbname > structure.sql mysqladmin drop dbname mysqladmin create dbname mysql dbname < structure.sql 

insert mysql credentials required, eg -u root -psecret -h localhost


Comments

Popular posts from this blog

apache - Add omitted ? to URLs -

redirect - bbPress Forum - rewrite to wwww.mysite prohibits login -

php - How can I stop spam on my custom forum/blog? -