Moving / Exporting Joomla from one location to another (with Phpmyadmin and FTP)

Locked
User avatar
cronlin
Joomla! Explorer
Joomla! Explorer
Posts: 484
Joined: Sun Aug 28, 2005 1:19 pm
Location: Noel, MO
Contact:

Moving / Exporting Joomla from one location to another (with Phpmyadmin and FTP)

Post by cronlin » Mon Sep 12, 2005 11:26 pm

To move your Joomla site from either one folder to another or one server to another, here are a few basics.


    * Copy over your files, either via ftp or SSH/command line
    * Backup and then restore your database - perhaps using phpmyadmin or SSH/command line
      (this step only needed if moving site from one server to another.)
    * Edit your configuration.php file to reflect the new values. Specifically the following:
     
      $mosConfig_user = 'joomla_joomla';
      $mosConfig_password = 'password';
      $mosConfig_db = 'joomla_joomla';
      $mosConfig_absolute_path = '/home/joomla/public_html';
      $mosConfig_live_site = 'http://www.joomla.org';
      $mosConfig_cachepath = '/your absolute path/cache';
Note: You may also need to ensure you have configured your .htaccess file in the new location.
Of course with the release of Joomla! it will no longer be $mosConfig_ but $josConfig :D
Last edited by Tonie on Fri Sep 28, 2007 6:54 pm, edited 1 time in total.
As soon as you make something idiot proof, Nature makes better idiots!!!

If you want to know what "coulda", "shoulda", and "woulda" gone wrong, send it my way! I have a natural ability of mucking things up!

User avatar
manuman
Joomla! Guru
Joomla! Guru
Posts: 891
Joined: Fri Aug 12, 2005 1:58 am
Location: Perth - Western Australia
Contact:

Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmin

Post by manuman » Tue Sep 13, 2005 4:48 pm

Q: Why do I get errors importing my database into a new database?

A: Probably the most common problem is a result of the way you exported your database.
Make sure that if you have the option "Use Backticks" or something similar in your MySQL GUI you select that option. What it does is enclose table/field names and data in backticks. This prevents these items from being confused as SQL operators.
Last edited by mcsmom on Fri Sep 28, 2007 11:11 am, edited 1 time in total.
Shayne Bartlett - Joomla Co-Founder
CTO/Web Architect: Elastik Limited https://elastik.space

User avatar
guilliam
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 4181
Joined: Thu Aug 18, 2005 10:27 am
Location: Sunny City Cebu, Philippines!
Contact:

Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmin

Post by guilliam » Wed Nov 23, 2005 9:41 am

.

frequently asked for a our Joomla newbies and newbies alike:

"HOW do i Move/Export Joomla's mySql DB to another host or server via phpmyadmin??"

in response to this, a newbie walkthru in the park type of ducomentation is hereby provided to the community.



REQUIREMENTS:

1. should have phpMyAdmin in both the dev site(1st site) and live site(2nd site).
2. an internet/web browser(fire fox is suggested, as this is what being used in this walkthru).
3. there are reported instances that phpmyadmin and/or the gzip compression is having issues with mac SAFARI. so its hereby strongly suggested to iether use firefox or i.e.

TERMS USED:

A. 1st site - the server or the database in which you will be transferring from.

B. 2nd site - the live site or the live server in which you will be transferring the database to.

C. WHM - Web Host Manager, can be cPanel, Plesk, Direct Admin, Helm, etc.

D. DUMP - A database dump contains a record of the table structure and/or the data from a database, and is usually in the form of a list of SQL queries. A database dump is most often used for backing up a database so that its contents can be restored in the event of data loss. Corrupted databases can often be recovered by analysis of the dump. Database dumps are often released by open source projects, to allow reuse of forking of the database. definition from wikipedia.


THE WALKTHRU:

STAGE 1 - Making a mySQL Dump from the 1st site.

1. login to the WHM(web host manager) of your 1st site  either cpanel, helm, DA, plesk,.. etc.. and then look for phpMyAdmin. open the phpMyAdmin.

2. in the phpmyadmin select the Joomla database name in the pull down menu as show in the image below(pny34a_joomlancer in this example):
Image


3. click on export as shown below:
Image


4. click on 'Select All', tick on SQL on the button below the 'Select All".
Image


