cPanel :: MySQL server is currently offline
Posted by blackonsole on November 22nd, 2012 03:40 AM | No Comment
:: How to fix if you got "MySQL server is currently offline" in cPanel
just change mysql root password via WHM:
WHM - SQL Services - MySQL Root Password - Change the password
:: Links
+ Google
+ HostOutCast
:: Install DBMail Administrator on CentOS
Posted by blackonsole on December 2nd, 2011 10:14 AM | 1 Comment
:: What is DBMA
DBMail is an open source, Unix IMAP/POP3 mail storage and retrieval system which together with an MTA (Mail Transfer Agent) like Postfix enables vastly scalable mail systems with SQL database (RDBMS) storage (i.e.: MySQL, PostgreSQL) and retrieval of all e-mail and user data. - dbma
:: Install MySQL 5.5 from source
Posted by blackonsole on November 17th, 2011 10:18 AM | No Comment
:: What is MySQL
MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. - wikipedia
:: How to install MySQL 5.5 on Linux OpenSUSE
:: drop all tables in mysql db
Posted by blackonsole on May 24th, 2011 04:04 AM | No Comment
:: how to drop all tables in mysql db
$ mysqldump -u -p --add-drop-table --no-data | grep ^DROP | mysql -u -p
:: links
+ google
+ thingy
Repair db / table mysql on centos
Posted by blackonsole on April 3rd, 2011 12:57 AM | No Comment
|| what is mysql
please take a look this..
|| how to repair db mysql on linux centos
# /etc/init.d/mysqld stop
# myisamchk -r -q /var/lib/mysql/DB_NAME/*.MYI
# /etc/init.d/mysqld start
|| how to repair table mysql
# /etc/init.d/mysqld stop
# myisamchk -r -q /var/lib/mysql/DB_NAME/TABLE_NAME.MYI
# /etc/init.d/mysqld start
|| links
| google
| thegeekstuff
Install phpmyadmin on linux
Posted by blackonsole on March 28th, 2011 04:13 AM | No Comment
|| what is phpmyadmin
please take a look this
|| how to install phpmyadmin on linux
| download phpmyadmin package
# cd /var/www
# wget //sourceforge.net/projects/phpmyadmin/files%2FphpMyAdmin%2F3.3.10%2FphpMyAdmin-3.3.10-english.tar.gz/download#!md5!f399aed03797442d535a75b9fffe81fc
| installing phpmyadmin on web root
# cd /var/www
# tar -xzf phpMyAdmin-3.3.10-english.tar.gz
# mv phpMyAdmin-3.3.10-english phpmyadmin
| accessing phpmyadmin
goto url on:
//yourhostname.tld/phpmyadmin
|| links
| google