An open-source, relational database management system.

learn more… | top users | synonyms

1
vote
2answers
1k 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 ...
1
vote
3answers
421 views

Upgrade MySQL 5.0.88 to 5.1.69

I am upgrading my MySQL installation on a Fedora 10 (and 14) box (in test first.) I have made a system image (it is a VM) and have downloaded MySQL Server Community 5.1.69-1 from the MySQL site. Once ...
1
vote
2answers
687 views

Script that uses MySQL query to automatically remove output

I have this query that outputs updates older than 7 days from a database. How would I make a script that takes the MySQL statement and puts it into a script to be executed by cron. echo "select name, ...
1
vote
3answers
545 views

Multiple Mysql databases backup tool?

My OS is Ubuntu 10.10. I have several small sites (all on various shared hosts) and I'm thinking that it'd be probably good idea to regularly backup mysql databases from these remote shared hosts. I ...
1
vote
1answer
876 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
1answer
142 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 ...
1
vote
2answers
2k views

How to view a list of previously run mysql queries in a live feed format?

How do i view the last run queries in mysql in a live feed format? I want to leave my terminal window open and just have mysql queries pop up on the screen whenever something is run. I know I can do ...
1
vote
2answers
7k views

Turn off --skip-grant-tables in MySQL

I'm pretty new to using Linux but am setting up my MySQL databases on an Amazon ec2 instance. I followed some directions I found about resetting the user login pass by using the --skip-grant-tables ...
1
vote
2answers
917 views

Getting error 2006 MySQL server has gone away on CentOS

I need to import a database into a freshly created CentOS 5 virtual machine. However, whenever I run the import command on the console, it stops working in about a minute and I get the error message: ...
1
vote
1answer
2k views

Why can't I run mysql?

I'm trying to import a database from Wamp to Xampp. I run Lampp first, then go to /opt/lampp/bin and run: mysql (or mysqladmin ?) -u root -h localhost but I get: mysql: command line not found ...
1
vote
3answers
1k views

Error dropping database in MySQL 5.1 on Ubuntu

I am using MySQL v5.1 on Ubuntu machine. I have a database named my_db which I would like to drop it, so I execute command: mysql> drop database my_db; ERROR 1010 (HY000): Error dropping ...
1
vote
1answer
34 views

can not install mysql-server on centos 6.7 32bit . Error: need rpm?

when I try to install mysql-server on centos with this command: yum install mysql-server server replies: Loaded plugins: fastestmirror, security Setting up Install Process Loading mirror speeds ...
1
vote
1answer
53 views

copy and symlink mysql to another disk partition

I'm using ubuntu 12.04 and have two disk partition named: /dev/sda and /dev/sdb. my home partition and other programs are in /dev/sda. therefor any work like database benchmark on my mysql databases ...
1
vote
1answer
243 views

How to install a newer version of mysql workbench than is available in my distro's repos

I'm guessing this will be a quick fix for you. I am trying to install a version of mysql workbench that is NEWER than what is available to me through the regular debian repos. I started by adding ...
1
vote
1answer
339 views

mysql-server-5.5 unmet dependencies each time running apt-get

Each time I run "sudo apt-get install package-name", the following error happened, even if I tried to install other packages other than mysql ones: You might want to run 'apt-get -f install' to ...
1
vote
1answer
77 views

get mysql count of id in shell script

I am trying to get count of column user_Id using count(user_Id) from mysql as follows: count=$(mysql -uroot -proot csv_imports -e "select count(user_Id) from test_data where user_Id=\"12345\";") I ...
1
vote
3answers
192 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 ...
1
vote
1answer
90 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 ...
1
vote
1answer
83 views

Not able to rename root user of MySQL

As part of security hardening, I wanted to remove/rename root user of mysql. While trying I get an error mysql.procs_priv doesn't exist. what is the significance of 'mysql.procs_priv'? Is it ...
1
vote
1answer
149 views

FreeBSD Reinstall postfix with mysql support

I have installed postfix using the ports tree without making modifications to anything. In my main.cf file i can't specify any 'Mysql:/' arguments because postfix does not have mysql support. Now i ...
1
vote
1answer
241 views

Calculating RAM/Swap Space Requirements [duplicate]

I have been developing a MySQL database that makes some use of BLObs. This has now been transferred on to a virtual machine (VM) in preparation for going fully into the 'cloud'. However some of the ...
1
vote
1answer
33 views

Tool for migration of service configuration

Is there a tool that handles generic migration of config? For example if I have httpd, postfix, MySQL and users and groups data, is there a tool that can extract the config data for each service so ...
1
vote
1answer
2k views

compiling php 5.4 and higher with mysql

i'm running a pile of mediawiki instances on oracle enterprise linux and i'm trying to upgrade from 1.19.x to the latest LTS version, 1.23.x. i'm currently using php 5.3 and due to some odd issues ...
1
vote
2answers
448 views

Ubuntu: where add a script executing SQL on machine start?

Each time Ubuntu is starting I need to run a script, which is running some SQLs. So I need run it after MySQL already started. Where should I put such script?
1
vote
1answer
2k views

Problems installing mysql on debian

I have a : user@Node:~$ uname -a Linux Node 2.6.32-042stab092.1 #1 SMP Tue Jun 24 09:10:28 MSK 2014 x86_64 GNU/Linux With a : user@Node:~$ cat /etc/debian_version 7.6 and I am having problems ...
1
vote
3answers
30k views

Can't start mysql service

Trying to start my mysql service. /etc/init.d/mysql start returns: Job failed. See system logs and 'systemctl status' for details. Further: systemctl status mysql.service returns: ...
1
vote
1answer
1k views

How to install mysql-server 5.6 on RHEL 5.8 (when MySQL-server 5.0 is already installed)

