An open-source, relational database management system.

learn more… | top users | synonyms

1
vote
1answer
72 views

Find and Replace in wordpress postings

I have a wordpress blog with 93 posts on it, in which I want to replace [bash] with <pre> but how do I do it please? I need to go through all the posts changing [bash] to <pre> in each ...
1
vote
1answer
404 views

Mysql log confusion

I have installed a standard installation of mysql on Debian Wheezy and I am confused as to where the logs are supposed to be logged. In my /var/log/ directory, there are files mysql.log which are ...
-3
votes
1answer
216 views

Best Linux for a small Web server [closed]

I'm currently planning my business servers and I would like to know what's the best Linux distro for these needs: Nginx + MySQL + PHP 5.4 Zimbra Collaboration - Open Source Node.js w/ Forever I ...
1
vote
1answer
718 views

How can I install mysql on an angstrom distribution?

I tried using a different distribution (debian) but the rest of my application did not work. I've tried opkg install mysql-client and opkg install mysql-server however I get the error Unknown package ...
0
votes
1answer
352 views

Python Web interface for simple mysql database

We need a new web interface for our internal car booking system, which is implemented in mysql database. Could somebody please advise, what would be a suitable solution (which framework, if any). The ...
2
votes
0answers
142 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
128 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
53 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 ...
1
vote
1answer
3k 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
105 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
0answers
106 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
5k 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
218 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
677 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
224 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
197 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
34 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 ...
2
votes
3answers
469 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
159 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 ...
-3
votes
3answers
3k 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
963 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
299 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
1k 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
51 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
519 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
121 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
26 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
252 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
560 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
198 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
340 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
1k 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
189 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
216 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
41 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
134 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
540 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
22 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
110 views

Open source MySQL performance tool

Are there any open source MySQL performance tools to help optimize SQL queries?
0
votes
1answer
500 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
322 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
283 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
973 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
729 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
275 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
243 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
85 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
2k 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
555 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 ...