-
FreeBSD MYSQL Configuration
thanks to http://www.barik.net/archive/2008/05/26/114616/ for the tip. FreeBSD does not automatically include a default my.cnf for MySQL. Instead, a set of sample configuration files can be found under /usr/local/share/mysql. These configuration files include my-small.cnf, my-medium.cnf, my-large.cnf, my-innodb-heavy-4G, and my-huge.cnf. The appropriate file can be copied and used as a template configuration by performing the following actions: cd /usr/local/share/mysql/ cp /usr/local/share/mysql/mysql-large.cnf /usr/local/etc/my.cnf /usr/local/etc/rc.d/mysql-server restart
-
Open Port 3306 in ubuntu 12.04 to allow connections to mysql from any ip
server running on a server and I wanted to know how to Open a Port 3306 in ubuntu 12.04 to allow connections to mysql from any ip mysql> select user,host from mysql.user; GRANT ALL ON *.* to user@’%’ IDENTIFIED BY ‘user-pwd’; mysql> FLUSH PRIVILEGES; mysql> select user,host from mysql.user; mysql>quit Also need to comment out…
-
Mysql Error Got error 28 from storage engine
Problem : Limited Storage cek your Storage > df -h find the biggest file > find /data -ls |sort +6nr |head remove some file to other directory
-
Mysql Repair
The database server needs to be running to do any of these checks. Log in as ‘root’ via SSH and: Shows you if any need repair: myisamchk –check /var/lib/mysql/*/*.MYI Then try ‘safe-recover’ first: myisamchk –safe-recover /var/lib/mysql/*/*.MYI and, if neither that nor this works: myisamchk –recover /var/lib/mysql/*/*.MYI Then use the ‘force’ flag: myisamchk –safe-recover –extend-check –force…