I want to install mysql-server 5.6 on RHEL 5.8, but when trying rpm -i or rpm -Uvh it complains that I already have version 5.0 on there. I am happy to replace, upgrade or install another instance. ...
1
vote
1answer
323 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 ...
1
vote
2answers
580 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 ...
1
vote
1answer
3k views

MySQL aborting during initial db installation

Linux version: shell> cat /proc/version Linux version 3.2.0-4-686-pae (debian-kernel@lists.debian.org) (gcc version 4.6.3 (Debian 4.6.3-14) ) #1 SMP Debian 3.2.46-1+deb7u1 Installing MySQL ...
1
vote
1answer
97 views

Find and Replace in wordpress postings

I have a wordpress blog with 93 posts on it, in which I want to replace [bash] with <pre> but how do I do it please? I need to go through all the posts changing [bash] to <pre> in each ...
1
vote
1answer
1k views

Mysql log confusion

I have installed a standard installation of mysql on Debian Wheezy and I am confused as to where the logs are supposed to be logged. In my /var/log/ directory, there are files mysql.log which are ...
1
vote
1answer
336 views

Correct diacritics in a mysql dump on CentOS

On my CentOS server, I have got a dump file of a mysql table which contains special czech characters in it (e.g. á, é, č, ž). When I view the file using cat, the special characters are broken (e.g. ĂĄ ...
1
vote
3answers
3k views

How to create an interactive bash script to collect arguments for a command in linux?

I'm trying to create an interactive bash script where I can collect user input variables to be used as arguments in another command. Can someone provide me an example of this? Currently i want to do: ...
1
vote
1answer
313 views

Uninstall MySQL server without removing or breaking any client functionality

I have an Ubuntu webserver which once used a local database, but we migrated it and now the database is stored remotely on a separate server accessed from many different places. The webserver runs ...
1
vote
2answers
1k views

How to monitor the number of rows inserted per second and per minute into MySQL db

I have a running script which is inserting data into a MySQL database. I want to know how many rows are getting inserted per second and per minute. If the count of rows inserted per second or per ...
1
vote
2answers
308 views

MySQL server on Ubuntu fails to start after changes made to my.cnf in Windows

I have MySQL 5.5 running on Ubuntu Server 12.10. When I run /etc/init.d/mysql restart, I get the following: mysql start/running, process 2754 However, when I open /etc/mysql/my.cnf in Windows via a ...
1
vote
1answer
223 views

How to purge package in debian without affecting other packages?

I had mysql-server-5.1 installed, then upgraded to mysql-server-5.5 and now upgraded to percona server (package percona-server-server-5.5). So now I have 2 mysql-server packages removed, but not ...
1
vote
1answer
232 views

fedora can't find mysql service

I have a VPS running Fedora 16 (upgraded from 15). Mysql was installed and working until recently. Now I can't get the mysql service started. when I try /etc/init.d/mysqld start I get the error ...
1
vote
2answers
151 views

Find all postgresql and mysql databases on a system

Is there a way to find all postgresql and mysql databases on my system? (Perhaps using the find command).
1
vote
2answers
5k views

Can't start mysqld

I've installed mysql through $ sudo apt-get install mysql-server-core-5.1 $ sudo apt-get install mysql-client-core-5.1 This is my current conf file And the service won't start, at first the ...
1
vote
2answers
4k views

MySql: LOAD DATA INFILE

I am using MySQL v5.1 on Ubuntu machine. MySQL data directory is /var/lib/mysql/ I have a test.dat file located on /var/lib/mysql/tmp/test.dat I would like to load data from the test.dat file into ...
1
vote
1answer
97 views

dump out some tables of the database

I am using MySQL v5.1 on Ubuntu machine. I have a database named db_test which contain tables like cars, customers, departments, prices , and so on. I know I can use the following commands to dump ...
1
vote
1answer
76 views

can't connect to mysql as admin from outside

I have a dedicated server (CentOS 5.3) but I can't log on to mysql as admin from outside, however I can do that when I'm on server's command line. I assume there's a setting somewhere that can give me ...
1
vote
1answer
2k views

Install MySQL workbench on ubuntu

I am using Ubuntu 9.10 - the Karmic Koala - released in October 2009 I downloaded mysql-workbench-gpl-5.2.33b-1ubu1004-i386.deb from here But when I run this package it show me following error: ...
1
vote
1answer
970 views

MySQL Workbench warning when connecting to MariaDB

When using MySQL Workbench 6.3 on Kubuntu 15.10 and MariaDB Server version: 10.0.22-MariaDB-0ubuntu0.15.10.1 (Ubuntu), I get the following warning. Is this expected? Incompatible/nonstandard ...
1
vote
1answer
144 views

MariaDB - dependency problems - leaving unconfigured

I have tried to install ISPConfig3 on Debian Jessie 8.1, and it couldnt connect to mySQL (mariaDB 10.1). So I CTRL+C to kill the install and I tried to manually login to mySQL, but I failed. It was ...
1
vote
1answer
94 views

How to use SSH tunnel to connect to remote MySQL server?

I am trying to connect to remote MySQL server, which runs on CentOS 6.6 cPanel server. I am creating tunnel this way: ssh -L 3306:xxx.xxx.xxx.xxx:3306 user@xxx.xxx.xxx.xxx -p PPPPP Where ...
1
vote
1answer
385 views

Mysql Isn't starting

I recently asked this question the reason mysql wasn't starting is because there was no disk space. After a long discussion with casey in chat room and after following his answer, I freed about 10 GB ...
1
vote
2answers
762 views

How to Subscribe a Bash Script as a MQTT Client

From my understanding: Client can be any device as long as it has an MQTT library running on it, from a microcontroller to a server, but must be connected to an MQTT broker over any network Broker ...