Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock under cpanel , i had to first locate the correct mysql.sock file by running find / | grep “sock” and them created a symlink to that lock file from the /var/tmp folder The strange that is the my.cnf files claims the sock file is located at [...]
After moving restoring my data I notice i was had some ???? question marks . The character set and collation was incorrect . For my example the character setis utf8 and the collation is utf8_persian_ci set name uts8 ALTER TABLE tbl_name [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name] http://dev.mysql.com/doc/refman/5.0/en/charset-table.html http://www.bluetwanger.de/blog/2006/11/20/mysql-and-utf-8-no-more-question-marks/ http://en.wikipedia.org/wiki/Persian_language alter db ALTER DATABASE `dbname` [...]
MyISAM tables (the default table type in MySQL) become fragmented when you delete records (this can even happen when you update records, if your table format is dynamic). You cannot avoid this effect if you’re using MyISAM tables. If you don’t optimize fragmented MyISAM tables, they will become slow to scan because the operating system [...]