Database Administration/PHPMyadmin - Where Is It?

Login as admin to plesk panels, then follow this path. If you cannot login as admin, you need to upload phpmydmin to a website on the server.

 

Oh wow! That's pretty cool. How did I miss finding that? (Or is this a new addition?)



There's my xf dev version, and the clone of Holly's system, and the databases from this summer. I'm intrigued to look further inside those lists, but don't quite trust myself yet. (I know I've worked with phpMyAdmin before but it's been awhile.)

 

1. Looking is safe. To look, click on databases and table, to see their data and structure. You can copy a database using the operations tab at the top. You can also trash a database with the operations tab.
   
2. Our file backups are good.
3. We were not backing up databases, until tonight. I just could not leave it undone.

You file backups look like this, on my backup server


Your database backups are on your server, in /root/db_backups/db_backup.0 and /root/db_backups/db_backup.1.
They are run every hour. The most recent backup is in /root/db_backups/db_backup.0.
The file backups are pulled from my backup server and the database backups just run on your server. They also run hourly.


Backups for the server running 21c look like this:


None of our databases are in there.

Our backups of hollyswritingclasses.com look like this:



In addition, Holly's files and databases are backed up nightly by TT.

 

The database backups are not running automatically on your server. I am fixing that now.

The way this task has dragged out is something I cannot let happen. We have to have basics like this working and not taking our time anymore.

 

Ok, now the db backups are working right on your server. Let's see if I can apply this to mine!

 

And that worked for me too.

The reason it dragged out was a lot of little things. I think I know what they are. They all boil down to one thing to remember when setting up cron items. Always use full paths.

GOOD
In cron
cd /root/db_backups; /bin/bash /root/db_backups/backup_dbs.sh

In backup_dbs.sh
#! bash
cd /root/db_backups
/bin/bash /root/db_backups/betterDump.sh

In betterDump.sh
rm "/root/db_backups/db_backup.1/*" > /dev/null 2>&1
mv /root/db_backups/db_backup.0/* /root/db_backups/db_backup.1/

NOT GOOD
In cron
cd /root/db_backups; bash backup_dbs.sh

In backup_dbs.sh
#! bash
cd /root/db_backups
/bin/bash /root/db_backups/betterDump.sh

In betterDump.sh
rm "db_backup.1/*" > /dev/null 2>&1
mv db_backup.0/* db_backup.1/

 

Not new, but it is not place prominently within Plesk