Questions tagged [mysql]

MySQL is an open-source database owned by Oracle. ServerFault topics include how to run the server. For more MySQL specific questions like backup/restore/recovery/configuration, dba.stackexchange.com is probably a better home.

Filter by
Sorted by
Tagged with
3 votes
3 answers
641 views

Two server with same data in case one goes down

I actually own two linux web servers and I was wondering how I could make them work together in case one goes down. From what I found, cluster seems to be the closest, because it would replicate the ...
1 vote
2 answers
447 views

Error running any Java web project on my notebook

when I try to run any java web project I get this error. BUT this only happens on my notebook. I've tried on other desktop and other notebook on the same order and everything works well there but to ...
7 votes
2 answers
5k views

Import a 260GB csv file into MySQL

I have a really big csv ~260GB and I want to import it into MySQL. I use the following mysql script in MacOS DROP TABLE IF EXISTS tmp_catpath_5; create table tmp_catpath_5( a1 BIGINT(20),...
0 votes
1 answer
312 views

MySql not starting during startup even after adding symlink to rc5.d

I recently added mysql.server to start during the start up by doing this: cd /etc/rc.d/rc5.d/ ln -s /etc/init.d/mysql.server S98mysql I have perhaps not correctly understood the <number> part ...
1 vote
2 answers
590 views

Best way to run admin side mySQL based sessions (without modifying php code)

I'd like to set up mysql sessions in my hosting environment that works for all of my clients across the board for my load balanced environment. After some googling, it sounds like most people's ...
1 vote
2 answers
6k views

Cannot login to mysql after setting incorrect mysql privileges/host

On CentOS 5.x I used webmin panel and I was in mysql settings, I was trying to allow "root" to login from my home ip in addition to localhost. In the hosts list I had "any" or "localhost", I tried to ...
2 votes
1 answer
1k views

SFTP authentication with credentials in Wordpress MySQL database?

I'm trying to find a solution that will allow for a user to connect to a server via SFTP using a provided username/key combination (stored in a Wordpress installation's MySQL database), without ...
5 votes
4 answers
6k views

mysql connection is slow (5seconds)

After building my webapp on a first boot i create 2 connections to mysql on debian then 1-2 (r/w) for every page after that. The connection consistently take 5.2 seconds to connect. Debian is in a VM ...
0 votes
2 answers
3k views

Efficient way of importing large amount of data into SQL Server 2008 from MySQL

Alright, to start, please don't comment on the switch from MySQL to SQL Server 2008 - I tried to resist this decision - I know it's not ideal, but it's the reality of what I am trying to do. I'm ...
0 votes
1 answer
2k views

How to block the MySQL export option

I searched here and googled for this answer but had no success. I need to block the export option from a user at my MySQL database, is there a way to do it? I already blocked the update and edit ...
8 votes
9 answers
4k 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??
0 votes
1 answer
1k views

Setting up MySQL server on LAN to be used with JDBC

I'm creating an application with client-server architecture in java. What I'm trying to achieve is a simple client-server architecture connected via LAN with an ethernet switch, the server is having a ...
1 vote
3 answers
1k views

MySQL incremental backups and database replication

We have some servers that runs a tomcat app with a MySQL database. These servers are in different cities and the web app is used locally by our customers. On these servers a crontab job runs twice a ...
0 votes
2 answers
1k views

connect mysql from php without yum command manually

I am trying to connect to mysql from php, it says i have not configured mysql-php, call to undefined function:mysql_connect();. My server is not registered with RHN, hence i cannot yum install php-...
4 votes
2 answers
246 views

Figuing out the "who, what, when and why" of a server crash

Currently, I'm the Moodle Admin for my University, and one of my responsibilities is to keep the server running and working all the time. Sometimes, for no apparent reason, Apache or / and MySQL ...
3 votes
3 answers
1k views

Good practices for backing up MySQL on a large scale

I am a newbie to DB and in particular to MySQL. Are there any good practices to backup MySQL on a large scale? For example, there are a few things I've already found. Use mysqlbackup (physical backup)...
1 vote
1 answer
3k views

