An open-source, relational database management system.
3
votes
0answers
38 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":
...
1
vote
2answers
32 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 ...
0
votes
0answers
40 views
dependency problems prevent configuration of mysql-server
This question has been asked verbatim about a dozen times on this forum, and yet none of the solutions have worked for me.
I'm trying to install mysql and everytime I try to install I get this ...
2
votes
1answer
56 views
mysql replication not working
I have two servers A and B I tried to setup replication between two servers for fixed dbs DBA and DBB but it's not working my configurations Tables are not getting updated why??
Master:(/etc/my.cnf)
...
0
votes
0answers
55 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 ...
3
votes
0answers
65 views
MySQL stop/waiting issues; “can't connect … through socket”
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 ...
0
votes
0answers
28 views
proftpd mod mysql
I've setuped a proftpd server on a distant host. I made it work in some simple way, actif mod, with unix user, blocking user in /var/www. It was working nice, but now I need the mod sql (package ...
2
votes
0answers
46 views
No communication services enabled following startup
I recently installed Parsix (Debian) on my system, and I've been struggling to figure out how to autostart my services. Of the list of services that don't run and should run are:
ssh
apache
mysql
...
4
votes
1answer
79 views
MySQL server-id not being set with Fedora 16
I am setting up a mysql slave on a Fedora 16 system, and the server_id is not being set properly. My /etc/my.cnf is:
[mysqld]
server-id=16
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
...
0
votes
1answer
25 views
Mysql LOG only specific users
I need to set up some logging on my debian squeeze x64 mysql 5.1 Server:
1) logging when users logged in and logged off
2) logging only specific users commands
set up logging which will not slow ...
0
votes
3answers
93 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
1answer
106 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
126 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
2answers
50 views
How to dump mysql dbs in live boot
I can't log in to my fedora linux because of I/O errors(system halts after grub). Now I want to create a backup from my mysql databases. I tried chroot /path/to/root and then mysqldump, but I get the ...
0
votes
1answer
37 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 ...
0
votes
2answers
84 views
phpmyadmin is listing my server version and client version as being different
In a continuation of this question, I have purged the 5.1 client via sudo apt-get purge mysql-client-core-5.1. I have reinstalled the 5.5 client - sudo apt-get --reinstall install mysql-client-5.5 ...
1
vote
1answer
86 views
Mint 12 - Error updating MySQL (mysql-client-core-5.1)
I have MySQL 5.5 installed via packages.dotdeb.org. When trying to update 5.1, which is also installed, I get the following error:
E: ...
1
vote
2answers
139 views
Using a lua rock installed with luarocks
I wanted to install luasql.mysql with luarocks, and I've ran into a problem. Even though the packages were installed providing mysql.h, luarocks couldn't find it. I solved it eventually:
luarocks ...
1
vote
2answers
68 views
Import sql files using xargs
I have a number of sql files to import. For a single file I use the following command:
mysql -u root -p dbname < db.sql
Is it possible to use xargs to bulk import all files? something like:
ls ...
0
votes
1answer
154 views
Debian Squeeze/MySQL error
I am a Unix/Linux noob, so please bear with me.
I installed lighttpd and PHP on MySQL using the instructions in the accepted answer here:
...
2
votes
2answers
211 views
Building MariaDB 5.5.27 without OQGraph: How to deselect the plugin?
I'm trying to build MariaDB 5.5.27 from source. In fact, I just need the client, but I seem to have to build the complete database system anyway.
While configuring with cmake and later compiling with ...
1
vote
1answer
342 views
update mysql on debian
I'm trying to update Mysql on debian without success, and all tutorial on internet just fails.
I got Debian 6.0.6 squeeze, my mysql version is mysql Ver 14.14 Distrib 5.1.63.
I did apt-get update and ...
2
votes
2answers
447 views
MySQL Linux Client Timeout/Keepalive
Is there a way to set a keepalive in the command-line MySQL client on Linux?
Our network recently moved to a VLAN setup, and our systems department no longer has control of the firewall. The ...
3
votes
2answers
190 views
MySQL 5.1 to 5.5: all UTF-8 characters lost!
I decided to upgrade my Debian installation, and after some days using MySQL 5.5, I found that mysql prints garbage to the terminal intead of UTF-8 characters.
I had a look at the SQL file that was ...
6
votes
1answer
140 views
/etc/passwd sql with bash access
I just got a CentOS VPS and was reviewing the passwd file and saw this:
mysql:x:498:499:MySQL server:/var/lib/mysql:/bin/bash
Is bash necessary for mysql?
1
vote
1answer
182 views
AutoMysqlBackup --lock-tables=false
I'm trying to use AutoMysqlBackup script to perform daily backups of my application.
Unfortunately on the first try it didn't served me how I thought it would.
I believe that the script has used the ...
1
vote
2answers
414 views
MySQL not getting started on linux
I need to run MySQL service for my linux 2.16 version with SUSE version 11 distribution.
Downloaded the following files and installed all the rpms as under:
MySQL-server-5.5.27-1.sles11.i586
...
1
vote
2answers
130 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
2answers
252 views
Import single rows from SQLite to MySQL?
I need to do some kind of incremental import again and again from a SQLite 3 database to a MySQL database. Column names are the same in both databases. Is there a good way to do this by a script ...
1
vote
2answers
104 views
How do I set the mysql server character set in FreeBSD 8.2?
My mysql server's current server character set is latin1. My server is started on startup via rc.conf setting mysql_enable="YES". How to set my server to use utf8 as the server character set?
0
votes
0answers
100 views
DP: Apache Web Server character encoding [closed]
I'm double posting because I think U guyz may have a clue:
http://serverfault.com/questions/423663/apache-web-server-character-encoding
10x
0
votes
1answer
135 views
Force users to change email password every six months
I'm going to build an experimental mail server with Postfix + Dovecot and Mysql for user accounts.
The server will offer SMTP + POP3 + IMAP.
Is there a way to force users to change their mail account ...
1
vote
0answers
107 views
Force mysqldump encoding
I have two mysql servers, viewed from the same mysql client, right_server is rendering the french characters correctly, wrong_server is not. Encoding is the same :
$ mysql -h right_server -NBe "SHOW ...
3
votes
3answers
234 views
Encrypt a password the same way mysql does
I've created a user ... but forgotten the password
mysql> create user 'blayo'@'%' identified by 'right';
Which Linux command line tool can encrypt the password the same way mysql 5.5 does ?
...
1
vote
1answer
138 views
Convert mysql count(*) to int in bash?
I'd like to execute this and check if count is 0, 1 or > 1 in bash.
mysql -e "select count(*) from mydb.mydb;"
The output is:
+----------+
| count(*) |
+----------+
| 0 |
+----------+
I ...
1
vote
2answers
139 views
How to allow mysql remote connections via particular interface
I have a 10.237.49.251 IP on eth0 and another IP on another interface
How do I enable remote mysql calls on eth0 device?
3
votes
2answers
218 views
Error establishing a database connection; how can I determine whether or not these connections are real?
I've just run into a problem today with MySQL reaching its database connection capacity.
The error I'm receiving is, Error establishing a database connection. When I try to access /phpma, I get this ...
1
vote
1answer
463 views
How to fix this mysql permission problem?
I'm trying like mad to get rails dbconsole to work (Rails 3.2.6, if that helps). The problem is that when I run the command, I get:
gems/railties-3.2.6/lib/rails/commands/dbconsole.rb:81:in `exec': ...
1
vote
2answers
263 views
Trying to create tunnel to mysql through SSH
Im in a bit of a bind here. I have a client that want's me to set up his website, but he runs the server w/ SSH and CentOS 6.2 as it's OS.
Now, I'm trying to add the sql server on Mysql Workbench for ...
0
votes
3answers
112 views
Why “Linux Generic” use RPM extension in MySQL download page?
I need to install MySQL 5.5 from source in Ubuntu 10.04.
So I'm trying to find tar.gz source from here.
But when choosing "Linux Generic" from the drop down menu, it is showing an RPM extension
I ...
0
votes
0answers
255 views
Installing MySQL complete? [closed]
How I can install mysql in ubuntu 12.04(gnome 3). So that I will have my mysql installation in /usr/bin/mysql
It's library and header files in /usr/lib/mysql and /usr/include/mysql respectively.
...
3
votes
3answers
268 views
How to force rpm to check dependencies during upgrade?
We have a current version of our software that has a dependency on MySQL 5.1 and this is specified in the RPM requires.
For our new version, we now require MySQL 5.5 and specify this in the RPM ...
2
votes
3answers
1k 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 ...
1
vote
1answer
170 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 ...
0
votes
3answers
1k views
Where, in automysqlbackup, do I add mysqldump parameters?
How to stop automysqlbackup's cron.daily script -- as installed and configured from apt-get install automysqlbackup -- throwing the following error:
mysqldump: Got error: 1142: SELECT,LOCK TABL ...
1
vote
1answer
324 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
...
6
votes
2answers
179 views
Back up mysql server
I want to backup all databases, users and etc on our mysql sever.
I have come across the command mysqldump and believe I can use it like this? (Trying to backup a REMOTE server to our LOCAL machine)
...
0
votes
1answer
497 views
Install Mysql 5.6.4 or greater on web server with on CentOS / openSUSE with Plesk 10
I need to install MySQL 5.6.4 or greater on my web server because I'm using the full text innodb feature. I'm trying to move my local installation (WAMP server) to my dedicated server and I'm not able ...
7
votes
5answers
1k views
Fedora 16 strange /tmp permissions: mysqld will not start
I installed mysql on a brand-new Fedora 16 server and it would not start. This is the line from the log file (^G and all):
^G/usr/libexec/mysqld: Can't create/write to file '/tmp/ibNPyIlu' (Errcode: ...
2
votes
2answers
378 views
Get a progress indicator when importing mysql databases
I often import MySQL databases, and this can take a while. There is no progress indicator whatsoever. Can one be shown, somehow? Either records imported, MB imported, or tables imported... anything is ...
