Solved

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

Posted on 2003-10-28
5
1,067 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
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
mysql joining from the same table 6 47
mysql between clause 2 32
MySQL Error Code 2 25
PHP query / monitor data from Telnet to MySQL 7 48
Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

856 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