MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

-1
votes
2answers
51 views

How to Dump all databases from MySql server with mysqldump without passwords

Is it possible to dump all databases without supplying the username and password for each databe ? The server has 10 databases with different usernames and passwords. I will be logged in as root ...
-1
votes
1answer
37 views

Migrate OTRS database from PostgreSQL to MySQL

OTRS supports PostgreSQL and MySQL databases. I'm using PostgreSQL 9.1 for my OTRS 3.2 but I want to migrate to MySQL 5.5. Is this possible? How?
-1
votes
1answer
40 views

Pros and cons of installing php 5.6 and mysql 5.6 on debian 7 wheezy

I was setting up a VPS server for my client and we had talked that I would install the last stable versions of the programs. Now, in Debian 7 wheezy by default php 5.4 and mysql 5.5 are available. I ...
-1
votes
0answers
12 views

mysql slow log filling up without queries

I have slow query logging turned on but have noticed it just fills up with this repeated. It's in there close to 5000 times since yesterday when I reset the log file. There are no slow queries on the ...
1
vote
0answers
56 views

ERROR 2003 (HY000): Can't connect to MySQL on server 'myhost.com' (101)

When trying to connect to my mysql server remotely with: ~$ mysql -u user -p -h myhost.com The result is (after asking for password): ERROR 2003 (HY000): Can't connect to MySQL server on ...
0
votes
0answers
11 views

Automate backing up of MySQL DB on Godaddy Windows account [migrated]

Does anyone know of a good way to set up an automated backup of our MySQL DB on a Godaddy Windows account? Most articles I have found talk about using mysqldump. But I can't figure out how to do ...
2
votes
0answers
52 views

Benchmarking for DISK I/O Writes Per Second - ElasticSearch and MySQL

During working on our project we needed to decide should we use "ElasticSearch" or "MySQL" to record the audit/trail logs of the system. Searching speed is not an issue here, we needed to see the disk ...
0
votes
0answers
29 views

Percona cluster signal 11

We have a percona cluster that is randomly getting signal 11's on different cluster nodes. I've exhausted everthing I know. Here's the .err file with the signal 11. We're running Server version: ...
0
votes
0answers
4 views

mariadb / mysql wont change table_cache / open_table_cache [migrated]

I've configured my i7 64gb ssd server with centos7 with the following my.cnf [mysqld] key_buffer = 12M max_allowed_packet = 16M table_cache = 4096 table_open_cache = 4096 table_definition_cache = ...
0
votes
0answers
19 views

Path to mysqldump on Azure VM?

I've set up a VM running MySQL Server (Community Edition) on Azure. My CMS (Perch) has a backup module, which uses mysqldump to back up the database. However, the default options don't seem to be ...
0
votes
1answer
39 views

Server with multiple replicate=do-db entries

I have a server that someone has setup which are acting as a master-master on both servers. Since they have been configured as both master on the same database, changes in one end has caused all sorts ...
0
votes
1answer
23 views

Provisioning MySQL remote users

Seeking advise on optimal way to provision remote MySQL user permissions, when the source of connections is a large network block. Since the MySQL server may have DNS lookups disabled for performance ...
-1
votes
2answers
45 views

Who is responsible for performing the query EC2 or RDS?

Normally I run my own MySQL server (within EC2), but I was looking for the possibility's of RDS ( https://aws.amazon.com/rds/ ). As I understand RDS is (directly after setup) optimized for ...
0
votes
1answer
31 views

ColdFusion Server slow connection to dedicated database server?

We had our database and web server on the same box. For performance reasons, we are now off loading the database to a dedicated server. When updating the CFDSNs to the new server, the verification ...
3
votes
1answer
48 views

searching for the correct way to compile postfix

I am experiencing issues while compiling latest version of postfix from source code. At the moment I'm trying to compile version 3 because Debian 7 and latest Ubuntu 14,10 (version 2,9 and 2,11 for ...
1
vote
1answer
30 views

Best method to ensure Mysql master slave replication is consistent?

I am running a master slave replication system on AWS EC2 systems over ssh. However I came across a couple of best practice articles indicating that even this might allow inconsistencies to creep into ...
0
votes
2answers
72 views

mysqldump connects as different user from cron and from command line

