The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
4 views

Procedure + Insert [migrated]

I would like to create a procedure with a while but I have an error. Here is my procedure: Delimiter // create procedure procedure1 () BEGIN Declare i INT; set i=1; while i< 74 do execute ...
0
votes
0answers
21 views

UTF-8 encoding gone missing after enabling mysqlnd

I've enabled mysqlnd on my PHP 5.4.26 server using MariaDB 10.0.8. My SQL config contained this: [mysqlnd] character-set-server = utf8 collation-server = utf8_general_ci It was all working fine ...
1
vote
1answer
101 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 ...
1
vote
0answers
46 views

MySQL rebuild after Corrupt ibdata1

I have a MySQL server that serves a couple of databases including a Magento e-commerce store. We have been suffering with corruption in the ibdata1 file for a while, but it has now reached a critical ...
0
votes
0answers
7 views

MySQL Server Not starting on Windows OS with Arabic

I have a MySQL server (The MySQL version is 5.5.25) that I packages with my software that I run on my Windows XP/7/8/Server, the MySQL server is starting up and running as required on the Windows OSes ...
0
votes
1answer
24 views

Where to download MySQL server 5.0.77-log

I have MySQL Server version: 5.0.77-log Source distribution on a RHEL6 server. I need to reinstall it on a second RHEL6 server to set up a testing environment but I cannot find where to download this ...
0
votes
1answer
57 views

MySQL 5.0 not logging aborted connections in general log

