Is there a way to empty a DB without having direct access (ie phpMyAdmin)? I searched the MySQL reference documentation and couldn't find (or maybe I missed it?) what I was looking for.

The best method, IMHO, is to use TRUNCATE (similar to DELETE on all records, but resets the table as well).

I don't know what you mean by 'direct access'. If you don't have 'direct access' one way or another (PHP script, phpMyAdmin, mysql command line client) then how else would you perform a query?

__________________

I reject your reality, and substitute my own.

I think he means via a query and not the MySQL application via command line. If I'm right then SOCK is right with TRUNCATE !

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

Ok, well as long as the connecting user has DELETE permissions, TRUNCATE will work from a PHP script.

MySQL Manual : TRUNCATE

__________________

I reject your reality, and substitute my own.

I don't want to empty all of the existing tables, I want to get rid of every existing table in the database.

Thanks for replies.

How many tables do you have? You could just use DROP TABLE (MySQL :: MySQL 5.1 Reference Manual :: 12.1.16 DROP TABLE Syntax) on each one.

Might take a while if you have thousands of tables though

Alan

Most of the time when forum posts request info on "how to do this with a database", they're referring to the table, not the actual database. I naturally assumed you wanted to empty the table, not DROP all tables from the database.

You can use the command line tool 'mysqladmin' to drop all tables in a comma delimited list, I believe. If you could create a system exec() statement that called this function with those parameters it might be easier to do that several calls to mysql_query() to drop the table(s) (depending on how many you have).

The other way to look at it, if you have the privilege to do so, just make one call to

__________________

I reject your reality, and substitute my own.

aye, sorry for the confusion, sock. I'm pretty sure I dont have the perms to be able to drop/delete an entire database.

Alan- that answers my question to a degree, but- the problem, and my fault for not bringing this up in my original post, is that I don't know all of the table names/prefixes in the db.

So, is it possible to drop all tables in the DB with something along the lines of this:

or

..?

Thanks for help so far!

Just DROP the database. If you don't have permissions, get them.

__________________