MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

1
vote
1answer
15 views

Getting no query results in email

This is the powershell script below. I am trying to export the query's results into email body. However, the email contains nothing except the table headers. Could anyone help out what could be wrong ...
-2
votes
0answers
15 views

INNODB failure in MYSQL

I had faced an issue in INNODB Engine, but it get solved, when added buffer memory in /etc/my.cnf file, but there happened an unusual thing that the .HTACCESS file of some domains get modified as the ...
0
votes
1answer
25 views

CRUD with MySQL Master-Slave Architecture

I have setup mysql master-slave replication with 1 master and 3 slaves. Now that I have finished setting up the architecture I am curious as to the best way to make my reads. I realize all writes, ...
1
vote
1answer
11 views

Size of MYI index smaller on slave server

I've recently altered a huge MyISAM table (80 million entries) by adding a new value in an enum field. After I did this I've checked the health of the table on 2 slave servers which are used to ...
-3
votes
0answers
36 views

mysqli phpmyadmin Seems to be something going on here [on hold]

Oddly I can find no help with this issue. I have a developer here who wants to use phpmyadmin. So I set it up on our server and get some errrors. I updated everything I get some errors. I swear some, ...
0
votes
0answers
16 views

How to recover MySQL database on xampp/windows using ib/frm files? [migrated]

I'm using xampp on Windows 7. Couple of tables of my Wordpress database got corrupted. When I view the database in phpmyadmin, the tables have the message "in use". I tried ...
0
votes
1answer
17 views

What is safe way to stop mysql docker container?

I run mysql container using Docker. I start it with like sudo docker -d --name mysql -p 3306:3306 -v /var/lib/mysql:/var/lib/mysql mysql_image I suspect that stopping mysql by stopping docker is ...
-1
votes
2answers
49 views

Data lost in MySQL DB when roll back happened after system restart [on hold]

Few days back due to electricity outage, client's system got restarted, resulted in DB rollback. But due to this roll back, we lost around 2k existing records from various tables.( which were already ...
0
votes
0answers
7 views

How to modify the below script to take tables and its sizes for a particular databse to send via mail to a recipient? [migrated]

SELECT top 10 t.NAME AS TableName, (SUM(a.total_pages) * 8)/1024.0/1024.0 AS TotalSpaceGB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN ...
1
vote
2answers
63 views

MySQL with bind-address - possible to create an ip exception?

If you set the bind-address to 127.0.0.1 in my.cnf is there any way to manually allow connections from a specific ip address? Mostly my database is accessed by the server it is hosted on, but I also ...
0
votes
0answers
11 views

Cisco CallManager AXL SQL Toolkit - Retrieve directory number and user ID

I have the below SQL query to retrieve the list of userid and their telephonenumber using Cisco CallManager AXL SQL Toolkit: sql query="select d.name as deviceName, e.userid, e.telephonenumber from ...
0
votes
0answers
2 views

Linked Server Mysql to SQL Server 2008 32-Bit

I have an SQL Server 2008 64 Bit and a Mysql-Server, and would like to use a Linked Server. However I need the 32-BIT Mysql ODBC Connector for an extern Application. When I would like to connect to ...
0
votes
0answers
5 views

How to report durations of 100+ queries in MySQL? [migrated]

I have list of 142 SQL queries in an .sql file. At the beginning of this file I put SET profiling = 1;. At the end SHOW PROFILES;. I execute it with: mysql -u root live_copy < ...
1
vote
0answers
25 views

Apache 2.4 prefork, MySQL 5.6 and 2GB RAM

I think I'm having problem setting up Apache24 correctly. Apache seems to taking up to much RAM, and I'm not sure how to configure it. The FreeBSD server is using 50% of it's swap space. We are ...
0
votes
0answers
14 views

hosting mysql server on windows server on azure [closed]

i'm hosting my website and my client websites on windows azure. now my problem is windows azure provide mysql and even they only provide 1 database from cleardb only with 20mb. all my client sites are ...
0
votes
0answers
18 views

Copy mysql frm files to new server

I've read different tutorials about how to restore mysql databases by the .frm files but I am not getting it done. What I did, I created a new database by phpmyadmin. Copied the old directory from ...
1
vote
0answers
24 views

MariaDB 5.5 on Slackware 14 need to change to new password format

Strangely, this worked fine for a while, but my computer rebooted recently and now my php apps won't work: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an ...
0
votes
0answers
13 views

