How to delete contents of MySQL database?

Question

linux

Hello everyone, I need to delete ALL CONTENT from the database on linux, while I want to leave the database itself, what command can I do this with?

Answer 1

The simplest thing is to make a backup of only the structure, without data ( mysqldump --no-data , https://dev.mysql.com/doc/refman/8.0/en/mysqldump.... ), delete the database, restore. Of course, don't forget to back up procedures/triggers/etc.

Answer 2

It's easier to recreate the database. Otherwise, delete/clear each table separately.