MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

-1
votes
1answer
250 views

win 2008 server: mysql password?

I've just installed php on my win 2008 server using the web platform manager and installed phpmyadmin. I've configured phpmyadmin using a username/password but I'm getting an #1045 error, so I assume ...
6
votes
2answers
781 views

Ubuntu MySQL GUI logins with certificate/key

I will connect to MySQL on ubuntu cloud server everyday with Mysql Administrator and Mysql Query Browser GUI tools and I feel very slow in responding. I know it is possible to connect with ssh ...
2
votes
5answers
953 views

Track resource usage on Ubuntu server while I'm sleeping?

I've got a pretty typical LAMP server running a web site but sometimes, during the night, resource usage skyrockets and the site becomes unresponsive. There are a lot of logged errors about being ...
9
votes
2answers
321 views

My server setup for a heavily used API

I will soon be buying a bunch of servers for an application that I am about to launch but I have concerns about my setup. I appreciate any feedback I get. I have an application which will make use of ...
1
vote
1answer
902 views

Is there a MySQL engine for in-memory tables that support row locks?

The default MySQL in-memory engine only supports table-locks. This is killing our performance on our session table (using Joomla on the front-end). Is there a (third-party) engine of an in-memory ...
4
votes
4answers
4k views

How to backup big MySQL database on Linux

I want to backup MySQL database which is around 200GB. How should I do it? Using mysqldump - I feel backing up 200GB database on which there are continuous writes are going on. Is it a good idea? I ...
3
votes
2answers
2k views

How to adjust MySQL performance

I'm facing a real problem with MySQL instance for a service online. We use hibernate and c3p0 pool with these settings: c3p0.max_size=200 c3p0.min_size=5 c3p0.timeout=60000 c3p0.max_statements=20 ...
2
votes
2answers
702 views

MySql raw binary data files copy 5.0 > 5.1

We are in the process of preparing a data migration of some fairly big DB (200GB), InnoDB tables from our old server to the new servers. The data is very index heavy and trying to migrate the data via ...
0
votes
3answers
2k views

Virtual IP or Load balancing for a http/ mysql cluster

First of all i have to say i'm very very newbie as sysadmin. I'm trying to do someone else's work, and i have almost 0 experience in clustering / load balancing and related stuff. This is the ...
4
votes
3answers
7k views

Automated failover strategy for master-slave Mysql replication - why would this not work?

I'd like some feedback about this failover strategy for a couple of MySQL servers I'm speccing up for a cluster, and I want to check if there's something obvious I'm not missing here. One app server ...
0
votes
1answer
260 views

Dovecot SQL authentication: How to differentiate between IMAP and POP3 access?

We are running courier currently which enables us to set different SQL userdb queries for IMAP and POP3. We need this because we do not want to give all users IMAP access, a boolean column in the ...
0
votes
2answers
614 views

Wordrpress with PHP 5.3

I'm trying to install Wordpress 3.1 on PHP 5.3 (under IIS 7.5), but before getting to the configuration page it's throwing this error: Your PHP installation appears to be missing the MySQL extension ...
0
votes
1answer
2k views

where can I find mysql_install_db for Mac

I have downloaded mysql-advanced-5.1.46sp1-osx10.6-x86_64.dmg and installed it. I have a custom my.cnf file and no data to begin with. I dont see mysql_install_db any where. How can i install one. ...
0
votes
2answers
1k views

Plesk broken after MySQL upgrade [closed]

I have a Virtuozzo VPS on a CentOS 4.4 box running Plesk 8.6. I upgraded MySQL from 4.1 to 5.0, but I had to use rpm -Uvh --nodeps to get around some Plesk packages that were dependent on ...
0
votes
1answer
109 views

MySQLDump backup a MySQL containing table of different charset

If a database contains contains table of different charset, what should I do in order to have them appear in a single file? or is it possible?
1
vote
1answer
339 views

MySQL InnoDB random data corruptions: hardware or software errors?

I'm an administrator of a social game which uses MySQL(Percona 5.1.56 to be precise) for data storage(all tables have InnoDB type). There are about 2 millions of players in the game and database size ...
0
votes
1answer
3k views