Google Cloud SQL - Lost connection and Timeout errors

I keep getting the following errors when attempting a simple connection to a Google Cloud SQL database instance from a PHP script. Lost connection to MySQL server at 'reading initial communication ...
1
vote
1answer
23 views

why is my mysql-proxy always doing selects on master?

My selects are always going to master and if i stop master I got some 'Cannot connect, all backends are down.' [read_query] 89.216.31.228:64166 current backend = 0 client default db = nivo client ...
3
votes
1answer
23 views

Is it possible to install MySQL extensions on Amazon RDS?

We are about to migrate our existing system from local MySQL instances on the same EC2 to a proper remote Amazon-RDS. Unfortunately there is a functionality called Median that MySQL is missing. Our ...
-1
votes
0answers
8 views

Mariadb refusing to read values on the my.cnf file [migrated]

today i was optimizing my mariadb since my website was running too slow My machine is a Centos 7 , 4 gbs ram 3 cpu i runned a script called mysql_tuner.pl and the results were: -- MYSQL ...
0
votes
1answer
16 views

How do I find out when a MySQL root password was last changed?

I have looked for solutions to this. I am able to change it, but I need to find out when it was last done and preferably also seeing who was logged in when it was done. Need proof for a security ...
0
votes
0answers
11 views

Why has MariaDB created database directories with @ in?

