[How To] Backup Only Data of a MySQL Database

[How To] Backup Only Data of a MySQL Database

For exporting MySQL database’s only the data, use –no-create-info option. The dump will not re-create the database, tables, fields, and other structures when importing. mysqldump -u username -ppassword –no-create-info database_name > dump.sql Use this …
[How To] Backup MySQL Databases

[How To] Backup MySQL Databases

There are two methods to backup MySQL, first method is by copying all files such have extentions *.frm, *.MYD, and *.MYI, and second is by using mysqlhotcopy utility, this methods are only for MyISAM tables.
Seven Layers of the OSI Model

Seven Layers of the OSI Model

The Seven Layers of the OSI Model 7 Application Network Process to Application   Provides network services processes to application processes (such as electronic mail, file transfer,…) Provides user authentication         6 …
FreeBSD Wallpaper

/etc/services (Default Port Numbers) [System Files]

/etc/defaults/rc.conf Here is the original FreeBSD /etc/services file # /etc/services: # $Id: etcservices.txt,v 1.2 2005/12/18 13:54:31 francis Exp $ # # Network services, Internet style # # Note that it is presently the policy of …
Linux, UNIX Directories

Linux, UNIX Directories

Linux directory structure Mount Point Explanation / Root directory /bin Main program /boot Used at boot /dev directory Where the registered user devices (modem, mouse, keyboard, etc.) /etc Configuration files /home Home directories of users, …
Transfer of static routes to DHCP

Transfer of static routes to DHCP

Write in the main section of the configuration file of DHCP server: option ms-classless-static-routes code 249 = array of unsigned integer 8; option rfc3442-classless-static-routes code 121 = array of unsigned integer 8; add this in …