Questions tagged [dump]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
14 votes
5 answers

MySQL server has gone away obstructing import of large dumps

I am trying to import a large sql dump (2GB) to my local mysql on my mac. I have been able to do this in the past (I was using MAMP), but now I get a ERROR 2006 (HY000) at line 7758: MySQL server ...
naxoc's user avatar
  • 241
49 votes
1 answer

Dump only the Stored Procedures in MySQL

I need to dump only the stored procedures : no data, no table creation. How can I do this using mysqldump?
nakhli's user avatar
  • 733
68 votes
9 answers

Export Postgres table as json

Is there a way to export postgres table data as json to a file? I need the output to be line by line, like: {'id':1,'name':'David'} {'id':2,'name':'James'} ... EDIT: postgres version: 9.3.4
AliBZ's user avatar
  • 1,749
8 votes
2 answers

DROP PROCEDURE IF EXISTS not included in mysqldump

I'm dumping my stored procedures only using the following command: mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt databasename -u username -p > outputfile.sql but the ...
nakhli's user avatar
  • 733
7 votes
1 answer

How to change temporary directory for pg_dump?

I'm running out of space from my hard drive which has a 18GB PostgreSQL database. When I try pg_dump to a different drive, PostgreSQL creates temporary files on the disk it's dumping from, so I run ...
kissgyorgy's user avatar
6 votes
1 answer

Backup a database with a huge number of tables

Is there a way to backup a PostgreSQL database with a huge number of tables? An attempt with pg_dump for a database of about 28000 tables resulted in the following error message: pg_dump: WARNING: ...
krlmlr's user avatar
  • 361
4 votes
1 answer

Mongodb incremental oplog Dump not working

I am not able to take an incremental oplog dump. I am not getting any error messages the connection happens fine and also there is a operation recorded(shows up in db.currentOp()), but still nothing ...
Prashanth Kumar B's user avatar
3 votes
3 answers

How to detect a running mysqldump?

Here are the things I can't change: We got a mySQL myISAM replication running a master and some slaves. One slave is being used for nightly backups using mysqldump. The backups is using heavy locks ...
Sebastian's user avatar
  • 197
1 vote
1 answer

Difference in database dump file size

Actually I am bit confused with my database export, while i exporting it shows "Total estimation using BLOCKS method: 20.83 GB" But my DB export dump is only 6 GB. Few days back we deleted some ...
SHS's user avatar
  • 152
1 vote
1 answer

restore database from dmp file

I have a situation: I have a dmp file and a database with old data server crashed and the latest data we have ar in the dmp file! we managed to pull the server back but it has old data! so we need to ...
Data-Base's user avatar
  • 357
0 votes
2 answers

Encountering "Snapshot too old" error during execution of expdp command

As am facing an issue while performing expdp command in my production db.(Oracle 11g in windows enviornment) cmd> expdp 'sys/123@PROD as sysdba' DUMPFILE=BACKUP_02082017_BACKUP.dmp LOGFILE=...
SHS's user avatar
  • 152