MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
77 views

Fix PHP error Invalid argument supplied for foreach() after update PHP & Mysql

I have updated PHP from 5.3 version to PHP 5.6.21 (mod_fcgid) on my CentOs 6.5 vps. The vps holds 4 Prestashop and almost works but cart doesn't work as expected. The php error log contains this ...
0
votes
0answers
31 views

InnoDB table takes more than 1 second for insert query

during an insertion it takes about an second for sometimes (not always) in MySQL 5.6.17-log which is causing performance issue How to over come this issue current set of parameters for innodb ...
0
votes
0answers
39 views

Laravel real time data add and send update from mysql

I have been developing a system which is on laravel, i need a few knowledge on technology i am not sure of which should i follow. On my laravel i have an end point link which hits whenever someone ...
0
votes
0answers
12 views

How to restore mySQL slave server that is lagging behind in transactions

I recently setup replication between two servers for the purpose of facilitating a fail-over scenario between the master and the slave. I'm using the mySQL utilities fail-over utility and it was ...
0
votes
1answer
60 views

How to import large mysql database (innodb , myisam tables) to MySQL NDB cluster

Mysqlcluster used:- GA 7.4, Centos 7 I have 30GB each physical memory in 2 datanodes and SSD 200GB each but the database size(cumulative size of multiple db's belonging to free radius ) is around ...
-1
votes
1answer
340 views

Freshly installed MySQL server 5.7.12 fails to start on FreeBSD 10.3

root@w:/var/db # pkg install mysql57-server mysql57-client Updating FreeBSD repository catalogue... FreeBSD repository is up-to-date. All repositories are up-to-date. Checking integrity... done (0 ...
-3
votes
2answers
75 views

High CPU load of my VPS [closed]

I use VPS from digitalocean. The configuration is: 8GB RAM, 4 Core Processor, 80GB SSD with cpanel installed. Most visitors are in the site http://www.secretdiarybd.com/bn . Which is on wordpress ...
0
votes
0answers
9 views

courier-authlib not connecting on Gentoo

I may have 2 issues, or miss reading one. logs: May 15 11:17:17 r2d2 authdaemond[26904]: Installation complete: authpipe May 15 11:17:30 r2d2 postfix/smtpd[26986]: sql auxprop plugin using mysql ...
0
votes
1answer
24 views

Connection between sql workbech on my Laptop and Mysql on Google cloud compute engine (not cloud sql)

Is there anyway to open a port 3306 between MySQL database running on compute engine in google cloud (not cloud SQL) and MySQL workbench running on your local machine to connect ? I was able to ...
19
votes
4answers
6k views

Why not use a WAMP stack?

I recently had a talk with some experienced people and they suggested to me not to use a WAMP stack, and instead install apache, mysql and php separately. I don't understand why they have suggested ...
0
votes
1answer
204 views

SugarCRM CE 6.5.20 Ubuntu 14.04 MySQL “Cannot Load DB Manager”

I am currently following the installation wizard for the SugarCRM Community addition. I am now on the step where I link to the MySQL database that I have set up on my Ubuntu server. However I am ...
21
votes
7answers
15k views

MySQL InnoDB - innodb_file_per_table cons?

By default MySQL InnoDB stores all tables of all DBs in one global file. You can change this by setting innodb_file_per_table in the config, which then creates one data file for each table. I am ...
1
vote
2answers
200 views

Yum dependency available but not marked for install

I'm trying to install a specific version of MySQL: mysql-community-server-5.6.29-2.el6 on RedHat 6.6. When I run yum install, I get dependency errors, but the dependencies are clearly available. I'm ...
0
votes
0answers
26 views

Run mysql-workbench remotely, no proxy/or tunnel

We are on AWS, with a MySql RDS. The RDS is set up so that only clients that are on the VPC can access it. (Just being VPN'd in is not good enough) So I assume that I could set up a tunnel,proxy, ...
0
votes
1answer
26 views

Setup MySQL replication of specific tables of a database to another mysql server

I have several production MySQL databases running on an RHCS cluster. I want to setup replication of one specific database, with only specific tables from that database, to another brand new mysql ...
0
votes
1answer
349 views

Having trouble installing MySQL Community Server on new RHEL 6.8 instance

I'm having trouble installing MySQL 5.7.12 on RHEL 6.8. The first RPM I downloaded was for RHEL 7.0. This is a brand new instance, and I stupidly assumed it would be RHEL 7. It's not. So my ...
0
votes
2answers
37 views

Recovering an EC2 instance

I was running an ubuntu EC2 instance for about an year and I lost SSH connectivity to it after installing the latest updates. I was running a Rails application with automated capistrano deployment ...
0
votes
1answer
13 views

Selectively restore specific databases from a complete mysqldump

I have multiple Wordpress databases stored on a VPS. I am using the following command to back them up: # mysqldump -u root -p password --all-databases > /tmp/all-database.sql This creates a ...
0
votes
1answer
17 views

MySQL long_query_time Seems to be Ignored

I added the following to MySQL config file... slow_query_log=1 log_queries_not_using_indexes=1 long_query_time=1 slow_query_log_file='slow_queries.log' So why would the log file contain entries ...
1
vote
1answer
628 views

Can't restart mysql from cron job

I have a problem where MySQL (running on Ubuntu 12.04 with all latest updates) dies after a few days so put this script into a cron job that runs as root every 60 seconds. Everything works except ...
0
votes
1answer
23 views

MySQL processes gets killed after 900 seconds

I hope this is the right place to ask.. I am facing a strange issue where the connection to the mariadb server gets terminated after a certain time. Like I am trying to connect to the mariadb server ...
6
votes
3answers
8k views

MySQL access denied error when connecting via SSH tunnel

For months I've been connecting to the MySQL instance running on our local test server through an SSH tunnel without any issues. All of sudden though, with no changes I can think of, the server has ...
11
votes
6answers
18k views

Where does MySQL store its database files on OS X?

As I would like to move those files from one server to another server, while the database is offline.
0
votes
1answer
120 views

ownCloud Unable to Connect to Local Database on Fedora 23 (LEMP stack, selinux permissive)

The Problem I am having a very strange issue where ownCloud seems unable to access my SQL database, using nginx, mariadb, and php-fpm running on Fedora 23. When I attempt to access the page, I get ...
2
votes
4answers
478 views

CentOS installing MySQL 5.6.26

My server is CentOS 6.7 x86_64. I installed mysql by yum -y install mysql-server. But this install v5.1.73. Installed: mysql-server.x86_64 0:5.1.73-5.el6_6 Dependency Installed: mysql.x86_64 0:5....
0
votes
2answers
24 views

MariaDB taking ages to restore backup

So I did a mysqldump of a pretty huge db and I'm trying to restore it now using: mysql db_test < db_test.sql but it looks like it's not gonna end by the end of this year. It's been about an hour ...
0
votes
0answers
36 views

How can I add SHA512-CRYPT support to SOGo 2.3.10?

I am trying to connect SOGo to an existing Dovecot/Postfix setup (trusty tahr) with a MySQL backend. I established the connection and so far everything seems to work except the login part since the ...
1
vote
3answers
149 views

Database select error

Database select error its my problem and when I restart my mysql to fix this error this problem solve but after 30 minutes or after hours again this error happen again. I put link here screenshot ...
1
vote
1answer
59 views

Connecting to MySQL is taking a long time

Here is a normal client side sending an AJAX request to the server, without using any libraries. About The Database: There is only 1 table in the DB having 2 columns and 2 rows. The Storage Engine ...
0
votes
1answer
26 views

What to use as DB Host when installing WordPress?

I am aware of how daft this question seems. I am installing WordPress on two load balanced servers (hardware load balancer), with MySQL set up in Master-Master configuration with an installation on ...
0
votes
1answer
31 views

MYSQL datadir renames itself after rebooting server

I've mounted MySQL datadir to separate disk due to space constraint in the Redhat server. The problem occurs whenever I rebooted my Server. After the reboot, the existing MySQL datadir i.e., Mysqldata ...
2
votes
4answers
15k views

How do I dump view schemas for a MySQL database?

I have a MySQL database for which I wish to dump schemas for views. How do I do this? I tried mysqldump with --no-data, but that only dumps table schemas.
3
votes
8answers
7k views

MySQL where's the my.cnf path?

I've managed to locate my install directory for MySQL: /usr/local/mysql/ Where can I find the path to my.cnf to know where I should configure the server? I've tried creating a /etc/my.cnf(as shown ...
0
votes
0answers
11 views

How do I get to write exim delivery result in mysql

Good evening. I have such a scheme. The main server and multiple mail servers. Each mail server installed exim is realized through sending phpmailer. Logs are parsed delivery in php and then recorded ...
1
vote
0answers
57 views

PHPmyadmin Login without a password is forbidden by configuration even when entering password

Basically it is all in title. I did a clean install of CentOS7.2 (needed CentOS7 for running ARK). I made a LAMP server and it is working with tests, and then I installed PHPmyadmin. Whenever I try to ...
1
vote
1answer
127 views

mariadb mysql parallel installation apache and php

I'm trying to install mysql and mariadb on the same server as a parallel installation, each service on a different port. I installed mysql server using apt-get on a debian-based distro and then ...
0
votes
1answer
108 views

Munin and mysql plugin

I've installed munin on a vps and I want to monitor mysql usage of 3 mysql servers, I have configured mysql_ plugin as follow: [mysql_*] env.mysqlconnection DBI:mysql:mysql;host=mysql1.neocrafters....
1
vote
1answer
73 views

“Committed Bytes In Use” is high when there are plenty of “Available Bytes”

My windows computer keeps showing low on memory message so I used performance monitor to check memory status. The results are: Commit Limit: 25,758,334,976 (bytes) Committed Bytes: ...
0
votes
0answers
94 views

Backup MySQL with LVM, questions about the MySQL Session

I want backup my mysql database with lvm. I will do the backup with cronjob. Here the pseudocode Open mysql session Run SQL FLUSH TABLES WITH READ LOCK Do backup lvcreate -l100%FREE -s -n mysql-...
1
vote
0answers
35 views

MySQL on Ubuntu. 10061 error on 3306

A fresh install of Ubuntu inside of a Virtualbox with LAMP option selected. I am unable to connect to the server via telnet on this port or via ODBC from my host machine. I can ping and SSH both ...
0
votes
1answer
121 views

Mysql conflicts on Centos 6.7

I am trying trying to install RMySQL on Centos 6.7 however I am not very experienced with server stuff so bear with me. I use this command sudo yum install mysql-devel However I keep getting the ...
15
votes
4answers
51k views

No mysqld or mysql.server after mariadb-server install

So... likely I'm an idiot, but I'm stuck. I just set up a CentOS 7 on Digial Ocean and I can't seem to get the MariaDB/MySQL server running. Some output [root@hostname ~]# yum list installed |grep ...
0
votes
0answers
18 views

Unable to install php5-mysql on Ubuntu 14.04

When I'm trying to install php5-mysql on my local PC with Ubuntu version: # cat /etc/*-release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=14.04 DISTRIB_CODENAME=trusty DISTRIB_DESCRIPTION="Ubuntu 14.04.4 LTS" ...
0
votes
1answer
46 views

Dovecot quota clone

I'm trying to use dovecot's quotas and share them via mysql with modoboa. I'm using the count module for that: http://wiki2.dovecot.org/Quota/Count To share the quota I'm trying to implement the new ...
0
votes
0answers
29 views

Configure auth with MySQL in Apache 2.22

I've got a raspberry pi 1 which serves web pages using apache 2.22. I've done some research and I found a way to secure "pages" using a database (mysql in this case). I've found this little guide to ...
0
votes
2answers
62 views

iptables - access to port 3306 timeout

I cannot connect to mysql from a remote server. I have bind-address commented out but when I add rules in iptables to block other connections the requesting server's connection times out. I tried ...
3
votes
0answers
52 views

When configuring rsyslog to log to mysql DB, what is purpose of SystemEventsProperties table?

I've configured rsyslog on my servers to log to a remote mysql DB. I did this essentially by following the rsyslog wiki and it essentially creates two tables: mysql> show tables; +----------------...
1
vote
1answer
55 views

MySQL server experiencing high stress/max connections

The Short: We're hitting max connections and seeing very poor performance from MySQL during peak business hours and cannot determine if it is a load problem or a configuration problem. The Long: To ...
3
votes
1answer
3k views

InnoDB “log sequence in the future!” crashing, won't start

I stopped mysql only to find that it wouldn't come back up, /etc/init.d/mysql start only outputs . . . . . . failed. I've narrowed it down to an issue with InnoDB. The database starts when ...
0
votes
0answers
187 views

--secure-file-priv Causes MySQL to not Accept LOAD DATA INFILE since Update

After upgrading from mysql 5.6 to mysql 5.7 (due to update from Ubuntu 15.10 to Ubuntu 16.04 and using purge before, because of a bug in the update: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/...