An open-source, relational database management system.

learn more… | top users | synonyms

1
vote
3answers
77 views

How can I upgrade MySQL in Debian using apt-get?

I'm using the Turnkey Linux virtual machine. The version of Debian in there is apparently on the "Wheezy" upgrade path (if that's what you call it). I'm not completely comfortable with Linux, as you ...
0
votes
1answer
22 views

Creating operating system (OS) user in Oracle LINUX

I am a user with sudo access. To install MySQL, I have to create an operating system (OS) user called MySQL. Can I create a user which also has sudo access on this machine?
0
votes
1answer
15 views

Installing multiple versions of MySQL on Oracle Linux

I have a Oracle Linux 5 server. I have to install MySQL 5.1 as well as MySQL 5.6. Is it possible to install both version of MySQL on the same machine? If yes, how can I achieve this?
2
votes
0answers
23 views

MySQL Database Charset

I have just migrated a MySQL database to a new server using mysqldump. The charset of database is normally UTF-8 and everything was working fine on the old server but when we switched over to new one, ...
1
vote
0answers
29 views

Restore deleted Mysql Directory in linux [duplicate]

My MySQL directory has been deleted from directory /root/var/ by mistake, we need to restore it, Is it possible ?
2
votes
1answer
39 views

cronjob for automatic DB backup to date prefixed file

I am using the latest Linux Mint. I was wondering if it's possible to create a special cronjob for a database backup. In my /etc/cronjob file I have the following code: # Minute Hour Day of ...
0
votes
0answers
14 views

Send data from file to rsyslog local0 facility

Is any possibility for logger to permanently get data from file - and send it to local0 facility? Why - I want to collect all data in database. For this - I'm use rsyslog-mysql. In it - I have ...
0
votes
3answers
44 views

Where Is MySQL installed on My Machine?

What is going on, everybody? Recently I have installed MySQL server on my Debian machine using Advanced Packaging Tool, and I am curious where it is installed and how I can find all the source files ...
0
votes
1answer
32 views

WordPress installation with Docker

