MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

1
vote
1answer
219 views

Enable selinux to allow mysql files to be read and written on a nfs share

I have moved my /var/lib/mysql directory to an nfs share, updated all the config files and created symbolic links where appropriate. This works when I have selinux turned off, but mysqld fails to ...
1
vote
0answers
53 views

MySQL SSL Problems

I need to configure SSL for a MySQL server. I've read all of the directions for doing self-signed certs but it's preferred that I sign and use the certs from a different CA running AD Certificate ...
0
votes
2answers
659 views

MySQL database really slow with a really big table [closed]

I have a MySQL table with 150 million rows. Below is its data structure. Below is some of its data. Now, using PHP My Admin I ran the below command. SELECT `iwords` FROM `wordstable` WHERE ...
0
votes
0answers
25 views

Php, IIS8, and MS Sqlserver2008 driver installation

I am new to iis setup, so this is quickly turning into a nightmare. I have installed php using wpi (IIS8)(server 2012) everything is working fine. Now i would like to connect to the ms sql server (v ...
0
votes
1answer
38 views

Linux CentOS dedicated server, process is dissapearing from WHM process manager

I have a script running on my dedicated server /usr/bin/php/home/user/public_html/myscript.php. When I log in to WHM/Process Manager, sometimes this script disappears from the list. Also, when I log ...
0
votes
0answers
40 views

Find out what process initiated a mysql query

Is there any way to trace back what process initiated a mysql uqerry like the two below. MySQL on localhost (5.0.95-log) up 178+23:58:01 ...
0
votes
1answer
56 views

How do I make a program start up automatically on reboot?

I am currently renting a VPS that is running CentOS 6.5. I am using it to run a basic forum site, and obviously, I need a web server and MySQL to power that. I have chosen Apache for my web server, ...
0
votes
0answers
169 views

Export CSV data from IPERF output to MySQL

I have a multiple clients to single server bidirectional iperf set-up for network monitoring. The iperf server runs good and displays output in CSV format based on the cron jobs written on the client ...
-4
votes
2answers
75 views

How, with a mounted disk image, can I migrate a MySQL database to a new server?

One Ubuntu EC2 VPS is fried after an upgrade that went awry. I don't have the server live, but I have its disk mounted on another (Ubuntu EC2) VPS. How can I migrate the contents of a database on ...
0
votes
1answer
53 views

Percona UDF - FUNCTION MURMUR_HASH does not exist

We have a 5.5.28-29.3-log mysql master that has the percona UDFs installed including murmur_hash. We installed mysql on new host but I can't seem to find where to get the UDFs from. This doc suggests ...
0
votes
1answer
54 views

How does creating multiple virtual machines affect performance of a Dell Server? [closed]

Say, a dozen applications have to hosted on a single Dell Server using open source technologies like XenServer. Some of the applications are resource intensive while others are not. What should be ...
0
votes
1answer
116 views

update and insert MySQL DB on AWS RDS with local MySQL DB

I have created an RDS database and have used mysqldump to send all my local data to that remote database using the following commands: $ mysqldump -u root fishDB > localDB.sql $ mysql -h ...
1
vote
0answers
61 views

Openstack instances, routing, packets not delivered for SPECIFIC services

I am taking over management of an existing openstack system at work and I have only a little prior experience with openstack. I have about 8 instances running and all of them appear to function ...
0
votes
2answers
242 views

MariaDB Permission denied when using socket

Here is the gist of my problem: I have a web application that won't connect when the database has the host is set as localhost, however it will if I use the address 127.0.0.1. The error that PHP ...
0
votes
2answers
238 views

Check if remote mysql query was successful - bash

When using a bash script to execute remote MySQL queries, how can I know if the command was successful or not. Locally it would return an exit code. However, remotely it seems to send the query and ...
0
votes
0answers
105 views

Setting default character set to UTF8 in MySQL

I followed some old thread on Stack Overflow for setting the default character set of the MySQL server to UTF8 instead of latin1. So, I made the following changes: [client] default-character-set = ...
-1
votes
1answer
798 views

CentOS 6.5 Lampp (Xampp) and MYSQL CDR

I was wondering if it was possible and if so, how to use Lampp's MYSQL to store the call detail records in. I've tried installing the mysql-devel package and i've tried changing the modules.conf, ...
1
vote
1answer
294 views

Invalid parameter config_hash: Attempting to install mysql (and Openstack) via Puppet

I've searched around for hints on how to solve this but I haven't been able to find anything concrete. I've seen Puppet apache module causing 'Error 400 on SERVER: Invalid parameter ...
0
votes
2answers
112 views

MySQL stops working on AWS ec2 instance periodically for no reason

I run a development server on AWS which has worked perfectly fine without a hitch. Recently, periodically the mysql server starts to not work. I then type in service mysqld restart which yields ...
0
votes
1answer
166 views

Ubuntu 13.04 MySQL won't start

My main SolusVM Node / OpenVZ Node needed a reboot today out of the blue and a kernel upgrade. So we finished that then on a couple of the VPS units for some reason MySQL won't start after the reboot. ...
1
vote
0answers
62 views

Transfer user data of a Tigase server

I'm trying to transfer a Tigase XMPP server from an Ubuntu VPS to a CentOS VPS. Unfortunately there isn't any official documentation available and I need to experiment in order to preserve all of the ...
1
vote
1answer
184 views

Query cache for MariaDB Galera cluster

I've read from multiple sources now that you can't have query caches with Galera, but my current application could really benefit from a query cache. I'm load-balancing this cluster with HAProxy and ...
0
votes
0answers
187 views

Apache password mismatch using mod_dbd

I Using Apache 2.4, using mod_dbd authentication i followed all steps to configure but when i tries to login, shows me AH01617: user pedro: authentication failure for "/": Password Mismatch But i ...
0
votes
0answers
19 views

Cluster Manager Ignoring Config File

I have just setup my first cluster manually (not using the auto install) and it all works great. I have 1 SQL node, 2 data nodes and 1 management node (all on separate machines). I intend to port ...
0
votes
2answers
30 views

Distributed LAMP vs DB and Web Server same box

We have a very read heavy semantic web (RDF) application which is RHEL 5/Apache 2.2.3/Tomcat 6/Java 6 on one Server, and MySQL 5.1 on another. Apache and MySQL are backported Red Hat repo stuff, so ...
0
votes
1answer
459 views

Can't install mysqldump on Ubuntu

Another technician recently reinstalled our mysql on our LAMP-server and now I can't use mysqldump anymore. # mysqldump The program 'mysqldump' is currently not installed. You can install it by ...
1
vote
1answer
2k views

Processing Conflict: mysql55w-libs-5.5.36-3.w6.x86_64 conflicts mysql-libs < 5.5

I'm trying to install the latest webtatic MySQL 5.5 edition via yum (http://webtatic.com/packages/mysql55/) on CentOS 6.5 but every time I try I get the following output ending in error: # yum ...
1
vote
0answers
89 views

MAGMI fails while importing big chunks of records. Ideal Mysql configuration for Magmi

Configuration: Linux Centos 6, NGINX, Mysql We are trying to use MAGMI a common tool for mass importing of data in Mysql based on webbrowser. I run in an issue. As a try to import more than a small ...
0
votes
0answers
22 views

Mysql Error 1130 only while additional IP address is active

Originally, I had two IP addresses on eth0 on my CentOS install. They both have the same gateway and are on the same subnet. Mysql works fine. Mysql connections originate from the first IP and ...
3
votes
1answer
336 views

BGINFO with MySQL for storing computer information

We are trying to set up BGinfo to record network computers' information in a centralized database. We intend to set up BGinfo to start up for all users and record logon and logoff time plus setting up ...
1
vote
1answer
108 views

RoundCube too many sleep connections in mysql

we have a mail service with these details: 1-Centos 6.4 2:Postfix 2.6.6 3:roundcube 0.8 4:dovecot 2.0.9.7 5:mysql-server 5.1.71 everything is ok but in peak usage time ...
2
votes
1answer
854 views

What is the rdsadmin user and should I care?

I've inherited control of an AWS MySQL RDS instance. I'm curious to know what the 'rdsadmin' user is and whether I should know the password for this or whether this is purely for use by the Amazon Web ...
-1
votes
1answer
84 views

Running PHP/MySQL on Windows Server 2008 [closed]

I have a client that has a fairly basic web ordering system that was built for them many years ago. It is based on runs fine on PHP 5.3. Now, it connects to a (even older) warehouse management system ...
0
votes
0answers
63 views

best logic to Load balancing YiiFramework web app

I'm going to launch a Yii framework app next days, and i'm currently searching the best way to deploy it in order to scale and support high traffic. I use Amazon RDS to host the DB, and 2 Memcached ...
0
votes
0answers
93 views

Transfer mysql database from wamp to a server

i want to transer my data bbase from wamp on my local machine to my vps (ubuntu) can i juste copy the folder of the data base from C:\wamp\bin\mysql\mysql5.6.12\data to /var/lib/mysql ?
1
vote
0answers
19 views

MySQL tuning memory [duplicate]

I have some MySQL problems, I am not sure how to tune memory settings From mysqltuner.pl: >> MySQLTuner 1.3.0 - Major Hayden <major@mhtx.net> >> Bug reports, feature ...
1
vote
1answer
116 views

How Come mysqld -u root will start my database, but mysqld_safe -u root gets “Permission denied”?

The title is fairly self-explanatory. I am a mysql newbie, so any help is appreciated. I can boot my database and everything works fine using mysqld. When I try to run mysqld_safe in a similar ...
1
vote
3answers
193 views

MySQL refuses to accept remote connections

I've just installed a fresh ubuntu server with mysql (percona 5.5), but it refuses to accept connections from remote hosts Here is what happens if I try to connect to this server remotely: mysql ...
1
vote
1answer
67 views

Trigger actions automatically when package is installed or user is added

When installing mysql-server on Debian Wheezy, the user "mysql" is created without a home directory. In my setup, directly after MySQL was installed, a new task is performed which relies on the mysql ...
1
vote
1answer
131 views

MySQL Server not running

I'm sorry for my bad English. After upgrading MySQL up to 5.6.17 version it's not working. I'm using Windows 7 as my server's operating system. Here is the my.ini and error log: [mysqld] ...
0
votes
0answers
116 views

PHP application response time increases when application requests decrease

I've got a very powerful dedicated server, running a PHP 5.5.3, MySQL (Percona 5.6) SMF forum. It's running Ubuntu 13.10, it's a Xeon E3-1270 V2, 1TB disk space (0.7% full), 16GB DDR3 (15% used). I'm ...
0
votes
0answers
19 views

What mysql configuration offers the highest write performance

Which multiple mysql server configuration offers the highest write performance? We are looking at changing a web application which is heavy write and want to know what configuration is going to give ...
1
vote
1answer
528 views

MySQL high CPU usage on small website

I have a small website hosted on a dedicated server (FreeBSD 9.2, MySQL 5.6.1 and php 5.5.5). The problem is that MySQL eats a lot of cpu resources even if the website have a few visitors. The ...
0
votes
2answers
30 views

How to backup sql relations for server re-installation?

I am in need to re-install the nginx ubuntu 12.04 server I'm using in another machine. I've already got all the scripts (php,js,html, etc) so every data in the server is secured, but how can I do the ...
1
vote
3answers
112 views

How to safely restart an ubuntu server lamp stack?

I've searched, and all resources are about how to perform the restart. I know how to reload, restart, stop; Apache, MySQL, etc and how to restart the OS. My question is how to perform a server ...
0
votes
1answer
52 views

Delay in loading site - not caused by Apache, MySQL. How to find the cause?

I've just moved two sites to a new server. They are both similar, Drupal based sites. One loads normally (1-3 seconds) but the other takes up to 12-15 seconds. After much logging and measuring I've ...
3
votes
1answer
262 views

RPM that installs to /opt/rh

I've noticed that the "mysql55" RPMs in the standard CentOS 5.10 repository install everything to /opt/rh. Is it expected that an end user might change this location somehow? It creates complications ...
1
vote
1answer
40 views

Updating usernames and passwords for 450 WordPress databases - 450 ftp Accounts and 450 MySQL user

How would you update these in a consistent, reliable manner? I'm new enough to system administration, self taught and still learning but - I have this problem to solve in no specific time and under my ...
0
votes
1answer
54 views

Postfix MySQL percentage error in query

I have a somewhat complex SQL query that I'm using to get alias forwarding e-mail in Postfix. The problem is that Postfix uses %s as it's insert of alias mark in the SQL query. I think this causes the ...
0
votes
1answer
47 views

MySQL Replication across two mounts on AWS Amazon Linux

Recently we took advantage of the SSD instance stores available on AWS. While these are great, they obviously get deleted when the instance dies. Obviously the performance of non Provision IOPS is ...