Stack Overflow
Stack Overflow

Questions tagged [dbimport]

14 questions
2
votes
0 answers

Dbimport utility missing in informix docker image?

I am trying to import data exported from remote instance of informix database into my local docker instance, but there is no dbimport in /opt/ibm/informix/bin inside the docker container. I didn't find anything about this anywhere. Am I missing…
Belovoj
  • 818
  • 13
  • 22
2
votes
2 answers

Need to understand dbimport utility in Informix DB

Can anyone help me to understand the command below? I have a confusion about hw and hwdbs01 and the function of the dbimport utility. dbimport hw -c -q -d hwdbs01
appi
  • 75
  • 1
  • 3
  • 10
1
vote
1 answer

Temenos DBImport error when trying to import from Oracle to H2

I'm trying to import Temenos T24 database from Oracle to H2 with the following settings: Target Database : H2 URL : jdbc:h2:tcp…data/temenos/h2/TAFJDB1 Driver : org.h2.Driver User ID :…
Ecaterina Oniciuc
  • 25
  • 1
  • 4
1
vote
1 answer

informix dbimport throws 23103 - Code-set conversion function failed due to illegal sequence or invalid value

When I try to import an informix database with command dbexport -c that was already exported. I get this Error: 23103 - Code-set conversion function failed due to illegal sequence or invalid value. I wonder if this is…
Amrouane
  • 143
  • 3
  • 16
1
vote
1 answer

How I can escape backtick (´) from table name and column name?

I am trying to import DB dump with following command. mysql -u doadmin -p -f tetdb < test.sql then I am getting all imported table name and column warped by Backtick (´). ´test_cache_menu´ ´test_cache_data´ My test.sql is too big (40GB) so I can't…
visabhishek
  • 113
  • 2
  • 11
1
vote
1 answer

Informix: How to truncate a table when importing a dbexport

Is there any good way to truncate the data of a table when importing a dbexport. I realize that I need to amend the number of rows in the .sql file, but how do I need to amend the unload file?
weismat
  • 7,195
  • 3
  • 43
  • 58
0
votes
0 answers

Build content type from sql file in strapi

I am using MySql database for my strapi project. I already have populated db to be used in my strapi application. I have connected to the same db from my strapi project but can not see any content types created from my strapi admin panel. Is there…
Drashti Kheni
  • 1,065
  • 9
  • 23
0
votes
2 answers

Bulk data import in a java application

I am on java project to import huge amount of data from .csv file to a database. I am interested in understanding what can be the best approach in achieving this. Definitely one of the options is to using java application calling stored procedure.…
Antony
  • 1,608
  • 1
  • 20
  • 27
0
votes
1 answer

How to load remote location xml file data to mysql/(any other) database

I have found the solution to load xml file data to mysql db table Here My question is how I can load remote location xml file and dump it to mysql database table. If you have any idea or have done something like this please help to find the…
meOn
  • 194
  • 1
  • 12
0
votes
1 answer

importing complex data from csv to mysql table

I am trying to import data to a table. Basically its a MCQs. All my questions are having superscripts and subscripts, for example X2 , and log52.... I have more than 2000 records, i have to import it. But after importing it comes in plain format,…
user2178637
  • 117
  • 1
  • 14
0
votes
1 answer

#1044 - Access denied for user 'someuser'@'localhost' to database 'somedb'

I'm tried a lot to import the sql script to create database and tables through phpmyadmin in the new site I hosted. But i'm getting the error, #1044 - Access denied for user 'someuser'@'localhost' to database 'somedb' I tried to create a sample db…
user3141777
  • 179
  • 1
  • 1
  • 4
0
votes
1 answer

Heroku, data import error with mysql2

I am beginner on Heroku. I push my exist ruby on rails application into heroku and that was fine. Next i push my mysql data into heroku with 'push' command as following. $heroku config:add DATABASE_URL='mysql2://
onoke
  • 79
  • 6
0
votes
1 answer

Import large database faster

I'm currently importing a large database: 8GB and the largest table has 40 millions row. The import is taking for hours. I'm importing using the following command: mysql -u root -p db < db.qsl When I do: SHOW PROCESSLIST; There is only in query. Is…
bl0b
  • 926
  • 3
  • 13
  • 30
-2
votes
2 answers

i am having difficulty on exporting issues on sql

i want to upload sql file into database but it is the size of the file is more. However server's phpmyadmin's import database limit is just 50mb so i am not able to upload it How can i increase this default size limit?
bhavin
  • 1
  • 2