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:
Output:
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.
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)
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)
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)
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT OPENSOLARIS
mysqlshow
mysqlshow(1) MySQL database mysqlshow(1)NAME
mysqlshow
- Shows the structure of a mysql database (databases,tables and columns)
USAGE
shell> mysqlshow [OPTIONS] [database [table [column]]]
SYNOPSIS
mysqlshow [-#|--debug=...] [-?|--help] [-c|--character-sets-dir=...] [-C|--compress] [-h|--host=...] [-i|--status] [-k|--keys]
[-p|--password[=...]] [-P|--port=...] [-S|--socket=...] [-u|--user=#] [-V|--version]
DESCRIPTION
-#|--debug=...
output debug log. Often this is 'd:t:o,filename`
-?|--help
display help and exit
-c|--character-sets-dir=...
Directory where character sets are
-C|--compress
Use compression in server/client protocol
-h|--host=...
connect to host
-i|--status
Shows a lot of extra information about each table
-k|--keys
show keys for table
-p|--password[=...]
password to use when connecting to server If password is not given it's asked from the tty.
-P|--port=...
Port number to use for connection
-S|--socket=...
Socket file to use for connection
-u|--user=#
user for login if not current user
-V|--version
output version information and exit
NOTE
If last argument contains a shell or SQL wildcard (*,?,% or _) then only what's matched by the wildcard is shown. If no database is given
then all matching databases are shown. If no table is given then all matching tables in database are shown If no column is given then all
matching columns and columntypes in table are shown
SEE ALSO isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi-
lege_tables(1), mysql_zap(1), perror(1), replace(1)
For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online
at http://www.mysql.com/doc/en/
BUGS
Please refer to http://bugs.mysql.com/ to report bugs.
AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no
warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur-
media.com)
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+--------------------+------------------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+--------------------+------------------------------------+
|Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
+--------------------+------------------------------------+
|Interface Stability | External |
+--------------------+------------------------------------+
NOTES
Source for mysql is available on http://opensolaris.org.
MySQL 4.0 19 December 2000 mysqlshow(1)