MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
17 views

icinga2 mysql connection issue

I followed all the install wizards When setting up icinga2, I have the following error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13) ...
8
votes
8answers
70k views

“Error 1067: The process terminated unexpectedly” when trying to install MySQL on Win7 x64

I've run into a brick wall trying to install MySQL v5.5 on my machine. My PC is Windows 7 x64, Enterprise edition. MySQL installs fine, but when I run the "MySQL Instance Configuration Wizard", it ...
2
votes
4answers
9k views

Incremental/Differential MySQL Backup using mysqldump

Are there any techniques to use mysqldump (or similar command) to make incremental or differential backups for MySQL?
-4
votes
0answers
31 views

nginx after one or 2 Hour error

my site is joomla and i config windows server 2008 r2 to mysql php and nginx it work ok but after 1 or 2 hour suddenly show error page?! this is my configuration: worker_processes 32; events { ...
0
votes
1answer
159 views

Mysql general query log tool to play back queries in time?

I am trying to reproduce production activity in time for benchmarking purposes from the mysql general query log. I'd like to be able to use the date data from the log to reprduce the time intervals ...
0
votes
0answers
19 views

URL routing for domains

I have a site with 10's of thousands of users. Each user has their own site hosted by me at a subdomain of mysite.com/user1 or as an add on domain at user1.mysite.com or user1.com. This is all done ...
-2
votes
0answers
9 views

How to create a sub project in weblate? [on hold]

I just setup a new server with weblate software send I have no clue how to set correctly a sub project with github source. Can anyone please post a model to follow? The documentation at weblate is ...
0
votes
3answers
1k views

MySQl, Postgresql replication comparison

One main issue with MySQL replication is that the slave is single threaded. This can cause replication lag. How does Postgresql handle replication? Does it (or add-on such as slony-I) allow ...
0
votes
1answer
36 views

Mysql Allocates too much ram

I am using a 4GB VPS from 1&1 and the main mysqld process is allocating up to 2GB, though never using more than 100mb from them. Should I be worried about this and how can I optimize it? (Running ...
0
votes
1answer
11 views

Munin not warning on trespassing warning level

I have a Munin installation which surveils a bunch of servers. Two of them have MySQL replications running of which Munin plots the slave lag by use of mysql_slave_status. [mysql-slave.nmk.loc] ...
0
votes
0answers
6 views

MySQL (InnoDB) - processes waiting on futex

Currently troubleshooting a MySQL server spending a lot of time in futex syscalls. All databases are InnoDB and seeing high load on my 16 core machine, and slightly more than half of CPU time is in ...
0
votes
0answers
15 views

Why binlog capture only postions [migrated]

Please help me out, why master server records only position not statement. ### INSERT INTO `sanma`.`response` ### SET ### @1=743096223 ### @2=0 ### @3='IR' ### @4='UnderProcess' ### ...
0
votes
2answers
29 views

CentOS root user crontab for mysqldump

I am using CentOS 6.6. I am trying to set up a crontab. I made an .sh script which runs perfectly when executed manually. The command is following: mysqldump --skip-lock-tables --single-transaction ...
0
votes
1answer
32 views

MySQL frequently starts returning empty results on SELECT and throws no errors. After restart it starts working as expected

MySQL started frequently returning empty results to all queries on all databases until I restart it after which it again works as expected. No errors are thrown or logged and the MySQL server keeps ...
0
votes
2answers
2k views

Install Navicat for MySQL on Linux Ubuntu 12.04

How do I install Navicat on Ubuntu Desktop 12.04? I have just configured a new Ubuntu 12.04. Because I'm not so familiar with the command line, I prefer to use Ubuntu Desktop so that I can have a ...
0
votes
1answer
2k views

installing mysql5.6.12 in ubuntu 12.10 error:/etc/mysql/conf.d is missing

I am trying to install mysql in ubuntu 12.10. Downloaded 'MySQL-5.6.12-1.linux_glibc2.5.i386.rpm-bundle' from http://dev.mysql.com/downloads/mysql/. Extracted it and tried to install using rpm -i ...
0
votes
0answers
20 views

mysqld got signal 11 server halted

Since few days my mysql server halting whole server and I found such information in log 150129 21:22:35 [ERROR] /usr/libexec/mysqld: Sort aborted 150306 17:55:55 - mysqld got signal 11 ; This could ...
0
votes
3answers
42 views

Doing a backup with mysqldump and drop it on another server (Bash)

I'm using a cron job to do backups hourly and now, I want to drop those backups on another server by default. My script is the following: mysqldump -u db_user -p db_password db_name| gzip > ...
4
votes
2answers
1k views

vsftpd - PAM - MySQL and pam_mkhomedir to create directories

I've been successfully using vsftpd with virtual users connecting with PAM to my mysql DB. Now I'd like to automate creation of user directories with successful vsftpd connection. Here is ...
0
votes
2answers
32 views

What information is lost on a connection when passing it through a aws load balancer?

Bit of a newbie question here. What happens when traffic is forwareded through a load balancer? I had always assumed that load balancers just forwarded connections from clients to one of a set of ...
0
votes
1answer
914 views

MySQL (local) owner and permissions

I asked this question on the MySQL forums and got no answer. I asked on StackOverflow and received a recommendation to try on ServerFault. So here I am. I recently successfully installed the 64 bit ...
1
vote
1answer
24 views

Roundcube MySQL/session issues, “no valid session data found”

So Roundcube is connected to MySQL fine, and is running queries. However, whenever I login, I get a "Your session was invalid or expired." error. From some PHP debugging, I think it has something to ...
1
vote
3answers
455 views

AMD Phenom II X6-1055T HEXA Core vs Intel i5-750 Quad Core

I have an option to choose between the 2 processors for a dedicated server. Most of my sites use MySQL and Perl. Other difference is that I get 8 GB of RAM with the AMD processor and 2GB with the ...
-1
votes
0answers
17 views

What is the best way to run PHP script every 30 seconds? [duplicate]

I have kind of a special requirement that is, I'm using a Raspberry Pi 2 B device to feed some data to a mysql database in a cloud serve. So I have installed LAMP stack on raspberry pi and config my ...
0
votes
1answer
947 views

Installing mysql-devel to match MySQL version

I'm running MySQL 5.1.52 on CentOS 4.6 and I'm trying to install mysql-devel to match my MySQL version. If I do yum install mysql-devel it wants to upgrade MySQL to 5.1.58, yet if I do yum search ...
0
votes
1answer
61 views

Deploy MySQL/MariaDB on demand in a C# application

I'm creating a lightweight bug tracker, and I'm really having difficulties with people that don't know how to deploy and connect to a MySQL database on their own. What they should do is to create ...
0
votes
0answers
39 views

ProFTPd + MySQL + Apache

I am trying to set up a LAMP server with ProFTPd using MySQL authentication This is a dedicated server with a single website under /var/hitr/public. I'd like to use proftpd to for user's configured ...
2
votes
2answers
79 views

Segmenting mysql backups using tar

In addition to using mysqldump, I've been backing up my mysql server by tarring up /var/lib/mysql for redundancy and convenience. This directory includes ibdata, ib_logfile0, and ib_logfile1 as well ...
0
votes
3answers
85 views

MySQL Upgrade RPM

I have a centos5.5 system and have MySQL 5.0.27 install. Now I want to upgrade this to MySQL 5.5.28(Latest). I have two questions, What is the difference between RPM(Redhat) which is recommended and ...
0
votes
5answers
2k views

MySQL my.cnf file not being read, Ubuntu 10.04 64bit

I've been researching this for a few hours with no luck. Basically it looks like my server's my.cnf file isn't being read at all. I've searched my server, and there's only one my.cnf file on it, ...
0
votes
0answers
9 views

pure-ftpd-mysql doesnt work after install

I searched for a tutorial to install the ftp-Server correctly and I found this tutorial to install pureftpd-mysql but I can't login with the example user or any other user. I tried 2 other tutorials, ...
0
votes
1answer
10 views

Percona: What are the implications of changing repl.commit_order?

I'm currently doing some trials of Galera Cluster with Percona 5.6. I've progressed to testing a 2 node cluster on baremetal. With repl.commit_order set to 0 (off) the TPS performance as measured with ...
0
votes
1answer
20 views

MySQL - Can not connect from local network, but can connect from any other IP

Facing a really strange issue. The original requirement was to have a development server which can be accessed from our office in Sweden and from India. In our server in Stockholm, I created a new ...
25
votes
7answers
38k views

How can I copy MySQL users table from one server to another?

I'm setting up up a new MySQL server and I'd like to give it the same set of usernames, allowed hosts, and passwords as an existing server (which is going away). Would it work to just do a dump of ...
0
votes
2answers
1k views

How do I sync a subset of tables between two databases on the differnet mysql database server?

I have the main MySQL database which has the following columns in one of the car table: +---------------+-----------------+------+ |carId |name |model | ...
4
votes
1answer
6k 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
0answers
10 views

Upgrade MySQL Client API Library Mac OSX 10.10.4 [closed]

On my local development machine iMac running OSX 10.10.4 I have MySQL Server version 5.6 running, but the Client API is at 5.0.11. mysql -v Server version: 5.6.24 MySQL Community Server (GPL) ...
1
vote
2answers
1k views

Horrible PHP/MySQL Query Performance On Ubuntu Server 10.04

I just did a clear install of Ubuntu Server 10.04 with the standard LAMP config.. Then I made a small script to test insert speeds into a table with 3 columns. When I run the script on any of my ...
0
votes
1answer
107 views

Nginx using mysql result as variable to be used in headers more module

Without going into too much detail we have a requirement for the following: a) Query a simple single column, single row result from mysql. b) Use this variable as part of a more headers module, ...
0
votes
1answer
986 views

