• Which tool is preferable to test and evaluate the MySQL and MongoDB databases?

    I have developed a small case study online application using Hibernate that can communicate with both MySQL and MongoDB database. Now I need to test the performance of both the databases against each other by supplying a large dummy test data to the developed application on various scenarios such...

    gunasingh105 pointsBadges:
  • Removing MySQL rows from a table using SQL Query

    In MySQL, I have a table that currently holds the following topics: id url title company site_id So I have to go in and remove the rows that have the same title, company and Site_ID. Can this be done using a SQL Query? Thank you!

    ITKE380,245 pointsBadges:
  • How do I connect to a MySQL database in Java?

    I apologize if this is a simple question but can anyone help me with connecting to a MySQL database in Java? Thanks so much!

    ITKE380,245 pointsBadges:
  • MySQL: Threads showing in freeing items state

    I've been running SHOW PROCESSLIST in MySQL and there are a bunch of threads in the 'freeing items' state. A friend of mine told me that this is because of the query cache. But mine is set to zero so it should be disabled. What's happening here? Thanks!

    ITKE380,245 pointsBadges:
  • Export / import database in MySQL using command line

    Can I import / export my database in MySQL using the command line? I already have MySQL system configured and WampServer is installed. Thank you so much.

    ITKE380,245 pointsBadges:
  • Monitor progress of SQL file

    I'm trying to import a pretty large SQL file (roughly 6 GB) to my local database. Here's what I'm using: $ mysql -h localhost -u root 'my_data' < foobar.sql $ mysql --version /usr/local/mysql/bin/mysql Ver 14.12 Distrib 5.0.96, for apple-darwin9.8.0 (i386) using readline 5.1 So, I'm wondering if...

    ITKE380,245 pointsBadges:
  • Moving MySQL database to another server

    We have a MySQL server that is using a InnoDB table and the size is right about 30GB or so. Now, we actually need to move to our new server. How can we go about doing this?

    ITKE380,245 pointsBadges:
  • Disable replication on MySQL database

    For the past month of so, I've been running dual master MySQL replication but now I need to move to just one database that doesn't have a replication. Is there a way to completely disable replication on each database? Thank you

    ITKE380,245 pointsBadges:
  • Can I mysqldump specific tables in my database?

    In MySQL, is there a way I can dump a specific table / tables without including the remaining database tables? I would appreciate the help.

    ITKE380,245 pointsBadges:
  • MySQL: Reduce size of ibdata

    We have several production servers that have IBDATA files. These files are increasing daily. Actually, it's almost taken up 300 GB in space. The tables in the servers are InnoDB (most are read and write requests). Also, log file size is going up too. So basically, data continues to rise. Is there a...

    ITKE380,245 pointsBadges:
  • How to install Apache with MySQL and PHP on Linux CentOS?

    Hello, How can I install Apache with MySQL and PHP on Linux CentOS? Thank you!

    isophiawilson115 pointsBadges:
  • Migrate data from MySQL to SQL Server

    Hi all SQL Server experts, I'm new to SQL Server. Can you please help me out from I want to migrate data from MySQL to MS SQL. What steps do I need to follow? Can you please tell me in step-by-step? Thanks in advance.

    nasarbabu30 pointsBadges:
  • SQL query: Find out the count of employee whose name is more than one time

    In SQL, how do I find out the count of employee whose name is more than one time in a table?

    meghanap5 pointsBadges:
  • Stop Apache and MySQL from automatically starting up in Ubuntu

    For Ubuntu, I don't need Apache and MySQL to run automatically when I startup. When I boot up, they automatically startup. How can I stop this from happening?:

    ITKE380,245 pointsBadges:
  • Restore MySQL database from .frm files

    I'm in a huge bind. I'm using Windows Server 2003 / MySQL. I have to recover a MySQL database from an old server to a new installation. The server it was running on will no longer boot. So I cannot do a backup. All I have is the MySQL data directory from the old machine. I've stopped the MySQL...

    samaritan0535 pointsBadges:
  • Linux file system for MySQL

    What would be the best Linux file system for MySQL? My database is a web-based OLTP (and 90% read). Any help would be appreciated. I'm leaning towards XFS.

    ITKE380,245 pointsBadges:
  • MySQL upgrade error: FATAL ERROR: Upgrade failed

    We're currently upgrading our MySQL and it keeps failing on us! Here's what we're getting: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed Anyone seen this error before? If so, what can we do? Thank you.

    ITKE380,245 pointsBadges:
  • How to use a MySQL password on the command line

    I have a PHP command line that I use to version our database. Whenever development adds a new database patch, that's run this script runs. Here's the script: system('mysql --user=xxx --password=xxx < patch.sql'); But now development is saying we're getting this error message: Warning: Using a...

    ITKE380,245 pointsBadges:
  • Changing privileges for already created MySQL user

    For MySQL, how can I change the privileges for already created users (not new users)? My company is running an audit on our database and we noticed that some people have more access than they should. Thanks!

    ITKE380,245 pointsBadges:
  • How can I setup an Ubuntu server for sending emails in PHP

    Can someone help me with setting up an Ubuntu server? I have to send emails in PHP using the mail() function. I already have Apache, PHP and MySQL in my server. I appreciate the help.

    ITKE380,245 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following