7 votes

How to convert a MyISAM .sql dump into InnoDB?

You can use sed to search for engine myisam and replace it with engine innodb. sed -e 's/engine myisam/engine innodb/g' file.sql > file_innodb.sql
Tamar's user avatar
  • 186
6 votes

PowerShell: export GPO to a text file

You can use Powershell Get-GPOReport command to export all your GPO settings either to HTML or to XML file. Import-Module GroupPolicy # Export a specific GPO Get-GPOReport -Name "Default Domain ...
Net Runner's user avatar
  • 6,249
4 votes

Windows Error Reporting dumps VS procdump.exe

Both procdump and WER are good for capturing user-mode crash dumps when an application crashes. The rule of thumb is that the more comprehensive the dump, the more useful it can be, because mini-...
Ryan Ries's user avatar
  • 55.9k
3 votes

How do I dump view schemas for a MySQL database?

Mysqldump won't have any options to dump only on views.The below command will help you to take the backup of only views. mysql -uroot -pPassword INFORMATION_SCHEMA --skip-column-names -e "select ...
Sreedhar D's user avatar
2 votes

How to get a core dump from apache when segfaulting

Note that if you have PrivateTmp=true set in your /usr/lib/systemd/system/apache2.service (or whatever it's called on your system), meaning Apache actually looks for /tmp inside something like /tmp/...
Artem Russakovskii's user avatar
2 votes

PHP-FPM and continuos "exited on signal 11"

If it's still happening in the recent version of PHP, try running: $ dmesg | grep segfault | tail -10 php-fpm[327]: segfault at 834ac30 ip 000000000834ac30 sp 00007ffc112d1b78 error 14 in libnss_nis-...
kenorb's user avatar
  • 6,777
2 votes

How to install Oracle's exp / imp binaries

Instant client tools provides exp / imp utilities since v12. Unrestricted download is available: https://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/...
gavenkoa's user avatar
  • 872
2 votes

Using the CTRL - SCROLL LOCK key combination to cause a system dump

Try a 3rd-party utility to trigger the BSOD like NotMyFault https://docs.microsoft.com/en-us/sysinternals/downloads/notmyfault
David Svirskis's user avatar
2 votes

/sbin/dump: "Bad magic number in super-block while opening filesystem"

To dump an XFS filesystem, you should use the xfsdump utility. For example: xfsdump -l 0 - / will dump the / filesystem to stdout To dump on using another device/file as destination: xfsdump -l 0 -...
shodanshok's user avatar
  • 50.6k
2 votes

/sbin/dump: "Bad magic number in super-block while opening filesystem"

dump cannot dump XFS, use xfsdump
user1700494's user avatar
  • 1,662
2 votes

debugging stuck apache/php thread on production server

The following instructions are Linux-centric: Identify the faulty / stuck process In your case, the process is in state S, meaning from man ps: S interruptible sleep (waiting for an event to ...
iMil's user avatar
  • 251
2 votes

Modify source IP from a package dump

The tcprelay package typically includes the command tcprewrite. This can be used to modify a capture before passing it through tcprelay. There are examples on their wiki and in the docs. http://...
Zoredache's user avatar
  • 132k
2 votes

How to convert a MyISAM .sql dump into InnoDB?

If you really want to change the engine before importing, find/replace is the only way. Not sure if changing MyISAM to InnoDB can speedup import, but do consider couple of points: If you have a large ...
Sudhir's user avatar
  • 21
1 vote

Automating GDB memory dumps

Create a file in /usr/local/bin and make it executable afterwards: #!/bin/sh if [ $# -eq 3 ]; then tf=$(tempfile) echo -e "dump memory dump_file ${2} ${3}" > $tf gdb -p $1 -x $tf ...
flowtron's user avatar
  • 215
1 vote

why /var/spool/abrt/ folders not deleted

use the abrt-cli command: abrt-cli rm directory here is the help page: abrt-cli --help Usage: abrt-cli [--authenticate] [--version] COMMAND [DIR]... list, ls List problems [in DIRs] remove, rm ...
Tom Murphy's user avatar
1 vote

Where are "Debug Dump Files" located in windows?

I analyzed the file system during deletion process. Basically the Folder C:\Windows\Minidump was not touched at all. It deleted the file C:\Windows\MEMORY.DMP and freed up several Gigabyte.
Michael Hutter's user avatar
1 vote

sysctl kernel core pattern not working with ~

In the first command the substitution of the ~ isn't done. If you will check later the value of this sysctl variable, you'll see that. The path should be absolute. The ~ is a shell feature. And not ...
Anton Danilov's user avatar
1 vote

How to process core-dumps with Splunk?

Splunk can do this. What you're looking for is a scripted input. Splunk has documentation on this at http://docs.splunk.com/Documentation/Splunk/7.0.2/AdvancedDev/ScriptedInputsIntro Rather than ...
hmallett's user avatar
  • 2,465
1 vote

pg_dumpall is dumping only "postgres" database, not all databases

Clearly, the cron script is executing either as a different user. with different arguments. running a different program altogether. If you're on Ubuntu or Debian make sure you're using the one in ...
Evan Carroll's user avatar
  • 2,422
1 vote

make a memory dump of a large w3wp instance

For dumping the memory of a process, you can try via the task manager with a right click on your process and Full memory Dump Moreover, if it always fails, you can do a dump of all your RAM. For that,...
Sorcha's user avatar
  • 1,335
1 vote

debugging stuck apache/php thread on production server

You want to install PHP xdebug extension and enable tracing log. It will then create a file, which will have stats for every executed function - time it took to complete, amount of consumed memory, ...
Anubioz's user avatar
  • 3,725
1 vote

How do you force Windows to keep memory dumps?

In the registry, navigate to the HKLM\SYSTEM\CurrentControlSet\Control\CrashControl key. Set the value AlwaysKeepMemoryDump (REG_DWORD) to 1. Create the key if it does not exist.
Ryan Ries's user avatar
  • 55.9k
1 vote

Nginx worker process exited

Workaround is to use the same session cache for all server blocks, e.g. to configure it on the http{} level.
Dhruba Adhikari's user avatar
1 vote

Analyzing BSOD dump file from Windows 2008 R2 SP1

This looks like the issue described in the following KB article: https://support.microsoft.com/en-us/kb/2359223 "0x0000003B" Stop error occurs in Windows Server 2008 R2 and in Windows 7 when an ...
learley's user avatar
  • 459

Only top scored, non community-wiki answers of a minimum length are eligible