1. Unzip to/usr/local/mysqlgroupaddmysqluseradd-gmysqlmysqlcd/usr/local/mysqlchown-Rmysql.chgrp-Rmysql.chown-Rroot.chown-Rmysqldatacp/usr/local/mysql/support-files/mysql. se under Ubuntu
1. Unzip the package to/usr/local/mysql In Ubuntu.Groupadd mysqlUseradd-g mysqlCd/usr/local/mysqlChown-R mysql.Chgrp-R mysql.Chown-R root.Chown-R mysql dataCp/usr/local/mysql/support-files/mysql. server/etc/init. d/mysqldCp
Install unzip at in CentOS source code
Install unzip at in source code:
# Wget http://perso.orange.fr/sebastien.godard/sysstat-8.0.4.1.tar.gz# Tar zxvf sysstat-8.0.4.1.tar.gz# Cd sysstat-8.0.4.1#./Configure# Make# Make install
Use iostat to analyze servers under too much pressure:
$ Iostat-x 1Linux 2.6.33-fukai (fukai-laptop) _ i686 _ (2 CPU)Avg-cpu: % user % nice % system % iowait % steal % idle5.47 0.50 8
Extract sequence assignment to multiple objectsAny sequence (or an iterative object) can be extracted and assigned to multiple variables by a simple assignment statement. The only prerequisite is that the number of variables must be the same as the number of elements in the sequence.>>> data = [' ABCD ', ' a ', 1, 2, (3,4)]>>> a,b,c,d,e = Data>>> a,b,c,d,e(' ABCD ', ' a ', 1, 2, (3, 4))>>> a,b,c,d, (e,f) = data>>> F4>>>This decompression assignment can be used on any iterator object, not just a
Scenario: Package files under the Project_a folder into Project.war 1. PackagingJAR-XVF project.war/project_aDescription-C Create War package-V Show Process information-f Specifies the JAR file name, usually this parameter is required-M does not produce a manifest for all items (the Manifest) file, this parameter ignores the-m parameter-0 This is the Arabic numeral, only packing does not compress the meaning2. UnzipJAR-XVF Project.warNote: Unzip to t
FileOutputStream (Zippath));*/ //BOS = new Bufferedoutputstream (ZOS); //Buffer ...//}else{// // }File F=NewFile (FilePath); // //Create ZipFileInputStream FIS =NewFileInputStream (f);//Bufferedinputstream bis = new Bufferedinputstream (FIS); //set the file name in the. zip file//Zos.putnextentry (New ZipEntry (Zipentryname));Zos.putnextentry (NewZipEntry (F.getname ())); //Set the DeclearZos.setcomment ("by Zip test!");//byte[] b = new byte[102
Today, in the Linux server to extract a zip compression package, the following error message: [Email protected] zip_bcsa_courses]#Unzipbcsa_medias_bak_20161118.ZipError:zipfileToo big (greater than4294959102bytes) archive:bcsa_medias_bak_20161118.Zipwarning [bcsa_medias_bak_20161118.Zip]:31450041244Extra bytes at beginning or within ZipFile (attempting to process anyway) error [bcsa_medias_bak_20161118.Zip]: Start of Central directory is not found; ZipFile corrupt. (Please check the transferred
Liunx DeleteDelete Folder instance: Rm-rf/var/log/httpd/access will delete the/var/log/httpd/access directory and all files and folders under it2 Delete File Usage instance: Rm-f/var/log/httpd/access.log will force the deletion of/var/log/httpd/access.log this fileLiunx tar.gz extract to the specified directory1. Compress the command:Command format: TAR-ZCVF compressed file name. tar.gz Compressed file nameYou can switch to the current directory first. Both the compressed file name and the compr
We are in the maintenance of Linux server, often encountered to view the contents of various formats of compressed files, here I picked a few common format files, record, easy to find later.1. tar format file tar tvf test.tar2, tar.gz format file TAR-ZTF test.tar.gz3, tar.bz2 format file TAR-JTF test.tar.bz24, zip format file unzip-v TEST.ZIP5 , bzip2 format file Bzip2-tv test.bz26, rar format File Note: Additional Unrar software required (yum install
+ system.getproperties (). GetProperty ("File.separator");for (int i = 0; i {Zip (out, fl[i], base + fl[i].getname ());}}Else{//Compress all files in the directoryOut.putnextentry (new Org.apache.tools.zip.ZipEntry (base));ZipEntry zipentry=new ZipEntry (base);Zipentry.setunixmode (644);//Solve Linux garbledOut.putnextentry (ZipEntry);FileInputStream in = new FileInputStream (f);int b;while ((b = In.read ())! =-1){Out.write (b);}In.close ();}}private static void
backup file.-X releases the file from the archive file.3.2 Auxiliary Options:-B This option is set for the tape drive, followed by a number to indicate the size of the chunk, with a system preset value of 20x512 bytes.-F using a profile or device, this option is usually required.-K saves the file that already exists. For example, restoring a file, encountering the same file during the restore process, does not overwrite it.-M when restoring files, set the modification time of all files to.-M cr
Gzip Command: File compressionGzip is GNU software and is the preferred compression tool for Linux systems, and the-Z option compression of the TAR Archive command also uses Gzip/gunzip to compress/unzip files.gzip Generate. gz fileGrammar:gzip [options] [File or directory ...]Parameters:-C or--stdout or--to-stdout to output compressed (decompressed) content to the standard output device and retain the original file-D or--decompress decompression-L or
#!/usr/bin/env python#-*-coding:utf-8-*- fromZipFileImport*ImportZipFile#Unzip the zip filedefunzip (): Source_zip="C:\\update\\sw_servers_20120815.zip"Target_dir="c:\\update\\"Myzip=ZipFile (source_zip) myfilelist=myzip.namelist () forNameinchMyfilelist:f_handle=open (Target_dir+name,"WB") F_handle.write (myzip.read (name)) F_handle.close () myzip.close ()#add a file to an existing ZIP packagedefAddzip (): F= ZipFile. ZipFile ('Archive.zip','W', Zip
Linux Unzip the tar commandTar-zcvpf/backup/home.tar.gz/home with file attribute permission compressionTar cvpft/backup/config.tar/backup/configlist compression According to the list in the Configlist filetar-zxvpf/software/home.tar.gz with file attribute permissions decompressiontar [-cxtzjvfppn] files and directories ....Parameters:-C: Create a compressed file parameter directive (the meaning of Create);-x: Unlock the parameter instructions for a co
list all the files in the All.tar package,-T is to list the meaning of the fileThis command is to solve all the files in the All.tar package,-X is the meaningCompressiontar –cvf jpg.tar *.jpg //将目录里所有jpg文件打包成tar.jpgtar –czf jpg.tar.gz *.jpg //将目录里所有jpg文件打包成jpg.tar后,并且将其用gzip压缩,生成一个gzip压缩过的包,命名为jpg.tar.gztar –cjf jpg.tar.bz2 *.jpg //将目录里所有jpg文件打包成jpg.tar后,并且将其用bzip2压缩,生成一个bzip2压缩过的包,命名为jpg.tar.bz2tar –cZf jpg.tar.Z *.jpg //将目录里所有jpg文件打包成jpg.tar后,并且将其用compress压缩,生成一个umcompress压缩过的包,命名为jpg.tar.Zra
This article summarizes the SQL Server 2005 Command prompt utility for reference learning applications.
Practical Tools
Description
Installation location
bcp utility
Used to copy data between a Microsoft SQL Server instance and a data file in a user-specified format.
X:program FilesMicrosoft SQL Server90toolsbinn
DTA Utili
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.