An open-source, relational database management system.
1
vote
2answers
179 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
268 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
148 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
120 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
165 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
119 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
280 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
208 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
211 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
250 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
571 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': ...
2
votes
2answers
271 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
140 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
342 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
333 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
2k 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
184 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
2k 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
432 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
205 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
592 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
2k 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: ...
3
votes
2answers
499 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 ...
8
votes
1answer
414 views
MySQL gets killed by OS every 25 days or so
About 4 months ago we migrated from MS SQL Server to MySQL 5.5. Since then we have been experiencing an issue once approximately ever 25 days since where CentOS runs out of memory and as a result it ...
1
vote
1answer
162 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
0answers
674 views
Fedora Failed to get D-Bus connection
I have a VPS with fedora 16 installed. I have setup mysql and it was working a couple of days ago.
Now suddenly when I try to start mysql I get the error:
Failed to get D-Bus connection: Failed to ...
0
votes
1answer
141 views
How to use a password as an external variable in shell?
I have this MySQL backup script that I use to back up MySQL databases. Very useful, and it runs on fixed intervals using a cron. However, I need somehow provide this script with the MySQL password. ...
4
votes
3answers
2k views
Will yum remove mysql-server delete my databases?
My MySQL server has broken down, and I can't figure out why. Trying to do a yum reinstall I get this: Error: mysql-server conflicts with mysql-server
I figure that's because the server already had ...
1
vote
2answers
403 views
How would I direct local(127.0.0.1) MySQL traffic to an external SQL server?
Basically, I have two EC2 instances on Amazon Web Services. They are both running Ubuntu 11.10 x64. They both have a private and a public (Elastic) IP addresses. I'm having trouble setting up iptables ...
1
vote
2answers
311 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
2answers
75 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).
2
votes
1answer
381 views
How to script a database migration using SSH?
I am trying to create a sync.sh script that coordinates with our less-than-ideal version control for our website. This script will migrate a copy of the live database to our local development ...
0
votes
1answer
272 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
2answers
2k 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 ...
4
votes
5answers
478 views
Multiple ssh sessions in single command
I'm trying to copy a database from one server to another. I tried using the following command and it's getting tied up on entering the ssh passwords. If I put in one server's password, it complains ...
0
votes
1answer
232 views
Installing glibc 2.3 for mysql server
I need to install mysql server and client for a project of mine so I downloaded the MySQL-client-5.1.61-1.glibc23.i386.rpm for the client and MySQL-server-5.1.61-1.glibc23.i386.rpm for the server.
I ...
0
votes
1answer
459 views
Error compiling OSSEC HIDS with Mysql support
I work with OSSEC HIDS In Ubuntu 11.10 from the instructions on the OSSEC wiki.
When I install with mysql support, I get this error
/tmp/ccuS4FYw.o: In function mysql_osdb_connect': ...
0
votes
1answer
611 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 ...
1
vote
1answer
377 views
How can I determine the connection method used by a MySQL client?
When using a MySQL client (e.g. mysql) how can I determine whether it connected to the server using a Unix socket file or by using TCP/IP?
1
vote
1answer
848 views
Why don't I see the XAMPP page on Linux Mint?
I am trying to install PHP MySQL on Mint 12. I downloaded and installed XAMPP. According to the tutorial, when I go to localhost in a browser I should see this:
Instead, I see:
It works!
This is ...
4
votes
1answer
101 views
If I'm logged in as root, how do I restart mysql or apache with options?
I know the commands to restart/stop/start, but when I try to pass options it doesn't seem to work!
CENTOS 6, MySQL 5.14
service mysql restart
service httpd restart
Then I tried this:
...
2
votes
0answers
640 views
MySQL socket and PHP (and other languages)
Background info
I'm currently running CentOS (or Red Hat?).
uname -a gives (I edited out my domain name)
Linux XXXXXXXXX.com 2.6.32-71.29.1.el6.x86_64 #1 SMP Mon Jun 27 19:49:27 BST 2011 x86_64 ...
0
votes
1answer
1k 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 ...
3
votes
1answer
821 views
How to enable an federated storage engine in the Debian MySQL package?
How would I enable an extra (in this case FEDERATED) storage engine in the mysql-server-5.1 package from Debian?
I've installed mysql-server-5.1 via apt-get. But the SHOW ENGINES shows that federated ...
0
votes
2answers
276 views
How do I install software on Fedora 13?
I installed Fedora 13, but it doesn't come with a lot of software I want -- office tools, productivity, GUI environments, MySQL, and Kamailio. How do I get all this stuff onto my Fedora install?
1
vote
2answers
877 views
How to grant a “no-root-user” rights to start/stop/restart mysql server on suse machine?
Is it possible to grant priviliges to a "no-root-user" to start and/stop/restart the mysql server on a suse machine?
The goal is to make it for a developer possible to tune a mysql server/database ...
3
votes
1answer
4k views
How can I completely reinstall mysql?
I had to reboot in the middle of a large data import. I only have one mysql database, which has now been corrupted.
How can I completely remove mysql and reinstall it? I've tried apt-get purge ...
1
vote
1answer
1k views
Brute force access to a Firebird database?
Ok, so here's the deal. When migrating a certain product with terrible documentation to another database type, my Firebird database was deleted. I then proceeded to recover it from the filesystem ...
2
votes
0answers
291 views
Can't make a copy of /var/lib/mysql/ibdata1
I have a RedHat Linux server and I'm trying to make a copy of /var/lib/mysql/ibdata1, but I'm receiving an error saying permission denied and the file cannot be opened.
I'm logged in as root user and ...
1
vote
3answers
593 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 ...
