back up and restore mysql data (joomla-ravenswood)

[Uraken]

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.

[Guest]

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.

[plexer]

How about JoomlaClone?

 

http://extensions.joomla.org/component/option,com_mtree/task,viewlink/link_id,665/Itemid,35/

 

Ben

[plexer]

Hmm except it costs money.

 

Some cool addons here:

 

http://www.joomlaport.com/joomla-extensions/10-free-joomla-extensions-i-cant-live-without.html

[contink]

If you have shell access..

 

To grab the data

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

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