How to transfer VOS3000 database on remote server easly

Its very long process to transfer vos3000 or my sql database to remote server as you take backup and restore on remote server. This is how to transfer VOS3000 database on remote server easly

#mysqldump -u root -pPPPP  vos3000db | ssh root@x.x.x.x  mysql -u root -pKKKK  vos3000db

PPPP is local mysql root password  KKKK is  remote mysql root password x.x.x.x change with your vos3000 or mysql database server IP address

vos3000db is the database which will transfer from loacl server to remote server.

Hope it will help you .

if mysqldum is not working giving error copy backup file locally and restore the backup file as below command.

mysql -h localhost -u root -pPPPP vos3000db < vos3000dbbackup.sq

 

Leave a Comment