View Single Post
  #7  
Old 06-23-2003, 06:25 PM
Velosity
Sarnak
 
Join Date: May 2003
Location: Rancho Cucamonga, Ca
Posts: 77
Default

if you wish to drop a table just go into mysql and type this

Code:
MySql> use databasename;
Database Changed
MySql> drop table tablename;
Query OK, Yadda Yadda
If you wish to back up your database open up your command prompt (open start menue, go to run, open cmd) or open your MS-DOS prompt

then type this in

[Prompt]
C:\>cd c:\mysql\bin
C:\Mysql\Bin\> mysqldump databasename > filename.sql
[/Prompt]

That will put your database in a sql file

If you want just a specific table from your database dumped so you can do a drop table command type this

[Prompt]
C:\>cd c:\mysql\bin
C:\Mysql\Bin\> mysqldump databasename tablename > filename.sql
[/Prompt]

Hope that helps
Reply With Quote