PDA

View Full Version : Any way to wipe out a whole DB in one shot?

Fab5ISO
2-14-04, 10:15 AM
Something got coruppted and I need to rebuild it. Thanks :)
alphadesk
2-14-04, 10:22 AM
You can login to phpmyadmin (http://phpmyadmin.powweb.com/) ... click on DB name top left column.

All tables then show in right column. tick the box to select all tables ...

Then use the drop down menu to to do what you need.

drop, repair etc ... all tables
Fab5ISO
2-14-04, 11:06 AM
Originally posted by alphadesk
You can login to phpmyadmin (http://phpmyadmin.powweb.com/) ... click on DB name top left column.

All tables then show in right column. tick the box to select all tables ...

Then use the drop down menu to to do what you need.

drop, repair etc ... all tables

Got that fixed, put the new forum in and now I'm getting 500's with this error:

[Sat Feb 14 00:11:19 2004] [error] [client 68.101.148.28] Premature end of script headers: /www/g/guer/htdocs/forum/index.php
[Sat Feb 14 00:11:20 2004

What gives ughhhhhhh
alphadesk
2-14-04, 11:14 AM
What's the url to this forum ?

Make sure you you have folders/files chmod correct.
Fab5ISO
2-14-04, 11:30 AM
Originally posted by alphadesk
What's the url to this forum ?

Make sure you you have folders/files chmod correct.

http://www.galacticunion.com/forum
HalfaBee
2-14-04, 03:55 PM
Make sure your forum dir is chmod to 755
Fab5ISO
2-14-04, 05:05 PM
Originally posted by HalfaBee
Make sure your forum dir is chmod to 755 at 755 and still no good
HalfaBee
2-14-04, 05:08 PM
All files need to be 644 or 755 as well.
Fab5ISO
2-14-04, 09:36 PM
now I need to find out what my table Prefix is? How?
alphadesk
2-14-04, 10:50 PM
Depending on the forum script it will assign a prefix for all your tables. If you don't want to use default prefixes you can change them in the setup

for example all tables for phpbb forum will be

phpbb_tablename

for example all tables for invision board forum will be

ibf_tablename
Fab5ISO
2-14-04, 11:31 PM
Originally posted by alphadesk
Depending on the forum script it will assign a prefix for all your tables. If you don't want to use default prefixes you can change them in the setup

for example all tables for phpbb forum will be

phpbb_tablename

for example all tables for invision board forum will be

ibf_tablename

Let me clarify....how do I find out what my old table prefix was?
alphadesk
2-14-04, 11:45 PM
If you dropped the tables ... there gone and not sure why it would matter doing a new install.

What forum script are you installing?
HalfaBee
2-14-04, 11:59 PM
You could have a look in your backup files.

The table names will be there.