Hello all,
Sometime we need to backup mysql database from one vos3000 server to another vos3000 server, in that case we need to use safe command for mysql database backup and restore.
Here is mysql database backup command (Non CDR), with cdr vos3000 mysql data will be huge, so this is non cdr database backup commands: (those server do not have mysql password, mainly version upto 2.1.8.05)
mysqldump vos3000 `mysql -N <<< “show tables from vos3000” | grep -Ev “_[0-9]”` > /root/vos3000.sql
with that command the sql file will be saved at /root/ folder of centos server, now in new vos3000 server you have to upload the sql file in same /root/ folder and restore command is (without mysql password):
mysql -uroot vos3000 < /root/vos3000.sql
as desktop version is copy protected try amp/mobile version, so you can copy those commands
if you need more help anything related vos3000 problems please contact at : +8801911119966 (only whatsapp text)
Thanks