An open-source, relational database management system.

learn more… | top users | synonyms

1
vote
1answer
68 views

Script not working but command works outside of script

I have a very simple script that basically runs a command and then emails the report to a user: #!/bin/bash FROMDATE=`date -d "last week 13:00 " '+%Y-%m-%d'` TODATE=`date '+%Y-%m-%d'` ...
1
vote
3answers
86 views

yum ignoring exclude directive in yum.conf

I need to hold back mysql from being updated in yum update. I added exclude=mysql* to /etc/yum.conf as below: [main] cachedir=/var/cache/yum/$basearch/$releasever keepcache=0 debuglevel=2 ...
0
votes
1answer
24 views

Security of password in a cron job on a VPS

I have a site hosted on a VPS and need to run a MySQL dump nightly. If I create the cron command: mysqldump -u user -ppassword database | gzip > /path/to/zip/file are there any security issues? ...
1
vote
1answer
27 views

Keeping services on EC2 alive

I'm using a MySQL database and Apache server with an AWS EC2 instance running AWS Linux. I start them both using the service command, but I am not familiar with any other tool that would come ...
0
votes
1answer
37 views

Split MySQL query into an [executional part] and a [MySQL command part]

Following mysql -u root -ppassword -D database -s -N -e "SELECT id FROM myTable" with special password and database is working fine. I want to split the code into two parts: Executional part: ...
1
vote
0answers
310 views

MySQL Daemon failed to start. Starting mysqld: [FAILED]

Help me! problem : sudo service mysqld start MySQL Daemon failed to start. Starting mysqld: [FAILED] vi /var/log/mysqld.log : 151015 05:46:26 mysqld_safe ...
0
votes
3answers
61 views

How to create a script to run mysql commands

Is it possible to use a shell script to run this following command? mysql -u user use mydb delete from mydata where row='xx'
2
votes
1answer
126 views

How do I create a SSH user that can only access MySQL?

I want to set up an SSH tunnel to my MySQL database on a remote server. Can I create an SSH user that has only the minimum permissions that are strictly necessary to access MySQL, for example with a ...
2
votes
1answer
89 views

MariaDB client has no prompt in Emacs sql-mode

I just upgraded from an old MySQL client to mariadb-clients-10.0.21-3 on Arch Linux. After the upgrade, I no longer see a prompt when using Emacs's sql-mysql function. It seems mysql is buffering ...
1
vote
0answers
149 views

OpenSuse 13.2 mysql-workbench refuses to start

After running an zypper up mysql-workbench is broken. I get this error when trying to start it from CLI /usr/lib64/mysql-workbench/mysql-workbench-bin: symbol lookup error: ...
1
vote
1answer
332 views

How to compress a mysql dump using 7z via a pipe?

I've been attempting to compress my mysqldump output via 7z using the pipe operator (I have seen this question, but its answer uses xz not 7z). This is what I have tried so far: mysqldump -u root -p ...
0
votes
1answer
305 views

mysql result to bash variable

My script is like this: #!/bin/bash mysql dbname -N -uroot -p -hhost -se "SELECT COUNTRY, COUNTRY_NAME FROM server ORDER BY COUNTRY" output=$(mysql dbname -N -uroot -p -hhost -se "SELECT COUNTRY, ...
0
votes
0answers
29 views

SSL/Secure MySQL access with Postfix/Dovecot Mail Server

I have two MySQL servers setup, one in each data center in the US. The east coast db is the master and replicates to the west coast slave db over SSL. When I try to connect my mail server to the ...
1
vote
2answers
104 views

MySQLdump via crontab - Pass --password=/hashed/password/file so I can use via crontab w/o using plain text password

So I'm setting up a WordPress backup guide/making a backup schedule for myself for real. I want to do MySQL dumps daily, but the command either requires -p then user input or ...
0
votes
1answer
143 views

Can't find job mysql on crouton, ubuntu precise

I'm using Ubuntu precise as chroot in my chromebook machine. I'm trying to install mysql through apt-get install mysql-server. The thing is, when I try to start it, it can't find the job: ...
4
votes
1answer
273 views

forward all mysql traffic to a ssh tunnel

I have a local application that needs to connect to a remote mysql server at 40.40.40.40:3306 The main firewall blocks all connections but ssh, I can set up a ssh tunnel and connect to the server ...
0
votes
1answer
88 views

Why is the config file in /etc/munin/plugin-conf.d/ ignored?

