phpMyAdmin - Find/Replace Throws 500 Internal Server Error?

[pintwin173]

Sorry for any bother.

I've never edited and SQL db before and wanted to run a global find/replace on my Wordpress posts but got a 500 Internal Server Error.

Apparently over 10,000 of my posts have "http://", and I want "https://":



Looks like a global find/replace on the post_content field should do the trick...WOT?


Any help would be appreciated, thx in advance!

Pintwin173

 

[pintwin173]

No need to reply, here's what I wound up doing:

Downloaded the SQL database in SQL format.
Made a copy of the downloaded file and rename.
Opened the downloaded in a text editor and make any changes
Saved file using the same name
Went to x10Hosting --> MySQL Management
Deleted the existing database.
Uploaded the backup
Selected the modified SQL file & uploaded.
Verified the database.

Frankly, it would have been nicer to execute the Find/Replace in phpMyAdmin, it wouldn't require deleting the database and changes could be checked on the spot. Oh well.