IndianWebPortal.com

Something Different In Linux

Home » Posts tagged 'mysql'

why mysql_pconnect is disabled on shared server

Posted by Rishikesh Vispute Categories: mysql

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 ]

Database Hostname In mysql config file

Posted by Rishikesh Vispute Categories: mysql

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

Posted by Rishikesh Vispute Categories: mysql

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

Mysql commands

Posted by Rishikesh Vispute Categories: mysql

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

Popular Posts

remove index.php fro

How to remove index.php from url in magento Ans : If you ...

PHP-Java bridge on p

  What is php-java bridge? The php-java bridge is the php ...

Set expiration for y

If you want to set the expiration to your site ...

Warning: Parameter 1

Error: Warning: Parameter 1 to modMainMenuHelper::buildXML() expected to be a ...

domain pointing to e

If you domain uses external MX record and it is ...