I have a Munin script /etc/munin/plugins/mysql_replag that queries a MySQL server to check the status of a master-slave replication: #!/bin/sh # Plugin to monitor the Seconds_Behind_Master of ...
0
votes
1answer
35 views

Does MySQL processes run in user or kernel modes?

I try to count IOPS and I/O size with SystemTap script and use MySQL to be workload. I found mysqld doesn't call systemcall but mysqld has read/write on VFS. So, do MySQL processes run in user or ...
1
vote
0answers
90 views

what is the correct regexp for mysql filter in fail2ban?

I use the default filter file /etc/fail2ban/filter.d/mysqld-auth.conf for fail2ban service. But there are some errors in file /var/log/fail2ban.log as: Found a match for '150815 10:42:54 [Warning] ...
1
vote
0answers
48 views

How Remove permission denied with GRANT USAGE ON mysql

I have a mail server in my ubuntu instance. I have a webserver management FROXLOR and i recieve errors for access denied when i try to login in mail account. The log for this: Aug 16 03:14:33 email ...
1
vote
0answers
20 views

mysqld stops right after starting because of corrupted tables (disk full + hardware reboot) - how to fix it?

I'm dumb, I did the stupidest thing I could. On one of my servers, the SSD was full and I wasn't aware of it. The high-traffic website became working really slow, then started displaying errors, ...
0
votes
0answers
17 views

How to monitor mysql percentage disk utilization?

I am new to mysql world and not sure if there is a way to calculate mysql TableSpace/DiskSpace utilization in percentage. I am aware mysql does not provide upper limit or free space like Oracle DB, ...
0
votes
1answer
47 views

Can't install MySQL client libraries on Gentoo

I'm new in Gentoo. I'm trying get the mysql2 gem installed. But it's stuck. I found out that I need MySQL client libraries. I tried: emerge dev-db/mysql:minimal * IMPORTANT: 2 news items need ...
3
votes
2answers
329 views

Apt-get hangs on “Setting up mysql-server-5.5 (5.5.44-0+deb8u1)”

I'm on Debian 8 (stable) (Linux zenbook 3.16.0-4-amd64 #1 SMP Debian 3.16.7-ckt11-1 (2015-05-24) x86_64 GNU/Linux) and tried to apt-get update && apt-get upgrade yesterday. There was an ...
1
vote
0answers
144 views

MySQL update failed (debian)

I have problem updating MySQL server (pkg mysql-server5.5) MySQL server "can't stop" [FAIL] Stopping MySQL database server: mysqld failed! invoke-rc.d: initscript mysql, action "stop" failed. dpkg: ...
0
votes
0answers
20 views

Does postfix support MySQL connections over SSL

I have a postfix server and a MySQL database server. I setup MySQL SSL and have it working successfully. I can connect from postfix to mysql with the user requiring SSL. The problem I have is, when I ...
0
votes
1answer
1k views

Getting Minor Version Mismatch Error with Php and Mysql

I randomly started getting this error when trying to instantiate a new mysqli instance in php script: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50541 ...
2
votes
3answers
210 views

Shell script executed with cron results in different size file than executed manually

I have a RHEL server that I am running a MySQL database on. I have a Bash script that executes mysqldump that creates a backup file. The backup file created when executing the script directly in ...
1
vote
3answers
220 views

Check services running on the server and restart them if they have stopped?

I am trying to write a python script which shows me the services which are running on my server. The thing is that mongodb keeps going down on the server and each time it happens I have to manually ...
0
votes
3answers
77 views

prevent repeated emails via bash to overquote user

I need some help to improve the idea/implementation.Scenario is local mini ISP. users accounts are stored in freeradius/mysql. The task is to send user email who have consumed 80% of there assigned ...
0
votes
0answers
70 views

Is my Nginx,php-fpm and mysql config good enough?

