{"id":2999,"date":"2021-10-13T10:39:01","date_gmt":"2021-10-13T10:39:01","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=2999"},"modified":"2021-10-13T12:35:32","modified_gmt":"2021-10-13T12:35:32","slug":"learn-to-empty-a-mysql-database-in-simple-steps","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/learn-to-empty-a-mysql-database-in-simple-steps\/","title":{"rendered":"Learn to Empty a MySQL Database in Simple Steps"},"content":{"rendered":"

You can empty the content of a MySQL database Using phpMyAdmin or SSH. But you have to make sure that you take a backup of your database (phpMyAdmin or SSH) before making any changes to your databases.<\/p>\n

Empty a MySQL Database Using phpMyAdmin<\/h2>\n

As compared to other ways this is the easiest way to empty a MySQL database .<\/p>\n

Login to your cPanel account and navigate to Databses<\/strong> and select phpMyAdmin<\/strong><\/p>\n

\"delete-mysql-1\"<\/p>\n

Then select the database you which you wish to empty.<\/p>\n

\"delete-mysql-2\"<\/p>\n

All the database\u2019s tables list will get appeare. click on Check All<\/strong> link for selecting all the tables in the database<\/p>\n

\"delete-mysql-3\"<\/p>\n

Next, from drop down menu of “With Selected” select drop. With this, on all tables the DROP TABLE SQL query will run and after you make sure that you wish to move futher by clicking on Go, the database will be emptied.<\/p>\n

Empty a MySQL Database Using SSH<\/p>\n

Using SSH, when you drop the content of a database, in terms large databases it proves to be very useful. Here you will required to use the drop and create privilege ( or lese you will drop the database but won\u2019t be able to create it again).<\/p>\n