mysql: Incorrect information in file:
Incorrect information in file /path/test.frm This indicates that skip-innodb is enabled in the my.cnf file ..
Incorrect information in file /path/test.frm This indicates that skip-innodb is enabled in the my.cnf file ..
Error : ERROR 3 (HY000): Error writing file ‘/tmp/MY68ie0h’ (Errcode: 28) this is due to a storage issue with the partition that is holding /tmp
You may encounter a max user connection error if your my.cnf file is set to a low number and you have mysql.allow_persistent = on within your php.ini file. You have two ways to fix this . 1) use a mysql_close() statement within your code. this is not needed for non-persistent connection per the PHP manual [...]
mysql> show grants for ‘user’@’host’ or select * from information_schema.user_privileges where grantee like “‘user’%”; Tools Maakit
Thanks to VIVEK GITE for this —— Drop all tables using shell script w/o root access Nice script to run via shell I’ve small handy shell script that removes all tables without dropping and creating MySQL database again. #!/bin/bash MUSER=”$1″ MPASS=”$2″ MDB=”$3″ # Detect paths MYSQL=$(which mysql) AWK=$(which awk) GREP=$(which grep) if [ $# -ne [...]