deleting database

[cihangir]

how can i delete a database using telnet?

mysql -uUSER -pPASSWORD drop <database> ?

thanks

[Chris Schreiber]

You're very close :)

mysql -uUSER -pPASSWORD
mysql> drop <database>;

Just be careful, once you drop your database it's gone forever.

-Chris

[cihangir]

i did not want to post a new topic. i looked at other messages, but have still something what i must ask :)


%mysqlimport -d forums_db /path/to/your/template.sql

A few notes:
the "-d" argument deletes all the data in the table you are importing to
whatever your your backup file is called, that's the table it will be loaded into in your database. So if you named your file "mybackup.sql", mysqlimport will strip the ".sql" part and load the contents into the "mybackup" table - so you'll probably want to make sure that you call your backup file "template.sql".


can i use

mysql -uUSERNAME -pPASSWORD <database> < /path/to/your/template.sql

to import a table or my database too and is it important that a database/table is empty before i begin with importing?