• 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!

    ITKE413,725 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.

    ITKE413,725 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...

    ITKE413,725 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?

    ITKE413,725 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

    ITKE413,725 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.

    ITKE413,725 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...

    ITKE413,725 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!

    isophiawilson155 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?:

    ITKE413,725 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.

    ITKE413,725 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.

    ITKE413,725 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...

    ITKE413,725 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!

    ITKE413,725 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.

    ITKE413,725 pointsBadges:
  • Bind more than one IP address in MySQL

    In MySQL, would there happen to be a way to bind two or more IP addresses? I need to use more than one IP address and the 'bind-address' in my.cnf won't work. Thanks!

    ITKE413,725 pointsBadges:
  • Copy MySQL usernames and passwords from one server to another

    Over the past week, I've been setting up a new MySQL server for my work and I have to give it the same set of usernames and passwords from the previous server. Can I do a dump from the previous server and load it to my new server? Or is there another way?

    ITKE413,725 pointsBadges:
  • How to change column name in MySQL

    I need to change column name in MySQL. What should be the command for writing it?

    sachnikh15 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.

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

Following