delete 1 MYSQL database

[kii_kid]

how can i delete a database?

[BerksWebGuy]

contact support@powweb.com .

If you want to reuse a DB, you can drop all the tables, rename the db, and add a new user.

[exito100]

contact support@powweb.com .

If you want to reuse a DB, you can drop all the tables, rename the db, and add a new user.

how do I "drop" all the tables? I am interested too :)

[BerksWebGuy]

You can DROP tables through phpmyadmin (under the structure tab)....either by inidividual or checkbox all of them
You can DROP tables with a query using PHP or the query tab in phpmyadmin: http://www.w3schools.com/sql/sql_drop.asp

[joco]

Hi, I think this thread is likely to get pretty popular with all the site tools that were recently added with the "instant installer."

I'm here because I had all 5 free mysql db's taken up. Can I do the "table drop" mentioned above and use an old database again on the instant installer?

Well, I hope so because I'm trying it right now.

- Nope, doesn't work. I tried using the admin name and password that the db uses and changing to the corresponding db name in the drop down on the "warning, you will be billed" page.

Any help?

Thanks

[Croc Hunter]

joco: Please email support@powweb.com with your domain name and the exact database name/s you want deleted.

[RTH10260]

I'm here because I had all 5 free mysql db's taken up. Can I do the "table drop" mentioned above and use an old database again on the instant installer? You don't need to drop any database. You keep it and just delete its contents, eg in phpmyadmin click on the database name in the left margin to show the structure in the right, eg all tables. At the bottom of the list click on the Select All link and from the functions in the center chose DropTables. Once the database is emptied like this, you can reuse it for whatever else you wish. Note that several applications will allow you to specify a 'table name prefix' to they can share a single database with similar cooperating applications.

To change the name of a database, or the usernames used with it, go to OPS > package > MySql, select the database and modify as needed.

[Croc Hunter]

RTH10260: The instant installers create their own database. joco will need staff to delete some old ones to free up room before he can use the instant installers again.

[RTH10260]

RTH10260: The instant installers create their own database. joco will need staff to delete some old ones to free up room before he can use the instant installers again.
Thanks for the information tidbit.

As I have not been playing around with the Instant Installer, so I haven't made that experience. I just know that the old installer for osCommerce, and the Powweb Website Builder dropped the software into my site layout without asking where I would like it and in a way I didn't like. Especially the website builder installation was near to trash some existing content. :(

Not very economical way of handling databases by the Instant Installer, considering that many applications allow for sharing with a table name prefix.

[Croc Hunter]

Not very economical way of handling databases by the Instant Installer, considering that many applications allow for sharing with a table name prefix.Yeah it's not economical but easy for those who don't even know what MySQL is. I see a few problems with the current installer setups. The main one being only staff can disable db's then it takes 14 days before they are actually deleted. Considering only 7 days db backups are kept a few unhappy campers are bound to appear.