An open-source, relational database management system.
0
votes
2answers
56 views
Open source MySQL performance tool
Are there any open source MySQL performance tools to help optimize SQL queries?
0
votes
2answers
30 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
476 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': ...
4
votes
2answers
863 views
Selinux is denying access to mysqld
I have a script that dumps a mysql database. It then compresses the file and this gets stored in my home folder by using cron. The problem is I seem to be getting an error message.
mysqldump: ...
1
vote
2answers
269 views
Import single rows from SQLite to MySQL?
I need to do some kind of incremental import again and again from a SQLite 3 database to a MySQL database. Column names are the same in both databases. Is there a good way to do this by a script ...
1
vote
3answers
39 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
1answer
23 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?
0
votes
2answers
37 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
43 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
33 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
2answers
65 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.
...
5
votes
0answers
338 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 ...
0
votes
1answer
43 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
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 ...
0
votes
1answer
145 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
0answers
118 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 ...
2
votes
1answer
80 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 ...
0
votes
2answers
58 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
vote
2answers
216 views
How to allow mysql remote connections via particular interface
I have a 10.237.49.251 IP on eth0 and another IP on another interface
How do I enable remote mysql calls on eth0 device?
-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 ...
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
62 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
48 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 ...
-2
votes
2answers
66 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
1answer
62 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
3answers
98 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:
...
1
vote
4answers
465 views
Multiple Mysql databases backup tool?
My OS is Ubuntu 10.10.
I have several small sites (all on various shared hosts) and I'm thinking that it'd be probably good idea to regularly backup mysql databases from these remote shared hosts. I ...
2
votes
2answers
2k views
Can I copy a MySQL database by copying the files? What do the files contain exactly?
I am using MySQL database and using an Ubuntu Linux machine.
My database named db_test , I notice that under path /var/lib/mysql/db_test ,there are files suffix with .frm, .MYD, .MYI like following:
...
-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 ...
1
vote
1answer
38 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 ...
1
vote
3answers
1k views
Troubles installing php with MySQL support
So I wasn't sure if this question would go best here or on Overflow or Server Fault, but decided to try here first. I'm installing LAMP on a VPS, and am running into issues configuring and building ...
1
vote
2answers
96 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
215 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
118 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 ...
1
vote
1answer
545 views
Trouble installing MySQL from binaries
So, I am a freshman in Computer Science, and I have dug an old computer out of my garage to use as a personal hosting server for various services (email, web site, subversion, etc.), partly because I ...
3
votes
0answers
160 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 ...
1
vote
2answers
224 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 ...
0
votes
0answers
56 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 ...
1
vote
2answers
1k views
MySql: LOAD DATA INFILE
I am using MySQL v5.1 on Ubuntu machine.
MySQL data directory is /var/lib/mysql/
I have a test.dat file located on /var/lib/mysql/tmp/test.dat
I would like to load data from the test.dat file into ...
1
vote
2answers
112 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 ...
2
votes
0answers
56 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
146 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
...
4
votes
1answer
101 views
If I'm logged in as root, how do I restart mysql or apache with options?
I know the commands to restart/stop/start, but when I try to pass options it doesn't seem to work!
CENTOS 6, MySQL 5.14
service mysql restart
service httpd restart
Then I tried this:
...
0
votes
3answers
149 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
198 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
173 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
81 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 ...
