473,382 Members | 1,809 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Load file errors

Jim
Hi,

I am looking into writing many sql statements to a file and then
executing those all at once. I am using perl in windows to create the
insert statements and then need to load the data into a Unix Mysql DB.
Would like to do the insert from the windows side using perl and ODBC,
but it maybe much faster to do from Unix that it would be the better
way to go.

What command would I use and if a single statement were wrong, how
would the DB or script respond.

Thank you for any guidance.

Jim

Feb 27 '06 #1
1 1332
"Jim" <jf*****@gmail.com> wrote in message
news:11*********************@e56g2000cwe.googlegro ups.com...
I am looking into writing many sql statements to a file and then
executing those all at once.

What command would I use and if a single statement were wrong, how
would the DB or script respond.


The 'mysql' command-line tool is the best for this.
http://dev.mysql.com/doc/refman/5.0/en/mysql.html

Specifically, read these pages:
http://dev.mysql.com/doc/refman/5.0/en/batch-mode.html
http://dev.mysql.com/doc/refman/5.0/...-commands.html

There is also a "-f" option that causes the execution to continue if any SQL
errors are encountered. The default behavior is to abort when it receives
an error.

Regards,
Bill K.
Feb 27 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Shabam | last post by:
A web application of mine developed using C# + MS SQL runs fine normally. However when I stress test it with a load testing software (using about 60 simultaneous users) some instances start...
3
by: Torrent | last post by:
When Trying to Load an XSLT File with the XslTransform i got a rather annoying Exception being thrown "System.Xml.XPath.XPathException: XsltContext is needed for this query because of an unknown...
1
by: datapro01 | last post by:
We are attemtping a load using a dump file. The load is being run from an app server box (No 15) into a database server(box 13). The load works ok but we are getting some errors ...some rows have...
0
by: dbuchanan | last post by:
Hello, Why can't my application recognize or find the data layer. These are the design-time and runtime errors I receive. \\ "One or more errors encountered while loading the designer. The...
1
by: jz | last post by:
Hi All, I have an ActiveX control project, in the main form, I have an image control and load a JPG image from by setting Picture property of Image; I build it and everything is good, I...
1
by: Sumanth | last post by:
We are using cli bulk loader to load data into db2. In some cases the rows get rejected and this is flagged as a warning allowing the program to continue. Is there any way to trap this warning,...
0
by: giovanni gherdovich | last post by:
Hello, first of all: Is this the right place to ask plastek-related questions? I'm trying to make plastex work on my Ubuntu Dapper Drake. For LaTeX, I have the all-in-one package tetex.
2
by: =?Utf-8?B?YW5kcmV3Y3c=?= | last post by:
here is a DLL I need to mimic because the application does not connect to real hardware depending on where the application runs ( it runs in a simulation mode ). The application ( C#.exe )...
8
by: Joe Withawk | last post by:
I have a solution consisting of a c# project as win application and a c++ project as classlibrary. Both are .net 2.0 The classlibrary handles some loading of quicktime movies, but that should not...
1
by: mharrison | last post by:
Hi All, I'm using SQL 2000 and in a DTS I want to load in an error XML file to a SQL table. I am using the SQLXMLBulkLoad component in an Active X script. I have an XML file. see below, and...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.