Questions tagged [dump]

Recording the contents of memory after application or operating system failure, or by operator request, in a core dump for use in subsequent problem analysis. Also, recording a file or medium as a backup.

1607 questions
26
votes
8 answers

MySql to PostgreSql migration

My PostgreSQL is installed on Windows. How can I migrate data from MySQL database to PostgreSQL? I've read tons of aricles. Nothing helps :( Thanks. My actions: mysql dump: mysqldump -h 192.168.0.222 --port 3307 -u root -p --compatible=postgresql…
Andrew Kalashnikov
  • 3,073
  • 5
  • 34
  • 57
26
votes
7 answers

Postgres pg_dump dumps database in a different order every time

I am writing a PHP script (which also uses linux bash commands) which will run through test cases by doing the following: I am using a PostgreSQL database (8.4.2)... 1.) Create a DB 2.) Modify the DB 3.) Store a database dump of the DB (pg_dump) 4.)…
littleK
  • 19,521
  • 30
  • 128
  • 188
25
votes
2 answers

How to get Java8 Metaspace dump (not heap dump)

Are there any tools that are able to get Metaspace dump from a Java8 hotspot vm ?
czh
  • 395
  • 1
  • 3
  • 8
25
votes
5 answers

Restore dump on the remote machine

I've got my own machine with postgres dmp file, which I want to restore on the remote virtual machine (e.g. ip is 192.168.0.190 and postgres port is 5432) in my network. Is it possible to restore this dump using pg_restore without copying dump to…
Danila Zharenkov
  • 1,720
  • 1
  • 15
  • 27
23
votes
6 answers

C# How to dump all variables & current values during runtime

Are there any in-built or 3rd party libraries that allow you to simply dump all variables in memory during run time? What I would like is to be able to view variables & current values similarly to viewing them by hitting a break point and hovering…
mike
  • 3,146
  • 5
  • 32
  • 46
21
votes
4 answers

WinDbg x64: Cannot debug a crash dump - failed to load data access DLL

I attached WinDbg to a running process and had the process crashed (I have a separate question re. that case). Once the program crashed, WinDbg stopped and allowed me to debug the program. I took a crash dump for further investigation with a command…
net_prog
  • 9,921
  • 16
  • 55
  • 70
21
votes
1 answer

Compare heap dump (HPROF) files

Is it possible to compare two HPROF files? How?
Asahi
  • 13,378
  • 12
  • 67
  • 87
21
votes
2 answers

How to use pg_restore with AWS RDS correctly to restore postgresql database

I am trying to restore my Postgresql database to AWS RDS. I think I am almost there. I can get a dump, and recreate the db locally, but I am missing the last step to restore it to AWS RDS. Here is what I am doing: I get my dump $ pg_dump -h…
Micromegas
  • 1,499
  • 2
  • 20
  • 49
21
votes
4 answers

Is there a MySql binary dump format? Or anything better than plain text INSERT statements?

Is there anything better (faster or smaller) than pages of plain text CREATE TABLE and INSERT statements for dumping MySql databases? It seems awfully inefficient for large amounts of data. I realise that the underlying database files can be copied,…
Ollie Glass
  • 19,455
  • 21
  • 76
  • 107
21
votes
2 answers

What is sql-dump for?

I know that a SQL dump is a series of insert SQL statements which reflect all the records inside the database. But what is it used for? Why should we dump the database records? Does every database support a dumping function?
Yang
  • 9,794
  • 15
  • 44
  • 52
20
votes
3 answers

Is there a way to have an Android process produce a heap dump on an OutOfMemoryError?

The sun JVM supports a -XX:+HeapDumpOnOutOfMemoryError option to dump heap whenever a java process runs out of heap. Is there a similar option on Android that will make an android app dump heap on an OutOfMemoryException? It can be difficult to try…
emmby
  • 99,783
  • 65
  • 191
  • 249
20
votes
3 answers

Dump the whole HTTP communication as raw data in nodejs

I wonder if it's possible to dump the whole HTTP request+response as it goes over the wire. I don't want to get the method, the path info, the query string, the headers, the cookies, the body and whatever. I could in theory assemble the raw data…
maaartinus
  • 44,714
  • 32
  • 161
  • 320
20
votes
2 answers

Nodejs process hang, how could I debug it or collect dump?

my nodejs process which was running at Linux, now it is hang and the CPU is 100%. Is there anyway I can do to debug it and find the reason? Do I need to collect dump and how? Thanks.
kevin_song
  • 449
  • 1
  • 4
  • 14
19
votes
2 answers

Wikipedia Category Hierarchy from dumps

Using Wikipedia's dumps I want to build a hierarchy for its categories. I have downloaded the main dump (enwiki-latest-pages-articles) and the category SQL dump (enwiki-latest-category). But I can't find the hierarchy information. For example, the…
fersarr
  • 3,399
  • 3
  • 28
  • 35
19
votes
2 answers

How to use redis' `DUMP` and `RESTORE` (offline)?

I tried redis's DUMP command, redirect to file (or pipe), but RESTORE report this error: $ redis-cli dump test > /tmp/test.dump $ cat /tmp/test.dump | redis-cli -x restore test1 0 (error) ERR DUMP payload version or checksum are wrong $ redis-cli…
Frank Xu
  • 396
  • 1
  • 3
  • 9