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

    ITKE436,000 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.

    ITKE436,000 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?

    ITKE436,000 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.

    ITKE436,000 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.

    ITKE436,000 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?

    ITKE436,000 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!

    ITKE436,000 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?

    ITKE436,000 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?

    ITKE436,000 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.

    ITKE436,000 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!

    ITKE436,000 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).

    ITKE436,000 pointsBadges:
  • Show last MySQL queries on servers

    How can I show the last queries executed on all of my servers in MySQL? Is there a specific query to do this?

    ITKE436,000 pointsBadges:
  • Find current SQL Server database transaction level

    How can I find the current SQL Server database's transaction level? Thank you very much

    ITKE436,000 pointsBadges:
  • Best way to create a flat file

    Is there a format I can buy or can I convert an Excel spreadsheet into a flat text file?

    CJSDOYLE5 pointsBadges:
  • Apply an archive policy to all databases in a folder?

    How do I apply an archive policy to all databases in a folder?

    Brad Harris5 pointsBadges:
  • Replace MySQL word string

    For MySQL, I currently have a column that contains URLs. In the URLs, I need to change a word - from update to news. How can I do that? Using a script?

    ITKE436,000 pointsBadges:
  • Help me please, how open damaged MDB?

    Hi. I've stored my old email messages in an access database (MDB). Now I want to transfer those messages with attachments to Outlook or another email program so I can browse and search my messages with ease. There is an option in Outlook to import messages from an access database, but it's...

    stephangoldschmidt5 pointsBadges:
  • Backup and restore SQL Azure database

    I have a SQL Azure database that's roughly 40 GB and when I'm backing it up and restoring it, it takes roughly 6-8 hours. Is there a way to make it faster? If so, what's the process?

    ITKE436,000 pointsBadges:
  • MDX File not automatically linked to DBF

    USUALLY when you create an MDX on a DBF, that MDX will AUTOMATICALLY be used when one uses the DBF. However I am experiencing one DBF that will NOT link to its MDX when the DBF is used. I have to alter my programs to "SET INDEX TO" the MDX followed by "SET ORDER TO" For Example: USE PARAMS ORDER...

    Thanbor5 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