I finally found the SQL statement :
SELECT carddata INTO OUTFILE ‘/MyDir/MyFile.Vcard’ FROM contacts_cards WHERE id=1;
or even better : SELECT carddata INTO DUMPFILE ‘/MyDir/MyFile.Vcard’ FROM contacts_cards WHERE id=1;
as outputs aren’t the same format, choose which one suits you best.
You need also to be connected as “admin” or “root” to your DB otherwise you couln’t write on the file system; code: mysql -u root -pPSSWORD YourDB (-p and your PASSWORD should be attached, not -u YourUser)
But I get only one .vcard, how to generate all my contacts in separated .vcard files?
Thank you