An open-source, relational database management system.

learn more… | top users | synonyms

3
votes
1answer
287 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
38 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
15 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
73 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 ...
1
vote
1answer
64 views

unable to launch mysqld in arch linux

I have lately 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 outpout of sudo systemctl ...
0
votes
1answer
20 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
37 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
40 views

Linux Swap Space

I have got 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 ...
0
votes
1answer
11 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
80 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] ...
-1
votes
0answers
17 views

Php Problem with mysql_query() [migrated]

I've been having problems with my php code. I seem to be getting an error from @mysql_query(). Here's my code for php: <?php // A simple PHP script demonstrating how to connect to MySQL. // Press ...
-2
votes
1answer
46 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
30 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
80 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
42 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
11 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 ...
0
votes
1answer
33 views

Freeradius: MySQL query to show account expired yesterday

I have freeradius with mysql.using CLI, I want to list user account which have expired yesterday. Currently I am using following command but it shows today account, mysql -uroot -pSQLPASS -e "use ...
2
votes
2answers
77 views

High IO wait - How to determine the root cause?

I have a MySQL instance on two dedicated servers. One for the production, the other for the test platform. The 2 servers are pretty the same, the only difference is the RAID controller and the ...
0
votes
3answers
64 views

Bash to match two variables for time difference