I know there is a bug in MySQL 5.0 which prevents aborted connections from being logged in the error log (http://bugs.mysql.com/bug.php?id=24761). However, aborted connections should still be logged ...
0
votes
1answer
51 views

Increase the speed of mysqldump

Are there any flags or tricks to speed up mysqldump for backups? Here is what we are currently using: mysqldump --skip-opt --flush-logs --routines --triggers --allow-keywords --create-options ...
0
votes
1answer
30 views

Do global logging settings in MySQL5 stick after service restart?

Want to execute this on MySQL 5.0: set global log_warnings = 2; Will the setting stick after a mysqld service restart?
0
votes
2answers
566 views

MySQL 5.6 on CentOS 6 silently fails to start

I'm working on a fresh CentOS 6.5 install and trying to get a MySQL 5.6 server daemon running. The server is a fresh droplet on DigitalOcean's infrastructure. 512 MB size. I used the MySQL version ...
0
votes
0answers
126 views

MySQL 5.6 Create Table VERY slow

I recently upgraded my MySQL server from 5.1 to 5.6 (running on CentOS 6.x). Ever since the upgrade, when I try to perform certain table tasks the queries take a REALLY long time. This is really ...
-2
votes
1answer
443 views

Installed Windows 8.1, MySQL service disappeared and all MySQL data/settings gone [closed]

This weekend, I updated a Windows 8 workstation to Windows 8.1. This was a development workstation that had a locally hosted MySQL 5.6 instance used for web development work. After the update ...
0
votes
0answers
25 views

Cannot login to mysql through mysql-proxy

Good day, I have a user usera which I grant access. Thus I can do remote$: mysql -h dbhost-u usera -p my_db and dbhost$: mysql -u usera -p my_dba And both works. But after creating a ...
2
votes
1answer
82 views

MySQL Workbench sends computer name with login not IP

I am attempting to connect MySQLWorkbench to a remote MySQL Server. The server has granted access to user@IPAddress However, when I try to connect MySQLWorkbench, it sends user@computername ...
1
vote
0answers
157 views

how to enable remote access to a MySQL server on an AZURE virtual machine

I have an AZURE virtual machine with a MySQL server installed on it running ubuntu 13.04. I am trying to remote connect to the MySQL server however get the simple error "Can't connect to MySQL server ...
0
votes
2answers
117 views

MySQL consuming all system memory on INSERT … SELECT

The mysql daemon is getting killed because Linux is reaching out of memory: Oct 24 07:41:23 <hostname> kernel: [82297.673701] Out of memory: kill process 13816 (mysqld) score 1839626 or a child ...
0
votes
1answer
55 views

Unable to adjust php.ini max upload size directive on Centos 6.3

Currently i'm setting up Centos 6.3 (64 bit) on vm and installing Wordpress: Already adjust /etc/php.ini but seems like overwritten by other settings. Suspect this is due to selinux feature. My goal ...
1
vote
1answer
227 views

MySQL 5.1.69 at CentOS 6.4 doesn't know enable-named-pipe?

Trying to install MySQL (for WordPress) on a CentOS 6.4 /64 bit server. I have installed the mysql-server-5.1.69-1.el6_4.x86_64 package and executed the following commands: # chkconfig mysqld on # ...
0
votes
1answer
62 views

Queries going to mysql server even when no one is connected to it

I have a MySql server which has 2 active databases which are used for a web application and 3 inactive ones (left for archival purpose but not currently used). The problem is that the server seems to ...
0
votes
1answer
100 views

PHP connection for Mysql is very slow in another server

Few days ago, we moved our mysql database to another host because of some limitations with our current host. Everything is fine (Seem same performance and speed on our PHP framework based website) ...
2
votes
2answers
182 views

Innodb one file per tablespace

I'm walking into an environment that uses MySQL and Innodb as the storage engine. I'd like to enable innodb_file_per_table to increase performance. Considering all of the databases/tables are ...
0
votes
1answer
112 views

What can I do with corrupted DB in InnoDB format in this case?

guys, I have a big problem. There is one server with CRM database. I corrupted it probably and don't know what to do. ls /var/lib/mysql/sugarcrm/ accounts_audit.frm address_book.ibd ...
0
votes
2answers
393 views

Mysql 5.5 is not installed in CentOS 5.7

I am using CentOS 5.7 with 64 bit. In my machine already have MySQL 5.0.88 version. Now I want to upgrade MySQL to 5.5 version. I followed this link to start my installation process. When i give "yum ...
0
votes
1answer
594 views

MySQL 5.6 Upgrade - Incorrect definition of table mysql.proc

After upgrading MySQL to version 5.6.10 from version 5.5 I'm getting the following errors when starting MySQL server: 2013-03-19 05:32:38 2666 [Note] /usr/sbin/mysqld: ready for connections. Version: ...
0
votes
0answers
160 views

How to set debian with it_IT@EURO without converting the MySQL database?

I have a machine with Debian 6.0.x and MySQL Server version: 5.1.66-0 + squeeze1 (Debian). If I configure my machine with it_IT@EURO instead of en_US.UTF-8 Mysql is not happy, eg a table control / ...
2
votes
2answers
5k 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
80 views

How to proceed setting up a secondary mysql linux slave?

I have a mysql database master and slave in production. I want to setup additional mysql slave. There is around 15 Terabyte of data in the database and there are MYISAM and InnoDB tables in the ...
4
votes
2answers
510 views

mysql error 1062 'duplicate entry' when restoring backup

Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this. Requirement: To create an exact replica 'db4' of an existing DB 'db3'. Procedure ...
2
votes
4answers
455 views

MySQL : Separate Log File for Each Database

I have a server with multiple databases on it. Its actually an instance on AmazonRDS so I do not have access to the my.cnf file. What I am trying to do is a create a log for each database separately ...
1
vote
3answers
75 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 ...
2
votes
3answers
168 views

MySQL specific database replication (Master - Master)

We have a MySQL server at one location, replicating to another in a Master->Slave configuration. There are about 5-7 different databases on this server. We are wanting to do this... We have a second ...
1
vote
0answers
1k views

How do I set my root account in mysql to be accessed locally?

I am running into a bit of a problem here. I have a mysql server setup on an Ubuntu 12.04 distro. After the initial install I have been using MySQL Workbench to do all my db creation and ...
1
vote
3answers
193 views

Replicate between mysql 5.0.xx community and enterprise edition over ssh

I'm trying to setup a mysql replication over an SSH tunnel. The odd thing about this setup is that I have one master with mysql 5.0.60sp1-enterprise-gpl-log and one slave with mysql ...
1
vote
1answer
172 views

Ubuntu script to add multiple user with apache userdir and mysql username

In Ubuntu 12.04, I'm having difficulties creating a script (since I'm not experienced with it), and is assigned to add multiple users from a list of names in file usernames.txt. The users will have ...
1
vote
1answer
925 views