I have to migrate my WordPress installation to my own server in order to get SSL working properly. (It was originally on GoDaddy shared hosting, which doesn't allow for external SSL cert ...
1
vote
1answer
44 views

how to check if mysql table is used or an application accesses the table in shell script?

A shell script is doing dump for a mysql table, but before dumping the table I want to check if this table is used by any other application. If so, I want to wait and enter in a loop until the ...
0
votes
0answers
28 views

mysqlcheck -o --all-databases does not finish [migrated]

I have a problem with my MySQL Databaseserver. I have many tables and there is quite some traffic going on there (around 4 connections per second). Since the phpMyAdmin advised me to do a OPTIMIZE ...
3
votes
0answers
42 views

Why does the php 'date' function returns a wrong time (off by ~24 seconds)? [migrated]

I have the following small php snippet running on a gentoo Linux (php version 5.2.10-pl0-gentoo): #!/usr/bin/php5 <? class TestDaemon { public function __construct(){ while (TRUE){ ...
0
votes
0answers
12 views

How to concatenate an echoed string to include literal single quotes around a value pulled from MySQL? [migrated]

I've run into a slight dilemma when I try to contain a value from an array of data pulled from MySQL inside single quotes. This would normally be a no brainer, but I run into issues since it's inside ...
0
votes
1answer
41 views

proftpd via mysql & web management of FTP users

I have installed prftpd and proftpd-mysql rpm on a linux machine. Intention is to have usermanagement of ftpusers via web. So I have installed proftpadmin from Here Now when I am adding the below ...
3
votes
1answer
27 views

How to interpret the following pattern of uptime data?

I have a small web server running mysql and wordpress which after a while appears to stop processing web requests. I can't even log into the server via ssh as ssh client times out when trying to ...
2
votes
2answers
42 views

Why does the root user have control over mysql directories but not show as a member of the mysql group?

Sorry if this is a duplicate. It seems somewhat similar to the question here but I think what I'm asking is a little different. I've got a CentOS 5.x box running with mysql on it. The root linux ...
0
votes
1answer
197 views

SMTP issues - unable to connect : CentOS 6.5, Postfix, Dovecot, MySQL

I'm trying to setup an email server on a CentOS system with Postfix, Dovecot and MySQL. I'm following this article for an Ubuntu system: ...
0
votes
3answers
37 views

mysqldump should prompt for password

When I'm executing mysqldump command from localhost or from remote host, it's not prompting me for password. I want the password prompt even though I'm running it from remote or from local. On my ...
0
votes
1answer
14 views

dovecot mysql-connection error because of special charater in config

I successful set up my Server with froxlor, etc. but now I get errros with my mail delivery Agent because I use a '#' in my mysql-pw. I tried to escape it with a '\' but it doens't seem to work. :( ...
1
vote
0answers
41 views

Linux Heartbeat options possibilities

I would like to understand if my below scenarios are possible in Heartbeat in Linux. Setup: Two Database Servers running Mysql in Active/Passive mode in replication mode having Heartbeat setup for ...
3
votes
1answer
65 views

MySQL server won't install to a new os (Debian, Ubuntu)

Today I wanted to install (on a new VPS with new OS) a MySQL server. I used this command: apt-get install mysql-server mysql-common mysql-client-5.5 I tried with Debian 7 (x64 and x86) and Ubuntu ...
1
vote
1answer
40 views

Can MySQL be malicious without PHP (or other language)?

I'm pretty sure the answer is "no", but who knows. Is a MySQL database able to initiate a communication with the server without any human action ? This server is disconnected from the exterior ...
1
vote
1answer
58 views

How to alter stored procedure in a MySQL database using the Linux command prompt?

I want to alter the stored procedure in my server machine. I'm uploading the codes via SSH Linux command prompt, I need to alter an existing stored procedure in my server. I don't have c-panel or ...
1
vote
1answer
83 views

Segmentation fault (core dumped) when try to run iptables rhel6

Im currently trying to set up a mySQL replication and i dont have a /etc/sysconfig/iptables. So I tried to install it with yum install. It showed the following output. Installed Packages Name ...
1
vote
2answers
36 views

Is it possible for a OpenVZ container to interact with a MySQL database on the host?

Say every container and the host itself has its own dedicated, external IP. Is it possible to do this without any problems? And is this really a good plan? Instead of hosting a database per ...
0
votes
1answer
46 views

Where does MySQL store its databases on Debian?

Our system crashed and we're trying to recover our data. The disc is fine, but the OS is gone, so I'm trying to get at the actual MySQL database files. Does anybody know where to look for them in a ...
2
votes
1answer
63 views

How do I avoid echoing password (two simultaneous prompts)?

The command I'm talking about is this: mysqldump -u root -p DB | mysql -u root -p DB2 And here's the output: Enter password: Enter password: MYPASS As far as I can tell, after I enter first ...
2
votes
1answer
67 views

Compile proftpd with MySQL authentication support on AIX

Edit 1: The problem seems to be related to MySQL component. because if I remove every SQL directives from config file, it does work on ftp/ftpes, sftp and ftps Edit 2: If I put an existing host ...
0
votes
1answer
54 views

why is my php script slower on debian than freebsd?

We moved a web-based application to a new server recently, but the new server seems to run slower than the old one. The old server was FreeBSD 7 with Apache 2.2, mod_php 5.3, and mySQL 5.1. The new ...
3
votes
2answers
664 views

Mysql query resultset in bash script

I am using the bash script to connect to the mysql database and execute a query. I use the below script to connect to the database and execute the query. #!/bin/bash Total_Results=$(mysql -h ...
0
votes
0answers
16 views

Removing SQL permissions in webmin

This may seem like a dumb question, but can anyone tell me how to remove permissions for MySQL users using webmin? I really can't figure it out.
0
votes
2answers
47 views

No package community-mysql-devel available

I'm trying to get this package because I need it to build software on CentOS 6, but I'm getting this error: No package community-mysql-devel available I'm logged in as root, using yum. Could it be ...
0
votes
1answer
79 views

Wordpress won't recognize the MySQL database

I want to install Wordpress on Archlinux but I have this error: Your PHP installation appears to be missing the MySQL extension which is required by WordPress. I un-commented this line in ...
1
vote
1answer
24 views

Mysql import the most recent file from a directory

I have a directory with daily backups of my entire MySQL database. I want to import the most recent backup into the database. I know to import a backup I need to use mysql -u root -ppasswordhere ...
14
votes
2answers
439 views

Will my MySQL query continue to run even if my ssh connection drops?

I've connected to a server over SSH and logged in to mysql, and asked it to run a query (the results of which are dumped into a CSV) that could take well over an hour. Although I have instructed my ...
1
vote
1answer
130 views

MySQL refuses to uninstall

apt-get remove mysql-server Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: ...
0
votes
0answers
33 views

Help required for LAMP Stack fail-over Configuration

I am using cloud servers of digital ocean for last some months. Recently One of my cloud servers disappeared from panel with backups @ ubiquity, the server co guys put it back after 1 day. However my ...
2
votes
1answer
1k views

Problem Starting MySQL on new Centos 6 build

I have a VPS with ChicagoVPS that's running Centos 6. Official version of the build is: Linux RedHat 6.5(Final 2.6.32-042stab078.26 x86_64) I followed this guide to add the repository and ...
1
vote
2answers
168 views

Running `sudo /sbin/service mysqld start` causes system to crash

OS: CentOS 5.10 Service: Amazon Web Services Attempted to remove MySQL 5.0 and install MySQL 5.6 I had a server set up, and was going to use MySQL, but it was was set up with MySQL 5.0. Since ...
3
votes
2answers
97 views

How can I monitor a file that fully recreates during its run?

This is a follow-up question of Why are some file changes not shown in tail -f? With the use of capital F: tail -F I can monitor the output of tail -F ~/.mysql_history from the manual: ...
3
votes
1answer
77 views

Why are some file changes not shown in tail -f?

I tried to follow the mysql history file with: tail -f ~/.mysql_history in another window I entered as the same user: mysql -u someotheruser -p and none of the following commands are shown in my ...
1
vote
2answers
68 views

How do I restore my MySQL databases that were dumped from phpMyAdmin?

I recently did a clean install of Linux Mint 16 Petra on my laptop. Before I wiped the old system, I did a backup of all my MySQL databases by going to the Export tab in phpMyAdmin and dumping all ...
2
votes
1answer
101 views

redirect error out to standard output

I can save the error out in the same file as standard out. I have used this method below. The problem is that the error out is "always" shown at the top. In the example given below the error relates ...
2
votes
1answer
335 views

MySQL permission denied error even after setting security context for SELinux on VM

I have MySQL installed on CentOS (detail versions given below). My OS is a VM machine and not a physical machine, the directory /data/mysql is a local disk (virtual). I suspect I might need to do some ...
0
votes
1answer
127 views

MySql not accessible by root user

I have a local MySql server. It is started as I can access it with my local user like $ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 66 Server version: ...
1
vote
1answer
628 views

OOM Killer - killed MySQL server

On one of our MySQL master, OOM Killer got invoked and killed MySQL server which lead to big outage. Following is the kernel log: [2006013.230723] mysqld invoked oom-killer: gfp_mask=0x201da, ...
0
votes
1answer
39 views

Getting Sublime + xDebug to work on Debian

I have been trying to get sublime and xdebug to work on debian, but have had no luck. I can't seem to find any debian specific guides. I have tried using the ubuntu based guides, but they don't work ...
0
votes
0answers
145 views

Sending emails from AutoMySQLBackup from Linux Mint

I have set AutoMySQLBackup on a Linux Mint machine and I want to have the backups sent to an email, but I cannot make it work. I'm new to Linux environment and don't understand it very much. I ...
4
votes
4answers
187 views

~/.mysql_history size limit

My .mysql_history file size is limited to 300 lines. I would like to keep the mysql history unlimited. However, I couldn't find any way to do it (in man page, and in google) Can somebody please ...
0
votes
2answers
547 views

Cannot apt-get - Package install issue

I was halfway through updating my machine when it crashed and I had to reboot. It was updating new packages while it crashed. When I try to use apt-get it always fails because of a mysql package. ...