Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
mysqldump asterisk > 2012_08_06_XXXXXXXXXXX.sql
mysql -e "drop database asterisk"
mysql -e "create database asterisk"
mysql asterisk < Prior_backup_name.sql
mysql asterisk < upgradeXXXX.sql
/usr/share/astguiclient/ADMIN_backup.pl --debugX
williamconley wrote:first use mysqldump to capture your present db (just in case).If using a password, you'll need to add "-p" and enter the pass at the prompt.
- Code: Select all
mysqldump asterisk > 2012_08_06_XXXXXXXXXXX.sql
then drop the existing database and recreate it
- Code: Select all
mysql -e "drop database asterisk"
mysql -e "create database asterisk"
then apply the mysql backup to it.
- Code: Select all
mysql asterisk < Prior_backup_name.sql
It may be a good idea to reboot. It's definitely a good idea to tell the server to rebuild the conf files under Admin->Servers->(select your server)
williamconley wrote:first use mysqldump to capture your present db (just in case).If using a password, you'll need to add "-p" and enter the pass at the prompt.
- Code: Select all
mysqldump asterisk > 2012_08_06_XXXXXXXXXXX.sql
then drop the existing database and recreate it
- Code: Select all
mysql -e "drop database asterisk"
mysql -e "create database asterisk"
then apply the mysql backup to it.
- Code: Select all
mysql asterisk < Prior_backup_name.sql
It may be a good idea to reboot. It's definitely a good idea to tell the server to rebuild the conf files under Admin->Servers->(select your server)
trail -f /var/log/apache2/error_log
[Fri Aug 26 17:56:56.440220 2016] [php5:error] [pid 1202] [client 10.54.9.20:52145] PHP Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given in /srv/www/htdocs/vicidial/admin.php on line 30524, referer: http://10.61.5.151/vicidial/admin.php?ADD=31111111111&extension=41004&server_ip=10.61.5.151
williamconley wrote:ViciBOX version does not affect ViciDIAL version. The installer (vicibox) will install whichever version you select during installation.
More important: If you installed a version of the VICIDIAL software different than the version of your backed up database ... you must either restore the rest of your vicidial system (the web code and script code, etc) to match your DB or upgrade your DB to match the Vicidial software you just installed.
Under Admin->System settings, check your DB Schema.
Then in /usr/src/astgcuiclient/[versionChosenDuringInstall-probably trunk]/extras/upgradeXXXX.sql (based on the version you installed) ... check the last db_schema line in the file. If they do not match ... find your db schema in the file, delete everything before it and run everything after it (ie: save it to a new file with only the lines AFTER that one in it ... then execute it just like you did the restore).
- Code: Select all
mysql asterisk < upgradeXXXX.sql
williamconley wrote:ViciBOX version does not affect ViciDIAL version. The installer (vicibox) will install whichever version you select during installation.
More important: If you installed a version of the VICIDIAL software different than the version of your backed up database ... you must either restore the rest of your vicidial system (the web code and script code, etc) to match your DB or upgrade your DB to match the Vicidial software you just installed.
Under Admin->System settings, check your DB Schema.
Then in /usr/src/astgcuiclient/[versionChosenDuringInstall-probably trunk]/extras/upgradeXXXX.sql (based on the version you installed) ... check the last db_schema line in the file. If they do not match ... find your db schema in the file, delete everything before it and run everything after it (ie: save it to a new file with only the lines AFTER that one in it ... then execute it just like you did the restore).
- Code: Select all
mysql asterisk < upgradeXXXX.sql
mattyou1985 wrote:hope this helps
williamconley wrote:mattyou1985 wrote:hope this helps
Every bit helps. Even if all you are really doing is storing this for your own personal use "next time" so you can't forget it. LOL It will STILL help someone who may be floundering next week and save them some hair pulling. Keep it up. You might even get a thank you from someone who uses it.
donX wrote:... is it safe to update the current sql version of my old dialer so it wont mess up the new db once i do a restore?
Users browsing this forum: Bing [Bot], Google [Bot], Majestic-12 [Bot] and 116 guests