Troubleshooting MySQL Performance Issues

Environment: 1 physical machine 8GB RAM some older Core2Duo CPU 1 HDD Windows Vista 64 bit 1 Virtual Machine 16 GB RAM 2 vCPUs Windows 7 64bit Both machines running MySQL 5.5.28 (64Bit) with ...
0
votes
1answer
18 views

MySQL process in Sleep command and page is loading after 1 minute

I'm using VestCP which installed for me Apache2.2, PHP 5.5.25, MySQL Percona and Nginx. I have an app built in ZF1 which works fine on all my development computers but on this server the application ...
0
votes
3answers
67 views

MySQL keep crashing

So a little background, a few weeks ago I brought a new CentOS dedicated server in Melbourne, however it seems beside the number of attackers I get, there also seem to be an issue with the MySQL ...
0
votes
2answers
49 views

MySQL, NFS and symbolic links

I have been migrating an older server running apache2 + mysql under ubuntu to a new server running debian (wheezy). The migration works fine while the databases are storted localy (in our case ...
4
votes
7answers
6k views

Is there any equivalent of mysqlhotcopy for InnoDB?

Currently I'm using mysqldump to make backups which is slow, but OKish. The big problem is restoring database, which takes a few days. The dump is around 7GB gzipped, so it's not a tiny database, but ...
-4
votes
0answers
17 views

How to let your server connect from a DB located to another server? SmartFoxServer/Phpmyadmin [closed]

When i try to start another server so ill have 2 servers in one db. but my 2nd server cant connect to db that is located to 1st server. can someone help me? I use xampp as mysql phpmyadmin.
5
votes
2answers
19k views

MySQL warning “IP address could not be resolved”

I've got MySQL Master/Slave setup and I've noticed the following warnings in the mysql log files on both servers: [Warning] IP address 'xxx.xxx.xxx.xxx' could not be resolved: Name or service not ...
11
votes
6answers
35k views

How to completely remove MySQL from Windows?

(I realize there are similarly-titled questions, but this one is really 'how do I reset the password', and this one doesn't specify an OS and has only gotten Linux-oriented answers.) On Windows XP, I ...
0
votes
1answer
6k views

Lost connection to MySQL server at 'reading initial communication packet', system error: 0 with windows

I found similar questions but none of them helped me with a windows machine. I originally posted this on stack overflow but it was suggested that I ask here. I was able to connect to mySQL through my ...
16
votes
4answers
12k views

Why can't I connect to Amazon RDS after setting it up?

So, I just created the Amazon RDS account. And I started an instance of database. The "endpoint" is: abcw3n-prod.cbmbuiv8aakk.us-east-1.rds.amazonaws.com Great! Now I try to connect to it from one ...
2
votes
2answers
6k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...