Questions & Answers
Active Directory, AS/400, Backup, Business Intelligence, Career Development, CIO, CRM, Data Management, Database, DataCenter, Development, Hardware, IBM DB2, IBM iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Exchange 2003, Microsoft Exchange 2007, Microsoft Outlook, Microsoft Outlook 2003, Microsoft Outlook 2007, Microsoft Windows, Microsoft Windows 7, Microsoft Windows Server 2003, Microsoft Windows XP, Mobile, Networking, Oracle, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Uncategorized, Virtualization, Visual Basic, VoIP, VPN, Windows Server, Windows Server 2008 ...VIEW ALL TAGS
- Business Intelligence
- Career Development
- Cloud Computing
- Content Management
- Data Management
- Desktop Management
- Email Administration
- IT Strategy
- Lotus Domino
- Microsoft Exchange
- Microsoft Windows
A coworker wants to me send me a .SQL file and I have to export / import that file to / from our MySQL database using the command line. What's the command to do that? Could I possible use mysqldump? Quick note: The file might have several constraints too.
Can I figure out how much disk space my MySQL table is using? The table is in InnoDB. What can I do?
Is there a chance I could backup just one single table in a MySQL database? I tried mysqldump but that backed up the entire database. Thanks.
Good morning, In SAP, I keep getting this error message: An error has occurred in the smart form. What should I do?
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.
Can my partner and I import out MySQL database from terminal? For some reason - we can't come up with the right syntax.
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?
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?
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?
Does TechTarget / ComputerWeekly give out any awards apart from the TechTarget Modern Infrastructure award?
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?
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.
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.
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!
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.
What does Internal message (-4015) mean in SAP Business One?
How would a SAP BW practitioner build a good Functional Knowledge and become a Techno-Functional?
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...
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.
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.