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.
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.
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.
- Web Host Manager, can be cPanel, Plesk, Direct Admin, Helm, etc.
- 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
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):
3. click on export as shown below:
4. click on 'Select All', tick on SQL on the button below the 'Select All".
5. leave the right side options as the default(this usually work with just the defualt options)
6. tick on the 'Save as file', tick on '"gzipped", then click "go"
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.
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'
3. create a NEW db by filling the new DB name and clicking 'Add Db' (on this walkthru, we placed the name as "testing").
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'.
7. you will be brought to a page something like the iamge below, then click on "Go Back'
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:
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).
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:
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:
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:
and to the left side/panel of the screen you should see the tables are populated and see something like the image below:
Congratulations!!! you just had your first successful Move/Export of Joomla's mySql DB to another host or server via phpmyadmin. cheers!
- guilliam roque
* 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.
forum search keywords: export mysql db, export import mysql database, move mysql database to another host or server,