An open-source, relational database management system.
0
votes
1answer
21 views
Reinstall mysql keeping db intact
basically on my vps somehow mysql.sock vanished in tmp as well lib folder. I want to reinstall mysql but will db get lost?
1
vote
3answers
24 views
Upgrade MySQL 5.0.88 to 5.1.69
I am upgrading my MySQL installation on a Fedora 10 (and 14) box (in test first.) I have made a system image (it is a VM) and have downloaded MySQL Server Community 5.1.69-1 from the MySQL site.
Once ...
0
votes
2answers
31 views
How to view a list of previously run mysql queries in a live feed format?
How do i view the last run queries in mysql in a live feed format?
I want to leave my terminal window open and just have mysql queries pop up on the screen whenever something is run. I know I can do ...
0
votes
1answer
22 views
Use an existing wampserver from a windows partition on linux mint
I dual boot Windows 7 and Linux Mint 14.
I have wampserver installed on Win 7 and have a couple of websites already set up there.
Is it possible to use that same installation apache/mysql/php ...
1
vote
1answer
16 views
gcc not found when installing mysqldb for django 1.4
I am trying to install the python module mysqldb which is the python interface for mysql. I need this module because I am creating a Django development server (Django 1.4, OpenSUSE) and the database ...
0
votes
0answers
69 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
52 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 ...
-1
votes
2answers
50 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 ...
0
votes
1answer
50 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
19 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
1answer
38 views
from a laptop with CentOS 6.3 what is the command line to talk mysql server on my pc?
I have CentOS 6.3 running on my laptop which is already connected to the net. I would like to know how to use the MySQL installation on my PC?
I meant :
from a laptop with CentOS 6.3 what is the ...
-6
votes
0answers
32 views
How to use the MySQL installation on my PC? [closed]
I have CentOS 6.3 running on my laptop which is already connected to the net. I would like to know how to use the MySQL installation on my PC?
-2
votes
2answers
59 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
1
vote
1answer
14 views
See latest added data in MySQL DB, Debian
Is there any way I - via any commmand - can see which data have last been added to a MySQL DB and when that data was added?
Dist: Debian 7.0 (wheezy)
0
votes
2answers
45 views
Open source MySQL performance tool
Are there any open source MySQL performance tools to help optimize SQL queries?
0
votes
1answer
45 views
Connecting from OpenVPN Server to MySQL Server
I have an OpenVPN server installed on a server. What I'm trying to do connect from the OpenVPN server using the mysql client to the MySQL server than is connected to the OpenVPN server using a ...
0
votes
1answer
37 views
Mysql server remove/install problem - horribily broken
I'm having the same issue as Ken did on this post; Removing broken packages .
And I did pretty much what Ken did except to different packages. Now, I'm stuck with unclean hooks. I've detailed my ...
0
votes
1answer
109 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
3answers
78 views
How to create an interactive bash script to collect arguments for a command in linux?
I'm trying to create an interactive bash script where I can collect user input variables to be used as arguments in another command. Can someone provide me an example of this?
Currently i want to do:
...
0
votes
2answers
51 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.
...
-2
votes
1answer
59 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 ...
2
votes
1answer
59 views
How to copy the whole MySQL DB between two servers?
There is a very good connection between the two machines (MySQL 5.5.28):
mysqldump -u root -p'password' --all-databases | ssh root@SERVERNAME mysql -u root -p'password' --all-databases
So AFAIK ...
1
vote
1answer
33 views
Uninstall MySQL server without removing or breaking any client functionality
I have an Ubuntu webserver which once used a local database, but we migrated it and now the database is stored remotely on a separate server accessed from many different places. The webserver runs ...
5
votes
0answers
263 views
FreeBSD: “Too many open files” but should be able to open another 160,000 files
I have a FreeBSD 8 system running ZFS, with a MySQL 5.5 server which is about 355GB and projected to grow to be a couple of Terabytes.
MySQL is triggering errors about "Too many open files" on ...
1
vote
2answers
80 views
How to monitor the number of rows inserted per second and per minute into MySQL db
I have a running script which is inserting data into a MySQL database.
I want to know how many rows are getting inserted per second and per minute. If the count of rows inserted per second or per ...
0
votes
0answers
191 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 ...
2
votes
1answer
104 views
mysql replication not working
I have two servers A and B I tried to setup replication between two servers for fixed dbs DBA and DBB but it's not working my configurations Tables are not getting updated why??
Master:(/etc/my.cnf)
...
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 ...
3
votes
0answers
134 views
MySQL stop/waiting issues; “can't connect … through socket”
So this was my first time putting up a LAMP stack on a Bodhi machine (previously experience with WAMP, and LAMP on 10.04); I got Apache going, and a Drupal install begun, then I go to create a new ...
0
votes
0answers
51 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 ...
2
votes
0answers
52 views
No communication services enabled following startup
I recently installed Parsix (Debian) on my system, and I've been struggling to figure out how to autostart my services. Of the list of services that don't run and should run are:
ssh
apache
mysql
...
4
votes
1answer
135 views
MySQL server-id not being set with Fedora 16
I am setting up a mysql slave on a Fedora 16 system, and the server_id is not being set properly. My /etc/my.cnf is:
[mysqld]
server-id=16
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
...
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
3answers
132 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
174 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 ...
1
vote
2answers
169 views
MySQL server on Ubuntu fails to start after changes made to my.cnf in Windows
I have MySQL 5.5 running on Ubuntu Server 12.10. When I run /etc/init.d/mysql restart, I get the following:
mysql start/running, process 2754
However, when I open /etc/mysql/my.cnf in Windows via a ...
1
vote
2answers
73 views
How to dump mysql dbs in live boot
I can't log in to my fedora linux because of I/O errors(system halts after grub). Now I want to create a backup from my mysql databases. I tried chroot /path/to/root and then mysqldump, but I get the ...
-1
votes
1answer
54 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 ...
0
votes
2answers
105 views
phpmyadmin is listing my server version and client version as being different
In a continuation of this question, I have purged the 5.1 client via sudo apt-get purge mysql-client-core-5.1. I have reinstalled the 5.5 client - sudo apt-get --reinstall install mysql-client-5.5 ...
1
vote
1answer
120 views
Mint 12 - Error updating MySQL (mysql-client-core-5.1)
I have MySQL 5.5 installed via packages.dotdeb.org. When trying to update 5.1, which is also installed, I get the following error:
E: ...
1
vote
2answers
213 views
Using a lua rock installed with luarocks
I wanted to install luasql.mysql with luarocks, and I've ran into a problem. Even though the packages were installed providing mysql.h, luarocks couldn't find it. I solved it eventually:
luarocks ...
1
vote
2answers
102 views
Import sql files using xargs
I have a number of sql files to import. For a single file I use the following command:
mysql -u root -p dbname < db.sql
Is it possible to use xargs to bulk import all files? something like:
ls ...
0
votes
1answer
176 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:
...
2
votes
2answers
242 views
Building MariaDB 5.5.27 without OQGraph: How to deselect the plugin?
I'm trying to build MariaDB 5.5.27 from source. In fact, I just need the client, but I seem to have to build the complete database system anyway.
While configuring with cmake and later compiling with ...
1
vote
1answer
426 views
update mysql on debian
I'm trying to update Mysql on debian without success, and all tutorial on internet just fails.
I got Debian 6.0.6 squeeze, my mysql version is mysql Ver 14.14 Distrib 5.1.63.
I did apt-get update and ...
2
votes
2answers
657 views
MySQL Linux Client Timeout/Keepalive
Is there a way to set a keepalive in the command-line MySQL client on Linux?
Our network recently moved to a VLAN setup, and our systems department no longer has control of the firewall. The ...
3
votes
2answers
310 views
MySQL 5.1 to 5.5: all UTF-8 characters lost!
I decided to upgrade my Debian installation, and after some days using MySQL 5.5, I found that mysql prints garbage to the terminal intead of UTF-8 characters.
I had a look at the SQL file that was ...
6
votes
1answer
158 views
/etc/passwd sql with bash access
I just got a CentOS VPS and was reviewing the passwd file and saw this:
mysql:x:498:499:MySQL server:/var/lib/mysql:/bin/bash
Is bash necessary for mysql?
1
vote
1answer
256 views
AutoMysqlBackup --lock-tables=false
I'm trying to use AutoMysqlBackup script to perform daily backups of my application.
Unfortunately on the first try it didn't served me how I thought it would.
I believe that the script has used the ...
1
vote
2answers
648 views
MySQL not getting started on linux
I need to run MySQL service for my linux 2.16 version with SUSE version 11 distribution.
Downloaded the following files and installed all the rpms as under:
MySQL-server-5.5.27-1.sles11.i586
...
