This article gives three methods to change Magento Base URLs through PHPMyAdmin and the command line. Method 1: Change Magento ba...
6:30 AM
This article gives three methods to change Magento Base URLs through PHPMyAdmin and the command line.
Method 1: Change Magento base URLs in Magento Admin Panel
- Log in to your Magento Admin Panel (Figure 1).
Figure 1. Magento Admin Panel.
- On the upper right, click System > Configuration.
Figure 2. System > Configuration.
- From the menu on the left, under the General list, click Web (Figure 3).
Figure 3. General > Web.
- Open the Unsecure and Secure dropdowns, locate the base URL line, and replace this with the new URL.
- Clear the Magento cache and your browser's cache. The site should now load properly.
Method 2: Change Magento base URLs with PHPMyAdmin
- Log in to your SiteWorx account.
- From the menu on the left, click Hosting Features > MySQL > PhpMyAdmin (Figure 4).
Figure 4.
Hosting Features > MySQL > PhpMyAdmin.
- You will see the main menu for phpMyAdmin. On the left side of the screen, locate and click the name of the Magento database corresponding to URL you want to change.
Figure 5. Magento database selection.
- You will see a list of all the tables in the database in alphabetical order. Search for the core_config_data table and click Browse (Figure 6).
Figure 6. List of tables and core_config_data table.
- Expand the viewing area of phpMyAdmin. At the top and bottom in the main panel, locate the grey box and change theNumber of rows to a larger number, such as 100.
Figure 7. Number of rows field.
- Locate the rows web/unsecure/base_url and web/secure/base_url and click Edit next to the corresponding lines. Change the base URL to the intended string, and click OK.
- Within the Value column, update the value of each specific secure and unsecure URL to the intended URL.
- Flush the Magento cache, and the site should load with the set base URLs properly now.
Method 3: Change Magento base URLs with the command line
Attention: Do not attempt to change the base URLs unless you are familiar with the command line and
MySQL queries.
- Use SSH to log in to the server hosting the Magento installation's database.
- Enter the following command, where $database_user is the database user and $database_name is the database:
- mysql -u $database_user -p $database_name
- Enter your password when prompted.
- Access their database using the following command, where database is the database name.
use database
- Run the following command:
select * from core_config_data where path like '%base%url%';
5. This will display the current base_urls set in Magento.
6. To change the base URLs, execute the following commands:
update core_config_data set value = 'http://domainname/' where path = 'web/unsecure/base_url';
update core_config_data set value = 'http://domainname/' where path = 'web/secure/base_url';
