How can I empty a mysql database? Print

53

The easiest way to empty a mysql database is by deleting it and recreating it again. This will preserve all user privileges to it and will just delete all of its tables.

Was this answer helpful?

Related Articles

What type of databases do you support? All Yadonia Group servers support MySQL databases.Also with any of our hosting packages you can... How can I import a large database to my account? PhpMyAdmin times out. For importing large databases we recommend using tools such as Mysql Query Browser.Before being... I get an error ACCESS DENIED CREATE DATABASE db_name when I try to import a database In order to solve this issue follow these steps: Open the mysql dump with a text editor on your... I don't have enough privileges for creating/dropping databases in PhpMyAdmin Your user does not have enough privileges for creating or dropping databases in PhpMyAdmin... I have problems accessing my mysql database remotely If you have problems accessing your database remotely please make sure that: You are using the...

« Back