I have to change over 1600 instances of the IP address throughout a huge multisite (over 100 sites in the network) and I'm preparing to launch tomorrow. I have had issues in the past while trying to update all instances of the URL in the database, because phpMyAdmin would just timeout with such a large Import. I don't want to have that issue again tomorrow, so I was hoping someone might know how to perform a global search and replace in phpMyAdmin. I just need to update the URL, the site is already on the server so we're not moving the files to a new hosting environment.
Does anyone know how to do this safely and effectively? I have only found information about how to change the URL in the options, but not globally. With over 100 sites to change and over 1600 instances of the URL, there has to be a more efficient way to do this, right?
Thanks in advance~