My Setup: Intel(R) Xeon(R) CPU E5-2680 v3 @ 2.50GH 30 GB Ram 1 Gbps Premimum/Dedicated Line Softwares3 MariaDB 10.0.20 NGinx 1.8.0 PHP with FPM 5.6.8 Our servers gets a LOT of requests (more ...
0
votes
0answers
20 views

MySQL won't start at boot with bind-address set to IP [duplicate]

When I set the bind-address to the IP of the RPi, it will not start at boot. It will only work if I set the bind-address to '127.0.0.1', 'localhost' or 0.0.0.0. The syslog provides the following ...
1
vote
0answers
214 views

Unable to install mysql-server-5.6

My website was running fine on server version 5.5, but now it hangs on the installation of version 5.6. I've tried removing it, purging it, even removing the /etc/mysql folder, then reinstalling it ...
0
votes
2answers
389 views

Cannot Access LAMP Web Server on Ubuntu Server 14.04

UPDATE: So it seems that I can access the website from computers outside of the LAN, it's when I try to pull up from any computer on the same LAN as the server that I get an issue. From what I've read ...
0
votes
0answers
84 views

Uninstall MySQL without removing HHVM on Laravel Forge / Ubuntu 14.04

Since I maintain database and web servers separatly, I wanted to have my Forge's maintained web server without mysql, as it tend to use a lot of memory, even if I don't use it. Trying to run a sudo ...
3
votes
1answer
401 views

Add 30 days in date

Using bash or mysql , how can I add 30 days in user expiry table? Example I have DB name USERS and table expiry like this: USERNAME EXPIRATION JOHN 2015-09-26 I want the command to take ...
3
votes
3answers
453 views

Using `nohup` to Import MySQL Dump on Debian Server

I am trying to import a mysqldump file into my mysql database, but my (putty) connection to the server keeps timing out halfway through. I tried to use nohup . . . . & but this doesn't appear to ...
0
votes
1answer
113 views

How can I uninstall MySQL if I have compiled it from source?

I'm trying to uninstall MySQL but when I get inside the directory and type make uninstall It get: make: *** No rule to make target `uninstall'. Stop. I've read that I have to delete all ...
0
votes
1answer
764 views

PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/php_mysql.so'

I am running PHP 5.6 on Linux. When I try to load a PHP page, I'm getting the following PHP error. PHP Startup: Unable to load dynamic library /usr/lib64/php/modules/php_mysql.so' When I look ...
2
votes
1answer
3k views

unable to launch mysqld in arch linux

I have recently installed Arch Linux x64 and I wanted to install the LAMP stack. Everything worked fine, until I arrived to the MySQL part that I installed but can't launch. The output of sudo ...
0
votes
1answer
27 views

Getting the log from MySQL into a file when running MySQL commands from the command line

I am trying to get the log from MySQL into a file when executing a script from the command line. For example mysql -v mydb u- alex -p**** < please_run_me.sql > /tmp/file.log Now, the work ...
0
votes
2answers
169 views

Ubuntu mysql reinstall service status not working

I tried to reinstall my mysql server on ubuntu 14. After reinstall all seems to run fun until the service mysql status/start/stop command When the server is started the mysql status is stop/waiting ...
0
votes
1answer
67 views

Linux Swap Space

I have 32GB memory. SSD and NonSSD drives. I installed Linux to NonSSD drive but I prefer SSD for /var directory and I didn't create swap space because there is high memory. I know physical memory ...
0
votes
1answer
16 views

Transfer Schema and Rebuild Databse on Another Server

I have made a number of changes to the database schema on my development including the addition of new tables and changes to others. Is there an easy way to transfer this schema to the server, build ...
4
votes
1answer
304 views

The file /usr/libexec/mysqld does not exist or is not executable

Whenever I try to start MySQL via the command service mysqld start I get the following error: MySQL Daemon failed to start. Starting mysqld: [FAILED] ...
-2
votes
1answer
141 views

linux shell command in Perl program

Hi friends here is some issue I want to write a script that restarts server which is in stopped status. Here I am using my MySQL server in future if it is in stopped status then it will be restarted ...
0
votes
1answer
95 views

Can't start mysqld (mariadb) on Fedora, if put a backup into /var/lib/mysql

After some terrible actions, I had to reinstall my Fedora (was 20, became 22). Unfortunately, I was unable to made mysqldump, so I backuped /var/lib/mysql folder. Now, I'm trying to put in on the ...
3
votes
0answers
1k views

How can I fully remove a tablespace from MySQL?

I have a MySQL database called camera_main_live, which I administer using Adminer. It is, to all appearance, empty. So when I want to add some content, I begin by running this script (with Adminer set ...
0
votes
1answer
215 views

Export mysql to remote server using one SSH session

I've come across a situation where I had to create a utilitary shell script that would be executed in many servers from different regions. The objective is to dump the local mysql database, copy it to ...
0
votes
0answers
39 views

Strange MySQL with WHM connection issue

I am not really the best way to explain this except state exactly what happened and my basic configuration. I have 1 VPS on Rackspace that has WHM installed on it. This has 3 sites/accounts, that ...