@sterndata , thanks so much for your insight, I just meant the “that’s cruel, man” last thing I said as a joke to poke fun at my own self. I thought of a few questions for earlier in the process, on which I wanted to check:
1) At the point in this process where I would run “better search replace” and replace all of the instances of http://example.com with https://example.com in all of my tables, I understand that whenever someone purchases an SSL certificate, there’s a point in the process where one chooses a “Common Name”, and one has to specify either http://www.example.comor example.com (with or without www). My web-host has already told me which choice will use, in my case, for my site, but does change or relate to this search string that I will enter into “better search replace” whenever I am attempting to do this process you have recommended, of changing all of the instances of http://example.com with https://example.comin all of my tables?
2) When I am ready to actually run this “better search replace”, I will uncheck the box called “Run as dry run?”, and then when I hit the button “Run Search/Replace”, that is what runs it for-real, correct?
3) I am trying to run phpmyadmin and create a backup of my WP site like described here in the “Custom backup process” section:
https://codex.ww.wp.xz.cn/Backing_Up_Your_Database
But I am unsure whether, on step 6 of the instructions, if I am supposed to choose the Add CREATE DATABASE / USE statement option or not. The instructions on https://codex.ww.wp.xz.cn/Backing_Up_Your_Database seem to show to *NOT* select that option on step 6 in the “Object creation options”, but when I was getting some support help from a technician at my web-host, they told me that I *do * need to select that Add CREATE DATABASE / USE statement` option on step 6 in the “Object creation options”.
Also, whenever I am in my phpmyadmin , whenever I see on step 5 where I am supposed to have options at the bottom, “Structure and data”, I do not have that option in my phpmyadmin. That support technician at my web-host said all I need to do in order to save a backup is do this:
`Add DROP TABLE / VIEW / PROCEDURE / FUNCTION
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Save as file >> File name template (1): MyDatabase_Backup > Compression choose – zipped.
After that you need to click on ” Go” button.’
But, I just want to make sure I save the right file in the right way, so in case I have to restore it, that I do this all correctly.
4) Is there a way for me to test and make sure that “An error occurred processing your request. Try decreasing the “Max Page Size”, or contact support” error won’t happen whenever I uncheck the “Run as dry run?” box and do the real thing? Like, am I able to test and make sure that it will work and not give me the “An error occurred processing your request. Try decreasing the “Max Page Size”, or contact support” error whenever I have the “Run as dry run?” checked and try the dry run first? If the Dry Run works, is that safe to assume that I will not get the “An error occurred processing your request. Try decreasing the “Max Page Size”, or contact support” error and it will carry it out for-real whenever I uncheck the “Dry run” and start the for-real process?
5) Are there any server requirements in order to use “better search replace” that I need to check with my web-host, that I could check right now, to ensure that it it wlll run and load and function as it should and everything?
6) Do you have another plugin that’s free and dependable that you could recommend, that I could just know about and have waiting in-reserve, in case, for whatever reason “better search replace” does not work?
Appreciate any insight you can give me.
