An open-source, relational database management system.
0
votes
1answer
141 views
Can someone provide an xargs example piping mysql query data into another command?
Can someone provide an example for the command xargs? I want to do a mysql query to return the ID field of a column then feed that result into xargs into another command say mysql query delete. How ...
0
votes
2answers
63 views
Problem with configure and build php 5.2 on redhat 5
I downloaded php binaries and tried to build the same using following command.
./configure --with-apxs2=/usr/sbin/apxs --with-mysql
But i'm getting the error related to mysql client library.
...
0
votes
1answer
38 views
Mysql LOG only specific users
I need to set up some logging on my debian squeeze x64 mysql 5.1 Server:
1) logging when users logged in and logged off
2) logging only specific users commands
set up logging which will not slow ...
0
votes
1answer
177 views
Debian Squeeze/MySQL error
I am a Unix/Linux noob, so please bear with me.
I installed lighttpd and PHP on MySQL using the instructions in the accepted answer here:
...
0
votes
3answers
2k views
Where, in automysqlbackup, do I add mysqldump parameters?
How to stop automysqlbackup's cron.daily script -- as installed and configured from apt-get install automysqlbackup -- throwing the following error:
mysqldump: Got error: 1142: SELECT,LOCK TABL ...
0
votes
1answer
593 views
Install Mysql 5.6.4 or greater on web server with on CentOS / openSUSE with Plesk 10
I need to install MySQL 5.6.4 or greater on my web server because I'm using the full text innodb feature. I'm trying to move my local installation (WAMP server) to my dedicated server and I'm not able ...
0
votes
1answer
141 views
How to use a password as an external variable in shell?
I have this MySQL backup script that I use to back up MySQL databases. Very useful, and it runs on fixed intervals using a cron. However, I need somehow provide this script with the MySQL password. ...
0
votes
1answer
1k views
Can't start mysqld
I've installed mysql through
$ sudo apt-get install mysql-server-core-5.1
$ sudo apt-get install mysql-client-core-5.1
This is my current conf file
And the service won't start, at first the ...
0
votes
2answers
181 views
Linux (Debian) web server advice
I'm at the start of a new company in which the main activity is building internet web apps. I was very familiar with linux 8-9 years ago, but since then, I've lost a lot of touch with it (couldn't ...
0
votes
2answers
229 views
Installing MySQL 5.5 on Mac OS 10.6
I am trying to install MySQL from source on my Mac OS. I've expanded the source code, and am now trying to configure it. However, I can't get past that step:
...
0
votes
0answers
115 views
What caused my CentOS 6.4 box to reboot itself?
I noticed that the MySQL daemon running on my CentOS 6.4 machine was suddenly not running anymore. I checked the MySQL log, but didn't see anything relevant:
121229 22:17:45 mysqld_safe mysqld from ...
0
votes
2answers
57 views
Cron job not running / not successful?
I have a couple of cron jobs set up to maintain a local copy of a remote database.
The first one downloads the latest version of the database from the remote machine, which runs every day and is ...
0
votes
1answer
61 views
bash script that shows mysql innodb log file size
I am creating bash script that gives me size of mysql innodb log file in MB. Currently I am getting its output in bytes.
Please check it out following script and help to get output in MB.
#! /bin/sh
...
0
votes
1answer
20 views
Only value required using mysql command
I created following command to get value of Innodb_data_writes using command show status in mysql database.
mysql -u root -p**** -e "show status" | grep Innodb_data_writes
Current Output: ...
0
votes
2answers
54 views
Open source MySQL performance tool
Are there any open source MySQL performance tools to help optimize SQL queries?
0
votes
0answers
211 views
dependency problems prevent configuration of mysql-server
This question has been asked verbatim about a dozen times on this forum, and yet none of the solutions have worked for me.
I'm trying to install mysql and everytime I try to install I get this ...
0
votes
0answers
74 views
Failure to install MySQL
I attempted to install MySQL using Synaptic but it failed to start on update with the following output:
Selecting previously unselected package mysql-client.
(Reading database ... 131143 files and ...
0
votes
0answers
55 views
proftpd mod mysql
I've setuped a proftpd server on a distant host. I made it work in some simple way, actif mod, with unix user, blocking user in /var/www. It was working nice, but now I need the mod sql (package ...
0
votes
3answers
147 views
recreate mysqld file centos
I have tried installing mysql several times but keep getting this error:
mysqld: unrecognized service
I've tried:
yum remove mysql-server
yum remove mysql
yum remove MySQL-*
then
yum install ...
0
votes
1answer
193 views
Turn off --skip-grant-tables in MySQL
I'm pretty new to using Linux but am setting up my MySQL databases on an Amazon ec2 instance. I followed some directions I found about resetting the user login pass by using the --skip-grant-tables ...
0
votes
0answers
122 views
DP: Apache Web Server character encoding [closed]
I'm double posting because I think U guyz may have a clue:
http://serverfault.com/questions/423663/apache-web-server-character-encoding
10x
0
votes
0answers
349 views
Installing MySQL complete? [closed]
How I can install mysql in ubuntu 12.04(gnome 3). So that I will have my mysql installation in /usr/bin/mysql
It's library and header files in /usr/lib/mysql and /usr/include/mysql respectively.
...
0
votes
1answer
274 views
phpmyadmin 403 error
i mannually installed phpMyAdmin according to this doc:quick install.but i keep getting the 403 error, i can successfully get into other folders in the root dir, how can i sovle this?
here is my ...
0
votes
1answer
466 views
Error compiling OSSEC HIDS with Mysql support
I work with OSSEC HIDS In Ubuntu 11.10 from the instructions on the OSSEC wiki.
When I install with mysql support, I get this error
/tmp/ccuS4FYw.o: In function mysql_osdb_connect': ...
0
votes
1answer
613 views
How to easily maintain the latest versions of Apache/ MySQL/ PHP on CentOS 6.2?
We have a few servers running CentOS 6.2 deploying web applications using Apache/ MySQL/ PHP.
In the past we've just regularly run "yum update" to keep all the software up to date.
As of right now ...
0
votes
2answers
2k views
MySQL table is repeatedly crashing
I have xen virtual machine (Debian stable in PV mode) and I've Joomla on it.
Several times in a day I see this message on the front page of my site.
jtablesession::Store Failed
DB function failed ...
-1
votes
1answer
3k views
Should the mysql user have access to /var/lib/mysql?
First, let me say that mysql seems to be working perfectly on the machine.
Still, when I su mysql and ls /var/lib/mysql, I get access denided. When I sudo ls /var/lib/mysql I see the data files ...
-1
votes
1answer
57 views
mysql access denied
Trying to find a way in by going through checklist of possible reasons I am locked out of mysql and one, I read, is to determine if I have grant tables.
-bash-4.1# cd /var
-bash-4.1# ls
cache empty ...
-1
votes
2answers
53 views
Copyed mysql files from previous system now error while connect, what to do?
Fist of all I have the files but the old system is gone.
I took the folders in /var/lib/mysql/ and gave then the permissions the mysql folder that was in there had. user mysql group root only ...
-2
votes
2answers
63 views
Linux distrib with apache and mysql pre installed [closed]
Is there a Linux distro with apache and mysql pre installed?
I just want a light and fast installation of apache + mysql + ftp server + phpmyadmin
-2
votes
1answer
65 views
How to set System Variable for mySQL in RHEL 6.2?
I am currently working on mySQL 5.6.10 server and RHEL 6.2. I need to set the system variable PATH for mySQL on RHEL 6.2 Terminal. How do I set it?
I also want to run a .sql file on Linux. I am using ...
