Sometimes you have to change your hosting company and you do not want to pay for premium transfer plugins. In these cases you must know how to change paths in database to keep everything fine.
- Download your database file from phpMyAdmin
- Open file with Notepad++
- Find and replace using this format:
- cPanel format: /home/accountname/public_html/
- DirectAdmin format: /home/accountname/domains/example.com/public_html/
- Plesk format: /var/www/vhosts/example.com/httpdocs/
- Save your file. Compress the file and upload it to your new host phpMyAdmin. (For DirectAdmin using .tar format is better. I strongly suggest 7-zip)
A real example:
Consider my website is kavianionline.com and I am using DirectAdmin. Now I am going to migrate to a cPanel hosting company. Also consider my accountname in DirectAdmin is kavi and in new cPanel is kavianio. I should open my database, find all “/home/kavi/domains/kavianionline.com/public_html/” to “/home/kavianio/public_html/”
(Note: If you are changing to new domain name, you must replace all domain names too. )