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

    ITKE376,290 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.

    ITKE376,290 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.

    ITKE376,290 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...

    ITKE376,290 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!

    ITKE376,290 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.

    ITKE376,290 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!

    ITKE376,290 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?

    ITKE376,290 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:
  • Run PHP script in AS/400 batch

    We have an application on our AS/400 where we are passing changes to data down to a MYSQL DB on a server. Using a purchased product we have issues when passing large amounts of data, Were get JAVA heap dumps. So I am replacing this with a PHP process. The RPG code writes SQL statements to a file...

    CharlieBrowne42,220 pointsBadges:
  • ODBC AS/400 connect to MySQL

    I am trying to figure out how to get data from the AS/400 into MySQL.

    Sunnyday25 pointsBadges:
  • MySQL stored procedure debugger tool

    Hi, I am looking for a MySQL stored procedure debugger tool for Ubuntu (Unix). Can someone help?

    Perfsid5 pointsBadges:
  • Should I use mysql_* functions?

    I'm pretty new to MySQL and my friend told me not to use mysql_* functions. Can anyone tell me why this is the case? Security concerns?

    ITKE376,290 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • Hardware sizing for the infrastructure

    Hi, I would like to do the Hardware sizing for below applications on Linux based OS both in Physical and Virtual environment, can someone provide details on how many servers, type of servers, storage, network and other if related to sizing required to setup centralized for 2000 to 50000 concurrent...

    12480355 pointsBadges:
  • Rename a MySQL database

    Is there a way to rename a MySQL database? I know that I can just dump the database / reimport it but I can't do that with mine. It's a huge database. Also, it needs to work with InnoDB. Thanks!

    ITKE376,290 pointsBadges:
  • PCI compliance issues on MySQL database

    We use Stripe to process credit card information / store client's payments in our MySQL database. We only store the ID of transaction and the client ID. And Stripe controls the PCI compliance issues. We also isolate payments to a single box that hosts the database and payment site. Now, here's our...

    ITKE376,290 pointsBadges:
  • Does temporary storage of credit card info meet PCI DSS requirements?

    For our department, we need to make sure that our temporary storage of our user's credit card information meets PCI DSS requirements. We have to make sure that deletion is compliant DoD's security standards. We thought about using MySQL but we're not sure about the reliability. What should we do?

    ITKE376,290 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.