BuddyDev

Search

Image titles restore?

Tagged: , ,

  • Participant
    Level: Master
    Posts: 163
    Audiomonk on August 6, 2018 at 7:57 pm #16672

    I made a big mistake last week, I ran a plugin that generated alt tags for the images on my site. I didn’t realise it also set title tags as well, so the names my users have given their mediapress images have been replaced by filenames 🙁

    I did make a backup before I ran the plugin, but if I restore the full backup, everything that has been added onto my site since then will disappear.

    How would I restore the image title data from the backup? The backup is made up of separate table backups and they all start “insert into” etc. I can’t use Phpmyadmin as it just says duplicate key.

    I know the entries are in the postmeta table from searching on the net. If there’s any help you can give, it would be great.

  • Keymaster
    (BuddyDev Team)
    Posts: 24623
    Brajesh Singh on August 6, 2018 at 8:35 pm #16673

    Hi Audiomonk,

    This is a bit problematic.

    The title is stored in the posts table in the post_title column. It is not stored in the meta.

    It is possible to restore by first importing the backup to a new table and then updating the curent table’s post_title based on post type etc.

    I will not suggest it if you are not too familiar with database.

    Did you take complete backup of database or just the posts/postmeta table.

    We only need the backup file for posts table. I can do it for you if you can grant me access to the backup file and the phpmyadmin(not today, tomorrow/ day after tomorrow).

    Thank you
    Brajesh

  • Participant
    Level: Master
    Posts: 163
    Audiomonk on August 7, 2018 at 9:20 am #16685

    Hi Brajesh

    I have backups of all the tables individually, so I do have the posts table backup. I can definitely grant you access to both backup and phpmyadmin. I’ll grant you access on the day after tomorrow, which will be Thursday here.

    Can you also tell me how to make a donation to Mediapress? You deserve it for all the kind help you give, day after day for everyone.

    Thank you

  • Keymaster
    (BuddyDev Team)
    Posts: 24623
    Brajesh Singh on August 7, 2018 at 12:28 pm #16689

    Hi Audiomonk,
    Thank you.

    There is no need to donate for MediaPress.

    In future, when you need a plugin, if one of our plugins help with the requirement, please do consider it at that time. That will be good enough for me 🙂

    The goal is to have a happy community 🙂

    I am looking forward to assist you further.

    Regards
    Brajesh

  • Participant
    Level: Master
    Posts: 163
    Audiomonk on August 7, 2018 at 4:55 pm #16697

    Well I’m certainly happy with the support that’s for certain. 🙂

    I’ve looked through the plugins a number of times, and there’s none really that fit what I’m using Mediapress for. The closest is the watermark plugin, but I’d want users to be able to add their own (they asked for this a while ago). I can set a global watermark with my lightbox too, but some don’t want one! Which is why a user option would work.

    I’ll keep checking them though, maybe soon there’ll be one that I can buy.

    Thanks for helping on Thursday, I really appreciate it.

  • Keymaster
    (BuddyDev Team)
    Posts: 24623
    Brajesh Singh on August 7, 2018 at 7:10 pm #16701

    Thank you Audiomonk.

    We don’t have the option to enable/disable watermark for the user but we do have an upcoming plugin that allows each user to have their own watermark.

    https://i.imgur.com/svrkU2r.png
    https://i.imgur.com/QjGsKEd.png

    It may not solve your purpose but I thought that since you have mentioned about watermarking, I will share it.

    Looking forward to assist you on Thrusday.

    Regards
    Brajesh

  • Participant
    Level: Master
    Posts: 163
    Audiomonk on August 7, 2018 at 7:15 pm #16702

    That’s what I was wanting a plugin that allows each user to have their own watermark, perfect ! 🙂

    I’ll be buying that when it is released.

  • Participant
    Level: Master
    Posts: 163
    Audiomonk on August 9, 2018 at 8:09 am #16728
    This reply has been marked as private.
  • Keymaster
    (BuddyDev Team)
    Posts: 24623
    Brajesh Singh on August 13, 2018 at 11:01 am #16776
    This reply has been marked as private.
  • Participant
    Level: Master
    Posts: 163
    Audiomonk on August 14, 2018 at 8:12 am #16793
    This reply has been marked as private.

You must be logged in to reply to this topic.

This topic is: not resolved