Export Lists to CSV

[gequiros]

Hello guys

I need to export from one server to CSV all lists loaded, it is a bit over 13m records, i am planning to do an install from scracth, since its been running for nearly 2 years, sometimes i feel it a bit slow while i search for a lead

Some lists had 2,5 million records, others are just small.

Can you guys please guided me ?

Thanks and have a nice day

Currently: VERSION: 2.9-441a / BUILD: 140612-1628 | 1 server Web and DB, and 2 Dialers | 45 agents
New One: VERSION: 2.12-570a / BUILD: 161029-2304 | 1 Web, 1 DB, 4 Dialers | We pretend / Will grow up to 120 agents

[mflorell]

You'll have to do that from the MySQL commandline. Something like this:

SELECT * from vicidial_list INTO OUTFILE "lead_data.txt";


Then you can grab the file from your database's data directory and import it as tab-delimited(which is the default when you do "into outfile" in mysql).