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

learn more… | top users | synonyms

1
vote
1answer
5k views

How to grant all privileges on all tables in a schema to a user in IBM DB2?

At first place, I want to export database from IBM DB2 AIX into IBM DB2 windows. Unfortunately, I can't use BACKUP and RESTORE command because of difference OS issue. So I have to resort to db2move ...
0
votes
0answers
244 views

How to import a text file with '|' delimited data to PostgreSQL database? [closed]

I have a text file with | delimited data that I want to import to a table in PostgreSQL database. PgAdminIII only exports CSV files. I converted the file to a CSV file using MS excel but still was ...
2
votes
1answer
760 views

Using Workbench to export. Views no longer work

I'm using Workbench 5.2 from my production DB machine (Ubuntu Linux). I've been trying to export. First try.. I had the entire schema selected including all tables and views in the right hand ...
0
votes
1answer
275 views

“relation does not exist” trying to import mysql dump into postgres

environment: ubuntu 10.04 mysql server 5.1.69 postgres 9.2 Here's the sequence of steps: created a new postgres database, myDatabase executed this command: mysqldump -u root -p ...
3
votes
3answers
631 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 ...
0
votes
0answers
188 views

How to clone a database from one environment to a database on another environment?

OS: RHEL DB: Oracle 11g version 11.1.0.7.0 I am trying to clone a database on one environment (environment A) to another database on a separate environment (Environment B). Environment B's database ...
1
vote
3answers
144 views

SQL Server Import Job Removed Data After Job Failed

I have a SQL Server Job set up to import data from a table to a table on another server, using the Import/Export data wizard. In one instance, the job failed (with, I believe a SQL connection issue), ...
0
votes
1answer
102 views

Writing with multiple psql processes to database seems to damage data

I have a couple terabytes of CSV data that I am trying to import into a PostgreSQL 8.4 database (on a RedHat 6.2 server), whose data directory is initialized on a multipath hardware RAID. There are ...
0
votes
1answer
510 views

Why would SequelPro only import 23k rows out of 130k?

I use SequelPro for mysql on a Mac OS X -- and I used the import function to upload a 130k .csv file to my database. Everything seems to work fine, then I get the message File Read Error: An error ...
1
vote
2answers
926 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 ...
0
votes
1answer
234 views

Exporting and importing a database

I have setup an Oracle 11g Database and have a question about exporting and importing a database. I am using Enterprise Manager and have browsed to the following: Data Movement->Export to Export ...
0
votes
1answer
234 views

ERROR 1034 (HY000) : Wrong aligned block, while importing in mysql

I got a SQLdump from my database and now I want to import it in to an other mysql server with same version(5.5.22-0ubuntu1) in ubuntu 12.04 .but at the middle of importing, it said: ERROR 1034 ...
0
votes
2answers
531 views

Oracle schema import is not importing all the tables present in the schema dump file

I have exported an existing oracle schema from another machine and then imported it in my local machine. Import was successful, but some tables which are present in the export dump file are not ...
4
votes
1answer
1k 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 ...
4
votes
2answers
654 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 ...
2
votes
2answers
267 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
253 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". ...
2
votes
1answer
205 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 ...
3
votes
0answers
142 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 ...
0
votes
4answers
224 views

which one is the fastest way of moving database form local to live server in sql server

I am using SQL Server 2008, I have big database almost 500 MB of data there. Now I wanted to upload or deploy this DB to Live server. Currently I am generating script and then uploading script to live ...
0
votes
2answers
336 views

Import batches of rows from Excel in parallel

We receive an Excel file weekly currently containing about 250k rows. The file grows by about 300 rows each week. In SSIS I've hooked up an Excel source to an OLE DB destination to import the file ...
0
votes
1answer
163 views

Does a standby slow down Oracle imp?

I have Oracle 10gR2 installed on Redhat Linux 5.4 on two servers (primary and physical standby). When I import data into the primary server while the standby is started it takes too long to complete ...
0
votes
2answers
102 views

How to create two database copies in two users from same dump file

I have a database dump file with me, I need to make two copies of the database using the same dump file in two users. Is it possible?
0
votes
1answer
396 views

Oracle not trusting statistics after an import?

We are seing some strange behavior in the way Oracle is handling statistics of an imported schema. We build a schema on the dev system, analyze if and import into the production with the stats. For ...
1
vote
1answer
304 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 ...
1
vote
2answers
1k 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?
2
votes
2answers
320 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? ...
1
vote
0answers
1k views

ORA-01460 during Data Pump Import

While migrating data from Oracle 11.2.0.1 RAC to Oracle 11.2.0.3 RAC using Data Pump, the import failed with ORA-01460: ORA-39097: Data Pump job encountered unexpected error -12801 ORA-39065: ...
0
votes
1answer
819 views

Oracle Imp Dump Full

Can I create a new instance in a new server and import a dump file which was made with the command exp full=y etc? If it is possible do I need to recreate tablespaces and users before the import? If ...
0
votes
2answers
544 views

Oracle dump import

After a system failure I bought a new server and now I'm trying to recreate the Oracle database I had. I have a dump file which was made with the command exp and full=y. Can I restore the full ...
2
votes
2answers
5k 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
200 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
1answer
445 views

bulk insert from file

I am often requested to upload data from file (let's say csv) into a Sql Server 2008 db. I would like to use BULK INSERT, but I have no access to the db server file system. Questions is there a ...
1
vote
1answer
418 views

How to restrict MySQL user to not import and export database

I have created a read only MySQL user but this user have an option to export the database through phpmyadmin. How can I disable the options Export and Import?
5
votes
1answer
9k 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 ...
1
vote
1answer
112 views

Regularly import tab-seperated log file to MySQL

I'm looking to keep arpwatch entries in a MySQL database to crossreference with other information I'm storing based on mac addresses. I've manually imported the arpwatch database into my mysql ...
0
votes
1answer
625 views

Getting error when using Oracle imp command to import dmp file

I am importing a dmp file using the following command: imp user/pass file=file.dmp log=logfile.log full=y ignore=y destroy=y I get the following errors: . . importing table ...
3
votes
1answer
315 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 ...
0
votes
0answers
330 views

MySQL import file with no column delimiter

Is there a way to use the mysqlimport command on a file that has no column delimiters? I would like to import the ctl file used with the sqlloader for Oracle
1
vote
2answers
205 views

PostgreSQL replication and large import

I am tasked with making large PostgreSQL imports to master instance, and then replicate it across the nodes as read-only data. Still, the CMS system has to be able to write data and replicate across ...
5
votes
7answers
20k 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 ...
4
votes
1answer
412 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
2answers
860 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 ...
2
votes
0answers
4k 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 ...
5
votes
2answers
285 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 ...
-1
votes
2answers
3k views

What program should I use to open .db3 files?

I have a series of .db3 files in my computer. They are like filename1.db3, filename2.db3, filename3.db3, filename4.db3 and so on. I can open filename1.db3 with sqlite editor. But when I open ...
2
votes
1answer
480 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 ...
6
votes
2answers
184 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 ...
9
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 ...
2
votes
1answer
2k views

Import/export wizard code page error

Using the import/export wizard I end up with an annoying problem: Error 0xc02020f4: Data Flow Task 1: The column "pinNumber" cannot be processed because more than one code page (874 and 1252) are ...