Need to clean up , too many databases

rocmel

• February 15, 2016 06:50

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

• 

  Infopro

  • February 15, 2016 11:55

  How do I determine which ones to delete.

  
  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. ;)

  0
• 

  rocmel

  • February 15, 2016 23:50

  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. ;)

  
  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?

  0
• 

  Infopro

  • February 16, 2016 01:19

  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.

  0

Please sign in to leave a comment.