Login or Register to Ask a Question and Join Our Community


Web Development

Deleting databases in MYSQL problem asking...

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Web Development Deleting databases in MYSQL problem asking...
# 1  
Old 02-04-2010
Deleting databases in MYSQL problem asking...
Hi,

I'm the new user of mysql. I facing one problem to delete one of the database in mysql. Hope can get all of your suggestion and advice.

Input:
Code:
mysql> show databases;
+-------------------------+
| Database                |
+-------------------------+
| information_schema      |
| mysql                   |
| test                    |
+-------------------------+
3 rows in set (0.00 sec)

Output:
Code:
mysql> show databases;
+-------------------------+
| Database                |
+-------------------------+
| information_schema      |
| mysql                   |
+-------------------------+
 2 rows in set (0.00 sec)

My purpose just would like to delete the "test" database. What command like or shell script I can create to archive my aims to delete the "test" database? Thanks a lot for any sharing and advice.
# 2  
Old 02-05-2010
From the MySQL Reference Manual, chapter 12, Section 1, Command 21
Code:
drop database test

Be advised that this is a DDL statement that cannot be undone, unless you have a backup.
Last edited by pludi; 02-05-2010 at 02:10 AM.. Reason: s/Handbook/Reference Manual/
# 3  
Old 02-05-2010
Hi
you may use the following in a script :-
Code:
mysql -u root -p<ur password> -e "drop database test"

cheers
# 4  
Old 02-05-2010
Thanks a lot, pludi.
Your code work perfectly and solve my problem Smilie
Thanks for your suggestion.

---------- Post updated at 01:56 AM ---------- Previous update was at 01:56 AM ----------

thanks for sharing Smilie
that is another way for me to solve my problem too ^^
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

MySQL Databases

Hello all again, How do you guys backup your MySQL databases? I have a few programs that have an default back up that make an .sql file which is great but I also use OpenX which runs on PHP and has a database. That does not have an auto-back-up feature so do I just download the... (2 Replies)
Discussion started by: AimyThomas
2 Replies

2. Shell Programming and Scripting

Problem in deleting files

Hi Guys, In one of my folders i have 10000 log files starting with sqlfile..... Iam trying to delete the log files alone from the folder using for loop but i am getting an error ksh: /usr/bin/ls: 0403-027 The parameter list is too long. For loop i used for i in `ls sqlfile*`... (4 Replies)
Discussion started by: mac4rfree
4 Replies

3. Shell Programming and Scripting

Problem with deleting

Hi, I have a folder A which contains files 1,2,3... I also have a file xyz under a diff folder B containg the entries 1,2,3... I am trying to compare and delete the nonexisting ones from xyz using the below code: QFILE=/B/xyz cd A ls -1 > /tmp/file1 for fname in `cat $QFILE` do if ... (4 Replies)
Discussion started by: swasid
4 Replies

4. Web Development

deleting file created from mysql

Hi, I executed the query in mysql as "select * into outfile "/tmp/result.out" from table_x; which inturn wrote all the records in that table to file in /tmp directory.After this i tried to delete the file "/tmp/result.out", but can't able to do that. Is there any way to achieve... (2 Replies)
Discussion started by: DILEEP410
2 Replies

5. UNIX for Advanced & Expert Users

problem with deleting a file

hi friends, i need to delete a file named "-vyxx-.0.sdct.txt" i'm unable to use "rm -vyxx-.0.sdct.txt" jus give me your suggesstions thanks in advance (5 Replies)
Discussion started by: rprajendran
5 Replies

6. UNIX for Dummies Questions & Answers

problem while deleting a file

Hi , In a particular path the below mentioned three files has been created. -rw-r--r-- 1 edwprod edw 0 Jun 5 00:06 -f%*lock.clock -rw-r--r-- 1 edwprod edw 151 Jun 5 00:06 -f.log -rw-r--r-- 1 edwprod edw 4 Jun 5 00:06 -f%conn_err.out ... (5 Replies)
Discussion started by: anupam_jash
5 Replies

7. UNIX for Dummies Questions & Answers

problem in deleting a file

Hello: I made this mistake on my tru64 machine, I renamed a file from: binary.errlog to binary.errlog(B3) now when im tryign to move or delete the file Im getting: # rm binary.errlog(B3) ksh: syntax error: `(' unexpected 4# mv binary.errlog(B3) log ksh: syntax error: `(' unexpected ... (3 Replies)
Discussion started by: aladdin
3 Replies

8. Shell Programming and Scripting

Mysql problem

No help guys??? :( Hi guys, i've got a question here... my intention is to write a script that would access a mysql db and extract some info and paste it into a file... so the first move would be, to access the mysql interface right? hence... #! /usr/bin/ksh echo "Job Begin: " `date` ... (1 Reply)
Discussion started by: 12yearold
1 Replies

9. UNIX for Dummies Questions & Answers

Problem while Deleting file

All, I am trying to delete a user created file from specified folder. This folder is using for my Team member (i.e, Public folder). For example, $ ls -l total 1336 -rw-rw-r-- 1 g_btha customer 2655 Dec 06 12:35 A_COL_1001 While deleting/moving this file I am getting the following... (3 Replies)
Discussion started by: nvkuriseti
3 Replies

10. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

MySQL on my server is down.... I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock Any suggestions? Here's what I can't do: can't be root don't have physical access (do stuff via SSH) reinstall MySQL (need to keep the current MySQL... (8 Replies)
Discussion started by: _hp_
8 Replies
Login or Register to Ask a Question