database-dump Questions

21

Solved

What command should I use to create a MongoDB dump of my database?
Leavis asked 2/2, 2011 at 22:52

11

Solved

Is it possible, using mysql dump to export the entire database structure, but exclude certain tables data from export. Say the database has 200 tables, I wish to export the structure of all 200 ta...
Compliment asked 27/11, 2012 at 21:12

21

Solved

I am moving away from Linode because I don't have the Linux sysadmin skills necessary; before I complete the transition to a more noob-friendly service, I need to export the contents of a MySQL dat...
Paddie asked 21/11, 2012 at 0:45

9

Solved

How can I make a perfect backup of mysql database using mysqldump? When I am making a backup, my tables from specified database are only getting backed up. The procedures and functions are not. Her...
Cecillececily asked 3/7, 2009 at 7:30

10

Solved

I am looking for the syntax for dumping all data in my mysql database. I don't want any table information.
Horsefly asked 24/2, 2011 at 20:24

6

Solved

I use EMS SQL Manager for PostgreSQL and I need to dump difficult database(domains, 300+ stored procedures/functions, triggers, data, etc). This tool cannot do it. Please advice me good GUI tool f...
Discomposure asked 26/4, 2012 at 16:0

8

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 n...
Fryer asked 25/5, 2012 at 20:39

12

Solved

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...
Talion asked 7/10, 2013 at 15:15

4

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 ...
Ashantiashbaugh asked 7/4, 2016 at 7:37

5

Solved

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...
Hepato asked 10/8, 2009 at 15:57

1

Solved

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: ...
Electronegative asked 27/8, 2018 at 1:33

3

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 d...
Gimcrackery asked 22/5, 2018 at 10:51

1

Solved

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?
Lorient asked 21/12, 2013 at 13:51

1

Solved

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 ...
Hessite asked 13/2, 2012 at 17:13

12

Solved

Is there a way to restrict certain tables from the mysqldump command? For example, I'd use the following syntax to dump only table1 and table2: mysqldump -u username -p database table1 table2 > ...
Baking asked 8/1, 2009 at 17:30
1

© 2022 - 2024 — McMap. All rights reserved.