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...
Tag: mysql
Database Hostname In mysql config file
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...
Update to latest Mysql version provided by cpanel
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...
Mysql commands
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 -p < or #mysql database name <...