Mysql - innoDb - is in the future! Current system log sequence number

I have this error in my syslog. I restored an older dump to solve this problem, after some reading. Now The errors in syslog are far less than before. But still a few times an hour I get Sep 1 ...
2
votes
2answers
153 views

Rebuild mysql slave from scratch

I'm having a master/slave mysql setup. This night I had some problems with the master. I needed to recreate all databases again because they were corrupt. Now I stopped my mysql slave but want to ...
0
votes
2answers
90 views

MySQL is converting MyISAM tables to INNODB automatically

I recently upgraded MySQL server on CentOS 5 with MySQL 5.0.96 After upgrade when i am trying to import old database dump which has got both MyISAM and INNODB tables in a single database, MySQL is ...
0
votes
0answers
177 views

Connecting to MqSql database externally on Windows

I want to access my MySql database remotely, but can't seem to make it happen. Accessing the database local works perfectly fine. System - Window Server 2008 Web Edition - IIS 7 - Mysql 5.1.56 I ...
0
votes
1answer
65 views

Mysql - Performance improvement of “ORDER BY” with index

Can I improve the "ORDER BY" by adding an index on fld_date. SELECT * FROM t1 WHERE fld1='XXX' fld2='XXX' ORDER BY fld_date; The query uses the index of (fld1,fld2 - combined index) in the where ...
0
votes
2answers
32 views

Mysql - Find out which Database a particular table is present

How would I find out which Database a particular table is present in MySql ? Mysql version is +----------------------+ | version() | +----------------------+ | 5.1.35-community-log | ...
0
votes
1answer
773 views

why does mysql have so many more open and fragmented tables than tables in the DB?

I've been working making our database run a little smoother and had good results over the past week. But there are still some things I dont understand. For one thing, the database has 25 tables. ...
0
votes
1answer
79 views

Optimize server for faster processing of requests [duplicate]

Possible Duplicate: LAMP Server Performance Tips I am running a web directory using WordPress which has a lot of categories, and I mean a lot. Around 26,000 to be precise. And it takes ...
0
votes
1answer
313 views

Issue with InnoDB engine while enabling and [ skip-innodb ] - [ERROR] Plugin 'InnoDB' init function returned error

In production server as of now we are running with MyIsam tables only, hence we have disabled the innodb engine with skip-innodb option. But now onwards we need to enable the innodb engine as well for ...
5
votes
3answers
4k views

Cant connect to mysql using self signed SSL certificate

After creating a self-signed SSL certificate, I have configured my remote mysqld to use them (and ssl is enabled) I ssh into my remote server, and try connecting to its own mysqld using ssl (mysql ...
0
votes
1answer
2k views

What is the use of ibdata1 file in mysql [closed]

I have application which has the backend db as Mysql(InnoDb engine), and currently my client wants to decrease the size of the ibdata file to some fixed size. I found the three below solutions. ...
2
votes
1answer
2k views

Is it safe to modify innodb_data_file_path value for mysql 5?

I recently experienced data corruption after changing the value of this parameter in my.cnf from : innodb_data_file_path = ibdata1:10M:autoextend:max:128M to : innodb_data_file_path = ...
0
votes
3answers
219 views

Pid file for mysql on Oneiric

I cannot locate pid file for mysql server on oneiric. Opened /etc/mysql/my.cnf and /etc/mysql/debian.cnf but see no settings about pid file. I need this pid file to have monit monitor mysql. Any clue? ...
0
votes
1answer
310 views

Relocating MySQL data files

I would like to move everything that is related to my current MySQL database(s) into a subdirectory of /home/mysql. I don't need to move log files or my.cnf, only data. I don't know where the actual ...
1
vote
1answer
477 views

Innodb Queries Slow

I have RedHat 5.3 (Tikanga) with Mysql 5.0.86 configued with RAID 10 HW, I run an application that queries Mysql/InnoDB and MyIsam tables, the queries are super fast,but some queires on Innodb ...
2
votes
2answers
57 views

MySQL server database log

I have a website with MySQL database. Someone deleted 1,000 records from a table. Is there any way to find out who have deleted the records and when from the website? And from where the records were ...