MySQL dump restore issue

After restoring mysql dump from pc 55 to sciforum found the user of sciforum vanished, all table database privileges of local system gone.

The lesson learned is never restore everything , the the needed tables and restore these. OR atleast exclude mysql user tables and recreate user, tables, db privileges.

Created user wp again and then found issues on update command of mysql, getting error “can not load from mysql.proc”

run command 
mysql_upgrade -u root -p 
and the problem is fixed

Rename VM / Boot order

RENAMING VM

hrgserver:~ # virsh dumpxml OL81 >MasterDB.xml
hrgserver:~ # virsh undefine OL81
Domain OL81 has been undefined
hrgserver:~ # vi MasterDB.xml
hrgserver:~ # virsh define MasterDB.xml
Domain MasterDB defined from MasterDB.xml

hrgserver:~ # virsh list –all

Id Name State

0 Domain-0 running
1 sciforum running
3 netware running
4 zs20804 running
26 Kaspersky running

  • MasterDB shut off

hrgserver:~ # virsh start MasterDB
Domain MasterDB started

CHANGE BOOT ORDER

<os>
  <type>hvm</type>
  <loader>/usr/lib/xen/boot/hvmloader</loader>
  <boot dev='network'/>
  <boot dev='cdrom'/>
  <boot dev='hd'/>
  <bootmenu enable='yes'/>
</os>