An open-source, relational database management system.

learn more… | top users | synonyms

2
votes
0answers
147 views

mozilla sync server and mysql auth

Recently I updated my debian squeeze to wheezy. Unfortunately my firefox sync server (weave) stopped working. I saved the config files and downloaded the new version via hg. I already fixed some ...
1
vote
1answer
158 views

mysql database dump script adding fuctionality to skip dumped database

I'm using the following script to dump my database. it works great. I want to add functionality that it first checks if a database table is already dumped or not, if a dump exists then it should be ...
0
votes
2answers
57 views

MySQL exact path

I am using whereis mysql in my terminal to get exact location of my MySQL installation, but it's showing too many locations: mysql: /usr/bin/mysql /etc/mysql /usr/lib/mysql /usr/bin/X11/mysql ...
2
votes
1answer
4k views

How to install phpmyadmin 4.0 on Debian

Is there a way to install an up-to-date phpmyadin on Debian via apt-get? I only found a PPA for Ubuntu on the that you can install with sudo add-apt-repository ppa:nijel/phpmyadmin apt-get update; ...
2
votes
1answer
131 views

strings command printing some extra characters

I am trying to capture mysql traffic using tcpdump and converting it to text using strings command, but while capturing mysql traffic, I am getting some extra character at the end of each character. I ...
1
vote
1answer
127 views

Data loss prevention ( or recovery) in a MySql db in embedded systems

I have a little ( big ) problem with a MySql application that write on a SD card or a Compact Flash. After a data loss ( a power failure , for example) , if I try to retrieve the data of my db , it ...
1
vote
2answers
7k views

df command not showing correct values

This is a RHEL server, I'm running a MySQL server on it, the database and log files (however, logging is disabled) are located on the /srv directory where plenty of space is available. Recently I had ...
0
votes
1answer
360 views

Catch all emails and save them in MySQL

I want to do something like Facebook has with it message system. When you reply to email sent from Facebook User, it automatically gets in his message box. This is done, because you reply to ...
0
votes
1answer
681 views

mysql different users access

I have six different sites set up with their respective databases on my server all linking to one localhost ip. Three of those users I set up from root have access only to the one database associated ...
0
votes
3answers
263 views

Brand new to Linux - running a web server/database server, need to connect to my servers- how?

I am brand new to Linux. I have a database server and web server both running CentOS. My database server will host MySQL and my web server will host Apache. I am very familiar with Windows and ...
1
vote
1answer
243 views

Correct diacritics in a mysql dump on CentOS

On my CentOS server, I have got a dump file of a mysql table which contains special czech characters in it (e.g. á, é, č, ž). When I view the file using cat, the special characters are broken (e.g. ĂĄ ...
1
vote
1answer
36 views

Searching multiple mysql tables for the same 2 fields in each table

I am trying to figure out how to search mysql tables for the same 2 fields. What I have is 2 tables in the same database. Below is what I have currently:- single search works ok SELECT * FROM ...
3
votes
3answers
592 views

Do I need to stop processes like mysql or apache before “reboot”?

I have been wondering if issuing a reboot command safely stops running LAMP processes like MySQL or Apache?
2
votes
2answers
222 views

How to config my.cfg file for mysql which was installed from sources?

I installed MySQL 5.6 from sources on debian. MySQL folder is /usr/local/mysql. Here is several question: 1) I would like to config my.cfg. But I couldn't find several parameters: socket ...
-2
votes
3answers
5k views

What mysql command can show me the tables in a database and how many rows there are? [closed]

is there a mysql command that will show me the tables and how many rows they have in them?
0
votes
2answers
1k views

How to install MySql on Red Hat 6.1?

I am trying to install MySQL-server-5.6.12-1.el6.i686.rpm on a Red Hat Enterprise 6.1 server. I receive the following error: rpm -Uvh MySQL-server-5.6.12-1.el6.i686.rpm error: Failed dependencies: ...
1
vote
0answers
344 views

Amazon EC2 MySQL Failed to Start

I'm having issues starting MySQL after it randomly stopped working a few minutes ago. I'm getting this error while trying to connect: Connect failed: Can't connect to local MySQL server through ...
0
votes
2answers
2k views

Run mysqld_safe in background

I have a bash script that installs mysql for me. One line, that executes mysqld_safe, makes the script to hang - it won't continue to the following code. Obviously there's ampersand at line's end, ...
2
votes
1answer
53 views

mysql console, keeps outputting garbled text if 'b' key is pressed

mysql -u username -p mysql> Now in the console whenever I press the b key the screen goes berserk with garbled text: Google doesn't help here. Edit: using ubuntu 12.10 with xterm or the ...
1
vote
1answer
582 views

install mysql 5.5(remi) with centos 6.2 complains error

Finished Dependency Resolution Error: Package: mysql-server-5.5.31-1.el6.remi.i686 (remi) Requires: libz.so.1(ZLIB_1.2.0) I type yum --enablerepo=remi install mysq and these error ...
0
votes
2answers
140 views

Is it not possible to store my local websites in my Dropbox folder?

I have a bunch of web sites that I develop, and I run an Apache server locally to do debugging and design. The web sites use Apache, PHP, and MySQL. To be clear, my Apache server is not serving these ...
0
votes
1answer
27 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
284 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
818 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
235 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
410 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
1answer
2k 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
2k 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
226 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
248 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
44 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
146 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. What is the command line to talk to MySQL server on my PC? Both devices are connected via my router and they can talk ...
-2
votes
2answers
746 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
24 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
113 views

Open source MySQL performance tool

Are there any open source MySQL performance tools to help optimize SQL queries?
0
votes
1answer
631 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
364 views

Mysql server remove/install problem - horribily broken

I'm having the same issue as Ken did on this post. And I did pretty much what Ken did except to different packages. Now, I'm stuck with unclean hooks. I've detailed my problem here and the attempts ...
0
votes
1answer
307 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
1k 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
963 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
347 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
289 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
96 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 ...
11
votes
2answers
3k 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
688 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 ...
2
votes
1answer
803 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
135 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 ...
4
votes
1answer
2k views

MySQL stop/waiting issues; “can't connect … through socket” [duplicate]

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 ...
2
votes
0answers
95 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
487 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 ...