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

    ITKE435,985 pointsBadges:
  • Linked tables corrupted Access 2007

    I have been using an Access database for some years now, it comprises of a front end called sitecal.mdb and has a back end which I think are all linked tables called sitedata.mdb Last week the sitedata.mdb which contains the linked tables crashed and I now get the error: Unrecognized database...

    domingoo5 pointsBadges:
  • SAP PI app server and database

    What is the SAP PI app server and database? How do I install it?

    Jeevitha125 pointsBadges:
  • Audit application access controls

    Hi, I'm reviewing access controls for a list of applications and some of the app owners claim they don't have human users. Is there a way to validate that? What procedures and evidence would give an auditor a good level of assurance that the app indeed has no users? Thanks. P.S. I'm not talking...

    stantastic5 pointsBadges:
  • Local domain server / database server / unmanaged switch = slow transfer to clients PC

    A network consists of domain server database server and unmanaged switch. Now the clients software is taking more than usual time when accessing database and their software hangs for some time. The client PC also have some shared data that other PCs on network. I think its because the database size...

    nomanisprfct5 pointsBadges:
  • how to display 10records in the browser again when we press the next button it will display 10 recors

    I am creating a form with three fields eno,name,salary and search button. I may or may not enter the values to the text fields and then press the search button. Here based on the values the query will generate and execute now the 10 records are display if may available otherwise it will display...

    suneelkumar15 pointsBadges:
  • SQL Server: Moving database files

    I currently have a SQL Server database and I need to move several .MDF and .LDF files somewhere else. But I can't stop the SQL Server service and I can't export it to another server too. How can I do this?

    ITKE435,985 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.

    ITKE435,985 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...

    ITKE435,985 pointsBadges:
  • SQL Server: Document databases

    Over the course of the past month, my department has noticed that several of our clients are not documenting their SQL Server databases and that's making us worried. First off, should we be worried? If so, then what should we do? Thanks!

    ITKE435,985 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?

    ITKE435,985 pointsBadges:
  • .MAR File opening with Microsoft Access

    How can I open a MS access report shortcut file using MS Access?

    NehaSoni5 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

    ITKE435,985 pointsBadges:
  • InnoDB: Shrink file without having to dump and re-import database

    I'm using InnoDB and it's storing all of my info in one big file. I went in and removed a big table but the file still keeps the same size. Is there a way I can shrink that file without dumping and re-importing my whole database. Thank you very much.

    ITKE435,985 pointsBadges:
  • SQL Server 2008: Shrink database files

    In SQL Server 2008, is there a way I can shrink my files (log and data) on all of my databases? I've already tried to use SSMS and right click each one but that's way too slow. Is there anything faster?

    ITKE435,985 pointsBadges:
  • SQL Server: Get database name

    How do I get the database name and associated user mapped for all database in SQL Server?

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

    ITKE435,985 pointsBadges:
  • Is it possible to set up a PHP-based Q&A module without a database?

    I'd like to set up a PHP-based Q&A module that doesn't require any kind of database. For example, a user would fill out a form asking a question, and then click on a submit button to send it to a moderator. The moderator would then instantly receive the question and have the ability to modify...

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

    ITKE435,985 pointsBadges:
  • Using two same files from different libraries in a RPGLE program.

    Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime. So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve...

    navinnegi45 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