Edit the MySQL configuration file. Configuration file can be found in /etc/my.cnf or /etc/mysql/my.cnf. Add or edit following row:
Restart the database server.
$ sudo /etc/init.d/mysql restart
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... 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... 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...