MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

0
votes
0answers
9 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
32 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
9 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 ...
0
votes
0answers
13 views

Setting up LEMP stack on cloud hosting for Magento with Varnish [on hold]

We're running a Magento store on a managed LAMP stack, its dedicated, Quad-core Xeon @ 2.2GHz and 4GB Ram. The site has around 28,000 products in the database and runs unacceptably slow. Currently ...
0
votes
0answers
18 views

MySQL: Converting Character set fails? [migrated]

I'm in the progress of migrating my database from latin1 to utf8 character sets/collations. I wrote a simple script that loops through all of my tables and executes this statement: ALTER TABLE ...
-4
votes
2answers
36 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
10 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 ...
-1
votes
0answers
27 views

MySQL manager or server PID file could not be found! [FAILED] [on hold]

I'm looking the whole afternoon for a solution. Problem was an error on all websites of one webserver, "could not connect to database". We didn't make any configuration last weeks, run no updates. ...
0
votes
1answer
29 views

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

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
29 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
22 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
26 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 ...
-3
votes
0answers
20 views

How to select proper VPS [duplicate]

I am planing for purchase a VPS for my tomcat based java web app. I have 4 JAVA tomcat enterprise webapp whose main purpose is data management. and data representation and filtering. Database is ...
0
votes
2answers
27 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
13 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 = ...
-5
votes
0answers
19 views

Exposing Restful Endpoints in PHPMyAdmin/MySQL? [closed]

I'm doing a Windows Phone 8 project and I'm new to using REST and I am trying to implement a service that communicates with my PHPmyAdmin MySQL Database, that has a file path to a video stored on the ...
-1
votes
0answers
17 views

Windows Server 2012 Connect to Remote MySQL Server and Retrieve Data [closed]

I'm totally new to Windows Server and it's services. I'm trying to connect to a remote MySQL server using Windows Server 2012. create a list from MySQL and save it as csv file locally on the windows ...
0
votes
0answers
28 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
29 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
0answers
32 views

Apt-get install older version of mysql server [closed]

I am looking to install mysql 5.5.31 via apt-get. I've tried: apt-get install mysql-server=5.5.31 but that didn't work. I don't know if there are additional repositories that I could add to apt-get ...
0
votes
0answers
16 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
19 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
11 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
votes
0answers
20 views

Two small VPSs or one bigger VPS? [duplicate]

I have a relatively busy WordPress site (http://ndsmcobserver.com). I'm currently on Linode 2GB plan, but performance is pretty sluggish, especially when performing searches and working every night ...
1
vote
1answer
13 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
18 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
11 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
14 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
42 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
75 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
15 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 ...
-1
votes
0answers
26 views

How to acheive Concurrency in mysql when there is 500+ request simultaneously to the server

I am using Mysql (InnoDb), in this I am facing problem when we checked the curl request upto 500 connection at a time (simultaneously) but when we try more than that then my servers goes to idle ...
0
votes
0answers
17 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
55 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
48 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
33 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 ...
0
votes
0answers
20 views

mysql synchronization databases [migrated]

hello, i have 5 MySQL servers masters each one have mysql slave , and i have to synchronize data from those masters to one other mysql(central mysql who contain the common data : it can be ...
-1
votes
1answer
32 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
14 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
30 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
16 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
41 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
45 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
28 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
45 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
28 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
17 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
53 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
28 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 ...
0
votes
1answer
36 views

access mysql remotely from raspberry pi? [closed]

I am using ubuntu 13.10 and I connect the raspberrypi with my laptop using ethernet cable. Now MySql Server is run on my laptop machine. Machine IP's IP Address (laptop machine) : 10.42.0.1 IP ...