Author: lc-root

NFS server (FreeBSD): /etc/rc.conf: portmap_enable = "YES" nfs_server_enable = "YES" nfs_reserved_port_only = "YES" /etc/exports (FreeBSD) /usr/local/nfs-rw 192.168.1.2 /usr/local/nfs-ro-mapall = nobody-network 192.168.1-mask 255.255.255.0 /cdrom-alldirs, quiet, ro-network 192.168.33.0-mask 255.255.255.0 /etc/exports

Configuring MySQL to listen to localhost only is a great way to secure your data from malicious attacks. This guide will help you to understand how you can

You should upload the dump file to the MySQL server, and type this command to import the databases into the MySQL server. mysql -u username –ppassword database_name <

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

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,

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 [box type=”warning”] Don’t put space after

Use –databases option for exporting several databases. mysqldump -u username -ppassword –databases db_name1 [db_name2 ...] >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

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,