This technique is advantageous when dealing with a lot of matches that you want to replace. It is a bit more user-friendly than the SSH method, and we recommend using it if you are not comfortable enough executing SSH commands:
- Please log in to your cPanel.
- Use the search field on the top right corner and type in "phpMyAdmin". After the result presents itself underneath the search field, please click on it. Alternatively, you can navigate to the "Databases" features group and choose the "phpMyAdmin" tool.
- This act will redirect you to the phpMyAdmin interface, and on the left side, you will see a column containing a list of all your databases on the server. Please click on the database where you want to perform the search. If you are not sure which is the database for your website, please log in via SSH and navigate to the root directory of the application, using the Linux Command Line Basics. When you are inside, please run the following command:
grep 'username_' * -Ril
Here is an example:grep 'hostaramda_' * -Ril
The output will show you the database of your website! - When you are sure which is the correct database, please click on it.
- Upon doing the above, all of the tables will be displayed in the middle of the screen. Above them, you will see a lot of tabs. The one you should click on is the "Export" tab.
- Upon doing so, you will land on a page, allowing you to export your database. Leave everything to its default value and click the "Go" Button. This click will trigger a download, and when it finishes, you will have the file locally saved.
- Please open this file using either NotePadqq or NotePad++.
- After you open the program, please press the "CTRL + H" button combination on your keyboard. This button sequence will open a popup window, where you will see two text fields. In the first one, please enter the current value you want to replace, and in the second one, the new value.
- Lastly, please click the "Replace All" button and wait for all the changes to be complete. You will receive an output, notifying you how many changes have been made. All you need to do now is save the new file somewhere on your computer.
- After saving it, please go back to phpMyAdmin and click on your database again. On the bottom left side, below the database tables, you will see a checkbox. Next to it, there is a button called "Check All" - please press it.
- All the tables will be selected, and now, using the dropdown menu on the right side of the "Check All" button, select the "Drop" option.
- This will take you to a new page, asking for confirmation about executing this query. Please press the “Yes” button on the right side of the screen. This button press will drop all the tables, allowing you to re-import the newly replaced file you currently have on your computer.
- To do so, please click on the "Import" tab located on the top of the page when the database is selected.
- After you land on the "Import" page, on the top of the screen, you will see a "Choose File" button. Please press it.
- Doing so will open a window, allowing you to select a local file from your computer. Please chose the SQL file you saved earlier containing all the replaced matches.
- Finally, hit the "Go" button on the bottom left side of the screen and wait for the importation process to finish.
- That's it! You have now successfully replaced entries in your database with new ones using the NotePad++/NotePadqq method!
If you do not feel comfortable enough to attempt this method yourself - do no worry! Our technical support team is 24/7 available at your disposal, and they will be happy to assist you. You can contact them by submitting a support ticket from your Client Area.