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.
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).
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.
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.
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.
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.
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.
You must be logged in to reply to this topic.