How to erase database?

[Jack_mcs]

I'm in a situation where I keep having to reload my database (for troubleshooting). In order to make sure it is clean each time I have been going through and using Empty on each table but this is very time consuming. Is there a way to get a clean database with just one command or by copying over it or some other way?

 

Jack

[Guest]

are you worried about any of the settings? one thing i do is once the database is setup, i copy out the configuration area from the sql file, and when i want to reload an empty database, i just have to run the sql script again, and it is there. another way is once you have the next install done, where it is 'virgin' is to make a backup. then when you need to go back to a 'virgin' database all you have to do is run the restore. takes about 20 seconds at most to do that.

[Jack_mcs]

A few times when I moved things around in my troublshooting, the site acted as if some options were still present even though they should not have been. So I'm assuming the db has some left over settings that were not cleared.

 

I just tried the first method but it didn't work. I'm sure I''m doing it wrong - I'm new at this. I select export in phpmyadmin and then check structure only and go. It gives a list of the db on a new page. I use select all and then copy it to notepad and save a an sql file. When I try reloading it, I got a bunch of different errors like table already present.

 

I've used the second method that you mention and I get a message saying it did work but then I have the problem I mention above so it seems that not everything is being reset.

 

Jack

[241]

I keep regular staged backup of the database and if I need to clear the database I select all and use Drop to clear the database then load which ever sql is required