Linux Server and Workstation Configuration How To

1. How to Export, Backup Or Dump A MySQL Database

Tags: [Export, Backup, Dump, MySQL, Database]  ...

2. How to Backup Only Data of a MySQL Database

Tags: [Backup, MySQL, Database]  ...

3. how to Backup MySQL databases

Tags: [backup, MySQL, database]  ...

4. Transferring a FreeBSD on new hard drive

... Size /dev/ad1s1a may be greater than /dev/ad0s1a. Create a temporary folder and subfolders: mkdir /backup mkdir /backup/root mkdir /backup/usr mkdir /backup/var mkdir /backup/tmp Boot ...

5. mv

Command mv Renames files and directories or move them from one directory to another. Syntax mv [options] source destination Options -b creates backup copies of files that are moved or renamed. ...

6. How To Enable Root Login on Fedora

... file (first create backup of config file). Type gedit /etc/pam.d/gdm or vi /etc/pam.d/gdm Put # before auth required pam_succeed_if.so user != root quiet line, after that file shuold look ...

7. cp

... file. -b creates a backup copy before copying the file. -d copy the link, but not the file pointed to by this reference. -i asks for confirmation before overwriting files. -l creates hard links instead ...

8. 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 ...

9. 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 ...

10. 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  ...

11. How to Online Backup Innodb Tables

Backup the database inevitable cause MySQL server unavailable to applications because when exporting, all tables acquired a global read lock using FLUSH TABLES WITH READ LOCK at the beginning of the dump ...

12. Send Mail Script

Mail content text is /tmp/message.txt # mail -s 'Server Status Report' george@example.com -c Jon@example.com < /tmp/message.txt Send Mail With Attachment # !/bin/bash # tar -zcf /tmp/backup.tar.gz ...

13. Default Port Numbers

... french minitel support 1529/tcp # GNATS cfinger 2003/tcp # GNU Finger ninstall 2150/tcp # ninstall service ninstall 2150/udp # ninstall service afbackup 2988/tcp # Afbackup system afbackup 2988/udp # ...