iletogv

I will now mark this topic as resolved.

IT’S ALL WORKING NOW. What I did to make this work was to give mysql user a full privilege over the database it is linked to. Before, my mysql user can only do select, insert, delete, and update privileges.

After giving the mysql user a full privilege I instantly noticed that BPS tables have been automatically created for me without re-installing the plugin.

THANK YOU VERY MUCH FOR YOUR SUPERB SUPPORT AND PLUGIN. ??

My DB engine for my database is InnoDB

Just to let you know, for the mysql user that I am using for wordpress, the user privileges I set to the user are the following:

select
insert
delete
update

1. Here’s what I’ve got from the BPS system info page:

MySQL Database Server Version: 5.5.42-cll
MySQL Client Version: 5.5.42
MySQL Database Server: localhost
Your MySQL Database: XXXXXX
SQL Mode: Not Set
MySQL Extension: Installed|Enabled
MySQLi Extension: Installed|Enabled

2. The database connection config in the wp-config in correct as I am not having problems with other modules. However, I noticed before that my BuddyPress DB tables were not being created as well in the live database so I had to copy the tables from my local machine to phpmyadmin on the live database.

3. Here is the result after running the “show storage engines”

MyISAM
YES
MyISAM storage engine
NO
NO
NO

MRG_MYISAM
YES
Collection of identical MyISAM tables
NO
NO
NO

MEMORY
YES
Hash based, stored in memory, useful for temporary…
NO
NO
NO

BLACKHOLE
YES
/dev/null storage engine (anything you write to it…
NO
NO
NO

CSV
YES
CSV storage engine
NO
NO
NO

InnoDB
DEFAULT
Supports transactions, row-level locking, and fore…
YES
YES
YES

ARCHIVE
YES
Archive storage engine
NO
NO
NO

PERFORMANCE_SCHEMA
YES
Performance Schema
NO
NO
NO

FEDERATED
NO
Federated MySQL storage engine

I did follow the backup job choice for the weekly job.

Actually, there were no database tables that have been created with a name that contains “bpspro” or “bps” when I check it on phpmyadmin.

These are my selections when i was creating my first DB backup job on the live server: (sorry i cannot remember the actual option name)

Frequency: weekly
Time: 12AM
Day: sunday
Month: 1st
Auto-delete backups: more than 30 days old

That’s all i’ve changed including the name of the backup.