The import of data is the automated or semi-automated input of data sets between different software applications.

learn more… | top users | synonyms (1)

6
votes
4answers
851 views

Mysql (percona-server 5.5) completely stalls during import (myloader)

While configuring our new servers (IBM X3650M4, 2x Intel Xeon E5-2620, 64G RAM, RAID 10 (4x 240G SSD)) we bumped into a strange problem. We're trying to import dumps (mydumper) from our (old) ...
2
votes
1answer
119 views

In SQL Server, are there any other options of data Import and Export

I've been working with SQL Server since SQL Server 7. So I know about BCP, Bulk insert, openrowset and SSIS. My question is a simple one: Do you know of any other ways to Import/Export data using ...
1
vote
0answers
34 views

SSIS Guarantee that all data will be moved to target when running data flows in parallel

My package has the following two tasks which run in parallel. DF - Move source data to target loads a copy of all source data to target via OLEDB Dest - Target and also loads a copy of source PK ...
0
votes
0answers
27 views

Efficient import of 1 million SQL files in Postgresql

I have a huge problem. I have 1 million SQL files varying in size from 9KB to 3MB that I need to import into one table very quickly. The files represent hundreds of billions of rows. Is there a ...
0
votes
2answers
369 views

Whats the best and fast way to import a huge DBF file to a Postgres in Windows?

I have some huge DBF files (about 35 GB) to import to Postgres. Whats the best and fast way to do it? OBS: I have 300 GB of free disk space and 8 GB RAM.
0
votes
1answer
76 views

Import quoted CSV

I have a set of quoted CSV files, which I need to import into SQL Server. Files look like this: "ColA","ColB","ColC" "12345","John Smith","-75.33" "12356","Jane Doe","43.12" BCP and BULK INSERT ...
0
votes
0answers
115 views

MySQL Export not possible to import due to ERROR 1064

we are currently in the progress of moving from MySQL to PG. To do so we are in the progress of setting up a test environment for our database operations. The process is rather simple: We have ...
0
votes
0answers
202 views

Mysql dump import shows error 1556 (HY000) “you can't use locks with log tables”

I'm trying to setup a replication slave for an existent MySQL server. Therefore I dumped all data from the master like this: mysqldump --skip-lock-tables --single-transaction --flush-logs --hex-blob -...
0
votes
2answers
195 views

Can I do an impdp with a file on my local computer

I was given a dump file which is currently on my local computer. I want to import this to our Oracle 11G DB which is hosted on a server. Do I need to move this file to the server to do the impdp or ...
5
votes
2answers
378 views

Import XML files into SQL Server 2012

Every Friday I have to import a couple (sometimes more than 300) of XML files into 2 tables. The structure of one of the tables, R000000, looks like this: R00000010 | R00000020 | R00000030 | ...
1
vote
1answer
222 views

After Insert Trigger never fires using Import Wizard

Using Import Wizard I tried importing tables tcc_Block and PROJECT_IDENTITY. These 2 table structures already exist in SQL Server and they are related with ProjectID columns. PROJECT_IDENTITY has ...
3
votes
1answer
61 views

Migrating database from old software to new software

I am a young web developer and I am facing a problem I cannot solve on my own and need some help and/or orientation. My client has an agenda (Lotus), which is a very old software, and I have ...
0
votes
3answers
2k views

mongoimport error - Failed: error connecting to db server: no reachable servers

I am currently trying to learn mongodb and I am having trouble finding a solution for this problem. When I run a mongoimport command it I get the following error: ~ mongoimport --host localhost --...
0
votes
1answer
72 views

Import sql structure from sql file which has data

I have a giant sql file that I created from my working server, but have had to shut that server down. I'm trying to import the sql into my test server (very small). I just want to import the table ...
1
vote
0answers
672 views

SQL Server 2014 Import Wizard missing data source option

I have already run the upsizing wizard from my production Access 2010 .accdb database to create all the table structures and move the data on to our new SQL Server 2014. This included adding some PKs ...
0
votes
2answers
68 views

Mysqlimport very slow when importing two smaller files

I am trying to import a large file, it was really big and it did not seem to be working so I broke it into pieces. The first piece takes 2 minutes, and the second one takes almost an hour!!! How can ...
0
votes
1answer
81 views

Fastest way to sync (or keep import) 3.5TB data from hadoop to sharded mongodb cluster

