MySQL in unix shell...

[New Born]

Hi,
I am facing some problem and I am really really new to MySQL..I installed yabbse
on my forum and then XMB forum. Now I reinstalled the XMB and it says Duplicate Key
means already any table exists...

Now how can I delete all the tables in database..I dont have any interface to do
that...These are unix commands on Telnet

edit
connect
status
go

etc...

or how can I use this command
mysql_drop_db -- Drop (delete) a MySQL database

I want to delete all the tables which I dont use...
please help me

Tell me the unix commands which I should write and delete

Bruce.

[Flash-db]

Best Solution:  Install phpMyAdmin

You can install phpMyAdmin on any server that PHP is running on.  You do not need to set any special server settings or anything else - just upload the phpMyAdmin scripts and add your username/password to the configuration file.  Then your done.  Everything will become about 100 times more clear with phpMyAdmin installed.  Makes it much easier to delete tables, edit, insert etc.  As well as transfer tables and database's from one computer to another.

[Jorge Solis]

If you are in a hurry, use Mysql client in UNIX shell via Secure Telnet with these commands

mysql -u 'user' (use your user, you'll be ask for the password)
use database xxx
drop table xxx

and so on until you delete all the tables
Think that the tables are files under the data folder of MySQL (the database is simple a folder) You can also delete the folder if you have the rigths.

Good Luck
Jorge
www.estudiobaires.com