R1Soft Restore mySql file from server from .frm no .sql file available

Posted in Server tips. No Comments »

Restore database using R1soft

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:

(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

Posted in Server tips. No Comments »

Google Apps – reset a users password

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:

  • A user forgets his or her password
  • A user’s account is compromised (security concerns)

To reset a user’s password:

    1. Sign in to the Google Apps administrator control panel.

      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.


    1. Find the user account. You can either search or browse:
      • Search: Enter the user name in the search box at the top of the Google Apps control panel, then click Search accounts.
      • Browse: Click the Organization & users tab from the top menu. Select an organization from the organizational structure on the left.


  1. Click the row for the user account to display the user information page.
  2. Click Change password.
  3. Enter the user’s new password in the Password: field, and then enter it again in the Re-enter Password: field to confirm the change.

    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.

  4. Specify whether you want to force the user to change the password the next time he or she signs in.

    Select the Require a change of password in the next sign in check box to require the user to create a new password.

  5. Click Save Changes along the bottom.

Once you’ve reset a password, be sure to provide the user with new login information.

Howto: Track conversions and phone calls in google analytics

Here’s the howto article on wordpresstips.googlethem.com

Posted in SEO, SEO Dental. No Comments »