Questions tagged [mysql]

An open-source, relational database management system.

221 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
365 views

mydumper segmentation fault in g_ascii_strtoull

I'm trying to use mydumper to generate a dump of my mysql databases, that I could use to restore the databases later in case of disaster. However, it just doesn't work. I use this command line: ...
0
votes
1answer
199 views

Save daily mysql row count change in RRD

EDIT: To make things clear: I have an integer called $blocks or something, which increases everyday. I want to make a graph with RRDtool, that shows the "increased" amount for everyday. So if my $...
0
votes
1answer
30 views

Is there a command link wizard to create a new MySQL username and a DB with the same name + password?

Is there a command link wizard to create a new MySQL username and a DB with the same name + password? As for now, I always do so online from PHPmyadmin, but would like to automize this process from ...
0
votes
1answer
72 views

Best way to migrate many SQL databases

So I'm switching VPSs, and have already done a backup of all the data files and moved them over. However I still need to move all the old databases over. I've been searching the internet for the best ...
0
votes
0answers
36 views

How to export the df result as a mysql table

I can get a table by following command df -h|column -t|sed -E 's/ +/\t/g' I hope to make it be a mysql table.This is my current try [root@localhost ~]# df -h|column -t|sed -E 's/ +/\t/g'>...
0
votes
1answer
39 views

Unable to type character “n” in ubuntu command line interfaces (R, mysql, python,…)

I am having a maddening problem which I hope someone has seen. I am working on ubuntu, remotely over putty. In the shell console, either bash or tcsh, everything is fine. Everything is also fine ...
0
votes
1answer
104 views

Pass output from metadata call to MySQL

Reference: How to pass password to mysql command line I want to grab returned metadata from an AWS EC2 instance and set a new mysql password based on this data. I need assistance with the script ...
0
votes
2answers
562 views

Loop through file to obtain bash script variable

I'm working on a script to check the status of several remote MYSQL hosts by logging into the every server and recording whether the login has been successful or not. The idea is to store the login ...
0
votes
1answer
186 views

Insert parts of a log file nginx to database(mysql)

I want to insert some parts of my log file to mysql. this is my log file 195.xx.x.x - - [25/Apr/2017:09:60:xx +0200] "POST /userx/index.php?m=contacts&a=form&... 192.xx.x.x - - [25/Apr/2017:...
0
votes
1answer
451 views

Slow response of server

I have a local development server in the local network. There are many instances of magento sites running there. Developers work a 5-6 different magento's and when there is such use the server ...
0
votes
1answer
230 views

Multiply instances of MySQL on CentOS 7

I want to run two instances of MySQL on one CentOS 7 machine. And I need to run instances on different users. Reason for this approach is need for limiting resources (CPU and memory) for each instance,...
0
votes
0answers
100 views

mysql.so: undefined symbol: vio_blocking

I'm trying to set up a Rails 2.2.2 installation (for an old app that I maintain) in a new Linux Mint 18 install. I've installed mysql (5.7.16-0ubuntu0.16.04.1 (Ubuntu)) and, using RVM, have installed ...
0
votes
1answer
711 views

Problems with MySQL 5.7 and reset root password when use mysql_config_editor

I am using MySQL 5.7.17 on Debian Jessie and wanted to dump the database using mysqldump with mysql_config_editor. The steps I did for the mysql_config_editor. They are: mysql_config_editor set --...
0
votes
1answer
65 views

Error 2002 MYSQL OS X 10.11

I had several installations of mysql on my laptop, like brew mysql, brew mariadb, MAMP and plain old Mysql. Now I'm just trying to use plain old mysql after I tried deleting anything that may be ...
0
votes
0answers
186 views

Mac install MySQL from a shell script

I want to programmatically install MySQL to a Mac system running OS 10.11.6 El Capitan, so once the .dmg has been downloaded the script unpack it with the command: sudo hdiutil attach mysql-5.7.16-...
0
votes
1answer
148 views

ODBC Authentication with .pem files on Ubuntu server with Python

Using the below 3 PEM files I am able to connected successfully to a MySQL database on windows threw setting up a Data Source. (No problems here) client-key.pem client-cert.pem ca-cert.pem But I ...
0
votes
1answer
465 views

Mysql_connect(): Can't connect to local MySQL server through socket in Linux

i am trying to connect mysql DB with xampp in linux centos . but i am getting error like this . Mysql Error : 2002- mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/...
0
votes
1answer
45 views

Is it possible to read from MYSQL-database to get valid IP-Adresses for Pingtable

is it possible that iptables reads the IP-Adresses it should packages from from a MYSQL-database?
0
votes
3answers
72 views

Does it matter if I'm root or not when installing apache?

I need to install a LAMP stack on a RHEL 6.7 server. Do I have to be root to install this or not?
0
votes
1answer
6k views

Installing mysqlnd for php 5.6 on CentOs 7

I get php warning: mysql_connect(): Headers and client library minor version mismatch. Headers:50547 Library:50624 Also I read that I need to install mysqlnd to my server. I tried do it using: ...
0
votes
1answer
109 views

Why is crontab executing on one server but not the other?

I have two servers on linode that have some websites on them. I created a script to see if mysql is running on the server and if it's not running then the script will start mysql. The script is on ...
0
votes
1answer
674 views

Backup mysql database via sftp

I have recently messed up my debian server and I have only sftp access for my files. I rescue almost everything except of my database. I have no longer direct ssh access, other than in rescue mode, ...
0
votes
1answer
498 views

unlang: SQL results to local variable