I have a bash command which gives me following result (Fetch user account details from the mysql using command select creationdate from users; Name Account Creation Date Mobile User1 ...
0
votes
2answers
50 views

Install app on tiny core

How do you install mysql on tiny core? Also how do you install clamav? Can you install apt-get or yum on tiny core? All should be done in command line / terminal
0
votes
1answer
38 views

MySQL process showing in top but no errors logged

I am seeing the following in TOP 2311 mysql 20 0 1324M 646M 9188 S 0.0 17.1 0:00.00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin ...
1
vote
1answer
158 views

Permission denied writing to mysql log

I am just testing out a new Ubuntu (Vivid 15.04) install on Vagrant, and getting problems with mysql and logging to a custom location. In /var/log/syslog I get /usr/bin/mysqld_safe: cannot create ...
1
vote
0answers
231 views

libmysqlclient.so.18: cannot open shared object file: no such file or directory [closed]

I am using Slackware 14.1 x64 and when I want to run a program that is using mysql.h over C I read the following error: bash-4.2$ /home/normal/Proyectos/a.out /home/normal/Proyectos/a.out: error ...
0
votes
2answers
28 views

How can I find where a program is installed or run from?

I installed centos and now I want to get into mysql via the command line, but I forgot my root password for mysql as its not the same as the root password I made to login to the system. I googled and ...
1
vote
0answers
51 views

mysql service exiting without error

I have installed mysql-community-server on openSUSE and am having trouble starting it as a service. I can start it using sudo mysqld --user=mysql without a problem and access the database normally. ...
0
votes
1answer
61 views

Update mysql database specific field with this bash script

I am using the following bash script to update an email address "currentemail@email.com" but the problem I have is that the field could be anything, not necessary "currentemail@email.com" I have tried ...
1
vote
1answer
25 views

Update mysql database

How would I go about updating MySQL database X, table Y and column Z with "abc". How would I be able to do this without having to do so interactively from the mysql> prompt? I want to do this with one ...
-2
votes
1answer
30 views

Replace mysql field with X

I would like to update a MySQL database table column with x. How would I be able to do this without having to do so interactively from the mysql> prompt? I want to do this with one simple command.
1
vote
0answers
20 views

Zombie mysql process ? - linux Mint

I am having the following problem with MySQL and Mint: mysql is set to run at startup: sudo update–rc.d mysql defaults After startup the service is running and I can connect to the database through ...
1
vote
3answers
90 views

I can not install MySQL using yum on Centos7

I've installed centos7 recently, but, when I am trying to install MySQL using the command: yum install mysql-community-server I keep getting Exiting on user cancel while I am not hitting any ...
1
vote
1answer
53 views

Xampp installer Error

I tried to install xampp ver 5.5.24 on Debian using terminal, after setting it to run as executables in permissions with. ./xampp-linux-5.5.24-0-installer.run I get Segmentation fault Then I ...
1
vote
2answers
61 views

Centos 7 - Recover mysql db from data files .frm and .ibd

I have migrated my operating system from Windows to Centos 7 without getting backup of mysql through mysqldump. Now I have mysql data files .frm and .ibd . I want to migrate them How can I migrate ...
1
vote
2answers
44 views

How to pass password to mysql command line

I have MySQL password saved on a file foo.php, for example P455w0rd, when I try to use it: $ cat foo.php | grep '$dbpwd=' | cut -d '"' -f 2 | mysql -U root -p mydb -h friendserver Enter password: ...
0
votes
1answer
54 views

php server can't connect to the remote mysql server

We have two servers. server 1 and server 2 they are running with Directadmin / CentOS6 my plan: server 1 is running php and html, images...etc. server 2 is running mysql and phpmyadmin They are ...
0
votes
2answers
56 views

Write permissions inside of shell script

I am using a Debian 7 Server. I created a shell script to be executed by crontab to save a mysqldump every day. mysqldump *database* -u *mysql-user* -p*mysql-password* > ...
1
vote
0answers
17 views

Howdo i avoid older mysqlclient versions

i'm running some CentOS servers. PHP and MySQL are installed from 3rd party repos. My problem is that on all servers i always have php mysql clients running their version far behind the actual mysql ...
1
vote
1answer
87 views

List available SQL commands at MySQL CLI

Is there a way to list available SQL commands at MySQL CLI? I mean if I type help at MySQL CLI I see various MySQL CLI specific commands like clear(\c) or tee(\T), but it would be handy to see a list ...
0
votes
1answer
43 views

MySQL: connection refused…coudn't find mysqld.service

I am trying to install MySQL onto a Fedora 14 VM. I successfully installed it using yum install mysql mysql-server after which I tried to start it with systemctl start mysqld.service which ...
2
votes
0answers
143 views

MySQL read only error but permissions set and SELinux AFAICT correct

I am new to MySQL and Linux and because I had issues with an old MySQL version (5.1) I used mysqldump and installed MySQL 5.6. I changed the datadir location by copying everything to the new folder ...
2
votes
0answers
69 views

is THP good or bad for MySQL Server?

Linux kernel new feature called Transparent Huge Pages (THP) which is by default enabled on CentOS 6.x and above OS. Is THP good for MySQL DB machine? I am trying following to disabled THP but seems ...
0
votes
0answers
97 views

HAProxy with Roundrobin working only on 2 of 3 MySQL servers, why?

Good day. I'm following this article to configure HAProxy to balance with roundrobin between 3 MySQL servers (db1, db2, db3) in a MariaDB Galera cluster (working perfectly). However I have a ...
0
votes
1answer
43 views

Appending to a CSV file after obtaining datum from a database

I can [finally] extract data from the MySQL DB my_database_query="SELECT * FROM my_database.database" mysql -uUSER -p'PASSWORD' << EndOfFile $my_database_query EndOfFile How can I append this ...
1
vote
1answer
56 views

Unable to access another server over local network on Digital Ocean

I have two servers. Let's call them A and B. Both are running ubuntu server 14.04. B runs percona server. Now I do not have any firewall set-up on either servers still I am unable to connect to server ...
0
votes
0answers
608 views

Error starting MySQL in a MariaDB Galera cluster in CentOS 7

I'm trying to setup a MariaDB Galera cluster following this tutorial exactly as it is, and I'm stuck in the Step 7– Initialize the first cluster node, I'm doing so with sudo /etc/init.d/mysql start ...
0
votes
1answer
56 views

Rebooting Centos Servers configured with MYSQL Master/Slave Replication

Sometime ago we configured MYSQL replication on our main web server to another CentOS 6 server. All is working perfectly and we can see the replication is working fine. My question is how to safely ...
2
votes
1answer
124 views

Why does logrotate zip a file before it is closed

I'm using logrotate to rotate mysql output. When cron runs logrotate, I get frequently get an e-mail with the following content: error: Compressing program wrote following message to stderr when ...
0
votes
1answer
42 views

Looking for an email server that supports mysql ssl connection

I am trying to secure connections to my MySQL server. I have SSL set up but I am looking for programs that support a SSL connection to MySQL. Specifically I am currently looking for an email server ...
0
votes
2answers
196 views

import .sql file into a remote server from a local machine

I've created a database in the remote machine. Currently, the database is empty and I need to import using a backup(.sql) file. The backup file is in my local machine, it is a 40gb file. And the ...
0
votes
1answer
100 views

Mysql exited with status 1 and restarted every 24 hours? How to debug?

After upgrade, MySQL on Ubuntu 14.04 keeps crashing and is restarted every 24 hours according to the dmesg. I would expect to some reason for the failure in MySQL logs, but all are empty. Any ideas ...
1
vote
1answer
93 views

How do I troubleshoot these SELinux AVC errors?

Background: I have a CentOS 6 LAMP server. Recently the server has started to become unresponsive every few days. Originally, mysqld would throw a nagios alert and I would be unable to even ssh into ...