Here’s how you’d properly restore myslq using r1soft.
1) Setup r1soft to connect to your MySQL instance and configure it to make mysql snap shots.
2) In the event a database and user are deleted:
2a) inside cpanel, create/recreate the usernameyou want to have access to the database
2b) restore the mysql data using r1soft
2c) from command line on the cpanel server run:
/usr/local/cpanel/bin/setupdbmap
(this will restore the database to the cpanel user account so it is visible)
2d) give the mysql user access to that database using cpanel
2e) restart mysql
3) In the vent you just want to roll data back:
3a) restore the data using r1soft
3b) restart mysql
from: http://support.google.com/a/bin/answer.py?hl=en&answer=33319&topic=14588&ctx=topic
You can always reset the password for a user on your domain. This is helpful when:
To reset a user’s password:
The URL is https://www.google.com/a/cpanel/primary-domain-name, where primary-domain-name is the domain name you used to sign up for Google Apps.
When you enter the password, the Password strength field below the text boxes evaluates the security level of the password. Click the link if you want tips for creating strong passwords. Google requires a password that’s at least eight characters, especially for optimal use with IMAP or POP.
Select the Require a change of password in the next sign in check box to require the user to create a new password.
Once you’ve reset a password, be sure to provide the user with new login information.
Here’s the howto article on wordpresstips.googlethem.com