Import / Restore from a BackUP / MYSQLDUMP

[gequiros]

Hello guys

I had to re-install whole cluster, i already created all phones and users

All i want to do is from a previous MYSQLDUMP:
a) How do i restore LISTS structure
b) Recover all the LEADS previously uploaded

Cause uploading all leads will take me weeks

Thanks so much !!!

[Vince-0]

You should just restore the entire database.

If you try get just the lists table back there will be no reference to logs tables etc.

Otherwise restore the entire database and dump just the vicidial_list, vicidial_lists tables but this isn't a good idea.

[gequiros]

There are no logs of any kind... and if any, it doesn't matter, server was never used...

[Vince-0]

It's a hack and not recommended but I don't even do a dump, just move the vicidial_lists, vicidial_list MYI, MYD and frm files into the new database.

Make sure the vicidial schema versions are the same.