Category: 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 …

Edit the MySQL configuration file. Configuration file can be found in /etc/my.cnf or /etc/mysql/my.cnf. Add or edit following row: bind-address=127.0.0.1 Restart the database server. $ sudo /etc/init.d/mysql restart

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 …

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 …

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.