What’s the risk of sql dump? And editing database through multiple tools
-
Hello,
Recently, I had to make changes to sections of the database of a multisite I run.
First, I made some changes through wp-cli commands
Later, I needed to make a few more updates, so I used Search and Replace plugin to make a few changes.
Again later, more changes were necessary, so I used Search Replace Script in PHP.My questions are:
1/Is there any downside to using different tools? Should I rollback changes and redo using one of them?2/I read that the wordpress database has its own serialization, not to be messed up, etc….
How or when do I know in case I messed it up or not? During WordPress update process….? This is the main question.3/I read that “sql dump is frowned upon” before I used the aforementioned plugin. I didn’t know what I was doing was sql dump. ?? should I rollback the changes I made using that plugin?
Thanks.
[Links to reading materials might suffice if they are written in normal English ?? ]
-
But WordPress itself recommended hand-editing in one case.
manually review all the wp_x_options tables and look for three fields and edit them as needed:
home
siteurl
fileupload_urlThis brings back the question, what exactly you guys mean by serialization.
Is it something that has refers to the internal consistency/coherence of the database?
Or it has something to do with the database’s ability to communicate with future wordpress versions..?This is not a theoretical question. It determines how you can check or verify the integrity of the database.
——–
In the absence of any material on this topic, I believe the issue meets the previous forum’s criteria of being more in-depth or complex than the usual So, I wish you return this post to that forum.If you believe this is an elementary question, please provide a link to any explanatory material. Since WordPress is an open source, no question is off limits. Right?
- The topic ‘What’s the risk of sql dump? And editing database through multiple tools’ is closed to new replies.