Joomla Spots ~ Joomla Websites Directory and Resource Library

Our senario assumes that we can access our Joomla sql database through phpMyAdmin
or any similar MySQL Database Administration Tool.
We also assume that old and new domain Mysql databases are having the same version, 
that you already know how to access them and that you already have created them.
Last but not least it would be helpfull if you have an editor installed on your Windows,
i use a commercial one called UltraEdit, you can use a free one like Crimson Editor. 
Be sure to install one of them before continuing this guide.

Old account absolute path: old
New account absolute path: new
Old database name is: olddatabase
New Joomla database name is: newdatabase
Old user database is: userA
Old user database password is: oldpass
New user database password is: newpass
New user database is: userB

Lets say we have our current Joomla website located at domain: www.oldjoomla.com 
and we want to move everything(content and database) to www.newjoomla.com

Below we are giving instructions based on steps:

1. Connect throught and ftp client to your old Joomla website www.oldjoomla.com and 
download all your files in your computer hard drive.
2. Open configuration.php and find the following lines and replace them as advised:

in line 7(more or less)

$mosConfig_absolute_path = '/home/old/public_html';
replace with
$mosConfig_absolute_path = '/home/new/public_html';

Keep in mind that if you dont know what “old” and “new” is about you should ask 
your hosting company to tell you what you should put there. Based on this read the following:

in line 11(more or less)

$mosConfig_cachepath = '/home/old/public_html/cache';
replace with
$mosConfig_cachepath = '/home/old/public_html/cache';

in line 14(more or less)

$mosConfig_db = 'old_olddatabase';
replace with
$mosConfig_db = 'old_newdatabase';

in line 46(more or less)

$mosConfig_live_site = 'http://www.oldjoomla.com';
replace with
$mosConfig_live_site = 'http://www.newjoomla.com';

in line 49(more or less)

$mosConfig_mailfrom = ' This e-mail address is being protected from spambots. You need JavaScript enabled to view it ';
replace with
$mosConfig_mailfrom = ' This e-mail address is being protected from spambots. You need JavaScript enabled to view it ';


in line 57(more or less)

$mosConfig_password = 'oldpass';
replace with
$mosConfig_password = 'newpass';

in line 69(more or less), there is a chance you dont have anything under this entry

$mosConfig_smtpuser = ' This e-mail address is being protected from spambots. You need JavaScript enabled to view it ';
replace with
$mosConfig_smtpuser = ' This e-mail address is being protected from spambots. You need JavaScript enabled to view it ';

in line 71(more or less)

$mosConfig_user = 'old_userA';
replace with
$mosConfig_user = 'new_userB';


3. When done save configuration.php and get ready to upload all your files to your 
new website through ftp.
Be carefull when uploading so that you don't have get any files corrupted.
My advice is to upload each directory alone and watch the procedure so that
everything goes fine.
The best way to upload your files can be achieved if you have cpanel access.
If so, zip all your old website files and then upload them through ftp to your
new website, then connect to your new website Cpanel and access to the File
Manager utility, there find the zip you just uploaded and extract contents.

4. Open your old websites database through phpMyAdmin(or any other MySQL Database Administration Tool)













































5. A new window opens, browse to your sql database and select it.




























6. Go to the right frame of your window and select tab: “Export”. Then “Select All” 
your tables and put the “SQL” as export type, select compression as “zipped” and press “GO”



































































7. After some seconds you ll get a new window that promts you to save the sql file as
a zip file. Press “Save” and place it in your hard disk.
































8. Extract the zip file

9. Open the file that was inside the zip file with an editor(as we mentioned at the beggining of this guide).
Lets say we are using Crimson Editor. (version 3.70)

10. We will use a function of this editor called “Find and Replace”. Go to menu
“Search” and press “Replace”







































11. In the fields you see put in 
“Find what:”    “oldjoomla.com” 
and in
“Replace with:”    “newjoomla.com”
and press “Replace All”
That way you replace all Joomla urls with the new domain without hurting their architecture.

















































12. Save file as “new.sql”

13. Now open your new website database administration tool(same way you did in step 4)
and select your new database.

14. Go to the right frame of your window(considering you are using phpMyAdmin)
and select “Import” and then select “Choose”



























15. Browse through your hard drive and select the new.sql you created 
at step 12 and then Press “GO”

16. After some seconds you ll get a succed message for uploading your database.
Keep in mind that if your new.sql is more than 50MB in size you ll have to split 
in smaller files and upload them one by one since phpMyAdmin cant upload
files bigger than 50MB in size.




If you experience any problems or you need to have something 
explained in further please contact us.