back up and restore mysql data (joomla-ravenswood)

hi all i created a website using the ravenswood standalone version of joomla i now need to get it online to my host, has any one done this that can give me some pointers.

i know how to transfer the template but its the database contents in mysql that i'm not sure of, although my host does use mysql too so i'm hoping its straightforward

As always cheers in advance.

Export the SQL database to a file via phpmyadmin on ravenswood

Copy your entire site to you webhost

Via your hosts phpmyadmin import your sql data file

edit your configuration.php file with the new sql database details / default locations and live site details.

How about JoomlaClone?

http://extensions.joomla.org/compone...665/Itemid,35/

Ben

Hmm except it costs money.

Some cool addons here:

http://www.joomlaport.com/joomla-ext...e-without.html

If you have shell access..

To grab the data

Code:

---

mysqldump -u DBUSER -pDBPASSWORD DBNAME > /home/YOURACCOUNT/public_html/mydbdump.sql

---

Use Wget to transfer it to your new host, create your new database on your new host account and then

Code:

---

mysql -u NEWDBUSER -pNEWDBPASSWORD NEWDBNAME < /home/NEWACCOUNT/public_html/mydbdump.sql

---