I'm trying to save a resultset of a SQL query in unlang. (First time with unlang for me, by the way, so please don't judge me for mistakes.) The corresponding line is Sql-Result-Set = %{expr: %{sql:...
0
votes
1answer
73 views

mysql monitoring tool

Is there any monitoring tool for mysql which will send a notification mail to mentioned email ID ? It must monitor below parameters. 1. mysql more than 500 concurrent connections. 2. mysql deadlocks. ...
0
votes
1answer
921 views

error on opening mysql workbench on fedora 23

I have installed mysql-workbench on Fedora 23 Virtual machine (VMware) using the command : yum install mysql-workbench Now when I tried to issue the command mysql-workbench from terminal I am ...
0
votes
1answer
122 views

Mysql init.d to systemd

I have two mysql instances on a centos 7 machine. init.d handles start on boot. problem is, only one instance starts on boot. both instances uses two different ports. Can someone help me with how to ...
0
votes
1answer
1k views

Cann't start MySQL on my Linux server with Centos 7 OS

I have already installed MySQL in a Server (Centos 7) by the following commands: yum install -y mysql yum install -y mysql-server yum install -y mysql-devel After the installation, I type mysql and ...
0
votes
1answer
62 views

How to take database backup and restore? And how can I view it?

I am using this commands to backup and restore my database mysqldump -u transgenic -p[ramesh] [transgenic] > transgenic.sql mysql -u transgenic -p[ramesh] [transgenic] < transgenic.sql I am ...
0
votes
0answers
337 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
2answers
666 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
25 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 ...
0
votes
2answers
1k 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
260 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 ...
0
votes
0answers
787 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 problem....
0
votes
1answer
1k views

Chromebook crouton LAMP

I'm trying to install a LAMP stack on Ubuntu through crouton on a Chromebook (Acer c720p). I was able to install the following packages apache2 mysql-client mysql-server php5 libapache2-mod-php5 ...
0
votes
0answers
1k views

can't connect to remote host with MySQL…firewall problem?

I've granted privileges to thufir for remote access through the shell (correct?), but cannot seem to actually connect. The router firewall has SPI to off. I've disable the IPv6 firewall on the ...
0
votes
1answer
322 views

Combine the output of while loop into tar

I'm trying to create a script that mysqldumps all my databases, creating an individual .sql file for each database and combines the output into backup-DATE.tar.gz. I've gotten as far as being able to ...
0
votes
0answers
3k views

Can't start mysql server on OpenSUSE 13.2

Try to start the server: # service mysql start Output: Job for mysql.service failed. See "systemctl status mysql.service" and "journalctl -xn" for details. Output for "systemctl status mysql....
0
votes
2answers
963 views

Is there any way to install MySQL 5.1 and PHP 5.3 on Centos 7

Is there any way to install MySQL 5.1 and PHP 5.3 on Centos 7. I researched a lot but could not find any link which gives step by step procedure. Can someone please give me steps to be followed to ...
0
votes
1answer
351 views

mysql high availablity for LAMP application (ubuntu 14.04)

im trying to achieve HIGH Availability (HA) for a LAMP application(News Portal website) which might be of interest to many unfamiliar users.For files im using Glusterfs (replica) for redundancy ...
0
votes
0answers
1k views

Disabling strict mode does not take effect from the config file

I am trying to disable the MySQL/MariaDB strict mode in the variable sql_mode. But it doesn´t work. My my.cnf in section [mysqld] got this line: sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" ...
0
votes
1answer
658 views

From Mysql query output to retrieve files in the file system and rename the files

I have to call a SQL query from bash that outputs 1000 rows of two columns File_Path (Eg., /opt/files/dest/2.bin) Name_of_the_file (Eg., fax attachment.pdf, invoice.docx... yes, there are spaces). ...
0
votes
0answers
14k views

completely clean re-install of mysql on CentOS 7

I have encountered problems with a mysql installation on CentOS 7. All the data is backed up, so I just want to completely erase every remnant of mysql on the machine and then do a clean install. My ...
0
votes
1answer
398 views

Apache / PHP config for production & staging & development

I have a server that has a production server a staging sever and a development server. I maintain code by changing it on the development server testing it. Then staging it and testing it and then ...
0
votes
2answers
95 views

Does “mysql” user exist in MySQL database system?

I searched mysql.user table and did not find any user named as mysql. root is the default username. I am curious to know whether mysql user exists or not? If yes, what is the purpose of this user? ...
0
votes
1answer
1k views

Mysql database didn't connect through sqlyog or any other mysql software?

I can connect to a MySQL server through a browser and also I can show all database list through PuTTY. But when I try to use sqlyog or running the mysqldump command through PuTTY it shows this error: ...
0
votes
1answer
89 views

How to get ids from xml file into mysql?

I've got 8 xml files and need to do some work on these records in mysql. What is a good way to get these IDs into mysql? <?xml version="1.0" encoding="utf-8"?> <Records> <Record> ...
0
votes
0answers
57 views

Updating data sets from Online databases/Webservice

I want to have an idea as to how to update the data regularly from the source, if its stored locally in your server or local machine.Lets say MySQL database. Source:It will be a webservice data ...
0
votes
1answer
1k views

Moving from InnoDB to TokuDB

I'm running MariaDB 10.0.x and I would like to move from InnoDB to TokuDB. When using ALTER TABLE <> ENGINE=TokuDB; everything goes fine for the Wordpress websites. Unfortunately the Magento ...
0
votes
0answers
443 views

Why does “Connection Failed: 2002” display randomly on my PHP/MySQL website?

I'm running CentOS 6 with Apache/PHP/MySQL. PS. I'm sort of a novice at Linux, but I did my best to gather info before coming here. I'm now a bit stuck. I recently upgraded PHP to version 5.5.12. I ...