Questions tagged [import]

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

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

It involves "translating" from the format used in one application into that used by another, where such translation is accomplished automatically via machine processes, such as transcoding, data transformation, and others.

525 questions
285
votes
18 answers

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 5.0.96, for apple-darwin9.8.0 (i386) using readline…
qazwsx
  • 3,327
  • 9
  • 21
  • 21
56
votes
3 answers

Why is a .bacpac file so small compared to a .bak file of the same database?

I've been doing backups of my SQL Server 2014 Express databases for import to other servers and noticed a difference in file size between .bacpac and .bak. Why is a .bacpac file so small compared to a .bak file of the same database? Thanks for any…
Chris
  • 663
  • 1
  • 5
  • 5
54
votes
6 answers

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 the .sql file but it doesn't work. I have also…
Barbara Dreamer
41
votes
8 answers

MySQL DB import/export command line in Windows

How do I import and export a local instance of a MySQL database via command-line interface? My operating system is Windows and WampServer server is installed.
Bharanikumar
  • 519
  • 1
  • 4
  • 5
33
votes
7 answers

Import a Oracle DMP file into a Fresh install of oracle

A client sent us an Oracle database we need to test against. We don't use Oracle or have any in-house Oracle expertise. We need to setup the database so we can connect to it and debug a problem. I did a fresh install of Oracle 9 (the version the…
James
23
votes
3 answers

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 using the LOAD DATA IN FILE statement, that reads from csv files and inserts the data into a database. Why should it differ from normal inserts? EDIT: I reduced the…
Alireza
  • 3,586
  • 10
  • 35
  • 43
21
votes
3 answers

mysql to mariadb: unknown collation utf8mb4_0900_ai_ci

I have a mysql 8.0 that I exported using mysqldump. I am trying to import it onto a Mariadb 10.4 database with phpmyadmin, both are the most current versions. Each time I do it though, I get: Error: Unknown collation utf8mb4_0900_ai_ci Then I went…
Frosty
  • 211
  • 1
  • 2
  • 3
21
votes
4 answers

Why is BULK INSERT Considered Dangerous?

I would like to understand why cyber-security teams in general (more than one organization I've dealt with) is dead set against granting BULK INSERT (e.g. TSQL) rights to applications and database programmers? I can't believe the "filling up the…
JackLThornton
  • 313
  • 1
  • 2
  • 5
16
votes
5 answers

Does it save anything to use a smaller varchar or nvarchar size instead of some large value like 4000?

In importing data to SQL server, one can often not account for how large the imported string fields will be. Can I just lazily keep using a large value for the char field definitions, and does it have any impact on performance and speed if I spend…
user55570
  • 329
  • 3
  • 5
15
votes
3 answers

Create a table from a CSV file with headers

I'm seeking to find a way to generate a new MySQL table solely based on the contents of a specified CSV. The CSV files I'll be using have the following properties; "|" delimited. First row specifies the column names (headers), also "|" delimited.…
user58602
  • 151
  • 1
  • 1
  • 3
13
votes
2 answers

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 all user data is stored in the USERS tablespace. On…
Roy
  • 1,060
  • 5
  • 16
  • 39
12
votes
3 answers

InnoDB import performance

I'm struggling with bulk importing a quite big InnoDB-Table consisting of roughly 10 Million rows (or 7GB) (which for me is the biggest table I've worked with so far). I did some research how to improve Inno's import speed and for the moment my…
nuala
  • 337
  • 1
  • 3
  • 9
11
votes
1 answer

Create index on a Postgres table as fast as possible

I have a large database import (100GB) on a Postgres table without indexes. After the import, I want to create an index for queries as fast as possible. No data is accessed in the table as long as the index is not ready. What is the quickest way of…
membersound
  • 301
  • 1
  • 2
  • 12
11
votes
4 answers

Oracle Import problem caused by different character 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 server uses AL32UTF8 character set (possible…
bernd_k
  • 12,001
  • 23
  • 74
  • 109
11
votes
1 answer

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 existing table, I'd prefer to clear down the old and…
Mark
  • 859
  • 1
  • 7
  • 17
1
2 3
34 35