An open-source, relational database management system.

learn more… | top users | synonyms

0
votes
1answer
178 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
108 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
1answer
614 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 ...
0
votes
1answer
670 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
2answers
851 views

Run mysqld_safe in background

I have a bash script that installs mysql for me. One line, that executes mysqld_safe, makes the script to hang - it won't continue to the following code. Obviously there's ampersand at line's end, ...
0
votes
1answer
1k views

What caused my CentOS 6.4 box to reboot itself?

I noticed that the MySQL daemon running on my CentOS 6.4 machine was suddenly not running anymore. I checked the MySQL log, but didn't see anything relevant: 121229 22:17:45 mysqld_safe mysqld from ...
0
votes
1answer
193 views

bash script that shows mysql innodb log file size

I am creating bash script that gives me size of mysql innodb log file in MB. Currently I am getting its output in bytes. Please check it out following script and help to get output in MB. #! /bin/sh ...
0
votes
1answer
32 views

Only value required using mysql command

I created following command to get value of Innodb_data_writes using command show status in mysql database. mysql -u root -p**** -e "show status" | grep Innodb_data_writes Current Output: ...
0
votes
2answers
103 views

Open source MySQL performance tool

Are there any open source MySQL performance tools to help optimize SQL queries?
0
votes
0answers
120 views

Failure to install MySQL

I attempted to install MySQL using Synaptic but it failed to start on update with the following output: Selecting previously unselected package mysql-client. (Reading database ... 131143 files and ...
0
votes
3answers
582 views

recreate mysqld file centos

I have tried installing mysql several times but keep getting this error: mysqld: unrecognized service I've tried: yum remove mysql-server yum remove mysql yum remove MySQL-* then yum install ...
0
votes
2answers
2k 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 ...
0
votes
2answers
501 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 ...
0
votes
1answer
836 views

How to easily maintain the latest versions of Apache/ MySQL/ PHP on CentOS 6.2?

We have a few servers running CentOS 6.2 deploying web applications using Apache/ MySQL/ PHP. In the past we've just regularly run "yum update" to keep all the software up to date. As of right now ...
0
votes
2answers
3k views

MySQL table is repeatedly crashing

I have xen virtual machine (Debian stable in PV mode) and I've Joomla on it. Several times in a day I see this message on the front page of my site. jtablesession::Store Failed DB function failed ...
-1
votes
1answer
7k views

Should the mysql user have access to /var/lib/mysql?

First, let me say that mysql seems to be working perfectly on the machine. Still, when I su mysql and ls /var/lib/mysql, I get access denided. When I sudo ls /var/lib/mysql I see the data files ...
-1
votes
1answer
74 views

Why sudo ./bin/mysqld_safe & on Mac OS X 10.6.8 doesn't ask for password?

I get the following permissions from terminal: $ cd /usr/local/mysql $ ls -l drwxr-xr-x 41 root wheel 1394 29 Apr 00:55 bin drwxr-xr-x 4 root wheel 136 29 Apr 00:55 docs ...
-1
votes
1answer
90 views

mysql access denied

Trying to find a way in by going through checklist of possible reasons I am locked out of mysql and one, I read, is to determine if I have grant tables. -bash-4.1# cd /var -bash-4.1# ls cache empty ...
-1
votes
2answers
170 views

Copyed mysql files from previous system now error while connect, what to do?

Fist of all I have the files but the old system is gone. I took the folders in /var/lib/mysql/ and gave then the permissions the mysql folder that was in there had. user mysql group root only ...
-2
votes
2answers
470 views

Linux distrib with apache and mysql pre installed [closed]

Is there a Linux distro with apache and mysql pre installed? I just want a light and fast installation of apache + mysql + ftp server + phpmyadmin
-2
votes
0answers
20 views

using mysqlimport on a large amount of csv files in a directory via bash scripting [on hold]

I have a directory with approximately 75 csv files in it that I need to mysqlimport into a MySQL database. The MySQL database does not have the tables created. The files: * The data is all numbers ...
-2
votes
1answer
227 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 ...
-3
votes
1answer
195 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 ...
-3
votes
3answers
2k views

What mysql command can show me the tables in a database and how many rows there are? [closed]

is there a mysql command that will show me the tables and how many rows they have in them?