IndianWebPortal.com

mysql_pconnect() will maintain a persistent connection to the database. Whenever your script calls the connect to database function, it first searches already existing connections to the database and if exists it will use the same connection to connect to the database, if not it will open a new connection to the database. ie. Connection is  [ Read More ]

Hosting Company ============================= DB_HOST Value Guess ====================== 1and1 db12345678 AN Hosting localhost BlueHost localhost DreamHost mysql.example.com GoDaddy h41mysql52.secureserver.net HostGator localhost HostICan localhost ICDSoft localhost:/tmp/mysql5.sock LaughingSquid localhost MediaTemple GridServer internal-db.s44441.gridserver.com one.com localhost pair Networks dbnnnx.pair.com Yahoo mysql Hosts with cPanel localhost Hosts with Plesk localhost Hosts with DirectAdmin ============================= localhost =======================

Update to latest Mysql version provided by cpanel To upgrade the mysql on the cpanel server * The best method to use the cpanel #/script/mysqlup to upgrade the mysql. * To upgrade the mysql from 4.0.x to 4.1.x you need to enable the mysql upgrade in the whm under tweak setting /scripts/upcp –force /scripts/mysqlup –force

How to connect to Database for any user through Server # mysql -u DBNAME -p DBPASS command for taking  mysql backup:=> #mysqldump databasename > file.sql command for restoring : => # mysql -u [username] -p[password] [database] < [backup_file] or #mysql database name < file.sql