Stack Overflow
Stack Overflow

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
39
votes
8 answers

postgresql- restoring .dump file

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:…
shahul
  • 391
  • 1
  • 3
  • 3
38
votes
4 answers

create dump file from database in mysql

following is the that I create dump from mysql database. mysqldump -u root tempbkk > ttt.dump but I want to create a dump that exclude one or more file while creating dump from database we select.What is the command for that ?
chetan
  • 3,175
  • 20
  • 72
  • 113
38
votes
3 answers

How can I get a SQL dump of a SQL Server 2008 database?

How can I get a SQL dump of a SQL Server 2008 database? That is, a .sql file with inserts to regenerate the data in another database, much like mysqldump.
Pablo Fernandez
  • 279,434
  • 135
  • 377
  • 622
37
votes
2 answers

dump jquery object in an alert box

I am not quite adept in maneuvering jQuery, and it came to a point that I need to debug a program that was passed down from me without a documentation. I have this var a, an object, that I really want to know the content of its collection. In my…
planet x
  • 1,599
  • 5
  • 26
  • 44
33
votes
4 answers

Export dump file from MySql

I want to create a dump file of a table in the database. So database --> king, tablename --> castle So what I want to do is create a dump file.. and then the next part is to import it in my local host. database name --> king_local. Any ideas on how…
frazman
  • 32,081
  • 75
  • 184
  • 269
33
votes
3 answers

Best (easiest) way to make a SQL Server dump and import that dump in another SQL Server

I would like to achieve a database export (dump) in SQL Server from one server and import that dump in another SQL Server and not necessarily in the same schema name. For example if I have a database prepared with all the data set for implement a…
simonC
  • 4,101
  • 10
  • 50
  • 78
30
votes
9 answers

Transfer Mysql database to another computer

I have a mysql database filled up and running on a Windows computer, is there any tool to transfer the database to another computer (running Ubuntu)? Else I'll just write a script to take all the data base into SQL and insert it on the other…
fmsf
  • 36,317
  • 49
  • 147
  • 195
29
votes
3 answers

mysql, dump, database restore

I have dumped my database with the following command: mysqldump -uuser -ppassword db_name > file then I completely removed my database: drop database db_name; then I created a new database: create database db_name; and then I tried to restore the…
Furqan Asghar
  • 3,670
  • 4
  • 23
  • 27
29
votes
3 answers

PostgreSQL: database restore from dump - syntax error

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…
Hoff
  • 38,776
  • 17
  • 74
  • 99
27
votes
4 answers

How restore a PostgreSQL table from *.sql using pg_dump or psql?

I need to restore a big table (250mb) in PostgreSQL database in console tool. How I can do this using ps_dump or psql?
NiLL
  • 13,645
  • 14
  • 46
  • 59
27
votes
4 answers

How to Dump a .NET Core Application on Linux

I have a .NET application that I have ported to .NET Core. I am testing it on Ubuntu 14.04. I am trying to figure out how to get a .dmp file or the Linux equivalent when the program crashes. I call Environment.FailFast but as far as I can tell this…
shortspider
  • 1,045
  • 15
  • 34
27
votes
7 answers

Migrate from Oracle to MySQL

We ran into serious performance problems with our Oracle database and we would like to try to migrate it to a MySQL-based database (either MySQL directly or, more preferably, Infobright). The thing is, we need to let the old and the new system…
Dan Soap
  • 10,114
  • 1
  • 40
  • 49
27
votes
5 answers

Svnadmin load from dumpfile causes "file not found error". Help?

Given: Repository_1 - source Repository_2 - destination I created a dump file of Repository_1/Folder1 using combination of svnadmin and svndumpfilter When loading from the dump file from Repository_1/Folder1 into Repository_2/Trunk everything is…
Chicago
  • 1,619
  • 4
  • 19
  • 32
27
votes
4 answers

SOS does not support the current target architecture

I am trying to use windbg to research a hang dump file created on an x64 machine for our x86 process. This is a 4.0 x86 application, so just to get an unmanaged stack, I had to do the following: .loadby sos clr .load wow64exts !sw kL However,…
Justin Pihony
  • 66,056
  • 18
  • 147
  • 180
27
votes
6 answers

CouchDB dump to file and load from file

I cannot replicate between two couchdb servers, so I would like to dump to file from one server and load from file into the other server. I used this statement to dump and it worked fine: curl -X GET…
eriq
  • 1,524
  • 3
  • 13
  • 22
1 2
3
…
99 100