BuddyPress.org

Of course I know how to backup database and restore it. However, the normal database backup does not work for me. I get following error:

mysqldump: mysqldump: Couldn’t execute ‘show table status like ‘wp\_user\_999\_friends\_activity\_cached”: Out of memory (Needed 2093952 bytes) (5)

mysqldump: mysqldump: Couldn’t execute ‘show table status like ‘wp\_user\_999\_friends\_activity\_cached”: Out of memory (Needed 2093952 bytes) (5)

I tried restoring an older version of the backup of live site on my test site setup using XAMPP on my desktop. I get “Fatal Error”

Fatal Error

If your blog does not display, please contact the owner of this site.

If you are the owner of this site please check that MySQL is running properly and all tables are error free.

Could Not Find Blog!

Searched for localhost.localdomain/rkn/ in wordpressmu::wp_blogs table. Is that right?

What do I do now?

Read the bug report page. Some of the guidelines there may help you figure out what went wrong.

If you’re still stuck with this message, then check that your database contains the following tables:

wp_blogs

wp_users

wp_usermeta

wp_site

wp_sitemeta

wp_sitecategories

If you suspect a problem please report it to the support forums but you must include the information asked for in the WPMU bug reporting guidelines!