I am using MySQL 5.0.77 Version rpm on CentOS 5 Red Hat Linux. I want to install micro second slow query log patch on this MySQL S/W version.As I found the slow query micro second patch on percona site i.e. [URL]step by step to install above mentioned patch with rpm based MySQL installation? Do we need MySQL source files to apply patch ?
View 13 RepliesI am on a CentOS 64 bit and used webmin to rotate MySQL slow query log. Now the thing is although logs are being rotated daily but the new log files being created are empty which means MySQL is unable to write them due to some reason. I have checked using "ls -l" that both permission and owner of files is same but still MySQL is not writing logs. What could be the reason?
View 10 Replies View RelatedCan query browser be installed in 11.4??
I've tried to use workbench but it's such a big step backwards in that you can't easily edit the output from a "select x,y,z from table" query. I'd have thought that was a pretty basic requirement...
I have created a database which stores students grades for different stages of a project. One of the stages of the project is the specification part. I have a simple bit of html code which is going to be used as the searching facility. I want the user to be able to enter their ID and then it will display only their results. At the moment, it is displaying the results for EVERY student because I cant seem to find the correct syntax for my statement.
Heres the HTML code
<html>
<head>
</head>
<body>
<body bgcolor="#6881bb">
<center>
[Code]....
At the moment when i click the button, no matter what I enter every students marks appear on the screen.
I think, but obviously dont know for sure because if i did i would know how to solve the problem, the code that i need to change is in green.
When i enter this query to mysql:
Code:
return this error:
Code:
when i delete the insert part :
Code:
query is ok:
Code:
1 row in set (0.00 sec)
I have the following mysql query which works great.
Code:
SELECT msg FROM `logs` WHERE ((`host` = 'aaa.bbb.ccc.ddd') OR (`host` = 'aaa.bbb.ccc.ddd')) AND `msg` REGEXP CONVERT( _utf8 'physical addresses' USING latin1 ) COLLATE latin1_swedish_ci
I need to refine this query so that I can query the last # hours using the `datetime` field in the database. I have researched the DATE_SUB function and can query for example the last 1 hour like this:
[Code]....
i have MySQL on my CentOS server and have installed it and got it up and running through the command line.
I have changed root's username and password so there is no user called 'root' anymore. I also created a database called pancakes.Now when i try to log in using Query Browser, i put the server's IP in 'hostname', my new roots username and password in 'username' and 'password'.When i try to log in it gives me error 1130 and says connection from myhostname not allowed.
Trying to export a Mysql query to a .csv file the query draws from multiple tables, e.g. sales, purchase and currency
Code:
What i'm trying to do is to export both the sales and purchase to a single line where both the currency for the sales and the purchase is specified.
Basically like this:
Code:
Problem here is that i'm stating currency.value twice in the same select and don't know how to define which currency.value applies to sales and which to purchase.
It is under PHP/MySQL
$queryresult = $conn->query("INSERT INTO normalrequests VALUES($finalkey, 1234, 5678, FALSE)");
It is connected to the database successfully but I feel there is something wrong with the statement up there.
I want to install mysql query browser in debian
View 1 Replies View Relatedi will be quick, im trying to send a mysql query output into an array ie:
Code:
declare -a HD
HD=`echo "USE db; SELECT uid FROM user" | mysql -u $login -p$pwd -h $dbhost -B`
echo ${#HD}
those vars in mysql connection are previously and correctly assigned.
but got an error
script.sh: 2: declare: not found
I am querying a single string column in a table. The string values have spaces in them. I want to loop over each value in bash. I set IFS to split lists on newlines instead of spaces. When I try this, it is splitting the list of results on the actual character 'n', not the newline ''.
DATA=`mysql -u root -ppassword --silent 'SELECT name FROM table_a;'`
IFS=$'
'
for i in $DATA; do
echo "item = $i"
[Code]....
I am not sure if this is possible. I have IP's stored in a mysql database. When I query the database, it returns the IP. I would like to replace the IP with something else prior to displaying the results. Is it possible even though I have not stored it in the database?
I have the following in a while loop (mysql_fetch_array).
Code:
<td align="left">' . $row[IP] . '</td>
Instead of displaying $row[IP] from the database, I would like it to display something else which I define in the PHP code but based on the IP.
ie. aaa.bbb.ccc.ddd = hostnameABC
So I've got a rather vast database, one of the columns is date in the following format: DD/MM/YY HH:MM:SS. This is starting to cause problems with a php page I'm writing which asks the user for a 'start date'. Would it be better for me to split the date column into date and say time? Or is there a way of using distinct and masking the times.
View 10 Replies View RelatedDoes anyone know where I can get a link to download MySql query browser(windows version)?
I want to query my database on my fedora box in windows to make life easier... I can not seem to find a link to download the query browser though
I am running Ubuntu 10.04 LTS. I am trying to run a query browser for mysql but keep receiving the following error:
X11 connection rejected because of wrong authentication.
The application 'mysql-query-browser-bin' lost its connection to the display localhost:10.0; most likely the X server was shut down or you killed/destroyed the application.
In ssh_config, I do have ForwardX11 set to yes.
I need help about the error in my website. I have the following error....
Code:
user warning: Got error 134 from storage engine query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'theme_registry:database1' in /var/www/html/web/includes/cache.inc on line 26.
This may be a stupid (?) question, but does any one know of a patch for sudo that allows the sudoers information to be pulled from mySQL?
I run multiple servers with multiple people working on them and would like a one-stop update of permissions.
Yes, I could use rsync or the like, but I'm just wondering if this has been done, or could be done.
(Sorry if this is the wrong forum, I'm kinda new around here, posting wise and this seemed to fit. Feel free to move it if it's not)
I'm trying to install CentOS 5.5 on an old Pentium 4 desktop PC I have, which is not being used for much other than being a MTA, and I want to migrate this functionality onto the CentOS platform for stability (Windows is a perpetual nightmare. I partitioned a spare 20GB to experiment with, and I want to install CentOS into here to play around with first so I can move my files around between Windows and CentOS, until I'm happy all of the stuff is gone, then I can scrub the Windows partition and claim the space for CentOS.
So, I've downloaded and burned the DVD and tried to install. I start the install with no args from the main install menu, and the process goes through some probing and then comes up with the "Welcome to CentOS" menu. I go through this, and then it tries to start X Server. It fails, and falls back to text mode. I get the "Welcome to CentOS" screen again, and then proceed through it. I set my keyboard layout to UK, then this message comes up at the bottom of the screen:
"_X11TransSocketINETConnect() can't get address for localhost:6001: Temporary failure in name resolution"
then on the next line: "Cannot open display :1" If I force the install to text, by typing "linux text" at the first menu, I get about the same way through, but the install just hangs doing nothing, and no disc access to the install disc.
I want to upgrade existing MySQL 5.0.77 version on CentOS 5 Red Hat Linux to MySQL 5.1.x. Is anybody have list of patches or upgrades to upgrade to MySQL 5.1.x?
View 6 Replies View RelatedQuote: select * from s_transaction Where between UNIX_TIMESTAMP('2010-06-28 15:40:00') and UNIX_TIMESTAMP('2010-06-28 16:00:00') and user_id = '15545941';
Is this the syntax correct to retrieve a particular user transaction between given time period? because "its return error check the syntax near the between"
I'm running Centos 5 and have recently done a yum update. I'm trying to query a package:
% rpm -q xxx.rpm
package xxx.rpm is not installed
OK, so I'll just go ahead and install the package, right?
% rpm -i xxx.rpm
package xxx.rpm is already installed
I have 2 Centos 5.2 install that cant be snmp queried from another machine and I am unsure of what to check next.
To make sure it was not an incorrect iptables rule i temporarily turned off iptabes with the same results. I have checked the hosts file and it is correct on both machines.
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community
I just want to upgrade my Slackware 13.1 kernel (2.6.33.4) to the latest stable kernel from kernel.org (2.6.38.2). I have never done anything like this and I am a Linux newbie, so I would appreciate a "Kernel Patching for Dummies" version if possible. I did do a search on this forum and most of what I read was over my head. I found an FAQ on kernelnewbies.org on "How To Apply A Patch" but when I attempted what they suggested, it said it couldn't find the file to patch at line 5 and asked me which file to patch. So I CTRL-Z'd out of there and came here. Here's what I tried:
[code]...
I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld]
datadir=/var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
[Code]...
How do I know the reply was from caching-nameserver, master nameserver or slave nameserver in BIND DNS.? Can I trace the nameserver that replied my dns query? Like I have a master nameserver, a slave nameserver and a caching nameserver in my network. Is it possible to know that which of these servers replied my dns query? Also can i trace back that replying server exactly?
View 3 Replies View RelatedA site -- to -- site vpn need NAT-T . But I don't know whether the Centos_5.2 support that function default, or I have to patch it by myself.If I should patch it all by myself, How to do it ? VPN suite: OPENSWAN KERNEL version : 2.6.18-92.1.22.el5 i686
View 1 Replies View RelatedIs there a mailing list or an alert where I can subscribe to, so I know if there's critical or moderate patches I have to apply to my Centos 5 servers.
View 5 Replies View RelatedI am trying to install php-mysql but I am getting conflicts. I manually installed
MySQL-shared-community-5.1.32-0.rhel5
MySQL-client-community-5.1.32-0.rhel5
MySQL-server-community-5.1.32-0.rhel5
and I can not seem to find a php-mysql that works with MySQL 5.1
I followed the below thread and added the CentOS-Testing.repo and did a yum update php and it updated 30 packages, but when I try to install php-mysql I get :
[URL]
yum install php-mysql
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
[Code].....
Where can I find a php-mysql that works with MySQL 5.1? I checked the mysql website and can not seem to find any matches.