ooops! This is a good idea! BUT where is this error log?
does not help (searching in /usr/local/mysql-5.6.11-osx10.7-x86_64). Sorry for this beginner question! And the system.log in /var/log/ does not tell anything of mysql server ...
:confused:
Hi Guys,
I'm not new to UNIX but I am new to HP-UX. I have a proven backup and restore procedue using cpio on Solaris, however, the filesystem structure appears to be different on HP. Can anybody help me with the following questions?
1) What is the best method for performing a... (7 Replies)
Hi.... everyone could help me to understand how to do a backup of my servers .. operating systems is sun solaris 8 .
I have some question about ....
1) Is better backup phisical disk or partition ???
i sow the command is ufsdump 0cfu /expbck/bcksunver/c0t0d0s5 dev/dsk/c0t0d0s5 to... (4 Replies)
I have several H80 machines, all with AIX 4.3.3. On these machines I have mksysb running for rootvg backups and savevg for non-rootvg backups.
I'm trying to get a list of files on the tapes, but I can't seem to do it with tar for the mksysb images. I keep getting the directory checksum errors?... (3 Replies)
Hello!
i have a blank harddrive and a complete tape backup of the workstation.
the backup is made with F-Backup.
Now my question is:
how can i restore my workstation?
thanks for every idea!
paul tittel
hup-si (3 Replies)
I am trying to do a restore on a backup tape (DDS2) and am having a little trouble. For one, I dont know how the tape was made, whether is was tar, cpio, dump..etc. Anyone know how to restore a tape without knowing the format of the backup? (5 Replies)
hi people i am in need of some assistance here hoping to star a linux course in january to wanted to get some experiance before starting so got a hold of some old assessments from a mate at college so just working through them in my spare time for the past 8 weeks or so and this is the final ? that... (2 Replies)
Hello everybody,
i am trying to make a script in UNIX to backup some compressed files to a tape drive. The thing is that i cannot use cpio command because some of these files are greater than 2GB. so i think the only solution left is backup command.
to restore the files i should use the... (6 Replies)
Hi experts, i got a question.
i have a production server with two Volume Group(VG) which are rootvg and datavg. Both of these VGs are 256 PP SIZE.
On Disaster Recovery Server (DR server) contains two empty hardisks for restoring rootvg and datavg from production server. This two hardisks are... (7 Replies)
Hi,
I need to back up a RH file system (96G).
The files are oracle .dbf format some of which are 5G in size.
I know that tar has got a size restriction of 2G so I cannot use this.
Can anyone recommend an alternative way of backuping up this FS?
I have been looking at dump but this... (6 Replies)
Discussion started by: Duffs22
6 Replies
LEARN ABOUT REDHAT
mysqlshow
MYSQLSHOW(1) General Commands Manual 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), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror
(1), replace (1), safe_mysqld (1), which1 (1), zap (1),
AUTHOR
Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). 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.mer-
curmedia.com)
19 December 2000 MYSQLSHOW(1)