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.