How to restore database to another db server?
Does vicidial versions matter?
Database restoration
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
3 posts
• Page 1 of 1
Database restoration
by donX » Thu Aug 25, 2016 10:45 pm
- donX
- Posts: 50
- Joined: Tue May 17, 2016 8:38 am
Re: Database restoration
by 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
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
by 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
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: Majestic-12 [Bot] and 115 guests