Fail to dump large size sql in phpmyadmin. Where to set PHP Timeout Limit? (CentOS with cPanel)

My server: CentOS 5.x, cPanel/WHM, PHP 5.3.6. I am trying to import a large size of mysql data into a db with phpMyAdmin, the progress is terminated. It says: Below, it also mentions that: So it ...
14 votes
5 answers
18k views

How to drop all tables in a MySQL database without dropping the database?

I need to drop all the tables in a database without knowing their names beforehand. The typical procedure is to drop and then recreate the database but this is not an option. What is the best way to ...
1 vote
3 answers
1k views

MySql: can connect normally to local db, can connect via TCP remotely, but cannot connect via TCP locally

Host A is running a mysql server. On A, I can connect to the db: hostA: mysql -p I have allowed user X from host B to connect. I am able to connect via this: hostB: mysql -h A --protocol=TCP -p -u ...
0 votes
3 answers
3k views

MySqldump success or failure test

I am using mysqldump to take the backup of my mysql database and have put it under a cron job . I want to test its success or failure and want it to echo the Success or Failure Message in the cron job ...
4 votes
2 answers
5k views

Estimating MySQL Query Runtime

I ran a MySQL query from command line using the following: nohup mysql --user=root --password=XXXXXXXXX database < report.sql > results.tab This query is extensive (5000 lines) and running a ...
0 votes
4 answers
1k views

How do I install Apache/PHP/MySQL onto Mac OS X Lion? [closed]

I don't know much about this but I am attempting to learn. I am on the following page: http://httpd.apache.org/download.cgi#apache22 Firstly, which one do I download between: Unix Source: ...
0 votes
2 answers
170 views

wait rate very high due to mysql server activity

Sometimes the server is very slow and needs a lot of time for serving the requests. iotop shows a disk read rate of 1-2 M/S on average for some minutes (which is not that much actually), after that ...
4 votes
2 answers
949 views

mysqldump stored procedures without locking tables

I'm trying to create a dump of a mysql databases stored procedures and table 'shapes' without locking any rows. mysqldump -uread_only -p --routines -d --skip-add-locks the_db_name This doesn't work ...
1 vote
2 answers
978 views

Set mysql query cache to never expire

I've googled all over the interwebs but can't find any documentation on this. how do i set my query cache to never expire?
1 vote
2 answers
6k views

MySQL consuming nearly all memory in cache? [duplicate]

I am running a server with 24G of RAM. The only thing running here is a MySQL server configured as Master. When I check the memory via free -m I am getting this: total used ...
2 votes
1 answer
4k views

How to setup two mysql servers in Synchronization mode

Infrastructure I have two database servers, running on two different boxes. One works as a primary database for my web application and other works as secondary database. Secondary data base is ...
-2 votes
1 answer
376 views

How to connect to MySQL database with HipHop PHP?

I installed hiphop php in CentOS 5.4 via yum with the repositories provided in the guide of the Git repository. Yum installed all the needed packages, including "mysql51". The problem is, i can't ...
2 votes
2 answers
3k views

Shorewall enabling MySQL port

I've recently set up an ubuntu server to host my site - I need to open up port 3306 for MySQL access on my server. I'm currently using shorewall on my server - how can open incoming connections to ...
3 votes
1 answer
2k views

How to convert Mysql database to Postgresql in Linux?

I have a large Mysql database containing tens of tables which I need to convert to Postgresql. I have tried a couple of ancient Perl scripts which I found here and there but none of them did the job ...
1 vote
1 answer
1k views

Zenoss MySQL database backups are huge after multiversion upgrade

The Context: We ran Zenoss 2.2 for way too long, and decided it was time to upgrade to the current version, 3.2. I followed the upgrade steps here, and checked to make sure everything was working ...
0 votes
1 answer
90 views

How to set backup / database in order to maintain heavy write loads

I have a write heavy application. Approx 5lac+ inserts per day in a MySQL table. I have master <> master -> slave. Performance is not an issue here. I need your inputs with regards to management ...
2 votes
3 answers
5k views

Is there a fast method for exporting a large table from mysql to postgresql?

