0
votes
2answers
54 views

Using Jenkins to access mysql files on the same instance

I have a Jenkins installation and running mysql server on the same box. One of my jenkins jobs is supposed to tar up the /var/lib/mysql folder but I get the following error tar: ...
0
votes
1answer
68 views

Debian mysql-proxy reserved connections

I was looking in too the mysql-proxy configuration, and decied to install it in order to make an access point to my servers whenever they reach high peak, however i want to have 5-10 reserved ...
0
votes
1answer
40 views

mysql with dom and sd cards loss data

I have a 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 fails and the error ...
0
votes
1answer
65 views

Table Locking - Large number of inserts - How do I identify the source of the inserts?

I usually post on Stack Overflow, but I think this may be the more appropriate forum for this question.... I have a dedicated server that servers several million pages monthly. We use LAMP. We're ...
1
vote
1answer
171 views

IPTables preventing remote connection to MySQL

My table rules: sudo iptables -L --line-numbers Chain INPUT (policy ACCEPT) num target prot opt source destination 1 ACCEPT tcp -- anywhere anywhere ...
0
votes
1answer
210 views

Upload database backup from mysql to Amazon S3 or Glacier without creating local file

Is there a tool that makes possible to backup a Mysql database to Amazon S3 or Amazon Glacier without having o create a local file with the database contents? Something like that: mysqldump -u ...
1
vote
0answers
487 views

MySQL crashes when connecting from localhost with tcp (UNIX sockets work)

I have Ubuntu 12.04 running MySQL server 5.5.24. I can connect with mysql --user root -p. status shows me : ... Connection: Localhost via UNIX socket ... When I try to connect with mysql --host ...
1
vote
1answer
1k views

Setting up PHP 5.4 with MySQL to use Unix Sockets

I've compiled PHP 5.4.5 from source, and I've installed nginx 1.2.1 and mysql 5.1.63-0ubuntu0.11.04.1 from apt-get on my Ubuntu 11.04 LTS server. I installed nginx using this: add-apt-repository ...
4
votes
1answer
52 views

Discrepancy between size of database listed in Unix and Mysql

When I see the size of my db_1 its listed as only 4k. But when I show table status for db_1, I see that the total size is approximately 3.7 GB based on data length. Why is there this discrepancy? ...
1
vote
1answer
186 views

mysql command line show statements a sql script executes?

I'm a long time postgres user, but am now looking after maintenance for mysql databases. One thing that I'm used to from postgres, is when you run a sql script it will output on the command line what ...
0
votes
3answers
270 views

Database server, Webserver - RAM versus Server Load relationship between servers

We have a website running on 2 servers: 1 database server, 1 webserver. Our understanding was that we had 4GB RAM on the webserver and 8GB RAM on the database server. The site is database intensive ...
3
votes
1answer
884 views

Which sql queries are using so much cpu?

I have an app with a lot of different queries all over the place. I'm getting spikes in CPU usage from mysqld which is maxing out my server and I'm not sure which of the many queries is doing this. ...
0
votes
1answer
83 views

mysql not started automatically upon server reboot

mysql not started @ server boot automatically but I can start manually as long as log as user "mysql" by using "/etc/init.d/mysql.server" the error I got on the log is 110809 9:16:21 InnoDB: ...
1
vote
4answers
419 views

Unix command to download a file off my server?

I have a few php files on my server that I created and I'd like to download them to this computer for backup purposes. Is there an easy way to do this? (I'm connected to my server via SSH). Also, are ...
0
votes
2answers
191 views

MySql does not start on Debian 5 VPS server

I have a 128MB RAM VPS server. I have Debian 32bit OS running on it and I have decided to install some light weight LAMP, so I installed lighthttpd and MySQL but then it had to be started It said it ...
0
votes
3answers
285 views

How to connect with MySQL server if it won't connect via the socket?

I have an account on a shared server. I have jailshell access and also PhpMyAdmin. I want to run mysql commands via SSH but I'm getting an error: $ mysql -u mySqlUser -p mySqlPw Can't connect to ...
-1
votes
1answer
1k views

Connecting to MySQL Server from PHP Command Line (MAMP)

First of all, I'm using Mac OSX 1.6, MAMP 1.9, PHP 5.3.4, and MySQL 5.1.44. I'm in the process of setting up a video encoding service for a site using Chris Boulton's PHP-Resque and Redis. Once the ...
0
votes
2answers
61 views

mysql and unix users control

Let's say I have two users on my UNIX machine - user1 and user2. I also have two MySQL databases - db1(mysql_user1) and db2(mysql_user2). I want to prevent user1 from connecting to db2 even if it ...
4
votes
9answers
2k views

How can I test the security of my server?

