Skip to main content
4 votes

How can I load csv data into mongodb and choose the types I'd like to have created for each column?

Ensure you're using mongoimport version 3.4 or higher, and use the --columnsHaveTypes parameter to tell the import what type each column is. See the MongoDB Reference Documentation for details. The ...
Hannah Vernon's user avatar
  • 70.2k
2 votes

Sometimes, not always, when loading an MSSQL table from Excel a new table suffixed with a $ is created by MSSQL. Why?

From this MSDN discussion: Excel object names that are appended with a dollar sign ($) represent worksheets (for example, Sheet1$), and that plain object names without the dollar sign represent Excel ...
Doug Deden's user avatar
  • 1,817
2 votes
Accepted

Shedding database server load from a web application: how to measure?

In my view the challenge will be to define what is loaded. Unless you have a baseline tied to business hour (with full cycle, day/night, weekday/weekend etc) there is no way to determine if you are ...
SqlWorldWide's user avatar
  • 13.5k
2 votes
Accepted

mysql load data local infile is skipping the 1st column of the 1st row

Depending on the source of the text file, the csv file here, it may have the byte of order (BOM) character. In this case, the very first column from fist row will be an invalid integer, and will be ...
Jehad Keriaki's user avatar
2 votes
Accepted

LOAD DATA LOCAL INFILE with specifying first column as auto-increment value

You should name the columns you are importing For example, this is from the MySQL Documentation on LOAD DATA INFILE CREATE TABLE jokes (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, joke TEXT NOT ...
RolandoMySQLDBA's user avatar
1 vote

Db2 - load LOB data returns error SQL3025N A parameter specifying a filename or path is not valid

I suspect that when you run load client, the LOB files are still expected to be on the server.
mustaccio's user avatar
  • 26.3k
1 vote

MySQL Load Data Infile extremely slow

REPLACE is DELETE any or all rows that match, then INSERT the one row. For REPLACE to be useful, you need an index, preferrably UNIQUE or PRIMARY so that it knows what to DELETE. Do you have an ...
Rick James's user avatar
  • 78.6k
1 vote

View created using Join Queries taking too much to load

Your view will join all the tables involved in the view definition in order to create the required view. First, of course, you should check that your tables are properly indexed so that the joins are ...
RLF's user avatar
  • 14k
1 vote
Accepted

Meaning of "Total work" for build indexes during load

Sometimes you feel really stupid... The purpose of the load process is to migrate a table to range partitioning. Somehow, I managed to ignore the fact that the target table is now partitioned: db2 -x &...
Lennart - Slava Ukraini's user avatar
1 vote

How to identify row change timestamp columns in Db2 Table

In Db2 for z/OS this information is in the DEFAULT column of the SYSIBM.SYSCOLUMNS catalog table. In your case the value you'll be looking for is 'E'.
mustaccio's user avatar
  • 26.3k
1 vote
Accepted

Load text column to postgres

The mysql command you show seems (experimentally, not from actual knowledge) to generate output which is compatible with PostgreSQL's TEXT format, not the CSV format. Newlines are represented by the ...
jjanes's user avatar
  • 40.2k
1 vote
Accepted

How can I get LOAD DATA LOCAL INFILE to work for MySQL 8.0.21 on a Windows machine?

Windows restricts the acces for that folder. Best is to create a separate folder and give it the right access rights. I tried a lot but i can't replicate your message, when the file exists it can open ...
nbk's user avatar
  • 8,434
1 vote
Accepted

How to restrict mySQL queries to not affect server and take it down?

Do you really mean = ' '? That is checking for the string being one character long, namely a space. OR is a performance killer, so let's get rid of it by using UNION: ( SELECT id, ((old_credit ...
Rick James's user avatar
  • 78.6k
1 vote

REINDEX or REBUILD the indexes of a table after truncating it and then repopulating it?

If your data is not sorted (by the indexed columns), the maintenance of indexes during the load of large amount of data may have some serious overhead because of the leaf node splits (not 90-10 splits)...
Balazs Papp's user avatar
  • 40.8k
1 vote
Accepted

What is the load impact of the Zabbix DB size query?

This 'random person on the Internet' can shed some light... The information_schema is not a 'real' database (until MySQL 8.0), rather it is derived from a bunch of data that may or may not be in RAM ...
Rick James's user avatar
  • 78.6k
1 vote
Accepted

MySQL: Load csv file to mysql

Issues when Loading Data with MySQL LOAD DATA INFILE You appear to have a few issues going on here and to resolve you can make a few adjustments to get your data to load without error. I've source ...
IT Thug Ninja's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible