dump

How can I take a dump file for Winforms application

Hi, I have a C# application which is crashing for unknown reason. For understanding the issue, i want to take a dump file for it. How can i do it? many thanks, Oz. ...

How to create dmp file of Oracle database?

I have database reside in my Oracle 10g, I need to carry it to another PC. What should i do to import and export it to another pc? ...

PostgreSQL: database restore from dump - syntax error

Hi folks, I'm trying to restore a PostgreSQL database by executing the SQL that pg_dump created, on an empty database. I'm getting this error: ERROR: syntax error at or near "\" LINE 5211: \. lines 5210 and 5211 read: COPY auth_group (id, name) FROM stdin; \. It works fine on my Linux server, where I use this command: psql -U ...

PostgreSQL, update existing rows with pg_resotre

Hello. I need to sync two PostgreSQL databases (some tables from development db to production db) sometimes. So I came up with this script: [...] pg_dump -a -F tar -t table1 -t table2 -U user1 dbname1 | \ pg_restore -a -U user2 -d dbname2 [...] The problem is that this works just for newly added rows. When I edit non-PK column I get...

postgresql- restoring .dump file

Hi, I am new for psql. i got from my server data.dump file. I need to restore it in my local. i tried these commands. i) psql -U postgres dbname -f servicedb.dump Error: psql: warning: extra command-line argument "-f" ignored psql: warning: extra command-line argument "servicedb.dump" ignored ii) psql -U postgres dbname ...

Split up a mysqldump file with multiple databases, by database

Hello, I have a mysqldump file of multiple databases (5). One of the database takes a very long time to load, is there a way to either split the mysqldump file by database, or just tell mysql to load only one of the specified databases? Manish ...

Can't open HPROF file with Eclipse Memory Analyzer

Eclipse Memory Analyzer prompts me only with this message: "Invalid HPROF file header". Stack dump: java.io.IOException: Invalid HPROF file header. at org.eclipse.mat.hprof.AbstractParser.readVersion(AbstractParser.java:135) at org.eclipse.mat.hprof.Pass1Parser.read(Pass1Parser.java:69) at org.eclipse.mat.hprof.HprofInd...

Opening 32-bit process crash dumps in 64-bit Windows (so Wow process) in Visual Studio 2010

CpupSyscallStub is what I See for all threads, in Windbg I can switch to 32-bit mode and get the real threads. How do I do this in VS2010? ...

how to get SQL Server table data completely by small parts without index

I have SQL Server table without any indexes, and i can not add them. There are millions of records in that table, and i can not get all records with single query because of insufficient memory. How can i get all records in small portions - for example 100 records per portion? ...

what's "\." in postgresql dump file?

Hey I have a Postgresql dump file which i'm trying to restore. I get this error regarding an invalid data i guess. ERROR: invalid input syntax for integer: "." and when i checked the file, there are data like this: 469215 2009-10-10 18:16:47.041377 0 1 471217 2009-10-10 18:25:12.536352 0 1 473224 2009-10-17 09:46:43.041...

How to read Database DUMP .DMP Files

i have .dmp file of a database , dun know sqlserver or oracle....how can i read data from it ....extention is .DMP.......what to do..... ...

Revisions of svn dump

I have a dump file dump.svn This dump file includes the revision 0 to 2879 When i load it svnadmin load /path/to/new/repository < /path/to/dump.svn I have a corrupted revision (1174) , so loading it failed . How to load only the revisions 1175 to 2879 in my new server. Thank you ...

Take a trac repository dump

Hi, I have a trac repository available on a local network and need to take a dump of the trac data to be able to access it out of that network. Can anyone suggest a way to do it ? ...

MySQL: Dump a database from a SQL query

I'm writing a test framework in which I need to capture a MySQL database state (table structure, contents etc.). I need this to implement a check that the state was not changed after certain operations. (Autoincrement values may be allowed to change, but I think I'll be able to handle this.) The dump should preferably be in a human-re...

core dumped - but core file is not in current directory?

While running a C program , It says "(core dumped)" but I can't see any files under current path. I have set ulimit -c unlimited and verified it with ulimit -a I also tried to find file named "core" but didn't get the core dumped file? Any help , where is my core file? ...

Searching for (freeware) database migration tool

Hello there! I'm searching for a tool to dump a database including DDL and content as plain SQL-SCript, so that in can be archived in plain text format. I know e.g. the Oracle dump tools or mysqldump, but is there a tool which can connect to different datasources and get the job done? GUI would be great. Thanks, Chris ...

Postgres pg_dump dumps database in a different order every time

Hello, 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.) Do regression testing by doing steps 1.) and 2.), and then take another databa...

Why Dumping a .NET Process Increases Memory Usage

We have a .NET service using ~30MB of memory at startup. (VM ~= Mem usage) I wanted to dump the process and find out what is holding those 30MB. The CDB debugger generating the mini-dump increased mem usage by 100MB. From the dump I could see those 100MB were image memory (DLLs) -------------------- Usage SUMMARY ---------------------...

Export mysql dump file, such that statments are in the order of dependency

I need to create a dump file such that when i execute it, i have no depency issues tables run before queries parent tables before child tables etc no failed insert due to foreign key failures ...

sybase - can not migrate database

hi, I am working on load database dumps to new ase server. but when I try to load 15gb and 32gb dumps to database, I get below error. When I load 2gb dump to db, everything fine. I search on net and they advice to get db dump with sp_flushstats in single user more but I have no chance to get new dumps. isql 1> load database db1 2> ...