Page 1 of 1

Import / Restore from a BackUP / MYSQLDUMP

PostPosted: Mon Jan 23, 2017 2:17 pm
by 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 !!!

Re: Import / Restore from a BackUP / MYSQLDUMP

PostPosted: Tue Jan 24, 2017 2:26 am
by 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.

Re: Import / Restore from a BackUP / MYSQLDUMP

PostPosted: Tue Jan 24, 2017 3:26 pm
by gequiros
There are no logs of any kind... and if any, it doesn't matter, server was never used...

Re: Import / Restore from a BackUP / MYSQLDUMP

PostPosted: Wed Jan 25, 2017 1:48 am
by 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.