MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

0
votes
1answer
13 views

Mysql database restore

My mysql backup is running everyday at 4 am & accidently my database got corrupted at 7am. Now how to restore data updated between time period of 4am & 7am
1
vote
1answer
661 views

MySQL - The server quit without updating PID file

I have installed MySQL 5.6.16 on Debain 7.4. But i encountered problems with starting mysql, where every time i start mysql i get this error: The server quit without updating PID file ...
0
votes
0answers
19 views

Mysql fresh install access denied [duplicate]

After having a similar issue with an old install, I just installed MySQL freshly (on CentOS 6.5) and ran mysql_install_db. I am trying now to set the root password using mysqladmin. However, I get ...
0
votes
1answer
16 views

Tons of apache processes running on a very low traffic development server

I have a development server that is having memory problems. There is little to no traffic on this server because it is a dev environment, but apache is spawning tons of processes and using up a lot of ...
3
votes
1answer
1k views

In mysql I want to set lower_case_table_names=1 on existing databases to avoid cases-sensitivity issues accross multiple platforms

In mysql I want to set lower_case_table_names=1 on existing databases to avoid cases-sensitivity issues accross multiple platforms. A) What are the risks ?( besides show table issue) B) After ...
1
vote
1answer
15 views

Finding and removing old mysql-bin files

I am running a MySQL server on Windows 8. The MySQL directory requires 118 GB of space and has a lot of 1 GB mysql-bin files that haven't been modified for years according to the file system. All of ...
0
votes
1answer
642 views

MySQL Database synchronizing with local and remote with c#

I've posted this here as its more of a mysql questions than c#, I have written some software that runs a local instance of mysql when it first starts, now once mysql is up I would like to synchronize ...
14
votes
3answers
813 views

