Database restoration

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Database restoration

Postby donX » Thu Aug 25, 2016 10:45 pm

How to restore database to another db server?

Does vicidial versions matter?
donX
 
Posts: 50
Joined: Tue May 17, 2016 8:38 am

Re: Database restoration

Postby ambiorixg12 » Thu Aug 25, 2016 11:58 pm

Use mysqldump to capture your source database, I think you should explore both server's DB structure to see if there is any change, Using PHPMYADMIN will make your live easier when completing this task.
restore is done using the mysql command example :

mysql asterisk < backup_name.sql

This thread my help you

http://vicidial.org/VICIDIALforum/viewtopic.php?t=11788
ambiorixg12
 
Posts: 453
Joined: Tue Sep 17, 2013 10:35 pm

Re: Database restoration

Postby donX » Fri Aug 26, 2016 5:37 am

ambiorixg12 wrote:Use mysqldump to capture your source database, I think you should explore both server's DB structure to see if there is any change, Using PHPMYADMIN will make your live easier when completing this task.
restore is done using the mysql command example :

mysql asterisk < backup_name.sql

This thread my help you

viewtopic.php?t=11788


It's indeed helpful. But still not sure if whether I'll have to reinstall a new vicidial.

It seems that the db version of the dumpfile is older than the db it was restored to, this might have caused the anomaly as per the thread you have provided
donX
 
Posts: 50
Joined: Tue May 17, 2016 8:38 am


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 163 guests