mysqlimport -r -f -u [username] -p --fields-terminated-by='\t' --verbose [dbname] *tsv
... should do the trick :-) cheers lenz On Fri, Aug 13, 2010 at 10:46 AM, Paul Bennett <[email protected]> wrote: > Hi all, > > Happy Friday! > I've a wee SQL import job - I have a (small) .CSV file from an SQL server db > I need imported into a MySQL table and then outputted using mysqldump so I > can use it. > > I'm snowed under - I'm sure a MySQL ninja / sensei could tackle this quick > smart. > > Let me know if you can turn this around quickly and what it'll cost. I'm > happy to fire the file through if you want to take a look. > > Kthxbai, > Paul Bennett > MoveForward - Web Development for Design Companies > http://www.moveforward.co.nz > Ph. 06 308 9722 > Mob. 027 255 8495 > > -- > NZ PHP Users Group: http://groups.google.com/group/nzphpug > To post, send email to [email protected] > To unsubscribe, send email to > [email protected] -- twitter: @norbu09 current project: iWantMyName.com painless domain registration (finally) -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
