An open-source, relational database management system.

learn more… | top users | synonyms

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 ...
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 ...
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 ...
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 ...
0
votes
2answers
1k 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 ...
11
votes
2answers
2k views

FreeBSD: “Too many open files” but should be able to open another 160,000 files

I have a FreeBSD 8 system running ZFS, with a MySQL 5.5 server which is about 355GB and projected to grow to be a couple of Terabytes. MySQL is triggering errors about "Too many open files" on ...
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
333 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
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 ...
0
votes
1answer
126 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: ...
3
votes
2answers
571 views

Installing php-cgi under Ubuntu for Cherokee web server

I have set up Cherokee web server on my server, and want to enable PHP and MySQL support for applications like Wordpress and phpBB. I have tried running these commands: sudo apt-get install php5 ...
0
votes
2answers
435 views

phpmyadmin 403 error

i mannually installed phpMyAdmin according to this doc:quick install.but i keep getting the 403 error, i can successfully get into other folders in the root dir, how can i sovle this? here is my ...
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
2answers
546 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. ...
1
vote
1answer
194 views

Adding MySql Workbench to favorites in Fedora 19

I'm using Fedora 19 64 bit on my Samsung Series 9 Ultrabook and I have installed MySQL workbench 6 (mysql-workbench-community-6.0.7-1.fc18.x86_64) via the RPM downloaded from the MySQL website. I'm ...
0
votes
1answer
156 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( ...
1
vote
0answers
39 views

Mysql user privileges : Only CREATE table

I am trying to create a user who will be able to manage all databases without the right to CREATE and DROP databases. I have been using the following link : ...
0
votes
1answer
147 views

KMail extremely slow/frozen when operating on local maildir folder

KMail seemingly freezes when trying to open a message or executing any command on the local email folders (maildir) such as moving or marking of messages. Sometimes the triggered action is executed ...
3
votes
1answer
937 views

Can't start mysql on Fedora 19

I'm running Fedora 19 and I have installed MySQL using yum install mysql. When I issue the mysql command, I get the following error message: ERROR 2002 (HY000): Can't connect to local MySQL ...
0
votes
1answer
87 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 ...
1
vote
1answer
269 views

postfix: save all incoming Mails in MySQL DB and have all addresses Verified for big servers

I am new to all that server based stuff. New to Postfix and new to Ubuntu. I have an Ubuntu v-server with Postfix, PHP and MySQL installed. Also I have an own domain. So far, I managed to receive any ...
4
votes
1answer
622 views

MySQL stop/waiting issues; “can't connect … through socket” [duplicate]

So this was my first time putting up a LAMP stack on a Bodhi machine (previously experience with WAMP, and LAMP on 10.04); I got Apache going, and a Drupal install begun, then I go to create a new ...
1
vote
1answer
2k 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 ...
0
votes
1answer
548 views

Error at starting mysql because lack of permission on /var/lib folder

OS : Redhat I try to launch the mysql database after a fresh installation. The problem is I am not root on this server and my user have not the permission to write in the /var/lib folder. When I try ...
0
votes
1answer
283 views

How to reduce buffers\cache

A monitoring system keeps alerting that my machine is reaching\breaking through it's RAM utilization threshold which is 15 GBs. I've done some reading and understood that the apparent RAM utilization ...
1
vote
1answer
59 views

Can anybody help me with MYSQL not starting

Here is a my error log file [localhost:local/mysql-5.5.15-osx10.6-x86_64/data] root# sudo localhost.err localhost1.err 130911 14:16:24 mysqld_safe Starting mysqld daemon with databases from ...
1
vote
1answer
51 views

MySQL 3.23 on Centos 6?

Don't ask why, just is it possible to install old mysql 3.23 on new CentOS 6.4 i386 or x64 version (same to me)?
1
vote
1answer
51 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 ...
2
votes
1answer
166 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 ...
-3
votes
1answer
159 views

Best Linux for a small Web server [closed]

I'm currently planning my business servers and I would like to know what's the best Linux distro for these needs: Nginx + MySQL + PHP 5.4 Zimbra Collaboration - Open Source Node.js w/ Forever I ...
2
votes
1answer
172 views

How to copy the whole MySQL DB between two servers?

There is a very good connection between the two machines (MySQL 5.5.28): mysqldump -u root -p'password' --all-databases | ssh root@SERVERNAME mysql -u root -p'password' --all-databases So AFAIK ...
2
votes
0answers
127 views

mozilla sync server and mysql auth

Recently I updated my debian squeeze to wheezy. Unfortunately my firefox sync server (weave) stopped working. I saved the config files and downloaded the new version via hg. I already fixed some ...
1
vote
1answer
236 views

Python Web interface for simple mysql database

We need a new web interface for our internal car booking system, which is implemented in mysql database. Could somebody please advise, what would be a suitable solution (which framework, if any). The ...
1
vote
1answer
99 views

mysql database dump script adding fuctionality to skip dumped database

I'm using the following script to dump my database. it works great. I want to add functionality that it first checks if a database table is already dumped or not, if a dump exists then it should be ...
0
votes
2answers
42 views

MySQL exact path

I am using whereis mysql in my terminal to get exact location of my MySQL installation, but it's showing too many locations: mysql: /usr/bin/mysql /etc/mysql /usr/lib/mysql /usr/bin/X11/mysql ...
1
vote
1answer
2k views

How to install phpmyadmin 4.0 on Debian

Is there a way to install an up-to-date phpmyadin on Debian Squeeze via apt-get? I only found a PPA for Ubuntu on the PMA download page
2
votes
1answer
67 views

strings command printing some extra characters

I am trying to capture mysql traffic using tcpdump and converting it to text using strings command, but while capturing mysql traffic, I am getting some extra character at the end of each character. I ...
1
vote
2answers
2k views

df command not showing correct values

This is a RHEL server, I'm running a MySQL server on it, the database and log files (however, logging is disabled) are located on the /srv directory where plenty of space is available. Recently I had ...
1
vote
0answers
82 views

Data loss prevention ( or recovery) in a MySql db in embedded systems

I have a little ( big ) problem with a MySql application that write on a SD card or a Compact Flash. After a data loss ( a power failure , for example) , if I try to retrieve the data of my db , it ...
0
votes
1answer
98 views

Catch all emails and save them in MySQL

I want to do something like Facebook has with it message system. When you reply to email sent from Facebook User, it automatically gets in his message box. This is done, because you reply to ...
0
votes
3answers
167 views

Brand new to Linux - running a web server/database server, need to connect to my servers- how?

I am brand new to Linux. I have a database server and web server both running CentOS. My database server will host MySQL and my web server will host Apache. I am very familiar with Windows and ...
0
votes
2answers
695 views

How to install MySql on Red Hat 6.1?

I am trying to install MySQL-server-5.6.12-1.el6.i686.rpm on a Red Hat Enterprise 6.1 server. I receive the following error: rpm -Uvh MySQL-server-5.6.12-1.el6.i686.rpm error: Failed dependencies: ...
0
votes
1answer
336 views

Connecting from OpenVPN Server to MySQL Server

I have an OpenVPN server installed on a server. What I'm trying to do connect from the OpenVPN server using the mysql client to the MySQL server than is connected to the OpenVPN server using a ...
0
votes
2answers
98 views

Open source MySQL performance tool

Are there any open source MySQL performance tools to help optimize SQL queries?
1
vote
1answer
153 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
1answer
31 views

Searching multiple mysql tables for the same 2 fields in each table

I am trying to figure out how to search mysql tables for the same 2 fields. What I have is 2 tables in the same database. Below is what I have currently:- single search works ok SELECT * FROM ...
4
votes
4answers
4k views

How can I check if mysql is installed using a bash script?

I need to check if mysql is installed from within a bash script. What would be an efficient way of doing that? I thought I could do this: if [ ! -f `which mysql` ] ; then echo "foo" fi But I ...
2
votes
3answers
306 views

Do I need to stop processes like mysql or apache before “reboot”?

I have been wondering if issuing a reboot command safely stops running LAMP processes like MySQL or Apache?