Open your database backup file (.sql) file to be specific using notepad++ text editor that you have recently installed.
– Single click your database file – Right click on it while it is selected – Choose Notepad++
Now that you have opened your database with the text editor its time for us to search for the URL that you wanted to change.
– Press CTRL + F in your keyboard that will open a new dialog box in your screen (this command does the search operation). – Click on the Replace tab. – Close the dialog box. – Press CTRL + S to save.
Alright, allow us to explain some stuff as illustrated on the screenshot. In the example above obviously the the database file is coming from the localhost and we wanted to use the same database file into our web server using a domain name that we bought.
So, if ever you are about to install the database from your web server to your localhost machine. All you have to do is to revert the method shown above.
Easy peasy process We hope that you have learned something new today. If you have come to read the articles linked above. We assure you that you can now do backup and restore with your WordPress website.
Do you find this article helpful? comment down below and share.
Like what you see and want to support our creation, consider buying us a cup of coffee.