Questions tagged [mysql]

An open-source, relational database management system.

233 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
1k 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
353 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
667 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
425 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
107 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
91 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
58 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
470 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 ...
0
votes
1answer
780 views

installing php-mysql on rhel6

I have rhel6 running on my server and installed mysql from Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 64-bit), RPM Bundle. Now I want to host a php site on that machine. And when I run yum ...
0
votes
1answer
622 views

How to reconfigure PHP

We have a new linux server CentOS 6.5 with Plesk. Default PHP is 5.3.3, I have installed PHP5.4 & 5.5 on the server. I have to install PHP by using this guide PHP installed successfully but ...
0
votes
0answers
38 views

If a buggy application underperforms, it it possible server tuning could have no affect?

To set the stage, imagine if you will: A read-heavy Tomcat Application with MySQL on Red Hat Enterprise Linux with some problematic Java Class files which resulted in the application performing a ...
0
votes
1answer
1k views

Can't seem to connect to my Debian Mysqli Server?

So I have a simple PHP script which I attempted to do something along the lines: $db = mysqli_connect("localhost", "root", "PASSWORD HERE", "database name"); mysqli_query($db, "SELECT STATEMENT HERE")...
0
votes
0answers
548 views

MySQL 5.1.73 in Oracle LINUX : Which is the correct mysql configuration file?

I have installed MySQL 5.1.73 manually by RPM on Oracle LINUX 5. When I searched configuration file - my.cnf I run below command and get list of multiple configuration files. $ locate *.cnf /etc/pki/...
0
votes
1answer
646 views

Automatic login for mysql used in CGI script

I have written a CGI script using bash which executes a MySQL query. For MySQL authentication , automatic login is used by supplying the credentials in .my.cnf file as shown below . # the following ...
0
votes
1answer
98 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
1answer
379 views

Performance Issue: AWS Medium Linux Instance V/S Hetzner Dedicated Instance

I am testing an AWS Medium Instance with CentOS (AWS AMI) and comparing it with Hetzner's EX40-SSD (http://www.hetzner.de/hosting/produkte_rootserver/ex40ssd). Software setup on both is comparable( ...
0
votes
1answer
320 views

Recover from ext2 filesystem corruption

I have a TinyCore (3.6) Linux distribution on a device of mine, which uses disk-on-module or compact flash storage. The filesystem is ext2. I have a LAMP stack on this device and I'm playing with a ...
0
votes
2answers
125 views

Open source MySQL performance tool

Are there any open source MySQL performance tools for optimizing SQL queries?
-1
votes
0answers
21 views

MySQL and Oracle DB backup scripts

I am urgently in need of a pre-freeze and post-thaw script for Mysql DB and oracle DB, and would appreciate any help I can get. I am also new to scripts so please, include explanations to applying ...
-1
votes
0answers
13 views

Is it safe to keep MySQL users?

When I ran select User,Host from mysql.user; I notice I have 4 users. Is it safe to keep those users ? Should I remove any of those default users ?
-1
votes
1answer
47 views

mysqldump have issue in cPanel cron job

To create auto backup of database, I am using this command in cPanel cron job mysqldump --opt -Q -u {mysql_user_name} --password='{password}' {database} | gzip > /home/[account_name]/db_backup/...
-1
votes
1answer
71 views

Risk of keep mysql data folder into linux cache

Is there a risk of doing: vmtouch -dl /mysql-data-folder On a production server with 192GB RAM and mysql data folder of 50GB. What is vmtouch? man vmtouch vmtouch opens every file provided ...
-1
votes
2answers
483 views

selecting and purging binary logs through Shell script

let suppose this is the master binary log and i want to purge the binary logs upto "mysqld-bin.000002" to free some space in disk. I want to do this with shell scipt.
-1
votes
2answers
121 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 ...
-2
votes
1answer
32 views

JSON_TABLE problem

I have a JSON structured like that ... { "market_order_line_details__c":[ { "PriceItem__r.Catalog_Item__r.Parent_Catalog_Item__r.Parent_Catalog_Item__r.Calendar__r":{ "...
-2
votes
1answer
967 views

Installing MySQL without Root Access on CentOS

I'm trying to follow the instructions here. 1) I can't find CentOS listed as an operating system on the MySQL website. So I downloaded the mysql-8.0.11.tar.gz from the MySQL website: MySQL Community ...
-2
votes
1answer
337 views

CentOS 7 Cannot Install MySQL 5.7 nothing I have done works still trys to instll mariadb

I have followed just about every instruction, including the instruction from MySQL and following instrucitons from around web including this site. I have downloaded the mysql57-community-release-el7-...
-2
votes
1answer
1k views

How to set System Variable for mySQL in RHEL 6.2?

I am currently working on mySQL 5.6.10 server and RHEL 6.2. I need to set the system variable PATH for mySQL on RHEL 6.2 Terminal. How do I set it? I also want to run a .sql file on Linux. I am using ...