MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

1
vote
2answers
3k views

What are the benefits of installing XAMPP vs [LAMP from repository] on Ubuntu Linux?

For dev purposes, is it better to install XAMPP or Apache MySQL & PHP from the repository?
0
votes
1answer
218 views

Configuring ASR and Oracle Clusterware

I have a four server cluster with Oracle Clusterware managing 4 MySQL instances on them. On failure Clusterware will move the MySQL instance to another server. I am on Proliant servers and also have ...
0
votes
3answers
661 views

mysql not runnning

i have windows 7 i just installed wamp Server 5.1 my php pages are running fine nut when i go to phpmyadmin i get this error MySQL said: Documentation #2002 - The server is not responding (or ...
0
votes
1answer
176 views

Installing an AMP environment on Ubuntu, manually, and keeping it up to date

On linux distros, it's more rule than exception to install things via some sort of package. Via a manager or command line. This then configures a lot of stuff for you and it just works. As such, ...
-1
votes
2answers
346 views

Hadoop on Virtual Machines [closed]

We would like to migrate from MySQL to Hadoop for scalability. Will hadoop clusters running on virtual machines improve our website's performance? What are the advantages and disadvantages of ...
0
votes
2answers
174 views

MySQL - Innodb, search

I recently switched from myisam to innodb in one of my mysql tables. Before i was using MATCH(). Since innodb doesn't support match() i decided to use LIKE. Now I have a problem. My table is 190,6 ...
0
votes
2answers
95 views

MySQL installation and unInstallation

How can we uninstall MySQL completely from the Windows OS ? So that we can freshly install MySQL.
0
votes
4answers
120 views

Using multiple machines to host a wbsite [closed]

I'm in charge of a file server at my high school and for now it's just one machine with a RAID set up with apache, php and MySQL installed. The problem is that all of the storage on the machine is ...
0
votes
2answers
198 views

Installing apache+mysql on primary hard drive or secondary? [closed]

I'm installing a fresh copy of apache and mysql on a windows 2008 server with two hard drives Primary one is naturally running the OS and more The second drive is for the websites (php scripts) ...
2
votes
2answers
541 views

Mysql PAM authentication

Is it possible for mysql to use PAM (or NIS) authentication. I want to allow all users from unix XXX group to be able to connect to mysql and do whatever they want.
2
votes
1answer
489 views

slow query logging in mysql server

I have installed MySQL Community Edition 5.1.41 on a windows 2000 server. In my.ini file I have enabled slow query logging and have redirected the output to a table.I have set the long_query_time to ...
1
vote
3answers
250 views

Non-root MySQL passwords always wrong

I am using MySQL 5.5 on FreeBSD, and everything is operational and has been for some time. The only problem is, no DB users other than root can authenticate properly. mysql Ver 14.14 Distrib ...
5
votes
2answers
5k views

What is the difference between Replication and Synchronization?

In phpMyAdmin there is a tab for configuring Replication and one for Synchronization. What is the difference between Replication and Synchronization? When do you should use the one or the other? ...
1
vote
3answers
1k views

Redirecting to alternative ports

I am trying a little bit of security by obscurity here and I want to do the following for a number of services (i.e. MySQL): Let the services definitely run on localhost on their default port Block ...
0
votes
2answers
369 views

change a mysql table column on slave then promote to master

If I want to change a NOT NULL column to allow for null values, is it safe for me to run that ALTER TABLE on my DB slave, wait for it to catch up, and then promote it to master?
2
votes
1answer
396 views

Can't use cmd for MySQL server Windows 7 [closed]

I just installed MySQL community server on Windows 7, completed the configuration wizard making sure the command line is included but I just can't use it from cmd. Entering mysql or MySql just ...
2
votes
1answer
63 views

offsite mysql access

I'm moving my mysql database off-site and for the most part web-apps (to be used privately) running on a separate server on the same network are all that need to access it. So from what I read it's ...
2
votes
2answers
1k views

How to monitor and automatically restart mysql?