MySQL crash with long semaphore wait

A MySQL-server crashed here yesterday, and I'm not sure why (the most irritating kind of crash). The error log is full of Semaphore waits, but I don't know how to interpret most of it (<path> = ...
1
vote
4answers
6k views

MySQL Auto Increment failing

I am having a table with one column of primary key and auto increment of int(11) data type. When I am trying to insert into that table, I am getting following error. Failed to read auto-increment ...
0
votes
1answer
216 views

web server mysql replication over slow adsl lines

I would just like some recommendations. Currently i am sitting with a vps server in europe that hosts my webserver and my mysql database. It servers our clients as a place to download documents and ...
2
votes
1answer
71 views

How to Properly Migrate SQL

If I am changing servers, I usually migrate my wordpress database by going to phpmyadmin and doing an SQL Export on one server and doing an Import on the other server. I notice that in this process, ...
2
votes
4answers
254 views

Blocking attacker's IPs: What options do I have?

A website of mine is being attacked by some IPs. I don't even know if it was a ddos yet, I only know that it has been filling my application's logs for longer than a day, and then the server crashed ...
1
vote
1answer
151 views

MySql DB with ext3 and XFS

Is there any advantage for XFS file system compared with ext3, With MYSQL DB ? Which is safest file system for hosting MYSQL DB ?
1
vote
1answer
2k views

How to Sync data from one amazon RDS to another?

Hi i am pretty new to Amazon RDS.my question how to Sync data from one amazon RDS machine to another? like taking a mysql Dump or something like that, and is it possible to Sync over multiple regions ...
2
votes
1answer
255 views

ProFTPd Multiple MySQL databases

I need ProFTPd to connect to few databases/tables and authorize users by data from them. I have ftp login data in db/tables: db1 / ftp db2 / ftp db2 / users db2 / ftp_vip db3 ...
0
votes
1answer
1k views

directory not owned by the 'mysql' or '_mysql' user

I have recently installed MSQL for a Rails App. After some tinkering, I have an error starting mysql now that reads as follows: Warning: The /usr/local/mysql/data directory is not owned by the ...
1
vote
3answers
195 views

Automatic Incremental Off-Site Backups

I'm running a Linux server where incremental backups (ideally daily) are required. I want things to remain fast, but for the backups to be reliable. I'll be using Apache and a MySQL database, what's ...
3
votes
1answer
89 views

Optimizing a MySQL table for intense use

I have a table. Due to the nature of the website, in that table, if i have 400+ users or so, it will have in it inserted 100,000 new rows per hour. If i have near 4000 then for 2 hours or so, i will ...
1
vote
1answer
1k views

mysql server hung up because of too many connections

Our mysql server causes huge overload because of number of opened connections. In my case most connections are in opened state and I cannot even kill them. That is I cannot understand. The connections ...
1
vote
3answers
510 views

How can I prevent MYSQL from writing to the disk?

I am using the MEMORY Engine for all tables associated with a particular MYSQL query because speed of access is paramount to my project. For some reason, I have noticed that a large amount of disk ...
0
votes
1answer
34 views

Is there any way to get databases belong to particular user

I am making script to backup users home directories and databases. i can make backup by going through dirs but i am not able to find a way to gets databases belong to particular user
2
votes
2answers
1k views

Why ibdata1 is still growing when I have used innodb_file_per_table in MySQL 5.1

All my table in the db are created after I enabled the option "innodb_file_per_table", so I don't understand why ibdata1 is still growing from time to time, even with a very slow speed.
2
votes
2answers
4k views

MySQL Binary Log activated = high-end server damn slow

On MySQL 5.1(.57-1.dotdeb), I have a ~2.0Gb database, and an average of ~350 requests per second. All is running fine if I don't activate the binary log. The CPU usage is decent (~15% of 1 CPU ...
1
vote
5answers
1k views

High load on server

I have a cpanel LAMP dedicated server and I've been having load problems the last 2 days. This is what my top looks like (sorted by M): top - 14:26:04 up 1 day, 1:08, 2 users, load average: ...
1
vote
2answers
107 views

Is it possible to store MySQL data as comressed?

Is it possible to store MySQL data compressed? Option for that in MySQL?
1
vote
2answers
3k views

How to connect to MySql in another Ubuntu machine?

Hi How do i connect to MySql from another Ubuntu machine. I tried this mysql -h 'IP' -P 3306 -u test -ptest I get ERROR 2003 (HY000): Can't connect to MySQL server on 'IP' (111). then i tried ...
2
votes
1answer
2k views

mysql - SQL slave thread is not applying changes

I have master/slave replication with 5 slaves and 1 master. The master is mysql 5.1.37 and the slaves are 5.5.8. Two days ago one of the slave stopped working. In "show slave status" I see that both ...
1
vote
3answers
852 views

PHP & MySQL combo is running insanely slow on Windows Server 2008

I wrote some PHP and MySQL scripts on a Linux (Debian) box a while back (Running on LAMPP). Pages that requested some 2000 MySQL rows executed and returned data in roughly 0.001 seconds, and looping ...
0
votes
1answer
3k views

mysql monitoring with monit

can someone please steer me in the right direction. I'm completely new to Monit, set it up, everything working fine, but I'm having a problem with mysql. This is the set up in my conf file: check ...
0
votes
2answers
898 views

can't connect to MySQL from localhost on Centos 5

I have a fresh install of Centos 5.5 on a new VPS and MySQL seems unable to resolve the keyword 'localhost' - if I use 127.0.0.1 instead it works fine. I checked the /etc/hosts file which is as ...
0
votes
2answers
2k views

importing data from .MYD back up file

How I can load the data from myd back up file to the database table? I have all 3 files: frm , myd and myi.
0
votes
2answers
260 views

Second installation of MySQL without touching first?

My problem is this. I have a project where I need to use a MySQL database. However, the computer (a LINUX server) I am dealing with has some other software that is untouchable. This software uses ...
-1
votes
1answer
238 views

wamp - What is the 'root' user, and why does it appear under localhost and '127.0.0.1'? [closed]

I created a new db in WAMP, and I note that under the 'Privileges' tab that list the users I have one user that I didn't create, named 'root'. What is it? It is listed twice, once under 'localhost' ...
0
votes
2answers
1k views

wamp - What do “global” and “database-specific” privileges refer to?

I'm pretty much a newbie with MySQL and WAMP. I just created a new db on localhost, which I called "admin" (original, huh?). On the next page after the creation, the user shows up with 2 lines under ...
1
vote
3answers
374 views

Is there any way to retrieve data of a mysql database that has been uninstalled

I wanted to know if there is a way to recover the data of a de-installed mysql server.
2
votes
2answers
2k views

How to dump a mysql database and transfer to remote ftp in one line -for crontab-?

I need to do a weekly backup of a mySQL table and then transfer it to a remote machine using ftp. This is the command I have now in crontab: 0 18 * * 1 /usr/bin/mysqldump --add-drop-table ...
0
votes
1answer
459 views

Adding Listen 3050 to /etc/apache2/ports.conf causes mysql to crash

I am trying to set up a staging server on a VM on my local PC. Ubuntu 10.4.2 LTS 64 bit server is installed. I have another VM on the same machine running as a full time server, so I set-up ...
2
votes
3answers
3k views

Replace text on MySQL - Wildcards to replace certain variable parts?

I'm trying to apply a text replace on my WordPress MySQL database. I need to delete part of the current images html code, but this part of the text is variable, althouth there is a part that never ...
0
votes
1answer
723 views

Joomla Editor not working after restoring mysql database

I've made a big mistake on one of my sites and I've deleted accidentally several files from our site's joomla directory. The database was Ok, so what I tried to do was to create a Joomla installation ...
1
vote
1answer
411 views

MySQL not accepting connections from WP

I have a few servers running WordPress. I am using IIS with MySQL. One keeps faulting; I reset the MySQL server and it works well for a few hours and after that I start getting "Error establishing a ...
1
vote
0answers
2k views

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [closed]

My website always ran fine, but since this morning I'm getting the following error randomly, most of the time when I quickly refresh the page while it's refreshing: Can't connect to local MySQL ...