How to migrate joomla website from windows to linux or linux to windows server?

How to take the Backup of Joomla

>> Login into Joomla Administrator
>> Click on Joomla Backup tool
>> Create the backup on local system in JPA Format
>> After that upload this JPA file on Our WIPL Server
>> Then Use the Joomla extract tool i.e. unjpa.php or kickstart.php
>> it will create the web-based installer which you can easily install like any web-based program.

Use following forums which will help you for the same.
http://forum.joomla.org/viewtopic.php?p=1782219
http://joomlapack.blogspot.com/2008/05/introducing-kickstart-and-jpa.html

Connection Strings (MSSQL 2000, MSSQL 2005, MSSQL 2008, MySQL4, MySQL5, MS Access Database)

MSSQL2000
Set conn = Server.CreateObject(“ADODB.Connection”)
conn.Open “Provider=SQLOLEDB; Data Source =mssql.dnsracks.com,1533; Initial Catalog = Yourdatabase; User Id = USER; Password=PASSWORD; Network Library=dbmssocn;”
If conn.errors.count = 0 Then
Response.Write “Connected OK”

MSSQL2005
Set conn = Server.CreateObject(“ADODB.Connection”)
conn.Open “Provider=SQLOLEDB; Data Source =74.86.116.10; Initial Catalog = Yourdatabase; User Id = USER; Password=PASSWORD; Network Library=dbmssocn;”
If conn.errors.count = 0 Then
Response.Write “Connected OK”

MSSQL 2008
Data Source=72.18.135.197,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

MySQL4
<%
dim CN
set Cn = Server.CreateObject(“ADODB.connection”)
CN.Open “DSN=dsn_name; Server=localhost;database=database_name; Uid=user_id; Pwd=password;”
%>

MySQL5
<%
dim CN
set Cn = Server.CreateObject(“ADODB.connection”)
CN.Open “DSN=dsn_name; Server=localhost:3307;database=database_name; Uid=user_id; Pwd=password;”
%>

MS Access

DSN-Less

<%
set conn=Server.CreateObject(“ADODB.Connection”)
conn.Provider=”Microsoft.Jet.OLEDB.4.0″
conn.Open “c:/webdata/northwind.mdb”
%>
Connected !!

DSN

1) You must first create the DSN in Helm under your domain.
2) Then use the following connection string – with your own DSN
name of course :

<%
Set connectionToDatabase=Server.CreateObject(“ADODB.Connection”)
connectionToDatabase.ConnectionTimeout=60
connectionToDatabase.Open”DSN=DSN_Name”
%>
Connected !!

To Know more about Connection Strings open the following link
http://www.connectionstrings.com/

1. Open phpMyAdmin.
2. Click Export in the Menu to get to where you can backup you MySql database.
3. Make sure that you have selected to export your entire database, and not just one table. There should be as many tables in the export list as showing under the database name.
4. Select”SQL”-> for output format, Check “Structure” and “Add AUTO_INCREMENT” value. Check “Enclose table and field name with backquotes”. Check “DATA”, check use “hexadecimal for binary field”. Export type set to “INSERT”.
5. Check “Save as file”, do not change the file name, use compression if you want. Then click “GO” to download the backup file.

Restoring a backup of a MySql database

1. To restore a database, you click the SQL tab.
2. On the “SQL”-page , unclick the show query here again.
3. Browse to your backup of the database.
4. Click Go.