Questions tagged [dump]
The dump tag has no usage guidance.
11
questions
14
votes
5
answers
47k
views
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 ...
- 241
49
votes
1
answer
76k
views
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?
- 733
68
votes
9
answers
121k
views
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
- 1,749
8
votes
2
answers
19k
views
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 ...
- 733
7
votes
1
answer
7k
views
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 ...
- 325
6
votes
1
answer
7k
views
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: ...
- 361
4
votes
1
answer
2k
views
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 ...
3
votes
3
answers
12k
views
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 ...
- 197
1
vote
1
answer
11k
views
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 ...
- 152
1
vote
1
answer
10k
views
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 ...
- 357
0
votes
2
answers
36k
views
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=...
- 152