dump Questions

3

Solved

I tried redis's DUMP command, redirect to file (or pipe), but RESTORE report this error: $ redis-cli dump test > /tmp/test.dump $ cat /tmp/test.dump | redis-cli -x restore test1 0 (error) ERR D...
Mcwhorter asked 21/4, 2013 at 3:34

4

Is there a difference between object = {1:"one", 2:"two", 3:"three"} file.write(json.dumps(object)) and json.dump(object). If no, which one should I use? Which one is...
Davon asked 7/3, 2021 at 22:51

5

Solved

I am trying to use windbg to research a hang dump file created on an x64 machine for our x86 process. This is a 4.0 x86 application, so just to get an unmanaged stack, I had to do the following: ....
Hopson asked 7/5, 2013 at 15:12

5

Solved

I need to restore a big table (250mb) in PostgreSQL database in console tool. How I can do this using ps_dump or psql?
Apollonius asked 24/2, 2012 at 9:17

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

18

Solved

I would like to know the command to perform a mysqldump of a database without the prompt for the password. REASON: I would like to run a cron job, which takes a mysqldump of the database once every...
Infernal asked 15/2, 2012 at 12:5

3

Solved

I got a little problem when I try to restore a large database (almost 32Go in custom format) on my devel database node (this node has less RAM, CPU... than my production server). My database dumps...
Lipocaic asked 2/4, 2013 at 13:37

2

Solved

I've always been able to dump my remote database using mariadb-dump from the CLI. Starting today, I suddenly got the following error mysqldump: Couldn't execute 'select column_name, extra, g...
Iona asked 7/3, 2023 at 12:39

4

Solved

I generated a fixture: python manage.py dumpdata --all > ./mydump.json I emptied all my databases using: python manage.py sqlflush | psql mydatabase -U mydbuser But when i try to use loadd...
Benbena asked 9/2, 2014 at 2:41

57

Solved

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C ...
Vraisemblance asked 16/7, 2013 at 0:43

3

Solved

I'm using mysqldump to share databases dumps, but I'm having an issue with triggers. The command does not add "drop" or "replace" lines with the triggers, making people who alre...
Uranium asked 22/12, 2016 at 10:54

5

Solved

How to create a MySQL database dump (.sql file) with all its triggers and procedures?
Dietsche asked 22/2, 2011 at 7:18

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

2

Solved

I used the Format-Hex command in PowerShell to get the hex contents of a string. My command "some_string" | format-hex gives me the output in a table. How can I make it into a raw hex dump so it's ...
Stockdale asked 21/1, 2018 at 23:53

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

16

Solved

I'm using a MySql database with a Java program, now I want to give the program to somebody else. How to export the MySQL database structure without the data in it, just the structure?
Stelu asked 30/5, 2011 at 11:6

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

3

Solved

Using Wikipedia's dumps I want to build a hierarchy for its categories. I have downloaded the main dump (enwiki-latest-pages-articles) and the category SQL dump (enwiki-latest-category). But I can'...
Spector asked 2/7, 2013 at 17:42

5

Solved

How do I export/import large database on MAMP ? Using PHPMyAdmin does not work as it supposed to be.
Immerse asked 27/6, 2013 at 13:24

4

I have a postgresql .sql dump file created by pg_dump on another windows 10 box. I am trying to restore it on my windows 10 laptop with "psql -U user -d database -1 -f filename.sql". I created the...
Zomba asked 8/8, 2019 at 17:16

3

Below is my code: In this code I am trying to split and normalize a ".p" file into files with different norms. However, it seems that the split is working but I cannot save them into ".p" files usi...
Kelcie asked 16/1, 2018 at 19:1

1

For a previous employer, while performing dump analysis, I have regularly used heap_stat.py, based on PYKD library for Windbg. I believe heap_stat.py script only works for C/C++ development. Is the...
Marchant asked 13/6, 2023 at 14:56

9

Solved

Is it possible to write a bash script, which would contain a binary executable program inside? I mean a script, which would contain a dump of an executable in a textual form, which will be dumped ...
Kursh asked 23/8, 2013 at 19:51

7

Solved

I have binary and want to extract part of it, starting from know byte string (i.e. FF D8 FF D0) and ending with known byte string (AF FF D9) In the past I've used dd to cut part of binary file fro...
Kaine asked 26/2, 2012 at 9:16

1

How to give WHERE condition in pg_dump to extract for particular values in below command, pg_dump --table=export_table --data-only --column-inserts my_database > data.sql
Craig asked 22/7, 2022 at 19:42

© 2022 - 2024 — McMap. All rights reserved.