Stack Overflow
Stack Overflow

Questions tagged [database-dump]

29 questions
232
votes
20 answers

How do I create a MongoDB dump of my database?

What command should I use to create a MongoDB dump of my database?
TIMEX
  • 259,804
  • 351
  • 777
  • 1,080
64
votes
12 answers

Mongodump from remote server

We recently ported some data over to MongoDB and are now looking into running daily backups, preferably from a cron job, and restore one of the backups to a secondary mongo database. Our system is set up as follows: server 1: the development mongo…
awestover89
  • 1,713
  • 4
  • 21
  • 37
61
votes
8 answers

How to restore PostgreSQL dump file into Postgres databases?

I have a dump file with a .SQL extension (in fact it is a plain-text SQL file). I want to restore it into my created databases. I am using pgAdmin III, and when I use its "Restore Wizard" it does not highlight the button "Restore". Instead it is…
Usman
  • 2,742
  • 4
  • 44
  • 82
22
votes
5 answers

English dictionary SQL dump?

I'm looking for an open source, full english dictionary, that includes the type of word (i.e.: adjective, past tense, etc.) in some sort of database format, either SQL or something that could be easily parsed and turned into sql. Any idea where I…
Andrei Serdeliuc ॐ
  • 5,828
  • 5
  • 39
  • 66
15
votes
4 answers

pg_restore: [archiver] input file is too short error in postgres

I am trying to dump the database in my local system by using the command : pg_restore --host=localhost --port=5432 --dbname=dev_db --no-owner --no-privileges db_dump_new.backup but I am getting the error : pg_restore: [archiver] input file is too…
the_unknown_spirit
  • 2,518
  • 7
  • 34
  • 56
10
votes
3 answers

Mysql take dump of some portion like 10-20 % of whole database

I know that to take database dump I can ignore some tables. but I want to take the dump of all table with some percentage of data like 20% 40% because the whole dump is too big. here is my normal dump query. mysqldump -h dburl -u user -p password…
Rick_C137
  • 144
  • 1
  • 11
8
votes
1 answer

Convert a PostgreSQL dump into a MySQL dump

I have a Postgres dump file and I need to turn it into a MySQL dump so I can create a matching MySQL database. I am new to Postgres I have it installed on my Ubuntu server and I was going to see whether I could import and export SQL of some sort. I…
user1207329
8
votes
1 answer

phpMyAdmin "Dump some row(s)" for more than one table at once

I have a MySQL database with about 50 tables and thousands of records in each table. How can I create a dump of the database containing all tables and only 10 records of each table?
Flavio
  • 846
  • 1
  • 9
  • 21
5
votes
1 answer

Dump database with pg_dump, ignoring tables that we don't have access to

I have a script where pg_dump is failing with a message like this: pg_dump -h db1 --format plain --encoding UTF8 --schema=public --schema-only --no-owner me pg_dump: [archiver (db)] query failed: ERROR: permission denied for relation…
Steve Bennett
  • 114,604
  • 39
  • 168
  • 219
3
votes
4 answers

PostgreSQL dump/restore

I don't want to Dump the entire table but only certain records in a table in my dump file and later restore the same. P.S.: I want to do the same for more than 1 table in my database but dump it in a single file. Is this possible? If yes then how do…
Shirish11
  • 1,587
  • 5
  • 17
  • 39
3
votes
2 answers

Easiest way to dump Heroku database for use in local seed.rb?

I can dump a heroku database with $ heroku pgbackups:capture. Also, this SO post shows that there are tools for taking a development database and dumping it to seed.rb. I'm wondering if there is an easy way to combine the two processes, effectively…
user456584
  • 86,427
  • 15
  • 75
  • 107
2
votes
1 answer

Spring 3 / Hibernate - execute DB dump during runtime

I am developing a application with spring roo, which uses spring 3 and hibernate. Due to the fact that the Backend is built to be not a productive one, I net an option to set the data back to a dump. This dump should be "executed" if the user…
Alexander
  • 7,178
  • 8
  • 45
  • 75
2
votes
0 answers

Pulling db from heroku to local db

I am trying to pull my pg database on heroku into my local development database. I am running heroku pg:pull HEROKU_POSTGRESQL_URL LOCAL_POSTGRE --app MY_APP Unfortunately I get : pg_dump: server version: 9.5.4; pg_dump version: 9.4.5 pg_dump:…
David Geismar
  • 3,152
  • 6
  • 41
  • 80
2
votes
1 answer

Proper way to migrate a postgres database?

I have a dev version and a production version running in django. I recently started populating it with a lot of data and found that the django loaddata tries to load everything into memory before adding it into the db and my files will be too big…
Joff
  • 11,247
  • 16
  • 60
  • 103
1
vote
0 answers

Mariadb Dump download from command line

i am trying to take dump of database using CLI mariaDb i am executing following query. mysql -u root -p --database = byx_prod_db < dumpfile.sql; i am getting this error ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that…
noobie-php
  • 6,817
  • 15
  • 54
  • 101
1
2