Solved

Import Dbf to MySQL Automaticaly (like a DTS in SQL)

Posted on 2003-10-28
5
1,074 Views
Last Modified: 2011-09-20
Hi, I need some help, sorry but my english is not good...
weel.. I´ll try to explain... I must publish a database in the web and I´am using MySQL, the source are Dbf files...And needs to be refreshed whit the latest rows.
I need a program that schedule that job, and I have no idea which I have to use...
Please, HELP MEEEEEEEE!!!!!!! :-(
Thanks
Leandro  
0
Comment
Question by:budadormilon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 17

Accepted Solution

by:
Squeebee earned 63 total points
ID: 9635871
Can you schedule the output of the rows to CSV? If so, you can schedule the input of the rows from CSV.
0
 
LVL 2

Assisted Solution

by:doryllis
doryllis earned 62 total points
ID: 9637886
I would suggest an export from your original file format to a delimited form (something where there is a separating character between each field in a simple ASCII-type file) .  I prefer to use the | (pipe) character if there is any chance of commas in your data. MySQL automatically assumes that the delimiting character is a tab.

Once you have your data file, you can use MySQL LOAD DATA INFILE syntax to pull in the delimited file.

From a MySQL prompt

LOAD DATA INFILE '/localpath/filename.txt'
   INTO TABLE table_name
   FIELDS TERMINATED BY ','  --This line can be changed to indicate whatever your field delimiter is.

If all of the data in your file fits the table name then your fine.  Otherwise, if you run into problems you can fool around with the text file itself and see if there are loose characters around.  There are also more options available for the LOAD DATA INFILE command.

Good Luck,
Dory
0
 

Expert Comment

by:bradylanter
ID: 14030631
0

Featured Post

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question