A backup script on a Debian server looked at /var/lib/mysql/*/ to find local database names. Having recently installed Seafile, this no longer works because although the databases are called normal ...
-1
votes
0answers
17 views

Can't create thread to kill server (errno= 11)

I can't restart mysql service. I got the following error: [ERROR] Can't create thread to kill server (errno= 11) Any idea what causes the error? Im using CentOS 6.6.
-1
votes
0answers
28 views

Can not start mysql server

After some messing around with mysql files and removing a lot of them, I just installed mysql-server as follows: root@server:/var/lib/mysql# aptitude install mysql-server The following NEW packages ...
0
votes
1answer
36 views

How to remove MySQL from Ubuntu 14.04?

I tried to move my datadir on a working MySql install, which apparently I messed up. I have tried to uninstall / reinstall numerous times, only to get the same errors on reinstall. The ...
1
vote
1answer
50 views

ISPconfig / Dovecot - Mysql went down = Mails gone?

So im running ISPconfig with Dovecot as mail-server (storing mails via mysql). Yesterday i made some changes to the mysql-config. I wanted the server to answer also External Requests. The Problem ...
1
vote
0answers
21 views

enable logging of password-like patterns in mysql client history [migrated]

From MySQL 5.6.8 onwards, statements containing the pattern *PASSWORD* or *IDENTIFIED* are not logged in the mysql command line client history. I know I can add to this list with --histignore or ...
1
vote
0answers
13 views

Destination Host Unreachable and Communications link failure when I connect to MySQL database using D2RQ library

I have a question: I have a web service which runs on a virtual machine located on a remote server with Ubuntu 12.04 operating system. Now, I want to test this Web Service and I'm using this code ...
0
votes
0answers
26 views

Local MySQL connection using eth0 rather than lo loopback

We've installed MySQL 5.6.22 on RHEL6.6 and noticed terrible performance compared to a previous install on RHEL6.5 and MySQL 5.6.20 The main thing that we've noticed is that all the traffic appears ...
-2
votes
2answers
31 views

How to start mysql automatically if that stop for any reason? [closed]

I have a digitalocean ubuntu vps for development use only, But sometimes the mysql server stop working. As per my investigation I don't have enough memory to handle few laravel installation. As I use ...
-1
votes
0answers
28 views

mysqld is generating a lot of disk IO writes. How can I figure out why? [migrated]

I have a Ubuntu 14.04 server running half a dozen wordpress sites. Total traffic to the server is on the order of 30k page views a day. Over the past couple months, with page views and network ...
0
votes
1answer
27 views

how to permanently increase innodb_buffer_pool_size on ubuntu

I have read lot of posts & manuals to try to find out how to increase memory in mysql 5.6 on Ubuntu, which say there are 3 methods: by editing innodb_buffer_pool_size in the my.cnf by command ...
0
votes
1answer
45 views

Two browser windows hitting same MySQL app, both can't run at the same time

I have a LAMP web application that has some pages that do quite a bit of processing and take a while to complete. Sometimes as the developer I like to do two things at once as I'm working on a ...
5
votes
1answer
269 views

Can I copy the entire /var/lib/mysql folder to a different server? (mysql vs mariadb, different versions)

I used to have a Linux system (LMDE) with MySQL. The system used innodb_file_per_table for most of the databases. (not sure about the version, whatever is the "latest" in LMDE) I am now on a new ...
-1
votes
2answers
46 views

Configure MySQL so it doesn't automatically change values in NOT NULL columns

Surprisingly (at least to me), the following queries will insert records. CREATE TABLE null_1 ( id INT NOT NULL, text1 VARCHAR(32) NOT NULL, text2 VARCHAR(32) NOT NULL DEFAULT 'foo' ); INSERT ...
0
votes
0answers
19 views

Database Organizational Structure, DB Groups

I'm setting up a web server where users can create their own databases. In order to prevent name clashing, I've typically seen hosting companies handle this by prefixing any DB name the user creates ...
3
votes
1answer
58 views

How can I drop a MySQL user whose username contains unprintable characters?

I have a user in MySQL 5.6 that was somehow created with a non-printable character in the username. How can I drop this user? mysql> select user,host from mysql.user where user like 'wiki%'; ...
0
votes
1answer
26 views

Force a connect to mysql

My Mysql server instance has crashed (I assume its been 10 hours and its not running) - I have tried show full processlist but the new connection can't connect. I've tried using mysqladmin and that ...
0
votes
1answer
14 views

Lowering MySQL Full Text Word Length

Hello I just installed MySQL 5.6 on my vps and I realized numbers were not searching in full text searches. Then I came across this article ...
-1
votes
1answer
37 views

MySQL recovery procedure [closed]

After the server die, I have "old" HD (it is external now) with sock file and data files in mysql directory. Where I should find information how to restore the data in fresh installed MySQL? What ...
0
votes
1answer
29 views

MySQL connections peak right after restart

I have a fairly busy server, with about 200 qps and a read/write ratio of about 10, running on MySQL 5.1.73 64bit on CentOs 6.6 Most aspects are optimized, however, whenever i restart mysql, it goes ...
0
votes
0answers
4 views

Local MySQL instance running extremely slow compared to remote version [migrated]

I posted here, on ServerFault, because make more sense over StackOverflow. The code below is just to show that my MySQL function is very simple, I think. I'm working on a local project and it have a ...
0
votes
1answer
66 views

Suddenly mysql/mariadb won't start

Suddenly, after simply adding a few tables to database within the install... the service won't start. Any help welcome. systemctl start mariadb Job for mariadb.service failed. See 'systemctl status ...
0
votes
0answers
15 views

Is this normal binary logging behaviour - maintaining one ever growing file despite expire_logs_days? [migrated]

I have a Percona MySQL DB running on a dedicated server. I have in my.cnf # REPLICATION # log_bin=/var/lib/mysql/binlogs/mysql-bin expire_logs_days=7 My issue is that the log file mysql-bin.000001 ...
0
votes
0answers
32 views

MySQL allows zero date(0000-00-00 00:00:00) after I enabled strict mode

I want to configure a MySQL db instance not to accept zero dates(0000-00-00 00:00:00) because the software running on top of it fails to run if it encounters such a field. The server is running ...
0
votes
1answer
24 views

Salvaging inaccessible MySQL db without InnoDB log files

In the past few weeks, I have been playing with the configuration of our test MySQL server, without first making a mysqldump of applications running on it. Aim was to increase performance and enable ...
-2
votes
1answer
44 views

PHP website grinds to halt for an hour, then runs fine…how to debug?

I have a PHP website which uses $_SESSION variables. It runs on Apache, Mysql and Ubuntu 14.04 on a very resourceful server (Amazon EC2 - M3.X-large) For some unknown reason, the website virtually ...
0
votes
0answers
9 views

Side effect of warning ip address could not be resolved name or service not known mysql [duplicate]

I setup Master Slave replication on two servers. It is working fine. But when I was reading error logs I found out the following warning - warning ip address could not be resolved name or service not ...
1
vote
0answers
20 views

Timed windows server event to prepare csv file for third party FTP collection

I hope this is posted in the correct forum. I have a Windows 2008R2 web server that runs MySQL. I need to execute a SQL script against the mysql database to create a CSV file, and save to a defined ...