The dump tag has no wiki summary.
8
votes
5answers
8k 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 ...
6
votes
1answer
2k 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?
4
votes
2answers
1k views
Import Oracle full dump file to fresh Oracle installation
I am importing a Oracle dump fill created on a AIX Oracle 9.2 installation with a Full Export option to a Windows Oracle 10.2.0.4 on Windows 2008 R2 x64.
I want to import the file to a clean ...
3
votes
1answer
120 views
pg_dump freezes on windows service application
I have a system running over Tomcat which executes a backup batch job every day, it calls pg_dump.exe from Java and stores its output to an SQL file.
When I'm executing Tomcat from the shell, it ...
3
votes
1answer
3k 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 ...
3
votes
1answer
205 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: ...
3
votes
1answer
134 views
Dump PostgreSQL schema with foreign keys and referenced data
The official PostgreSQL documentation states that pg_dump can use the --schema=SCHEMA option to selectively dump a given schema.
However according to the same documentation (read Note on ...
2
votes
1answer
489 views
Load database from Solaris (Sybase 15.0.3) to VMWare Solaris (Sybase 15.7.0)
I need to perform a load of a Sybase (15.0.3) Database from a Sun Solaris 5.10 environment (on sparc architecture) to Sybase (15.7.0) on Solaris 10 (on i86pc architecture) running on my vmware ...
2
votes
2answers
480 views
Export pipe-delimited data with progress db
I've been handed a task where we need to dump specific tables in a progress database (10.2B) to pipe-delimited flat files (50+ tables) and send them to a third party for analysis every week.
Looking ...
2
votes
1answer
83 views
MySQL - Partially restore binary log
I have restored a dump into MySQL. I also have a binary log, which I want to partially restore, let's say from position 10 - 2500.
How can I do that?
2
votes
1answer
652 views
Is it possible to convert a .mysql file to a .sql file?
I am facing an issue with a MySql dump file (i.e mydump.mysql) generated by a Drupal export module. I am trying to import it on a local Drupal installation via Acquia Dev Desktop.
When browsing for ...
2
votes
3answers
532 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 ...
2
votes
1answer
376 views
MySQLDump wrong dump
i'm trying to generate a dump from my database but when i try to load the dump file it gives me an error. What should i do ?
My MySQL ( loader) version is mysql "Ver 14.14 Distrib 5.1.57, for ...
2
votes
1answer
691 views
How to migrate data from Google AppEngine Datastore
How to migrate data from Google AppEngine's Datastore to other database (not Datastore)?
There is appcfg.py download_data but it produces sqlite3 file with empty bulkloader_database_signature and ...
1
vote
1answer
786 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 ...
1
vote
1answer
2k views
Error when load db dump (cross platform)
After a Sybase (15.0.3) compress dump a database on the original platform - Solaris Sparc 64 - with all the required steps (even the quiesce step), I have tried to load it on my Sybase (15.7) Solaris ...
1
vote
1answer
1k views
Difference between database dump (export) and database backup?
What is the drawback using only EXP command for a database dump (and considering it as a backup) instead of taking backups using BACKUP DATABASE command (via RMAN)? What is a difference between ...
1
vote
1answer
201 views
What is this database dump format?
I have a file which I believed was an Oracle data dump, but Oracle refuses to import it:
There is a problem reading from the import files
ORA-39143
"C:\nm\data\THEFILE.dmp" may be an original export ...
1
vote
1answer
137 views
MySQL Dump all rountines except one
We want to export a large amount of tables and routines and we've do this often. Each database, table and routine should be dumped with one exception: a procedure with a specific name. So I was ...
1
vote
1answer
292 views
How mysqldump replaces special characters during dumping records?
i am trying to dump a particular row using java.
So that i retrieve the data by using record sets and i manually written sql script code by appending the dynamic records.
But my problem is i could ...
1
vote
0answers
185 views
How do I import a dump for a deleted tablespace?
I'm trying to import a database dump, however I am encountering this error:
ORA-39083: Object type TABLE:"MYSCHEMA"."MINF" failed to create with error:
ORA-00959: tablespace '_$deleted$5$0' does not ...
1
vote
0answers
186 views
How to dump an advanced revelation database?
Retail store I work with has an ancient inventory/accounting/receiving system that is based off Advanced Revelation. They run the DOS and Windows clients. I'd like to get a dump of their data to ...
0
votes
1answer
170 views
Moving data between Oracle and PostgreSQL
For a future project I need to use the following setup:
Some small (offline) data boxes (colleting data over the time) fill PostgreSQL databases. (Summing up to about 1 TB a year.
For time to time, I ...
0
votes
1answer
425 views
I would like to launch a pg_dump command from a remote computer
I would like to launch the command: pg_dump.exe -h 255.255.255.255 -p 5432 -U postgres -F p -a -v -f "test.db.dump" mydb from a remote computer. Both the database and the remote computer are under xp.
...
0
votes
1answer
164 views
postgresql dump and load — need to dump “postgres” db also?
If I pg_dump a db from an 8.4 cluster, and then load it into a different 9.1 cluster, do I need to pg_dump and restore the 'postgres' db as well? (I'm not familiar with what is contained in the ...
0
votes
1answer
800 views
postgresql: how do I dump and restore roles for a cluster?
Where are roles stored in a cluster, and how do I dump them?
I did a pg_dump of a db and then loaded it into a different cluster, but I get a lot of these errors:
psql:mydump.sql:3621: ERROR: role ...
0
votes
2answers
2k views
Opening a .backup file for PostgreSQL
I'm going to warn you that whoever explains this needs to talk to me like I'm five years old, because this is something way, way beyond my level of expertise.
In short, I have what I think is a ...
0
votes
1answer
178 views
How to extract a whole database schema using only ODBC access?
I need to migrate an old proprietary database (custom database based on a Btrieve engine) to a newer system . All I have to access this database is an ODBC driver that works pretty well. When I ...
0
votes
4answers
251 views
How can I convert an Oracle dump file into SQL Server?
I want to ask about converting Oracle dump files (.dmp) into SQL Server files (.bak) where during conversion I don't have to be connected to any database server.
I've searched for related ...