How can I test the security of my server ? Please I know it is too general question. But I was wondering if there is a tester software or web service checking all ports of your server, or possibly ...
0
votes
1answer
77 views

binding unix user to mysql

I am just asking myself if it is possible to bind unix users to mysql. So that I can bind databases to users or groups known by unix. Thx, Axel
2
votes
2answers
172 views

tunnel ssh for a mysql connection

I need to do an ssh tunnel to connect to a mysql server. if i do : me@local> mysql -h host -u user -p pwd I get a 100 error I have an ssh account on a distant server and this command works : ...
1
vote
1answer
239 views

MySQL: Not much activity, but thousands of network connections remain in TIME_WAIT"

We are running MySQL 5.1.33 on FreeBSD 7.2-RELEASE. This is a development database server attached to a development webserver running Silverstripe and PHP 5.3. This morning, the development ...
1
vote
1answer
3k views

Failed depencies: libmysqlclient.so.16 is needed

I'm trying to install something on my server that requires mysqlclient, but looking at my RPM package list I have it ("MySQL-client-5.0.91-0.glibc23"). Doing a locate on libmysqlclient gives me this: ...
1
vote
1answer
171 views

mysql & maatkit: What kind of blocking will mk-table-checksum do?

We have two MySQL servers set up with simple master-slave replication. We currently use all MyISAM tables, but may move to InnoDB in the future. Our largest tables are more then 2GB. I would like to ...
1
vote
1answer
956 views

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

Can someone please help as i've spent all day trying to fix this. I installed the latest XAMPP and now i can't connect to mysql from terminal.I checked my .profile file and the PATH seems ok. Does ...
1
vote
2answers
2k views

Can someone help me install MYSQL server pelase? This is bugging me

$ sudo aptitude install mysql-server Reading package lists... Done Building dependency tree Reading state information... Done Reading extended state information Initializing package states... Done The ...
1
vote
2answers
900 views

How do I make sure that BOTH my server and MYSQL have the same timezone?

Because when I create a time in Python scripts..I want it to match MYSQL's time. How do I make BOTH of them pacific time?
1
vote
2answers
116 views
4
votes
6answers
9k views

How to check what port mysql is running on

On my windows dev box mysql is running on port 3306 How can I check what port it is running on the unix server that I have to upload the app to.
0
votes
1answer
818 views

Why can't I successfully install mysql server?

It's very easy. All I want to do is this: aptitude remove mysql-server mysql-server-5.0 --purge aptitude install mysql-server But when I try to run that I get this error: root@db2:/etc# aptitude ...
2
votes
2answers
583 views

A more useful MySQL Query log that's suitable for tail -f'ing

In order to debug a webapp and mysql queries, I've enabled the mysql query log. However it's not a very good format to tail and grep through. Ideally I'd like to be able to only show queries from a ...
0
votes
2answers
515 views

Why can't I uninstall mysql completely? look! it's still there

root@db2:/var/log/mysql# aptitude remove mysql-server --purge Reading package lists... Done Building dependency tree Reading state information... Done Reading extended state information Initializing ...
0
votes
1answer
97 views

Why is it that during my replication (master-slave), it keeps inserting data, then deleting data, then inserting data?

I followed this tutorial for master-slave replication: http://www.howtoforge.com/mysql%5Fmaster%5Fmaster%5Freplication Basically, this is what I did. Uninstalled mysql on both servers. Installed ...
0
votes
8answers
4k views

What could be eating up my entire hard drive space ? (650GB)

I only have a database , which is around 40G. I did have some problems with replication earlier....could it be some sort of log/files that are eating it up? How do I check why the space is taken up? ...
0
votes
3answers
357 views

Why is my RAM (16G) being completely used up?

When I do "top", I only see that mysqld is using 70% of Memory. Nothing else. Why is it being used up?
0
votes
4answers
88 views

What is the best way to set up a master-master rig?

Because everyone says master-master is not recommended. But if you think about it...1 write server is hardly enough! So, how would you set it up (high-level, not tutorial-level) so that it works out ...
0
votes
3answers
2k views

Cannot install MYSQL using aptitude…can anyone tell me why?

It just stops and freezes after this. The following packages will be upgraded: libmysqlclient15off mysql-client mysql-client-5.0 mysql-common 4 packages upgraded, 4 newly installed, 0 to ...
0
votes
1answer
779 views

MySQL auto-increment problem on master-master replication , and the logic to solve it

I had a auto-increment duplication issue for master-master replication. Then, I set: SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 99999; This skips 9999 queries. Then I did: SHOW SLAVE STATUS\G ...
0
votes
1answer
8k views

How do I uninstall MySQL completely?

remove ALL settings. remove ALL databases. remove ALL replication settings. WHat command do I run to remove that?