I had a bug in a backup script running as a cron job which I found and corrected, but I'm still puzzled by the fact that this bug did not show up when the script was started from the command line. The ...
0
votes
1answer
79 views

Postfix fails to install in MySQL 5.7

I am trying to install postfix in my server with Centos7 MySQL 5.7 Unfortunately it seems to be they are incompatible. Why? Here the error message. Is there a way around this ? [root@doc ~]# ...
1
vote
0answers
62 views

Amazon RDS Instance slowly losing free diskspace

A while back the server running my instance had 20GB of EBS storage. It then started getting disk storage errors, so I increased it to 40GB. Then again, storage missing errors so I increased again to ...
5
votes
1answer
188 views

Nagios alert based on scheduled MySQL queries results

I have installed Nagios 4.0 on my Ubuntu 14.0 and i want a plugin to alert me based on daily scheduled MySql queries .. if the result of ( select count(*) from tableName > 10 ) raise a critical ...
0
votes
0answers
41 views

CentOS 7 Cluster with load balancer

I'm trying to understand how clustering works in CentOS 7. I'm not a cluster expert!!! What I'm trying to do is to have three clustered services: httpd, mariadb (mysql) and postgresql. I've managed ...
1
vote
1answer
326 views

Nginx + HHVM + MariaDB + WordPress install -> Error establishing a database connection

I'm setting up a VPS for a WordPress blog. I'm using Ubuntu 14.04 LTS 64 bits and then I've installed Nginx 1.7.8, HHVM 3.6.0, MariaDB (don't remember the version). Finally I've downloaded WordPress ...
0
votes
1answer
94 views

connect to db instance in private VPC subnet with MySQL Workbench

How do I connect to an AWS (or other) instance in a private subnet in a VPC using MySQL Workbench ? My arrangement is a typical aws Scenario 2 : I can: - SSH into my NAT instance located in my VPC ...
-4
votes
2answers
52 views

How to avoid mysql query hang if the disk is full

The disk is full and my query hangs on the mysql query. From the mysql manual: When a disk-full condition occurs, MySQL does the following: It checks once every minute to see whether there ...
-1
votes
1answer
21 views

Synchronize Staging Server and Live Server [closed]

We have staging and live server at our office. Where Live code and DB changes are far more advanced than staging one.This application developed under php and DB is mysql. Earlier we used to work in ...
0
votes
1answer
35 views

How to monitor MariaDB Galera cluster status from command line

I know to check the Galera cluster status, the command that should be used after login to the mysql client is: SHOW STATUS LIKE 'wsrep%'; but, how to get the output directly from the command line? ...
1
vote
0answers
13 views

Leave only the Server and Client files in a mysql installed manually on windows

I am a php developer and I'm setting up a portable development environment on windows 7. I downloaded the version of mysql "NonInstall Zip Archive" and is working properly. However, I see that ...
-4
votes
1answer
36 views

mysql hot add memory

Is it possible for currently running jobs in MySQL to utilize memory that's been hot added? It looks like when memory is hot added to the VM the currently running jobs are not utilizing the additional ...
1
vote
1answer
41 views

Postfix + mysql: virtual_users combined with a catch-all in virtual_aliases

I have a Postfix (and Dovecot) server running, using MySQL to define the domain names, users and aliases. This is all running fine, but now I want to add a catch-all to a domain where I already have ...
0
votes
0answers
33 views

MySQL replication ignoring BINLOG statements for certain table

I'm trying to make MySQL Replication work, but my slave is constantly stopping because of constraint fails. This errors occurs because the replication of one particular table is not working. If I ...
0
votes
2answers
56 views

Syntax error when setting up master-master replication in MySQL

So I've set up my initial master-slave replication pair on two different MySQL servers. That part is working great. So all I have to do is set up the first master as a slave and set up the first slave ...
1
vote
1answer
31 views

MySQL - Unable to enable binary logging

I'm trying to enable binary logging so that I can set up master-slave replication between two servers. I'm working with an existing server with lots of data and I'm trying to dump the data with the ...
0
votes
0answers
26 views

Mysql reports “unknown variable pass” after upgrading from 5.5.41 -> 5.7.5 on Debian

We have the following problem after upgrading MySQL 5.5.41 (pre-installed on our Debian Wheezy LAMP server from Hetzner) to 5.7.5 version (downloaded from mysql.com). After updgrading from the ...
1
vote
0answers
33 views