I've got a table with around 2.7 million records, 63 fields, and several indexes. I need to be able to get this table from mysql to postgresql quickly (say within an hour). I know mysql can export the ...
1 vote
2 answers
254 views

How to dump database to be used with no credentials

I am wondering how can I generate a dumped database so that it can be restored without requiring the original database username and password? Ideally I'd like to know the pg_dumpall as well as ...
5 votes
2 answers
422 views

Apache processes at 100% with no traffic - how can I see what's going on?

I've got a server running apache, and have been seeing occasional apache processes go to 100% and stay there. Today, with two processes at 100%, I turned off external access to the server (to prevent ...
3 votes
0 answers
1k views

What are the risks of running a database on a server without ECC RAM? [duplicate]

A lot of branded servers come with ECC RAM, but it is expensive. For a database server or other critical servers, what would be the impact of not using ECC RAM? Data corruption? (I suppose the ...
0 votes
1 answer
91 views

Shared Hosting using Linux [closed]

I am planning to set up a server hosting multiple websites on a single high-end Linux server on Virtualization-enabled Hardware using a LAMP stack. I have decided to go with Centos 6.2 as a KVM host ...
0 votes
3 answers
2k views

MySQL server not starting up

I have a server running CentOS 5.5 x86_64, and have recently installed MySQL Server via YUM, but when starting the server I get: [root@server etc]# service mysqld start Warning: World-writable ...
0 votes
1 answer
197 views

mysql socket issues

Whenever I try and run mysql I get the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) I did some research and it looks to ...
4 votes
1 answer
20k views

MySQL max_allowed_packet greater than 1024 MB

I have a DB which is greater than 1GB (~1,4GB). The DB upload was stopped at 1GB, because, max_allowed_packet is 1073741824 (1GB). In file /etc/my.conf i set max_allowed_packet=2048M. How can I ...
1 vote
2 answers
631 views

Installing MySQL 5.5.19 with Macports

The MySQL packages currently available on Macports are up to date for branch 5.1, but for 5.5 they are quite old (the latest one available is 5.5.2). Is there some way to install the latest one at ...
0 votes
3 answers
1k views

DB Server Disk I/O utilization

I have a Linux server that I use to run the DB of my application (MySql), the server have 8GB Ram and 4 cores. there are no other applications running on the server besides the MySql. Most of the ...
1 vote
2 answers
760 views

Increasing the concurrent user performance in LAMP application

We have a LAMP application where we have started to feel the performance pinch due to large number of concurrent users connecting to the application. I have looked at the individual parameters of ...
0 votes
1 answer
391 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 ...
1 vote
2 answers
531 views

Setting max_allowed_packet for mysql on solaris 10

I want to set the max_allowed_packet setting for mysql (5.1.31) which is running on Solaris 10. Unfortunately mysql does not seem to read the my.cfg. I tried to place it in /etc/mycfg, /opt/mysql/...
4 votes
2 answers
472 views

Manually transfer MySQL databases

I have an external hard drive that has a non-bootable clone of an old machine (that I no longer have). One of the things that was present on that machine was a MySQL installation (v 5.5.19) with ...
1 vote
4 answers
2k views

Recommended MySQL monitoring tool [closed]

I am looking for a good all-in-one monitoring tool for a single MySQL server and underlying Linux OS. I need something that gives me a quick graphical view of what is going on right now and that ...
0 votes
1 answer
168 views

Slow request - mysql server?

Sometimes the server needs a lot of time for a request. There's also an error that there are too many connections to the mysql server. I've set the max_connections up to 800 but this doesn't help at ...
1 vote
3 answers
645 views

throttle cpu usage for a cronjob

I've got a cronjob that is basically nothing more than mysqldump whatever | gzip > backup.sql.gz. The database is fairly big. I've noticed that while the job is running, my apache is much less ...
0 votes
1 answer
130 views

Determine MySQL port and IPTables restriction

Linux CentOS 6 - IPTables I would like to know what command line(s) I need to enter to determine what my MySQL port is, or rather what config file I could check. I know it's typically 3306 but I'm ...

1
126 127
128
129 130
175