The import of data is the automated or semi-automated input of data sets between different software applications.
9
votes
6answers
12k views
Import a Oracle DMP file into a Fresh install of oracle
A client sent us a oracle database we need to test against. We don't use oracle or have any oracle expertise in house.
We need to setup the database so we can connect to it and debug a problem.
I ...
8
votes
1answer
1k views
Best way to re-import large amount of data with minimal downtime
I need to import about 500,000 records containing IP lookup (read-only reference) data about once a week (only three int/bigint cols).
I don't really want to worry about merging the data with the ...
7
votes
3answers
5k views
Why is 'LOAD DATA INFILE' faster than normal INSERT statements?
I've read an article that mentioned we can achieve 60,000 inserts per second by LOAD DATA IN FILE statement that read from csv files and insert it into database.
Why should it differ from normal ...
6
votes
3answers
635 views
Suggestion for Bulk Data Import
We are working on a project which requires import data from Excel spreadsheet on daily basis. The data will be import from pre-define template and what we're thinking, first we will upload data in ...
6
votes
2answers
3k views
How can I monitor the progress of an import of a large .sql file?
I am importing a 7 GB foobar.sql to restore a table in a local database.
$ mysql -h localhost -u root 'my_data' < foobar.sql
$ mysql --version
/usr/local/mysql/bin/mysql Ver 14.12 Distrib ...
6
votes
2answers
2k views
How to extract Procedure, Function, etc. Source Code from an Oracle Export
I have generated an EXPDAT.DMP file of an Oracle database with the command:
exp userid=usr/pass@db owner=own rows=n compress=n
I then ran the following command to generate a file containing the ...
6
votes
2answers
155 views
Workaround to importing data
I am trying to import data into a SQL Server. I can import through the Import and Export Data wizard. I cannot import from my machine using BULK IMPORT or OPENROWSET since the file is not on the ...
5
votes
1answer
739 views
Error on import of mysqldump file - Illegal double value found during parsing
I am currently getting the following error while trying to import / restore a mysqldump file:
ERROR 1367 (22007) at line 445: Illegal double '1.79769313486232e+308'
value found during parsing
I ...
5
votes
5answers
7k views
How to import a .sql file in MySQL?
I am trying to import a .sql file using MySQL Workbench and I get this error:
ERROR 1046 (3D000) at line 28: No database selected
I have first created an empty database called with the same name as ...
5
votes
3answers
169 views
Determining the optimal Column Widths from a .csv File
I want to import a .CSV file into a MySQL Table. I would like to determine the optimal column widths to use based on the actual data contained in the CSV file. Are there any scripts or utilities to ...
4
votes
3answers
9k views
Oracle Import problem caused by different charecter sets
I'm trying to import an Oracle 11 export into Oracle 11 XE.
I get the following messages:
import in XE fehlerhaft
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import ...
4
votes
4answers
556 views
Exporting\Importing a large MySQL data without mysqldump
I'm attempting to export about 150GB of data from a database with hundreds of tables, and have found mysqldump to be very buggy.
After running a simple --all-databases dump succeeds, but the import ...
4
votes
3answers
125 views
Index before or after bulk load using load infile?
I have a database with over 1B rows and two columns that are indexed (in addition to the PK).
Is it better to have the index pre-defined in the table before the load infile or better to index after ...
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 ...
4
votes
1answer
217 views
MySQL Import CSV with Multiple Field Separators
I'm trying to import this CSV file into MySQL that appears to be optionally enclosed by more than one character. Unfortunately, MySQL only supports one character as a field separator.
I am stuck ...
3
votes
3answers
207 views
Checking for dupes on Compact Insert Statement
I'm not sure if that is the correct term "Compact Insert Statement" It is just what I have always heard it referred to. It goes as follows:
INSERT INTO [tblUsers]
([username], [password])
...
3
votes
1answer
3k views
Importing schema to new or different tablespace
Is there a convenient way to import a schema into Oracle 11gR2 using a single new or different tablespace than where the data originated?
As an example, I have exported BLOG_DATA from OLDDB, where ...
3
votes
3answers
84 views
Fixed length text file insert into SQL table
I am not a DBA on this one and I will not have access to BCP or anything like that. So I'm wondering if there is still a way to do it in SQL keeping it very basic.
I have 100's of text files that ...
3
votes
2answers
430 views
Can you time how long an Oracle import takes?
I'm on a Windows machine with Oracle Client 11.1.0, and am going to import a database dump. I'm importing from the command line with the "imp" command.
Is there an option to time how long the import ...
3
votes
2answers
371 views
Import and Export database in Mongo just like MySQL
I am newbie to the Mongo.Before this I have worked only with MySQL.In MySQL we can import and export database easily.I want to know is there any option available in Mongo to import and export database ...
3
votes
1answer
5k views
How can I import the contents of an Oracle database into Visio to create an Entity Relationship Diagram?
I have an Oracle database, and I would like to create an ERD in Visio 2007 Pro.
I have so far looked at DBMS_METADATA.GET_DDL commands to generate ddl. I know that I can import an Access DB into ...
3
votes
1answer
5k views
Create dump file using Oracle SQL Developer
I think I'm missing a simple point, but I couldn't find a way to use Oracle export (exp/expdp) and Oracle import (ipm/impdp) with Oracle SQL Developer (version 1.5.5)? Is there a way for it?
If ...
3
votes
2answers
2k views
Export Oracle tables based on owner + all users from database
I would like to export all user and roles objects from Oracle 10g database to another.
I googled it but I cannot find out how to do it.
First I use this command:
exp system/root@[DB_Name] ...
3
votes
0answers
101 views
Database describing databases and references to tables
Context
The company I work for makes a number of different softwares each with its own database. As they're all about related things (accounting) a good amount of data is theoretically the same among ...
2
votes
1answer
988 views
Eliminate database fragmentation (export, drop and re-import tables)
I have one datafile that is highly fragmented. Its size is 10GB now and real size that is used is 2.5GB,so 7.5 is free.
I decided to export data, drop that datafile, recreate it and import data.
...
2
votes
2answers
110 views
Postgresql: Two concurrent COPY FROM
I'm importing several gigantic csv files into a table - so I'm wondering what would happen if I ran COPY FROM jobs concurrently?
2
votes
2answers
225 views
MySQL, import SQL dump with another database
I have an SQL dump of db1 that contains this line:
"USE db1"
If I import that file into db2 with:
mysql -D db2 -uroot -p < /var/backups/db1.sql.gz
Is there the risk that db1 will be overriden?
...
2
votes
3answers
1k views
Oracle “Import from Export Files” screen refusing both SYSADMIN and Normal users
I have just installed Oracle 11g on Win64, and I want to import some .dmp files.
I am trying with the tool Oracle Enterprise Manager 11g:
If I log in with SYS as SYSADMIN, and go to Import from ...
2
votes
2answers
537 views
Importing LARGE quantity of data into a PostgreSQL database
I am importing a large amount of data into a PostgreSQL server (across multiple databases on the server).
When I last attempted to import the data, it effectively "crashed" my machine (Ubuntu ...
2
votes
1answer
557 views
Oracle imp crashes without error
I have Oracle 10g XE database locally. I export schema with something like
exp %USER%/%PASSWD%@XE statistics=NONE owner=%USER% file=dump.dmp
Exp is 10.2.0.1.0 version - so is the DB.
Than I take ...
2
votes
1answer
86 views
Apply in a CSV file to multiple databases
Recently, I have been working with a client whom has asked us to provide their dataset for use in a mobile application we are making for them. The requirements for this project include the ability to ...
2
votes
1answer
343 views
Fastest way to copy data from MyISAM to InnoDB
I want to copy all data from a MyISAM table with 16 millions rows to a InnoDB table, that will have a different (optimized) schema. See tables below to see the changes.
However, every approach I try ...
2
votes
2answers
852 views
Materialized View does not import properly when importing a db for a second time in another schema
When I import a database with materialized view mv_mt in just one schema I get no errors.
create materialized view mv_mt
refresh complete
next trunc( sysdate ) + 1
as
SELECT sysdate, media_type.*
...
2
votes
1answer
724 views
Informatica Source Qualifier not working from Windows ODBC data source (system DSN) from Excel xlsx file
Reference:
https://community.informatica.com/message/62128
Windows ODBC Workflow:
Windows > Control Panel > Administrative Tools > Data Sources (ODBC) > click "System DSN" menu > click "Add" > ...
2
votes
1answer
767 views
ORA-12899: importing a .dmp file + character set conversion
I'm working on a django project on Ubuntu 10.04 with Oracle Database Server , so I've installed: Oracle Database 10g xe universal Rel.10.2.0.1.0 cx_Oracle-5.0.4-10g-unicode-py26-1.x86_64
When I ...
2
votes
1answer
174 views
Can I monitor the progress of importing a large .sql file in sqlite3 using zenity --progress?
I'm trying to monitor the progress of a sqlite3 command importing a large .sql file into a database using zenity --progress.
I've tried the following which will import the file, however progress is ...
2
votes
0answers
2k views
Oracle 11g .DMP viewer
I have received a dump of a Oracle 11.2.0.2.0 db, which I'd like to export to some readable format like plain text, CSV, excel...
Is that possible in some sort of a simple way? I've found a few ...
1
vote
1answer
240 views
How to troubleshoot COPY FROM inserting less rows then expected?
I have a CSV (tab-delimited in fact) file with 7,590,051 lines, according to wc -l, which I want to import using COPY FROM. I removed the table's primary key, so it has no constraints.
I ran COPY ...
1
vote
1answer
219 views
When using expdp to create a snapshot of an oracle schema, how do I ensure that no post-export additions are retained upon using impdp to revert?
I want to create a snapshot of an Oracle schema that I can revert back to after testing. Impdp and expdp seem to be the best fit as far as how I'd like to accomplish it, but the problem is that impdp ...
1
vote
2answers
400 views
Is there a free software that can import excel into mysql on mac?
not csv format files, but .xls or .xlsx format excel files, is there any free software for mac, that can import data into mysql?
1
vote
2answers
447 views
Restore data from remote server using “.sql” file
I have a ".SQL" file which contains data at a remote server. I could download that file to my local machine and import data in my local DB, but because of network issues, and the size of ".sql" file ...
1
vote
1answer
787 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
3answers
205 views
How to find out which data I just imported into Oracle?
I imported two dump files (no idea what they contained, my goal is precisely to find out what they contain) into Oracle, but now I am struggling to identify what is the data I imported, and what data ...
1
vote
2answers
92 views
MySQL export user with semi-colon “;” on the end
I am trying to set up automatic export of user accounts from one server to import into another. I am running the following command;
$ mysql -u root -p -B -s -e "show grants for 'myuser'@'localhost';" ...
1
vote
1answer
2k views
PostgreSQL not working, pgAdmin always says server not listening
I am brand new at this so maybe it's a simple mistake. I was given a very large .sql file with the instructions to make a copy of a database locally on a computer. I was told "to be able to install ...
1
vote
1answer
135 views
Imports & exports under storage constraints and preallocations
I have a 5GB oracle database that I want to export and then import on my own local database. Easy right?
The point is, I use oracle XE 10g which allows me to use up to 4GB. I then decided to make the ...
1
vote
2answers
56 views
Loading data in mysql using LOAD DATA INFILE, replication safe?
I am trying to load data into mysql database form CSV file. I found that we could use LOAD DATA INFILE command to do it. But as per the mysql documentation it is not replication safe. (See here)
Is ...
1
vote
1answer
105 views
Update oracle sql database from CSV
I tried google at first but no luck.
Is it possible to update tables from csv file?
I am using SQL developer and I am using a script to export edited rows to a csv file. I would like to update the ...
1
vote
1answer
61 views
Postgres copy data with \xYY as plain string instead of interpreting as encoded string
I have a log file full of URLs, generated by Bro IDS.
When Bro logs a URL with non-ascii characters in it, it inserts \xYY where YY is the hexadecimal character code. Also, some URLs contain "\x".
...
1
vote
1answer
107 views
Is SET INTEGRITY of any use after IMPORT statements, or just after LOAD statements?
I'm getting the feeling, both from documentation and empirically, that you can only put SET INTEGRITY to good use after a LOAD, not after an IMPORT. LOAD is mentioned for SET INTEGRITY, but not ...
