Category: HOW TO

MySQL

[How To] Export, Backup Or Dump A MySQL Database

To export a MySQL database into a dump file, simply type the following command syntax in the shell. mysqldump -u username –ppassword database_name > dump.sql Replace username, password, database_name and dump.sql as your needs. All …
MySQL

[How To] Export A MySQL Database Structure

If You need to export only the MySQL database’s tables’ structures use –no-data switch. mysqldump -u username -ppassword –no-data database_name > dump.sql Don’t put space after -p and then password
MySQL

[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 …