MySQL Error: (2003, “Can't connect to MySQL server on '2001:db8:81:2c::2' (-9)”)

I'm trying to set up Zenoss 4.2.0 on CentOS 6.3 to monitor a remote MySQL 5.5.25a server via IPv6. The firewall is open for the monitoring server and I can connect fine from the command line: ...
0
votes
1answer
736 views

WAMP Installation - Multiple PHP Version Issues

I have installed WAMP because I am attempting to modify an an application which uses Zend Optimizer (I cannot use Z.O. with PHP5.3+, which is why I decided to install WAMP). I downloaded the latest ...
10
votes
3answers
11k views

Can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied for 'cond_instances'

I am having trouble running mysqldump as the mysql root user. When I try to backup the mysql table I get this error: mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user ...
-1
votes
2answers
37 views

CENTOS Vs Windows 2008 R2

We have an application running on Windows Server 2008 R2 with Apache WAMP, Tomcat, Mysql, PHP and java SE for last 4 years. Its a Web based ERP application. I would like to know if it makes sense to ...
0
votes
1answer
677 views

HAProxy + Percona XtraDB Cluster

I am attempting to setup HAproxy in conjunction with Percona XtraDB Cluster on a series of 3 EC2 instances. I have found a few tutorials online dealing with this specific issue, but I am a bit stuck. ...
0
votes
1answer
24 views

debug mysql crash

I have a production server which I am managing and I have been running a rails application on this server. The issue has happened twice in the past month or so and I am not sure how to debug this. ...
11
votes
5answers
21k views

Unknown/unsupported storage engine: InnoDB | MySQL Ubuntu

I recently upgraded from the previous LTS Ubuntu to Precise and now mysql refuses to start. It complains of the following when I attempt to start it: ╰$ sudo service mysql restart stop: Unknown ...
0
votes
1answer
653 views

PHPMyAdmin running very slow over internet but fine locally

I connect to PHPMyAdmin remotely on a Centos server using my local PC via Firefox. Usually it's fine but today it's really slow (2 minutes to load a page), sometimes timing out. Other connections to ...
0
votes
3answers
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
1answer
38 views

Moving from Parse cloud to AWS [on hold]

I have an iOs app completely working on Parse cloud storage, however for some reason I need to switch to AWS now. I've never used AWS before, so I'm not sure which product to use in AWS. My data is ...
1
vote
2answers
661 views

Heavy write to Galera cluster - table locked, cluster practically unusable

I set up Galera Cluster on 3 nodes. It works perfectly for reading data. I have done simple application to make some test on the cluster. Unfortunately I have to say that the Cluster fails totally ...
3
votes
2answers
115 views

Cannot Establish Remote Connection to MYSQL Database

want to access the MYSQL database remotely but when checking on yougetsignal(dot) com I get a message that port 3306 is closed. Configuration: Fresh Server (Centos 6.4 64 bit with Zpanel installed) ...
0
votes
1answer
14 views

Zenoss - install.sh doesnt ask for mysql password

i'm trying to install zenoss on a ubuntu-14.04 virtual machine. I followed the following guide "https://help.ubuntu.com/community/Zenoss". After some errors with dependencies, I have the following ...
-1
votes
1answer
17 views

Telnet to localhost 3306 looses connection to host after few seconds

When I try to telnet into my localhost port 3306 which belongs to mysql, it shows me the hello packet, then looses connection after a few seconds. My skip networking is set to OFF, I have started and ...
3
votes
1answer
677 views

Deleting MySQL rows causes lock table error

I had a couple million rows to delete but they can't be deleted at once without this error ERROR 1206 (HY000): The total number of locks exceeds the lock table size So I wrote a script to delete ...
1
vote
1answer
817 views

AWS RDS MySQL remote connection extremely slow

I have a site hosted on AWS EC2 (Elastic Beanstalk), with a MySQL database hosted on AWS RDS. Everything works fine on the production server, fast and all. However when I try to connect remotely from ...
2
votes
1answer
727 views

Relay Access Denied (State 13) Postfix + Dovecot + Mysql

So we have been scratching our heads for quite some time over this relay issue that has presented itself since we re-built our mail-server after a failed Webmin update. We are running Debian Karmic ...
-1
votes
2answers
41 views

how do I move where percona mysql stores the databases? [on hold]

I'm running low on disk space and want to move my database's to a new disk (NAS). I have no clue how to do this. Any help is appreciated. I'm using Ubuntu 13.04 and the latest version of Percona ...
-1
votes
0answers
22 views

How to correlate apache events among a web cluster?

We have a cluster of about 200 web servers. From time to time we'll have an event occur where a subset of those servers will trigger the monitoring software to restart the apache daemon. We can get ...
0
votes
0answers
25 views

How to correctly recompile PHP?

Using Ubuntu Server 14.04 x64 / PHP 5.5.9-1ubuntu4 (cli) w/ FPM / MySQL InnoDB version 5.5.35 Incredibly frustrated with what was supposed to be a minor issue. Basically, I'm being forced to ...
2
votes
2answers
6k views

Error 2013: Lost connection to MySQL server during query when executing CHECK TABLE FOR UPGRADE

I just upgraded Ubuntu from 11.10 to 12.04. My rails app now returns the (passenger) error "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) (Mysql2::Error)". I ...
0
votes
2answers
31 views

Performance hit from moving DB to another drive symlink?

We're considering moving one database (there are 4 of them in total) with InnoDB tables, to a separate partition in a Ubuntu 14.04 VPS. This DB gets read/write intensive (500 writes per sec, about ...
0
votes
0answers
15 views

Performance hit from moving DB to another drive symlink? [duplicate]

We're considering moving one database (there are 4 of them in total) with InnoDB tables, to a separate partition in a Ubuntu 14.04 VPS. This DB gets read/write intensive (500 writes per sec, about ...
0
votes
2answers
3k 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 ...
1
vote
3answers
1k views

MySQL Startup Error - Root element missing

I have had MySQL installed for about 2 months on Windows Server 2003 R2. On start up we get presented with an error that says "High Severity Error - root element missing" followed by another high ...
4
votes
2answers
114 views

Aborted connection (Got an error reading communication packets)

The mysql error.log shows [Warning] Aborted connection 320935 to db: '...' user: '...' host: '...' (Got an error reading communication packets) While the client side get's: Lost connection to ...
1
vote
1answer
97 views

AWS RDS. Upgrade MySQL from 5.5 to 5.6, external replica and Access denied

I want to create external read replica for my RDS instance using this doc: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html My old instance is running ...
0
votes
1answer
58 views

Updating phpMyAdmin that works with MySQL 5.1.73

I have recently setup a Xen VPS hosting (CentOS 6/512MB RAM/20GB HDD) for my WordPress based website. My current phpMyAdmin version is 4.1.7 and the current MySQL version is 5.1.73. I wanted to ...
4
votes
2answers
6k views

MySQL simple replication problem: 'show master status' produces 'Empty set'?

I've been setting up MySQL master replication (on Debian 6.0.1) following these instructions faithfully: http://www.neocodesoftware.com/replication/ I've got as far as: mysql > show master ...
1
vote
2answers
29 views

php pdo connection cannot be established, but mysql command line client can

situation as follows: php script on server a, run by user 'web' (nginx + php-fpm) should access mysql on server b via pdo library, but gets SQLSTATE[HY000] [2003] Can't connect to MySQL server on ...
0
votes
2answers
1k views

ownCloud WebDAV interface seems to be broken

I've been trying to host ownCloud on my server but everytime I try to it tells me this : Your web server is not yet properly setup to allow files synchronization because the WebDAV interface seems to ...
6
votes
2answers
593 views

MySQL 5.5 degraded performance in linux kernel 3.2 compared to 2.6

Our database servers (mainly based on the Debian stable packages (=currently Wheezy) seem to have about 4 times more load for the same workload in kernel 3.2.0-4-amd64 then in it's previous ...
0
votes
1answer
831 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 ...
-2
votes
0answers
35 views

Mysql resolving 127.0.0.1 to hostname [migrated]

I'm trying to connect to mysql using the command mysql -h 127.0.0.1 It comes up with the error ERROR 1045 (28000): Access denied for user 'root'@'mydomain.com' (using password: NO) Why is ...
0
votes
1answer
20 views

Dovecot MySQL Authentication SlowDown

I have an IMAP/POP3/Webmail server with Dovecot1 2.2.10 with a MySQL backend located on another server. The server runs with default configuration. ... driver = mysql default_pass_scheme = plain ... ...
3
votes
4answers
3k views

how to know all users that can access certain database (mysql)?

how to know all users that can access certain database ?
1
vote
2answers
687 views

mysql-python with MySQL 5.6

I am having problems installing the mysql-python module in my server (CentOS 6.4 x86_64) with MySQL 5.6 installed and Python 2.6.6. [python@localhost ~]$ rpm -qa | grep SQL ...
1
vote
3answers
978 views

mysqld refusing connections from localhost

My mail server (Ubuntu 10.04) uses mysql for virtual domains, virtual users. For some reason, mysqld has started refusing connections from localhost. I see these in the mail server log: Oct 6 ...
0
votes
3answers
123 views

Changing the mysql bind-address within a script

What would be the best way to change the mysql bind-address in the my.cnf from a shell script? Is there a way using a tool like mysqladmin or should I use sed or should I simply append it to the ...
4
votes
6answers
14k views

How to undo DROP Table?

I accidentally dropped all tables. Can I restore back? I don't have the backup copy.
1
vote
3answers
105 views

localhost webserver vs separate server for small office [duplicate]

We have a small office (4 people at the moment) and work exclusively with healthcare data (HIPAA protected). For the past 2 years we've been storing all client data on a mysql database on my local ...
0
votes
0answers
8 views

Error: Trying to add tablespace 57 to the tablespace memory_cache

I was wondering if you could help me out repairing a Mysql database: InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Error: trying to add ...
1
vote
1answer
1k views

How can I set up mysql logs so that syntax errors are logged?

I've got mysql logging log_slow_queries or whatever, and had turned on all query logging for a moment before I found it to just be spammy and thus useless. How can I log only mysql queries that ...