I'm running mysql on Debian. Is there a way to monitor mysql and restart it automatically if it locks up? For example sometimes the server starts to take 100% of cpu and starts running very slowly. ...
1
vote
3answers
634 views

Replace text with spaces in MySQL

I'm trying to do a global replace of search in my database, which has a lot of articles with a double carriage return because of this code: <p> </p> I'd like to replace this in my ...
1
vote
3answers
285 views

MySQL Backup and Recover

I have been running mysqldump on my set of MySQL databases (MyISAM and INNDOB). Recently I wanted to restore the databases to another server, and so I created the databases and imported the dump file. ...
2
votes
2answers
1k views

Can I replicate data between mySQL and SQL Server/SQL Azure?

I have a replicated mySQL setup running happily on Amazon AWS, making user data available locally in various regions. Now I'm faced with an app that needs to go up on Microsoft Azure and I need to ...
0
votes
2answers
222 views

What is the best apache configuration for me?

I started to a new job. And my mission on servers which is not my work :( We have around 200 websites which use php - mysql. netstat -an|grep -c :80 is around 500 24GB ram with 2 E5420 Cpu Load ...
0
votes
1answer
69 views

How to track down why my shared web host is losing data bound for mysql?

I use shared web hosting for a couple of Drupal sites, using my hosting provider's MySQL database server for storage. One of the sites recently sent me a few emails that should have been written to ...
1
vote
4answers
749 views

how optimize small linux server?

I have a small Ubuntu server with 512MB of ram and several php/mysql websites (~20) running on it.It's been running for 2 years now without a single issue. But I think the moment for some optimization ...
0
votes
1answer
693 views

Import from *.sql into mysql… IBD files missing

Running ubuntu 10.10, MySQL, I imported a set of databases from a backup. The import looks OK - I can query the databases and see data in them. The strange thing is that in the /var/lib/mysql/ ...
-1
votes
3answers
2k views

mysql on virtualbox with datadir on shared folder [closed]

I've installed Ubuntu 10.10 on virtualbox machine. With apache/php/mysql ... now I'm trying to move mysql datadir to folder shared by host os (win7) so I've done following: 1) mounted shared folder: ...
2
votes
2answers
236 views

MySQL running but not responding

I had a crash on a machine and rebooted and restarted mysql. Mysql loaded fine, I can connect with 'mysql -p' and do simple commands like "show tables;". However, real DB operations (e.g., "select ...
4
votes
4answers
899 views

Backing up a MySQL database - while it is still in use

I currently backup my MySQL database using mysqldump, for example: mysqldump --user USERX --password=PWDX DBNAMEX > dbbackup__`date '+%m-%d-%Y'`.sql When I perform the backup (initiated via a ...
0
votes
1answer
490 views

mysql: option '--default-character-set' requires an argument

Ubuntu 10.10 server When I run the following command: mysql It tells me: mysql: option '--default-character-set' requires an argument I've updated the my.cnf file to set the default character set, ...
2
votes
2answers
107 views

Mysql leave slave 1 hour behind

Is it possible to leave the mysql slave 1 hour behind? I would like to create an script wich stops the slave when I markup some hacks such as big drop tables and stuff, to make this work I would like ...
0
votes
1answer
618 views

2 different mysql servers on localhost

Im trying to build application, which uses 2 mysql servers. I set up port forwarding (thats the name to callit -i dont know) like that: sudo ssh -g -L3306:foreignserver.ip:3306 me@foreignserver.ip ...
2
votes
1answer
65 views

What on earth is version “5.1.30really5.0.75” of MySQL on Ubuntu?

I'm trying to upgrade Ubuntu packages and see some strange names flying across the screen. This package naming convention is throwing me off just a bit :-) What is 5.1.30really5.0.75?
2
votes
2answers
584 views

MySQL - If slave is offline and comes back online, does it automatically catch data from master?

MySQL - If slave is offline for a few hours and comes back online, does it automatically catch data from master?
0
votes
1answer
422 views

Promote MySQL master-slave to master-master replication

I'll be doing a upgrade of a large MySQL 5.0 database to Percona 5.1 and I'm attempting to keep the actual downtime as short as possible during the upgrade, so the regular mysqldump + mysql import ...
0
votes
0answers
326 views

Promote MySQL master-slave to master-master replication

I'll be doing a upgrade of a large MySQL 5.0 database to Percona 5.1 and I'm attempting to keep the actual downtime as short as possible during the upgrade, so the regular mysqldump + mysql import ...
1
vote
2answers
523 views

Server stress test and configuring for beginners?

Our city is having a very public event soon (data harvesting for public spots available in the city hall) which required our company to create a form application to submit curriculums and some ...
0
votes
1answer
376 views

Frustrating JDBC MySQL Exception

So I'm setting up my new server after my old one had died of a server failure. The only boulder I've hit is the JDBC set up. My server runs a Java program that had originally worked fine with the old ...
2
votes
2answers
1k views

How can I change my mysql user that has all privileges on a database to only have select privileges on one specific table?

I gave my mysql user the "GRANT ALL PRIVILEGES ON database_name.* to my_user@localhost" treatment. Now I would like to be more granular, starting with lowering privileges on a specific table. I am ...
0
votes
1answer
393 views

Can MySQL use roles without MySQL Wokbench?

I have only found documentation about roles in MySQL through the use of Workbench, is there an alternative way to set them?
3
votes
2answers
618 views

Is MySQL replication possible with different versions of MySQL

Should MySQL slave have the same version or higher than Master for replication to work properly?
0
votes
3answers
230 views

installing mysql via apt-get with non-default data and logs directories

Is there a way to install mysqld via apt-get and have it a non default path for the data files? I know I can install it with the defaults and then move stuff (I've done that) but then I have about a ...
-2
votes
3answers
232 views

Locked out of server by not-sure-what, remote reboots don't help. What to do? [closed]

I'm in charge of a dedicated web server for a client. He's got some pretty good traffic and it's been going down more and more often in the last 2 months. I was just in the process of finalizing a big ...
0
votes
3answers
124 views

Semi dedicated linux server - trying to figure out reason for sluggish performance

I have a managed semi-dedicated server running Centos and a LAMP setup with PHP 5.2.9. I've noticed over the past couple of months that HTTP requests are taking much longer and page loading speeds ...
0
votes
2answers
458 views

JDBC CLASSPATH Not Working

I'm setting up a simple JDBC connection to my working MySQL database on my server. I'm using the Connector-J provided by MySQL. According to their documentation, I'm suppose to create the CLASSPATH ...
-1
votes
1answer
1k views

php http tunnel to mysql connection

How to create a HTTP tunnel to PHP to MySQL connection
1
vote
1answer
43 views

Mysql MyIsam Applications

Quick question, When you select, insert or update into an myisam table, does it require the table to lock? I've never scaled large-large applications. When should I start worrying about ...
2
votes
2answers
1k views

Automating MySQL configuration with kickstart

I've been testing deployment for a website with some virtual servers. I have most of my deployment steps done via kickstart file (package installation and user creation). However, for MySQL I have to: ...
1
vote
1answer
948 views

View-related privileges in MySQL

How do I grant view-related privileges to a user in MySQL (without granting all privileges)? I get this error when I try to do a mysqldump: mysqldump: Couldn't execute 'show create table ...
1
vote
1answer
355 views

Turn “log slow queries” ON

I'm trying to log mysql slow queries, but I can't turn it on. I will explain all my steps: Open and Edit my.cnf and add the following lines: long_query_time = 5 slow_query_log_file = ...
1
vote
1answer
275 views

Can I change a MySQL table back and forth between InnoDB and MyISAM without any problems?

I have a site with a decently big database, 3Gb in size, a couple of tables with a dozen million records. It's currently 100% on MyISAM, and I have the feeling that the server is going slower than it ...