DB Backup not appearing in the DB backup list

If the DB Backup log logged that the Backup Job was created then it should have been created successfully. Possible causes for not seeing the Backup Job you created could be a visual problem. ie the Backup Job is there, but you cannot see it visually due to something else you have installed interfering with BPS plugin js and css scripts so that things are not being displayed visually correctly. Check your WordPress Database using phpMyAdmin and look at this BPS Database Table: xx_bpspro_db_backup. Do you see the Backup Job you created?

FYI – The Backup Job you created has conflicting option setting choices. See the DB Backup Read Me help button for the best logical choices for creating DB Backup Jobs.

Best Logical Choices For Start Times When Scheduling Backup Jobs With the Create Backup Jobs Form
These are some common logical option choices for Creating/Scheduling Backup Jobs. There are other possible combinations of option settings/start times, but these are intended to be simple examples of common logical option setting choices.

Hourly Backup Job
– If you choose Hourly for the Frequency and you do not pick a start Time/Hour when the Backup Job is next run. The next Backup Job will be run at the top of the next hour. Example: If the time now is 4:30PM then the next backup job will be run at 5PM, then 6PM, then 7PM, etc.
– If you choose Hourly for the Frequency and pick a start Time/Hour when the Backup Job is next run. The next Backup Job will be run at the start Time/Hour that you chose. Example: If the time now is 4:30PM and you chose 8PM for the start Time/Hour then the next backup job will be run at 8PM, then 9PM, then 10PM, etc.

Daily Backup Job
– If today is Tuesday and you want to schedule a Backup Job to run at 12AM daily/every night. You would choose Daily for the Frequency, start Time/Hour of 12AM (12AM is tomorrow) and Wednesday for the day of the week for the start time when the Backup Job is next run. The next Backup Job will be run at 12AM Wednesday tonight/tomorrow and at 12AM every night/morning.

Weekly Backup Job
– If you want to schedule a Backup Job to run Weekly at 12AM every Sunday. You would choose Weekly for the Frequency, start Time/Hour of 12AM and Sunday for the day of the week for the start time when the Backup Job is next run. The next Backup Job will be run at 12AM next Sunday and every Sunday at 12AM.

Monthly Backup Job
– If you want to schedule a Backup Job to run Monthly on the 30th of each month at 11PM. You would choose Monthly for the Frequency, start Time/Hour of 11PM and 30th for the day of the month for the start time when the Backup Job is next run. The next Backup Job will be run on the 30th of this month at 11PM and each month on the 30th at 11PM.

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.

Ok then the problem is that the BPS plugin Database Tables were not automatically created when you installed the BPS plugin. When you install the BPS plugin these Database Tables should be automatically created:

xx_bpspro_db_backup
xx_bpspro_login_security
xx_bpspro_seclog_ignore

Try uninstalling and reinstalling the BPS plugin and check if the Database Tables are created. If they are still not being created then there is some kind of problem going on with your Database or maybe you are using an incompatible Database Type. Typically the most commone Database Engine’s will be either MyISAM or InnoDB. If you have a different Database Engine then post what Engine your Database has. You will find that in phpMyAdmin.

For a Weekly Scheduled Backup Job you would not want to select a day of the month. The reason for that is this: What if Sunday is not the 1st of the month? That would mean that the Backup Job would never match the settings you chose and would never create a backup job if Sunday was not the 1st day of the month.

You can use this MySQL Query to check for Storage Engine compatibility: show storage engines

Also go to the BPS System Info page and post this DB info:

MySQL Database Server Version: 5.6.16
MySQL Client Version: mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $
MySQL Database Server: localhost
Your MySQL Database: demo2
SQL Mode: Off

Did you clone your Local Development site to the Live site? If so, did you change the Database connection information in your wp-config.php file so that you are connecting to the correct database?

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

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

My DB engine for my database is InnoDB

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.

It would be very difficult to have to manually do this for every installation and upgrade (plugins, themes, WordPress itself) on your site so most likely your mysql user needs to have more priviledges added or the correct priviledges added. Obviously something is wrong with your MySQL DB.

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. ??

I will now mark this topic as resolved.

Glad you got it figured out. I just agreed with what you already knew was the issue/problem. ??