An open-source, relational database management system.
1
vote
0answers
33 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
49 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
32 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
28 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
55 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
46 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
23 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
77 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
29 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
59 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
142 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
60 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 ...
2
votes
1answer
87 views
How to increase the size of rootfs?
So I got this error today and decided to investigate:
/etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full! ... failed!
I'm not sure how... but I've filled up my rootfs
...
0
votes
2answers
94 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
27 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 ...
0
votes
1answer
150 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
50 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
25 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
74 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
45 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
68 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
70 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
231 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
100 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
69 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
83 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
1answer
70 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
94 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
16 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
66 views
Open source MySQL performance tool
Are there any open source MySQL performance tools to help optimize SQL queries?
0
votes
1answer
119 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
71 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
158 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
188 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
84 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
90 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
114 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
48 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 ...
6
votes
0answers
628 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
130 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
282 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
154 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
75 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
1answer
210 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
62 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
61 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
163 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
42 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
185 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 ...