How to change permission of users in RDS?

We have created a MySQL RDS instance on AWS called "lolbob" and while dumping our data over port 3306 using the user that was created during instance creation (also called "lolbob") it fails because ...
-1
votes
1answer
53 views

MySQL gives error “SSL connection error: Unable to get private key”

I keep getting the errors "SSL connection error: Unable to get private key" when using mysql client. In order to get it to work, I have change the permission 444. However, I would like to lock it ...
-1
votes
2answers
27 views

How to avoid 'too many connection' error in MySQL

It often happens that when trying to load the data from the database i`m getting an exception 'To many connection'. I do not know the internal features of the database work, so i do not understand ...
0
votes
0answers
12 views

Can’t load file into MySQL, even though local_infile is set

I’m trying to import a file into a MySQL database. I’ve added local_infile to my my.cnf file, and restarted the mysql service. In my PHP script, if I run phpinfo() then I can see ...
1
vote
1answer
30 views

Is it possible to safely edit mysql-bin.index file while mysql server is running

I changed location of mysql bin-log files. I copied them so mysql started fine, because they where in both locations, but then removed them from old location. I forget about correcting the path in ...
0
votes
2answers
45 views

Dedicated server stalls at 80 req/s - is MaxRequestWorkers the cause?

I have a physical Ubuntu server (see some of the specs here), with Apache 2.4.7, PHP 5.5.9, mysql 14.14, mysqlite and Yii framework 1.16 installed. The server performs amazingly at first, but ...
0
votes
0answers
25 views

Cannot start mysql on vagrant CentOS machine

I am getting the following problem doing "vagrant up" ==> default: [2015-03-10T16:31:03-04:00] INFO: template[default :start /etc/init.d/mysql-default] mode changed to 755 ==> default: ...
0
votes
2answers
84 views

elasticsearch-river-jdbc inserting duplicate record in mysql db

Sorry I am newbie to Elasticsearch and I am using elasticsearch-river-jdbc to connect to myql database,everything is working fine except for the fact that everytime it run as per schedule its ...
1
vote
1answer
76 views

Server crashes with “huge task timeout”

First things first, I've read a lot about the "huge task timeout" kernel panic and know that this often happens if the server is out of resources. Error messages which appear only in the VNC console ...
-1
votes
1answer
52 views

Using multiple IPs on one machine for web and game server

We are looking to host a game server. The game we are going to be setting up a server for is subject to DDoS from other servers, players, etc. Many other server and administrators have pointed out ...
1
vote
1answer
26 views

How to implement table security without SUPER privilege?

A MAJOR provider of cloud-based MySQL does not grant the SUPER privilege to the master user. The provider is Amazon RDS, but my question isn't about Amazon RDS specifically, it's for the general case ...
1
vote
0answers
79 views

freebsd cannot start mysql for the first time

I am having the same issue as this person serverfault link but the solution completely does not work for me. I cannot start mysql5.5 for the very first time. At first start of mysql with cd ...
0
votes
1answer
13 views

innodb files in wrong directory

I have created a database called TEST with innodb tables. When I look in the /var/lib/mysql/TEST directory I see a .frm file for each table. However, there are no .ibd files in that directory. The ...
0
votes
0answers
45 views

Can't connect Windows Azure VM with MySQL On-premise

I have a VM on Windows Azure with Windows 2008 R2, and I'm trying to open a connection to an on-premise MySQL database hosted on another network. We cleared the VM's public IP (the one displayed on ...
-1
votes
2answers
24 views

MySQL configurations are not saved after restarting windows server machine

I have a PHP application hosted on a windows server 2008 R2 machine. I had a problem with strict mode in MySQL and solved it by disabling the strict mode using the following command set ...
0
votes
1answer
28 views

Will frequent insert make select queries slower with MySQL?

I have a table that's frequently written to. There is a crawler that keeps inserting new records. How will this affect the read performance of the same table in MySQL?
0
votes
2answers
85 views

How to let PHP connect to database by using UNIX socket (Joomla)

I'd like to have my PHP applications such as Joomla make use of the UNIX socket to connect to the local mysql database. I've already configured the php.ini with: mysqli.default_socket = ...