There are 3.5TB data in our hadoop cluster(yes on hdfs). And we have newly built a sharded mongodb cluster(the latest 3.x) with 3 mongos, 3 configdb and 3 shards(each shard has 1 primary and 2 ...
1
vote
2answers
232 views

Are expdp/impdp commands appropriate for daily schema sync?

I've done following comands: expdp system/password@localdb ^ schemas=SCH directory=dumps_dir dumpfile=SCH_%date%.dmp logfile=expdpSCH_%date%.log It runs great, without errors. But when I use ...
3
votes
1answer
380 views

many csv file loading using bash script

#!/bin/bash # show commands being executed, per debug #set -x # define database connectivity _db="mydata" _db_user="root" _db_password="123" # define directory containing CSV files _csv_directory="/...
0
votes
0answers
24 views

MySQL: Automated reinstall, export + import all, for a fresh start?

I have the suspiction that my MySQL installation and all databases are somehow borked. For a fresh start, I would like to create dumps from all the databases, uninstall MySQL, delete the data in /var/...
0
votes
1answer
190 views

Import (flat file) into SQL Server

I've seen a couple of questions about the subject backfiring so I'll try to be specific about my concern... I have an old (MS Access) frontend I'm trying to rebuild and I left the part that troubles ...
1
vote
3answers
746 views

Fastest way to do bulk import in MYSQL

I have got a question about the fastest way to copy a large number of records (around 10 million) from 1 table to another in MySQL. The target table has 1 primary key, 4 indexes and 3 foreign key ...
0
votes
0answers
159 views

How to know imdp size?

I have a dump file using expdp with compression (oracle version >= 11g). Before running impdp I want to check if there is enough space on the machine but it seems as there is no parameter in the impdp ...
2
votes
1answer
61 views

MySQL Import Super Slow

I'm running MySQL on a HyperV virtual machine. The host has 384Gb of RAM and is nowhere near being fully committed. I've tried giving the VM 128G of RAM and 8 CPU and I've tried 2 CPU's and 32GB of ...
1
vote
1answer
631 views

Import data from one Database to another script

As part of a data migration I would like to script a data transfer from the existing to a new database. I used to do this with DTS on older versions of MS SQL. I am currently using SQL 2012. Note the ...
1
vote
0answers
235 views

Import CSV to MySQL with long text fields

I'm trying to import a CSV file (';' separated) to a MySQL table. Normaly, I use a SQL like: LOAD DATA LOCAL INFILE 'local-path/file.csv' INTO TABLE tmp_table CHARACTER SET latin1 FIELDS TERMINATED ...
0
votes
2answers
362 views

Import a sample database into SQL Server on AWS RDS free tier

I asked this on stack overflow but someone there suggested I try here as I might get better answers. So here goes... I'm signed up to Amazon Web Service (AWS) free tier, which allows you to run some ...
4
votes
3answers
410 views

Oracle - restore a single table

In a large database, an activity was performed to upload the data. Due to some mistake, a month's data was entered again, which was left in the temp holding table. So, to cover this up, we took dump ...
1
vote
0answers
212 views

Is there any way to set the default data source for the SQL Server Import and Export Wizard?

When I launch the SQL Server Import and Export Wizard for SQL Server 2014, the selection in the Data source drop-down defaults to .Net Framework Data Provider for ODBC. This happens regardless of ...
0
votes
0answers
71 views

.dmp file generating problem on oracle

I have a server windows2003 with oracle 10g and developer 6i. My experience is when I install developer 6i first and then install database 10g then .dmp file generate perfectly using imp or exp. but ...
0
votes
2answers
303 views

Unique constraint error Oracle

I have two databases - one is 11g and another 12c. 12c db has the exact data of 11g (expdp/impdp). Now I'm facing an error in one of the tables with unique constraint error. I have checked the ...
2
votes
1answer
43 views

Pausing the import of an SQL file in Postgresql?

I am currently importing a large database (6 - 7 GB's) into my postgresql on Ubuntu. It's taking sometime to do. A problem has come up where I need to physically relocate the laptop the postgresql is ...
0
votes
1answer
35 views

How can I inform myself that an automatic SQL Server process has worked?

I have a Windows batch file which extracts some data from a remote system and then imports it into an instance of MS SQL Server 2014. The batch file runs SQLCMD and uses SQL files to bulk insert from ...
0
votes
2answers
63 views

Is dmp file suitable despite ORA-01555 'snapshop too old' warnings?

Well, the title of the question is self-explanatory. Export finished successfully with warnings. Log shows several ORA-01555 snapshot too old errors. - Is it OK to use that dmp file to perform an ...
1
vote
2answers
1k views

HeidiSQL: Import CSV

A few lines of my CSV: "id","date","date_","pow","ene","reac" "ES0134000563024539AM0F","2013-05-02","2013-06-05","62","43","43" "ES0134000573024539AM0F","2013-05-02","2013-06-05","62","43","43" "...
0
votes
1answer
46 views

Is my import still committing?

I'm importing around 9 million rows into my MySQL DB using the following command: SET autocommit=0; SOURCE my_import.sql; COMMIT; The command line is no longer outputting lines of Query OK, X rows ...
0
votes
1answer
700 views

Operation failed with exitcode 1 - while importing from a dump folder

I'm new to dbs and I'm trying to learn how a certain db works. They gave me a dump folder to play with it but, after setting up a connection (works), while trying to import, I get this annoying ...
4
votes
1answer
4k views

How to import export.sql in sql developer?

In SQL Developer, from the top menu choose Tools > Data Export. This launches the Data Export wizard. So that is export. It creatres export.sql file. Now how to do import ? I am usgin SqlDeveloper ...
1
vote
2answers
221 views

Sending a database dump

Quite new to db admin here and I have a quick question. I am collaborating with another colleague off site and they would like me to send them a dump of our (1.5GB sql db) database via email as they ...
2
votes
2answers
282 views

Importing CSV's into MySQL(5.6) tables leaves date fields as 0000-00-00

During the import from a CSV file created from an MS Access table into a MySQL table it converts all date fields in the csv into 0000-00-00. I use the following Load Data command for the import. ...
1
vote
1answer
82 views

How can I import latitude and longitude data into a database using Mysql Workbench?

I am currently trying to get some latitude and longitude data to import into a database using the data import wizard in mysql workbench. the problem is that the floating point values that get ...
1
vote
1answer
132 views

Can I remove “/*!50100 PARTITION BY HASH…” to success with import?

I'm trying to import a database and get this message (Swedish lang phpMyadmin): As you see, I get the message: #1064 - You have an error in your SQL syntax; check the manual that corresponds ...
0
votes
3answers
331 views

How do I determine the appropriate size for my tablespace when importing a .dmp file?

I have a 14g DMP file. How large should I size my tablespace to import it into an Oracle 11g database?
1
vote
1answer
92 views

Can we reuse a .dmp file(expdp) to perform import using data pump utility

I'm an accidental DBA. We use Oracle 11g database. I had to do a database refresh in the test environment. I created a .dmp file using expdp command and performed an import using impdp command a week ...
0
votes
1answer
291 views

Trying to phpMyAdmin import a database with a different name

I've been searching for answers and couldn't find anything suited for my exact situation : I have a magento website and i'm trying to "duplicate" the website into another one selling other types of ...
0
votes
1answer
71 views

Are there any risks on using 'single-transaction' and 'extended-insert' on mysqldump?

I'm new in db administration and I've looked for a faster import of a mysqldump. I had a db with about 1.1 million rows and mostly InnoDB tables and wanted this to import on a managed server. Before ...
0
votes
0answers
27 views

doing a insert while selecting an specific user

I'm importing and legacy database to a new database, and changing data format. In this legacy database, I have data as following: Interaction id: 5458d717cd07870859000004 user_id: ...
0
votes
0answers
30 views

UPDATE from CSV generated with SQL JOINs

I want to do an UPDATE operation on DB by importing a CSV file. The complication is that I am creating the CSV by exporting the results generated by a Query containing SQL JOINs. How can I do an ...
0
votes
1answer
412 views

Using Identity Insert on a linked server

We have a database hosted in Microsoft Azure and using this database connection details I have created a linked server object in SSMS on our on-premise SQL box and I can insert into it as following ...
1
vote
2answers
2k views

SQLite CSV import won't create a table automatically

According to https://www.sqlite.org/cli.html#csv, sqlite> .mode csv sqlite> .import C:/work/somedata.csv tab1 There are two cases to consider: (1) Table "tab1" does not previously ...