Linux/Unix Tutorials and Configuration.

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 …

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

Use –databases option for exporting several databases. mysqldump -u username -ppassword –databases db_name1 >dump.sql

To damp all MySQL databases, use the –all-databases option. mysqldump -u username –p password –all-databases > dump.sql

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 …

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.

Mail content text is /tmp/message.txt mail -s 'Server Status Report' [email protected] -c [email protected] < /tmp/message.txt Sending mail with attachment # !/bin/bash tar -zcf /tmp/backup.tar.gz /home/david/files echo | mutt -a /tmp/backup.tar.gz -s “daily backup of data” …

/sbin/ifconfig ppp1 down /sbin/ip link set ppp1 name my_ppp /sbin/ifconfig my_ppp up

Problem kernel: irq 153: Please try booting with acpi=off and report a bug Apr 2 11:14:17 localhost kernel: irq 153: nobody cared! (screaming interrupt?) Apr 2 11:14:17 localhost kernel: irq 153: Please try booting with …

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 …