Finding a previous forum's Table Prefix

[inspiration100]

Can someone help me here... I bought a forum from someone and I would have expected to find the table prefix under phpmyadmin to be named "table" or something similar. But an idiot named it something other than that apparently... How can I distinguish this from all the other prefixes under my database? If I create a new one, will my forum act differently, will I lose information or will it run like before?

[punchbowl]

easiest way is probably to use phpmyadmin to inspect the database.

Or

you can do it through the command line like:

mysql -u root -p

use my_database;

show tables;

If you make a new database then it will be empty.

[inspiration100]

Well I can see all the tables, just which one do I use?

[punchbowl]

are they all prefixed with something? That's what you asked how to find out.

What else do you have in the db?

They may be all vbulletin tables.

[Seven Skins]

If you want to find out the name of the database you are using with your forum.
Download "config.php" form the server it has details of your database. Config.php is located in "includes" folder.

.

[punchbowl]

Originally Posted by Seven Skins

If you want to find out the name of the database you are using with your forum.
Download "config.php" form the server it has details of your database. Config.php is located in "includes" folder.

.

yes and it also references table prefixes, if any.

[inspiration100]

Thanks guys, you helped me figure it out. They had no prefixes so I left it blank and it worked!

Bravo. Thanks