Questions & Answers

  • How can I enable the MySQL query log?

    Would I be able to enable the MySQL query log function so each SQL query statement that we received from our clients is logged correctly (including time)? Can I use phpMyAdmin to do this? Thank you.

    ITKE436,080 pointsBadges:
  • Import MySQL database from terminal

    Can my partner and I import out MySQL database from terminal? For some reason - we can't come up with the right syntax.

    ITKE436,080 pointsBadges:
  • How to log MySQL queries

    How can I turn on my audit logging for a MySQL database? My boss asked me to monitor all of the queries that come in every hour, followed by dumping the log into a file. Is that even possible?

    ITKE436,080 pointsBadges:
  • Show MySQL database schema

    I'm currently in my MySQL console and I'm looking to find the schema for a specific table. What's the process to do that?

    ITKE436,080 pointsBadges:
  • Changing MySQL data type for single column

    For MySQL, I'm looking to change the data type (in my columns) from FLOAT to INT. NOTE - there's no current data in there. Can someone tell me the best way to do it?

    ITKE436,080 pointsBadges:
  • Does TechTarget / ComputerWeekly give out any awards apart from the TechTarget Modern Infrastructure award?

    Does TechTarget / ComputerWeekly give out any awards apart from the TechTarget Modern Infrastructure award?

    steeje015 pointsBadges:
  • Checking MySQL tables for storage engine

    One of our MySQL databases has several tables that have been using numerous storage engines (specifically InnoDB / MyISAM). Can we find out which table is using which engine?

    ITKE436,080 pointsBadges:
  • How to create DB file using C#

    Is there a way I can make a DB file using C#? I can't find it in the toolbox at all. Do I have to use SQL Express? Appreciate any help.

    ITKE436,080 pointsBadges:
  • Sync SQLite data with MySQL

    My computer is running SQLite and I'm looking to make it sync correctly with a MySQL server (through an external network). How can I do that? Basically - whenever data is modified in SQLite, I need that data to be modified in MySQL too.

    ITKE436,080 pointsBadges:
  • Migrate MySQL database to SQL Server

    My MySQL database is already full of data but I need to migrate it all over to SQL Server 2008. Is there a particular script / code I need to do this? I don't want to download any third-party software. Thanks!

    ITKE436,080 pointsBadges:
  • Backup MySQL database in AWS

    I'm working with both AWS and MySQL and I noticed peculiar - my instance disappeared because of hardware failure. For that reason, should I backup my MySQL database so I don't use anything? Thank you.

    ITKE436,080 pointsBadges:
  • SAP Business One Internal Message

    What does Internal message (-4015) mean in SAP Business One?

    aspall5 pointsBadges:
  • How to become a SAP BW practitioner

    How would a SAP BW practitioner build a good Functional Knowledge and become a Techno-Functional?

    PerryJay15 pointsBadges:
  • How to detect Application Layer Protocol

    I have redirected web, SSH, FTP to port 5000 where my server is listening for both TCP and UDP with the help of IPTables. Now I need to know the real destination port the traffic so that I could guess application layer protocol on the basis of original destination port. Or Is there another way to...

    hackingNerd5 pointsBadges:
  • Change my subscription preferences

    I cannot find anywhere on your website where I can view/modify my subscriptions. I really like the articles, but I need to whittle my list down and remove a few subscriptions, but not all.

    nikanthis15 pointsBadges:
  • Delete all MySQL events

    Is there a way for me to delete an event in MySQL? For some reason, I can't find the command to do this - I have to do it one-by-one too. Is there a certain query to do this? I tried the below code but it didn't work: "DROP EVENT IF EXISTS (SELECT EVENT_NAME FROM information_schema.EVENTS)" Thanks.

    ITKE436,080 pointsBadges:
  • Restoring MySQL database from WAMP

    Due to a security scare, I recently re-installed Windows and had to move my WAMP folder to another partition. I just installed WAMP again but I need my old MySQL database. Is there a way to take it from the old / saved WAMP folder to my new partition?

    ITKE436,080 pointsBadges:
  • Starting software company in networking field

    Can I start my software company in networking field?

    Ashish1539315 pointsBadges:
  • Recover Windows 7 forgotten password

    I have only one administrator account for Windows 7 computer, but one day ago I change its password and couldn’t remember it now. How can I recover Windows 7 password?

    fengguangyu5 pointsBadges:
  • What does =Macro!B40 mean in Microsoft Excel?

    What is =Macro!B40? And how to see the macro in an Excel sheet and what value in B40?

    teresa1235 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