> Has anyone written a perl script to get records from another > database and write it to a file on mysql's LOAD DATA INFILE > format? I just need some pointers in perl so a LOAD DATA > INFILE will be read correctly.
You might want to check out Perl's DBI module at search.cpan.org I use that all the time to interact with mysql. Simple quick and just as sexxy as mysql itself! HTH DMuey > > For example, a perl script: > Select * from emp from a Progress database > Will write to a text file called emp.txt in the LOAD DATA > INFILE format, Then, I can to a direct LOAD DATA INFILE into > my mysql database. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]