An open-source, relational database management system.

learn more… | top users | synonyms

0
votes
1answer
207 views

Wordpress won't recognize the MySQL database

I want to install Wordpress on Archlinux but I have this error: Your PHP installation appears to be missing the MySQL extension which is required by WordPress. I un-commented this line in ...
1
vote
1answer
41 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 ...
14
votes
2answers
926 views

Will my MySQL query continue to run even if my ssh connection drops?

I've connected to a server over SSH and logged in to mysql, and asked it to run a query (the results of which are dumped into a CSV) that could take well over an hour. Although I have instructed my ...
1
vote
2answers
349 views

MySQL refuses to uninstall

apt-get remove mysql-server Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: ...
0
votes
0answers
38 views

Help required for LAMP Stack fail-over Configuration

I am using cloud servers of digital ocean for last some months. Recently One of my cloud servers disappeared from panel with backups @ ubiquity, the server co guys put it back after 1 day. However my ...
2
votes
2answers
2k views

Problem Starting MySQL on new Centos 6 build

I have a VPS with ChicagoVPS that's running Centos 6. Official version of the build is: Linux RedHat 6.5(Final 2.6.32-042stab078.26 x86_64) I followed this guide to add the repository and ...
1
vote
2answers
433 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 ...
3
votes
2answers
119 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
96 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 ...
1
vote
2answers
132 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 ...
2
votes
1answer
152 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
884 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
1answer
679 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: ...
1
vote
1answer
1k 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
45 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
0answers
231 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 ...
4
votes
4answers
316 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 ...
0
votes
2answers
844 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
231 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
2answers
28 views

mysql USER unclear about what can be dropped?

When show databases there is the information_schema below it listing my created databases but what is 'USER' and 'mysql' listed in there? I don't know if ages ago I made a mistake and created them ...
0
votes
1answer
486 views

Create multiple databases in one command line?

Can this command be scripted? $ mysqladmin -u username -p create databasename I'd like to do it for multiple names all at once? Also I'd like to then set permissions for all of them at once as ...
0
votes
1answer
183 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( ...
4
votes
3answers
510 views

rlwrap: mysql autocompletion not working

Normally, autocompletion works fine in mysql command-line client (mysql-client-5.5). I have a table called booking. When I type the letter b and pres TAB the name of my table gets autocompleted: ...
1
vote
0answers
42 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 : ...
1
vote
1answer
188 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 ...
2
votes
1answer
135 views

Is it possible to import vmail folder from old iRedMail to new iRedMail installation?

Basically, what I did: Copied vmail folder to my local machine. Reinstalled my VPS. Installed iRedMail again. Created same users on the same domain. Question is - can I somehow copy over my old ...
3
votes
1answer
2k 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
110 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
318 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 ...
1
vote
1answer
325 views

ERROR: could not find driver after changing from mysql to mariadb

mysql was working fine but I wanted to give mariadb a try on a new server I have going. However I am having an issue where all my php websites seem to have issues communicating with mariadb. Webmin ...
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
1k 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
579 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
75 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
63 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
67 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
319 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
201 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 ...
1
vote
1answer
650 views

How can I install mysql on an angstrom distribution?

I tried using a different distribution (debian) but the rest of my application did not work. I've tried opkg install mysql-client and opkg install mysql-server however I get the error Unknown package ...
1
vote
1answer
321 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 ...
2
votes
0answers
136 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
118 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
48 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
3k views

How to install phpmyadmin 4.0 on Debian

Is there a way to install an up-to-date phpmyadin on Debian via apt-get? I only found a PPA for Ubuntu on the that you can install with sudo add-apt-repository ppa:nijel/phpmyadmin apt-get update; ...
2
votes
1answer
92 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
0answers
99 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 ...
1
vote
2answers
4k 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 ...
0
votes
1answer
174 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
1answer
671 views

mysql different users access

I have six different sites set up with their respective databases on my server all linking to one localhost ip. Three of those users I set up from root have access only to the one database associated ...
0
votes
3answers
209 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 ...