Export some fields of a table

[crepo]

I'm looking of a way to make a selective export from the users of my vbulletin database.

In the cron of my server (have ssh access) I want to start a export script that gives me a CSV file with the information of the vbulletin DB / user table and then only the fields “usersid / username / password / email” for all the records.

For or backup I use MySQLdump, but then I get the full database, and in this case I want only a small selection fields of it.

Any idea how to do this?

Thanks,
peter

[Logikos]

Can't you backup selected tables via phpMyAdmin? I could be wrong.

[crepo]

Originally Posted by Live Wire

Can't you backup selected tables via phpMyAdmin?

Yes, indeed. I find how to export with phpmyadmin all the fields of the table user.
But I only need some fields of it, and more imported I want to start this every day form the unix cron. And that is not possible from phpMyAdmin.

thx,
peter

[Dark_Wizard]

I'll throw something together for ya but give me a few days as I am struggling to get some of my own stuff out the door.