Database Administration/PHPMyadmin - Where Is It?

Discussion in 'Plesk' started by Dan Allen, Jan 10, 2016.

  1. Dan Allen

    Dan Allen Administrator Founder Not Banned Radio Button Problem - Leader

    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.

    upload_2016-1-10_12-48-43.png

    upload_2016-1-10_12-49-10.png

    upload_2016-1-10_12-49-25.png

    upload_2016-1-10_12-49-37.png

    upload_2016-1-10_12-49-50.png
     
  2. Kirsten Bolda

    Kirsten Bolda Administrator Radio Button Problem - 2nd Demo Parts A and B Founder Not Banned

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

    upload_2016-1-10_18-43-14.png

    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.)
     
  3. Dan Allen

    Dan Allen Administrator Founder Not Banned Radio Button Problem - Leader

    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
    upload_2016-1-11_2-10-2.png

    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:
    upload_2016-1-11_2-11-5.png

    None of our databases are in there.

    Our backups of hollyswritingclasses.com look like this:

    upload_2016-1-11_2-12-47.png

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

    Dan Allen Administrator Founder Not Banned Radio Button Problem - Leader

    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.
     
    Last edited: Jan 11, 2016
  5. Dan Allen

    Dan Allen Administrator Founder Not Banned Radio Button Problem - Leader

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

    Dan Allen Administrator Founder Not Banned Radio Button Problem - Leader

    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/
     
  7. Dan Allen

    Dan Allen Administrator Founder Not Banned Radio Button Problem - Leader

    Not new, but it is not place prominently within Plesk
     

Share This Page