6 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
i am new to unix shell scripting i have the below requirement
connect to server B and then connect to mysql in the server B and query for a particular record and capture that value
but when i perform this i am facing an error
can u guys help me on this:confused::confused:
... (2 Replies)
Discussion started by: Hamdul
2 Replies
2. Shell Programming and Scripting
Hello wise scripters
This is my first post and I am glad to join this community.
I am trying to make work a mysqldump via ssh tunnel in a shell script.
The problem is that running this sequence of commands manually works fine, but when I put these in a bash script they give me the following... (8 Replies)
Discussion started by: Solidus
8 Replies
3. UNIX for Dummies Questions & Answers
Hi all,
I am trying to import a database in putty with the syntax:
mysql –u database_username –p database_name < filename.mysql
As you can see in the screenshot it asks me for the database password - which suggests that the syntax is correct - but then after I enter the password it gives... (2 Replies)
Discussion started by: Juc1
2 Replies
4. UNIX and Linux Applications
After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the:
mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)... (3 Replies)
Discussion started by: jastanle84
3 Replies
5. Shell Programming and Scripting
Hi all,
Im new at scripting and i need to run a few commands at work every hours so i decide to make a script but on 1 of the steps i have a the follwoing problem:
The command i do is this:
#!/bin/bash
ssh root@asdasd001 'mysql -h A-db-1 -uroot -password --execute "show slave status"'... (3 Replies)
Discussion started by: Aparicio
3 Replies
6. UNIX for Advanced & Expert Users
I need a smal "how to" regarding editing mysql configuration on a unix server. Thanks in advance. (2 Replies)
Discussion started by: Denis.R
2 Replies
LEARN ABOUT PHP
mysqlnd_uh_convert_to_mysqlnd
MYSQLND_UH_CONVERT_TO_MYSQLND(3) 1 MYSQLND_UH_CONVERT_TO_MYSQLND(3)
mysqlnd_uh_convert_to_mysqlnd - Converts a MySQL connection handle into a mysqlnd connection handle
SYNOPSIS
resource mysqlnd_uh_convert_to_mysqlnd (mysqli &$mysql_connection)
DESCRIPTION
Converts a MySQL connection handle into a mysqlnd connection handle. After conversion you can execute mysqlnd library calls on the connec-
tion handle. This can be used to access mysqlnd functionality not made available through user space API calls.
The function can be disabled with mysqlnd_uh.enable. If mysqlnd_uh.enable is set to FALSE the function will not install the proxy and
always return TRUE. Additionally, an error of the type E_WARNING may be emitted. The error message may read like PHP Warning:
mysqlnd_uh_convert_to_mysqlnd(): (Mysqlnd User Handler) The plugin has been disabled by setting the configuration parameter
mysqlnd_uh.enable = false. You are not allowed to call this function [...].
PARAMETERS
o $MySQL connection handle
- A MySQL connection handle of type mysql, mysqli or PDO_MySQL.
RETURN VALUES
A mysqlnd connection handle.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.4.0 | |
| | |
| | The $mysql_connection parameter can now be of |
| | type mysql, PDO_MySQL, or mysqli. Before, only |
| | the mysqli type was allowed. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
mysqlnd_uh_convert_to_mysqlnd(3) example
<?php
/* PDO user API gives no access to connection thread id */
$mysql_connection = new PDO("mysql:host=localhost;dbname=test", "root", "");
/* Convert PDO MySQL handle to mysqlnd handle */
$mysqlnd = mysqlnd_uh_convert_to_mysqlnd($mysql_connection);
/* Create Proxy to call mysqlnd connection class methods */
$obj = new MySQLndUHConnection();
/* Call mysqlnd_conn::get_thread_id */
var_dump($obj->getThreadId($mysqlnd));
/* Use SQL to fetch connection thread id */
var_dump($mysql_connection->query("SELECT CONNECTION_ID()")->fetchAll());
?>
The above example will output:
int(27054)
array(1) {
[0]=>
array(2) {
["CONNECTION_ID()"]=>
string(5) "27054"
[0]=>
string(5) "27054"
}
}
SEE ALSO
mysqlnd_uh.enable.
PHP Documentation Group MYSQLND_UH_CONVERT_TO_MYSQLND(3)