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
VOS3000 High CPU Usage Essential Server Performance Optimization When your VOS3000 server’s CPU usage spikes… Read More
VOS3000 Database Recovery Complete MySQL Corruption Fix A corrupted MySQL database can bring your entire… Read More
Essential VOS3000 high CPU usage optimization guide. Diagnose CPU spikes with top htop, fix SIP… Read More
Essential VOS3000 high CPU usage optimization guide. Diagnose CPU spikes with top htop, fix SIP… Read More
Complete VOS3000 database recovery MySQL corruption fix guide. Repair InnoDB corruption, restore from mysqldump, use… Read More
Complete VOS3000 database recovery MySQL corruption fix guide. Repair InnoDB corruption, restore from mysqldump, use… Read More