5. leave the right side options as the default(this usually work with just the defualt options)
Image


6. tick on the 'Save as file', tick on '"gzipped", then click "go"
Image


7. in your browser, a pop-up window will show and click 'ok', remember where to save the file. on this walkthru we have saved the file in the desktop.
Image


8. at this stage. you already have a mysql DUMP of your 1st site's joomla database. this is where you leave your 1st site's phpmyadmin and login to your 2nd site's WHM.


STAGE 2 - Importing the mySQL Dump from the 1st site to the 2nd site.


1. login to the WHM of your 2nd site. open the 2nd site's phpmyadmin.

2. go to 'MySQL Databases'
Image


3. create a NEW db by filling the new DB name and clicking 'Add Db' (on this walkthru, we placed the name as "testing").
Image


4. once you clicked on 'Add Db' you will be brought to a confirmation screen which says like "Database Created - Added the database testing." (being testing as the db name we have created, will be variable depends on the db name you created) click 'Go Back'

5. you now have a db with the name ******_testing (pny552_testing in this walkthru since most host auto create the db with the hosting account as its prefix, thus in this walkthru 'pny552_' is added. this varies though depending on the hosting package that you have.) we have now a DB but we dont have a USER assigned to that db.

6. Add a user to that new db(pny552_testing in this walkthru) with all privileges(assuming that you already have an existing USER(in this walkthru guilliam_pny552 is the existing user). make sure that privileges of 'All' is ticked. click 'Add user to Db'.
Image


7. you will be brought to a page something like the iamge below, then click on "Go Back'
Image


8. upon clicking on 'Go Back' you should see your new DB by now with a USER with privileges set to "ALL". something like the screenshot below:
Image


9. open your phpmyadmin and select the new/fresh Db you just made from step 2 - 6 of STAGE 2(of this walkthru) from the drop down selection/menu(it may vary depending of how many db's you have in that hosting account). for this walkthru we have 'pny552_testing' see screenshot below for reference(image been cropped to hide the other db's hosted in this testing server/host).
Image


10. once selected from the drop down menu you should see a blank db or a db without tables or data. a text of which will show something like: 'No tables found in database'. from this page/screen click on SQL(2nd to the left tab located at the top). see screenshot below for reference:
Image

 
11. once the SQL button is clicked you will be brought to the 'Run SQL query/queries on database' or this is where you can execute mysql scripts. in which, DUMP exporting is actually a mysql script process. on this screen leave the default selection of 'compression' ticked on "Autodetect" on the  radio button(it will auto detect that your mysql dump is on gzipped format anyway) and click on 'Browse' button located in the middle portion of the window or the upload file field with the caption 'Or  Location of the text file'. check screenshot below:
Image


12. once the browse button is clicked, a "FILE UPLOAD' window will pop-up and look for the mysql DUMP that you have made from 1st site,. click open in that window, and browse for the file location of the dump to be exported(in your desktop or local pc as instructed in STAGE 1,  in our walkthru we have "pny34a_joomlancer.sql.gz').


13. "Go" button in the lower right portion of the window and wait for a moment while  the db is uploading and populated(the duration of uploading and populating depends on the size of the db).

14. the next window, you should see a confirmation which says:
Your SQL query has been executed successfully:
The content of your file has been inserted. (pny34a_joomlancer.sql.gz: xxxx Instructions)

(number of instructions, depends on how many tables and tasks has been executed.) check image below for reference:
Image


and to the left side/panel of the screen you should see the tables are populated and see something like the image below:
Image




Congratulations!!! you just had your first successful Move/Export of Joomla's mySql DB to another host or server via phpmyadmin. cheers!  ;D



- guilliam roque
cebu, ph





* this walkthru gives NO 100% GUARANTEE that it will work for you as exactly as instructed, since WHM's and mysql and phpmyadmin varies in versions and features.

**please post typographical errors of this post in this thread. barely have time to proof read the documentation and check for typo and grammatical errors.

***futher questions, feel free to ask or post it HERE.



- ditto




forum search keywords: export mysql db, export import mysql database, move mysql database to another host or server,
Last edited by Tonie on Sat Sep 29, 2007 12:54 pm, edited 1 time in total.
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net


Locked

Return to “Tips & Tricks - Moving”