Setting up NFS server and client on FreeBSD and Linux [How To]

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 (For Linux) (start – service start portmap …
[How To] Restore and Import MySQL Database

[How To] Restore and Import MySQL Database

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 < dump.sql Don’t put space after -p …
[How To] Online Backup Innodb Tables

[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 until finish. So …
[How To] Export, Backup Or Dump A MySQL Database

[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 …
[How To] Export A MySQL Database Structure

[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