Need Help with MySQL

[acivit]

Hi Everybody, I'm havin' this problem, I deleted a Forum from my site, now, I'm trying to add a new forum and there's a message:

An error occurred trying to update the database
Table 'phpbb_auth_access' already exists

the problem is, I don't know nothing about databases, I'm a WebDesigner

so, is somebody here in this forum can help me?

thanks so much!!

Arturo.-

[BerksWebGuy]

Do you have a database GUI...such as phpmyadmin (looks like SQL Enterprise)??

If you don't, you need one. Maybe you can rename the old table to something else or delete the old table to create a new one (may have to contact support@powweb.com to delete a table).

[Jade Dragon]

get a copy of phpMyAdmin installed. Just have to edit the config.php with your database info. Do not change directory name.

then go to yourdomain.com/phpMyAdminXXXXXX/

you will see all your tables to the left. Click on the database name that contains your tables you want to remove.

then hit structure (if your list isn't showing). that will list all the tables in the main window. Click the little box next to the ones you want to delete.

then scroll down to the very bottom of the page and select "drop" from the drop down menu. THIS WILL DELETE THOSE TABLES. so make sure you know which ones you want to delete. Have dropped several installs this way when testing phpbb out.

Also for multiple independant phpbb just change the table prefix from phpbb_ to whatever_


Also use .htaccess to password protect this directory.

Hope this helps. If you need more info I'll check back in a bit.

JD

EDIT: berkswebguy: *jinx* typing at the same time. :)

[acivit]

Thanks a lot for the tips, I don not know what is MySQLAdmin, I've something called IIS installed on my computer, but I don't know if I can say to somebody to do this for me, I don't know if this is possible, if someone can help me please, write me to this email address

arturo@creativeclick.com.mx

thanks so much!!

[vector]

If you don't need this table at all you can erase it.
Put this code into a .php file, upload the file to the server and call it from a web browser.

<?php

//-------change the following variables values

$dbase="your Mysql database name";
$host="your server DNS i.e. callisto.powweb.com";
$user="your MySql username";
$password="your MySql password";
$table="the table name";

//-------------------------------------------------------

$statement="DROP TABLE $table";

$link=mysql_pconnect($host, $user, $password);
mysql_select_db($dbase, $link);


mysql_query($statement, $link);

?>