• How to archive live MySQL database

    Our department has a live MySQL database and we want to archive the data daily so we can run different queries on it (without affecting the live database). How can we go about this? Would MySQL replication work for this?

    ITKE1,055,910 pointsBadges:
  • How to backup MySQL users

    Would it be possible for me to backup all of our MySQL users / privileges? Would something like MySQLdump work? Thanks!

    ITKE1,055,910 pointsBadges:
  • Setting MySQL row as read-only

    In my MySQL row, I have very important data that I don't want changed at all. Can I set that row to read-only so no one can update / change it? If that's not possible, is there another way I can make sure the data isn't changed? Appreciate the support.

    ITKE1,055,910 pointsBadges:
  • PostgreSQL to MySQL data migration

    I recently changed my database from PostgreSQL to MySQL. But how can I do a data migration from one to the other? Is there a certain command to migrate the database data?

    ITKE1,055,910 pointsBadges:
  • What’s the maximum MySQL concurrent connections?

    I work for a community college and I'm looking to revamp our social networking efforts (particularly the website). To do that - I have to setup a MySQL database. To start - the application can hold roughly 10,000 users. So my question is: Is there a maximum number of concurrent MySQL connections?...

    ITKE1,055,910 pointsBadges:
  • Migrate MySQL database to MongoDB

    I'm looking to change databases for development purposes. I'm thinking of going from MySQL to MongoDB. What's the best way to do this? Thanks!

    ITKE1,055,910 pointsBadges:
  • Do we have too many records in our MySQL InnoDB?

    We currently have a MySQL InnoDB that has millions of records. We're worried that it's too much for the database. Would you agree? Can the database handle this? Just because we noticed that several of our queries are much slower now. Thank you.

    ITKE1,055,910 pointsBadges:
  • Error message when importing SQL file: MySQL server has gone away

    I recently tried to import one of my large SQL files through phpMyAdmin but this odd error message keeps popping up: MySQL server has gone away. What does that mean? What can I do about this?

    ITKE1,055,910 pointsBadges:
  • Linux script to see what data has been changed in the past day

    My department is running a MySQL server on a Ubuntu machine. We noticed that someone changed some data in the past day but not sure of who did / what was changed. Is there a Linux script that could tell us what's been modified? This includes file names and file sizes. Thank you.

    ITKE1,055,910 pointsBadges:
  • Drop user on MySQL

    Hello again experts! Can I check if one specific user exists in MySQL and then drop him. The user doesn't work at the company anymore. I'm not sure if there's a way. Thanks.

    ITKE1,055,910 pointsBadges:
  • Open connections on MySQL database

    I currently have administrative privileges in MySQL for my job. For one of our databases on the server, is it possible for me to see all of the open connections?

    ITKE1,055,910 pointsBadges:
  • When was MySQL table last updated?

    For one of my MySQL tables, I'm looking to add a 'footer' at the bottom of the page saying when it was last updated. Is there a way to do that? Thanks.

    ITKE1,055,910 pointsBadges:
  • Cleaning MySQL InnodB storage engine

    I have a friend who needs to clean his MySQL InnoDB storage engine because it's still storing data from deleted tables. Is it possible to do that? Does he have to create a new database every single time? Thank you.

    ITKE1,055,910 pointsBadges:
  • How to export / import MySQL databases

    For my job, I have to make sure to backup all of our MySQL databases (there's over 100). For this, can I export all of them at the same time, followed by importing them into the server? Is that possible?

    ITKE1,055,910 pointsBadges:
  • Is a MySQL primary key indexed automatically?

    Hello experts, Would anyone know if a primary key is automatically indexed in MySQL? Do I actually have to create the index? Also - would this be possible in InnoDB too? Thanks!

    ITKE1,055,910 pointsBadges:
  • MySQL database export using Command Prompt

    I have a pretty large MySQL database and I need to export it ASAP. Can I use the Command Prompt to do this? Or is there another way?

    ITKE1,055,910 pointsBadges:
  • What data type should I use for storing currency values in MySQL?

    I'm using MySQL and I'm wondering what's the best data type if I want to store currency values in it. Is there a certain command?

    ITKE1,055,910 pointsBadges:
  • See indexes on MySQL database

    Specifically for MySQL, can I see if my database has any indexes? If not the database, can I see on a particular table? Appreciate the help.

    ITKE1,055,910 pointsBadges:
  • Select all MySQL columns except for one

    Is there a statement in MySQL that would select all of my columns (except for one specific column) in a table? Please note that there's roughly 50 columns in total. Thanks for the help!

    ITKE1,055,910 pointsBadges:
  • Trace MySQL queries on Linux server

    I'm using my Linux server and I was hoping there's a way to trace all of my live MySQL queries. Is that possible? I have a listener set up already (if that helps).

    ITKE1,055,910 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