Hello,

Can anybody tell me why i make a snapshot from the master database and then when i untar it in the backup database, all the tables in the second databases cannot be viewed???

I am so wondering why this could happen.......

Thank you.

I'm not sure what your exact problem is, but if you follow the detailed guidelines in the MySQL docs you shouldn't have any problems.

If by snapshot, you mean just the files in your data directory - you can't view the DB because there aren't any entries for it in the master mySQL table. So your best way to go is to get a snapshot, do a CREATE DATABASE on the slave server, then untar the snapshot there.

Oh, make sure permissions are right when you untar (mysql:mysql)