The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need to clean up , too many databases

Discussion in 'Database Discussions' started by rocmel, Feb 15, 2016.

  1. rocmel

    rocmel Registered

    Joined:
    Feb 15, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Australia
    cPanel Access Level:
    Website Owner
    I only have one website now , but multiple installs to a subdomain have left their mark.
    They were created by opencart MySQL.
    I'll like to safety delete some of them. How do I determine which ones to delete.
    The only options I have are Rename or Delete
    Database size User
    tensther_bn5x1 0.67 MB ----
    tensther_oc1 0.00 MB ----
    tensther_oc2 0.36 MB tensther_oc2
    tensther_oc3 0.97 MB tensther_con1 tensther_oc3
    tensther_ocar305 0.50 MB tensther_ocar305
    tensther_ocar671 0.50 MB tensther_ocar671
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,478
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    You might want to check your existing site's configuration file to make sure you know the name of the database still in use. Once you know that, the others can be killed with the Delete button.

    Making this sort of change, to be safe, it wouldn't hurt to run a Full Website Backup, first. You can never have too many backups. ;)
     
  3. rocmel

    rocmel Registered

    Joined:
    Feb 15, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Australia
    cPanel Access Level:
    Website Owner
    I done backups, in my config file it shows _oc3 been used, then tried myPhP to rename the other Db's but it wants to recreate with a new name.
    All I want is to disable them by adding _xxX.OLD
    Is there another way through the file manager?
     
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,478
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    You can manually back them up one by one before deleting them if you like. You can can create a new database named anything you want and copy the old to the new via phpMyAdmin too.
     
Loading...

Share This Page