Questions tagged [import]
The import of data is the automated or semi-automated input of data sets between different software applications.
531
questions
0
votes
1
answer
29
views
Importing mysql file fails printing last line and I find ^@^@^@^@^@^@^@^@^@^ on that line
I am trying to import some relatively large databases, over 100 GB dump file.
When I try to import the dump files with a command like:
mysql -h localhost -u username -p dbname < backup.sql
after ...
- 194
0
votes
1
answer
32
views
Microsoft SQL Server Import Export Wizard on Remote SQL Server
Is it possible to run the SQL Server Import/Export Wizard purely on a remote server (e.g., from one database to another on the same remote server)?
If I setup the source/destination connections in the ...
- 103
1
vote
3
answers
320
views
MariaDB Crashes Every Time Restarted
OSX Sonoma, OSX Monterey
Latest MariaDB from Homebrew (11.4.2-MariaDB, client 15.2 for osx10.17 (x86_64))
MariaDB won't start every time I restart the brew service or restart the computer. I ...
- 11
0
votes
0
answers
21
views
I need help pulling info from a .txt file into a table in either access or excel
So.. I've tried both Excel and Access to do what I need but I don't know the programs well enough to get them to do what I want, if it's even possible.
I have a hourly updating .txt file with ...
- 101
1
vote
1
answer
35
views
How to import MySQL RAW Database files without connection error
unfortunately I did not create a 'dump' file with the backup (Data Export) process on MySQL Workbench 8.0.26.
When I copy the old database files to the new Data directory, the server fails to start ...
0
votes
0
answers
27
views
Why trying to enable NULL values in a MySQL timestamp field fails?
I imported the table delete_me from the following mysqldump's exported file
-- MySQL dump 10.13 Distrib 5.7.42, for Linux (x86_64)
--
-- Host: 192.168.00.00 Database: main
-- ----------------------...
- 145
-1
votes
1
answer
22
views
POSTGRES : Data import
DB Version : 13.x
Source table schema\
CREATE TABLE mig_bus_data
mig_id SERIAL,
mig_data JSONB
Target table schema\
CREATE TABLE BUSINESS
id UNIQUE SERIAL,
data1 <TYPEx&...
- 11
0
votes
0
answers
28
views
Problems with minutes in timestamps when inserting data into InfluxDB via PowerShell
I am working with InfluxDB and trying to insert time series data via PowerShell. My goal is to insert data points with specific timestamps containing hours, minutes and seconds into InfluxDB. I am ...
- 101
1
vote
0
answers
215
views
Why is the data in a varchar field exceeding the size limit?
I have an application that is copying data from one PostgreSQL database to another. For the most part, that application works exactly as expected. However, there is a comments column in one of the ...
- 445
1
vote
1
answer
191
views
How can I simplify the process of importing only changed data?
Background
Two years ago, I asked a question about how to model a food's relationship with its nutrients. Today, that design has evolved. The biggest change is that whenever a food is updated, we ...
- 63
-1
votes
1
answer
71
views
Expecting "," or ")", found "nvarchar2"
Here is my SQL*Loader: Release 11.2.0.2.0 - Production on Fri Nov 10 00:39:56 2023
OS=UBUNTU 20
I am trying to load data from csv file with the help of following code:
OPTIONS (SKIP=1)
LOAD DATA
...
1
vote
1
answer
50
views
Is an import partially executed when mysql import errors during that import?
While importing a database I received a Duplicate Entry error.
ERROR 1062 (23000) at line 2825: Duplicate entry 'homerow' for key 'PRIMARY'
Are the import instructions up until line 2825 executed or ...
- 111
0
votes
0
answers
259
views
Trying to import large sql file in MySQL fails
I am trying to import an SQL file that is 685MB into MySQL.
First I tried it through phpmyadmin - it failed.
Then I tried through the command line with:
mysql -u root -p database-name < file.sql
...
- 101
1
vote
1
answer
487
views
TablePlus exporting without error but can not import it back
Exporting a table with 22,245 rows using TablePlus, after which TablePlus tells me "Export completed successfully".
If I create a new database and try to import the file I just exported, I ...
- 141
0
votes
1
answer
819
views
Importing CSV File into MySQL gives UnicodeDecodeError
I'm trying to import a CSV file into the insert tab of a MySQL database model. Importing the file gives the following error:
Error during data import:
UnicodeDecodeError("'ascii' codec can't ...
