Hello I regrettably, accidentally removed "usr" instead of "usb" directory completely. Fortunately since my USB were there could copy all mysql *.myd *.myi *.frm files. After that I installed a brand new server. My problem is how to restore these mysql *.myd *.myi *.frm files, it's about 6 GB. BTW, I Googled many options but didn't worked. It has been for two days I am busy with this server. Your kind helps appreciated in advance
Just create an empty database on the new server and the copy the files back. But this will only work for MyISAM databases, if you have InnoDB databases, then you have to restore the complete /var/lib/mysql folder from old server as the data of all databases is stored in a central InnoDB file by default.
Thanks till How do I know kept backup is MyISAM or InnoDB? I just copied whatever were inside mysql/lib/* (as far as I remember)