Restore DB to new DBschema Version

Any and all non-support discussions

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

Restore DB to new DBschema Version

Postby ruben23 » Wed Jun 03, 2020 9:25 pm

Version: 2.14b0.5
SVN Version: 3224
DB Schema Version: 1592
DB Schema Update Date: 2020-04-15 13:13:53
Password Encryption: DISABLED - S1 - C1
Auto User-add Value: 101
Recording Prompt Count: 0
asteriskvici 13.


Hello, i have backup an existing Vicidial with DBschema : 1592 and wanted this to be restored on the vidial with DBschema version: 1595 . any idea i need to do before doing the restore.? coz i remember before i delete all the the previous oldDBschema version on the MySQL_AST_CREATE_tables.sql but the script now dont have any old Dbschema listed already. Any idea how to proceed or i should just Restore it directly.?
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1161
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines

Re: Restore DB to new DBschema Version

Postby carpenox » Wed Jun 03, 2020 10:12 pm

If you have the db backed up then just run "mysql -p -f --database=asterisk < /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql" and import the backed up db....
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 30 guests