MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

10
votes
3answers
2k views

How to reset or recover admin account password for MySql?

I have a MySql database that I "inherited" and I was not given the admin credentials. I do however have access to the box that it runs on. Is there a way to either recover the admin credentials or ...
6
votes
2answers
2k views

Installing a third party application package on CentOS 6.4 fails due to missing dependencies libcrypto.so.10 and libssl.so.10

This is a Canonical Question about OpenSSL binary compatibility issues between Red Hat Enterprise Linux (and its derivatives) 6.4 and 6.5. This issue applies to a wide variety of third party ...
15
votes
6answers
8k views

MySQL InnoDB - innodb_file_per_table cons?

By default MySQL InnoDB stores all tables of all DBs in one global file. You can change this by setting innodb_file_per_table in the config, which then creates one data file for each table. I am ...
9
votes
3answers
3k views

Secure LAMP server for production use

What is the procedure for securing a Linux, Apache, MySQL, PHP Server (or even Perl) for production use? Other than setting the MySQL password and the root password for Linux what other (maybe not so ...
4
votes
2answers
2k views

How to fetch ./configure parameters used at last time?

I am upgrading LAMP stack on customer's server and need to ./configure mysql and apache with exact last settings they were compiled with last time. Where do I get these? PHP configure string can be ...
4
votes
1answer
3k views

How to restore mysql database from the physical files?

I just reinstalled my system, I didn't do dump backup but I still have the physical folder of my previous mysql installations. Is possible to use it to restore and update my current configuration?
19
votes
6answers
10k views

Scripted install of MySQL on Ubuntu

I need to write a script that will build my server from a fresh Ubuntu server install. Among things like Apache and PHP it needs to install MySQL. The only problem here is that when I install MySQL ...
1
vote
1answer
1k views

what is gen_clust_index used for in mysql?

It seems I have a deadlock in mysql (running innodb) that's due in part to a lock on gen_clust_index, however, this isn't a table that I've created. So... what's the short and sweet description of ...
14
votes
5answers
3k views

What is the best way to monitor a production server?

We are running two production servers with Apache 2 and MySQL. I am looking for a reliable way of monitoring our load, stability and uptime. I have come across monit, but are there better ...
20
votes
6answers
29k views

How can I copy MySQL users table from one server to another?

I'm setting up up a new MySQL server and I'd like to give it the same set of usernames, allowed hosts, and passwords as an existing server (which is going away). Would it work to just do a dump of ...
8
votes
3answers
6k views

How to copy user privileges with MySQL?

I have a MySQL installation with many databases and users that I need to migrate to a new MySQL installation. I can use phpMyAdmin to export then import the databases/tables, but I don't know of ...
1
vote
1answer
985 views

How do I set my.cnf in Mysql so that there are no limits to connections?

Unlimited connections, how do I edit that setting?
17
votes
9answers
5k views

Architecture for highly available MySQL with automatic failover in physically diverse locations

I have been researching high availability (HA) solutions for MySQL between data centers. For servers located in the same physical environment, I have preferred dual master with heartbeat (floating ...
34
votes
7answers
28k views

What is the best Linux filesystem for MySQL (InnoDB)?

I tried to look for benchmark on the performances of various filesystems with MySQL InnoDB but couldn't find any. My database workload is the typical web-based OLTP, about 90% read, 10% write. Random ...
10
votes
3answers
1k views

The A to Z of setting up a Linux box for secure local hosting

I am in the process of reinstalling the OS on a machine that will be used to host a couple of applications for our business. The applications will be local only; access from external clients will be ...
13
votes
3answers
24k views

MySQL: How do I get my “Maximum possible memory usage” down?

I've recently been having problems with thrashing as a result of running out of memory. (My VPS has 256M total) I'm trying to tune MySQL using mysqltuner.pl, and get the following results: -------- ...
13
votes
7answers
1k views

Backup MySQL Server

What's the best way to back up a MySQL server? I would like a method that doesn't require bringing down the server. Is something like InnoDB hot backup necessary, or can I just use the backup tools ...
6
votes
2answers
5k views

How do MyISAM and InnoDB Utilize HD Space?

My MySQL server is running out of HD space fast. Most of my larger tables use the InnoDB engine (for no mission-critical reason). In an effort to avoid the dreaded 'drop database to recover innodb ...
8
votes
1answer
5k views

Changing MySQL data directory in Ubuntu Server 10.04

I was getting the following error when trying to change the data directory in ubuntu server 10.04. 100809 19:33:00 [Note] Plugin 'FEDERATED' is disabled. /usr/sbin/mysqld: Can't find file: ...
6
votes
4answers
773 views

Any security tips for my first server? (complete beginner)

I'm paying for a VPS and hoping to launch my first website on it in the next few days. I'm worried there might be some glaringly obvious security holes in the standard setup, so I'm keen to get some ...
5
votes
3answers
2k views

Percona-server time out on /etc/init.d/mysql start

Every time I start mysql, using /etc/init.d/mysql start or service mysql start, it always times out. * Starting MySQL (Percona Server) database server mysqld [fail] However, I ...
4
votes
3answers
2k views

Create a MySQL slave from another slave, but point it at the master

Problem I have MySQL replication setup between 2 servers, master (A) and slave (B). I need to add a new slave to the mix (C). I want this slave to get it's updates directly from the master, I do not ...
4
votes
2answers
3k views

MySQL slave replication reset with no Master Downtime (using MyISAM)

Root of the issue: In all instructions for creating a slave on a running master requires flush tables with read lock. We use MyISAM, so we can't just use --single transaction to get consistent table ...
3
votes
8answers
2k views

MySQL is running VERY slow on CentOS 6x (not 5x)

I have two servers: a VPS and a laptop. I recently re-built both of them, and MySQL is running about 20 times slower on the laptop. Both servers used to run CentOS 5.8 and I think MySQL 5.1, and the ...
3
votes
5answers
4k views

How can I back up and replicate a large MySQL database?

How can I backup a large database in mysql? And what is the best way to replicate the database? what i'm looking for is backing up large database with large amount of data in a small time limit ...
1
vote
7answers
6k views

Mysql - Access denied for user 'root'@'x.x.x.x' [duplicate]

I am trying to connect to a remote mysql database from my local box. Initially I was not even able to hit the mysql db. But after commenting the binding_address in the my.cnf file and restarting the ...
3
votes
1answer
865 views

MySQL: How to backup and restore using different schema name using xtrabackup

I very often need to create a backup of a database and import it using a different schema name. These schema's are pretty large (3-5GB) and mysqldump is a pain. xtrabackup seems promising but I cannot ...
3
votes
3answers
1k views

ERROR 2002 (HY000): Can't connect to local MySQL

Ok, I've got a fresh Fedora 12 install, and I have installed mysql via yum. I searched around, including a couple similar posts on this site, but haven't been able to find an answer to my issue ...
1
vote
2answers
9k views

How should I diagnose ERROR 1045 during MySQL installation?

I recently setup a MySQL server and encounted the following error when I ran the mysql console (and incidentally the administrator GUI tool): ERROR 1045: Access denied for user: 'root@localhost' ...
6
votes
5answers
1k views

MySQL stopped working - full disk

Maybe it is because I am lacking in free disk space, take a look: Filesystem Size Used Avail Use% Mounted on /dev/sda2 1.9G 208M 1.6G 12% / none 998M 192K ...
5
votes
4answers
247 views

reseting mysql root password [duplicate]

Is there a mysql command to reset the root password? I am trying mysql -p -u root but I've forgotten the password. Is there any way to reset the password?
43
votes
9answers
50k views

How can I export the privileges from MySQL and then import to a new server?

I know how to export/import the databases using mysqldump & that's fine but how do I get the privileges into the new server. For extra points, there are a couple of existing databases on the new ...
17
votes
6answers
13k views

Optimize apache/php/mysql running on VPS for heavy load

Question about optimizing an apache/mysql server on a VPS with 512m of RAM. Under normal load everything runs fast, no connection lag. However when we get our heavy traffic days (50k+ visits) the ...
22
votes
7answers
3k views

Backing up a 22 GB MySQL database daily

Right now I am able to do the backup using mysqldump. But I have to take down the web server AND it takes around 5 minutes to do the backup. If I don't take down the web server, it takes forever and ...
39
votes
1answer
37k views

InnoDB: Error: log file ./ib_logfile0 is of different size

I just added the following lines in /etc/mysql/my.cnf after I converted one database to use InnoDB engine. innodb_buffer_pool_size = 2560M innodb_log_file_size = 256M innodb_log_buffer_size = 8M ...
7
votes
9answers
2k views

How do you usually back up your database?

I am using mysql How often do you back up your database? How do you normally backup your database? Export all data into sql or cvs format and keep it in a folder??
101
votes
9answers
139k views

MySQL: Bind to more than one IP address?

Is there a secret way to bind MySQL to more than one IP address? As far as I can see the bind-address parameter in the my.cnf does not support more than one IP and you can't have it more than once.
6
votes
5answers
15k views

How to improve MySQL INSERT and UPDATE performance?

This question can probably be asked on StackOverflow as well, but I'll try here first... Performance of INSERT and UPDATE statements in our database seems to be degrading and causing poor performance ...
25
votes
4answers
2k views

Why Swap is used when plenty of free memory is left?

I have pretty good web (dedicated) server with good memory resource System information Server load 2.19 (8 CPUs) Memory Used 29.53% (4,804,144 of 16,267,652) Swap Used 10.52% ...
10
votes
4answers
2k views

Should I backup and restore the `mysql` database?

In the process of creating an automated solution for backing up and restoring an entire MySQL server, I've come across the mysql database which seems to contain user accounts, permissions, metadata, ...
13
votes
9answers
39k views

phpMyAdmin: The additional features for working with linked tables have been deactivated

I'm getting this error in the main page of phpMyAdmin verson: 3.2.1deb1 The additional features for working with linked tables have been deactivated. To find out why click here. When I click the link ...
4
votes
2answers
4k views

mysqldump prompting for password in shellscript

I wrote a simple shell script to dump a specific mysql database. problem is it is prompting me for a password even though I provide on. The mysql db is version 5.0.27 if that matters. Here is the ...
15
votes
2answers
10k views

Out of resources for mysqldump

I'm trying to do a mysqldump on a Windows server and I get the following error message : mysqldump: Got error: 23: Out of resources when opening file '.\db\sometable.MYD' (Errcode: 24) when using ...
14
votes
3answers
34k views

How to setup a MySql server to accept remote connections?

I am installing a MySql server in Ubuntu desktop. I could connect MySql Query Browser to it when specifying the Server Hostname as localhost, but when I replace it by the machine's IP it stops working ...
7
votes
4answers
824 views

BIND HTTP “API”

First off, I'm a bit of a bind n00b so if I say things that don't make sense just ignore them =) Is there any software that would allow "API" like commands for creating, updating, deleting etc. zones ...
4
votes
3answers
2k views

'ALTER table' for all tables in a database

How can I run the following for every table in a database: ALTER table [table_name] type=innodb; I don't want to have to manually run it for each table, but rather run it for all tables in a ...
4
votes
5answers
4k views

MySQL 5.1.34 on NFS w/NetApp

Is this still a bad idea? I know older versions of MySQL performed poorly with NFS. I imagine the issue lies with the usage of fsnc() and/or O_DIRECT. If the issues are mostly resolved, are there ...
2
votes
5answers
6k views

IO Wait causing so much slowdown (EXT4 JDB2 at 99% IO ) During Mysql Commit

I am writing an indexer, using python, which indexes documents and insert them into Database, Before it was single process but now i made it to multiprocessing with 4 parallel processes running.After ...
2
votes
4answers
3k views

Which should I put on my bigger machine? Magento Webserver of Magento Database?

I am about to launch a new Magento website and I was interested in your feedback on this issue? Do you think the Magento PHP code is slower or the Magento MySQL operations are slower? Which should I ...
20
votes
4answers
2k views

Can MySQL effectively take advantage of 64 GB RAM?

We have been running into a problem where querying a table that has approximately 50 million rows, and has an index size of 4 GB (table size of about 6 GB) results in the database server swapping ...