+ Post New Thread
Results 1 to 5 of 5
Web Development Thread, back up and restore mysql data (joomla-ravenswood) in Coding and Web Development; hi all i created a website using the ravenswood standalone version of joomla i now need to get it online ...
  1. #1

    Join Date
    Oct 2006
    Location
    uk
    Posts
    494
    Thank Post
    19
    Thanked 3 Times in 2 Posts
    Rep Power
    17

    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.

  2. #2
    Guest

    Re: back up and restore mysql data (joomla-ravenswood)

    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.

  3. #3

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,611
    Thank Post
    647
    Thanked 1,616 Times in 1,446 Posts
    Rep Power
    421

    Re: back up and restore mysql data (joomla-ravenswood)


  4. #4

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,611
    Thank Post
    647
    Thanked 1,616 Times in 1,446 Posts
    Rep Power
    421

    Re: back up and restore mysql data (joomla-ravenswood)

    Hmm except it costs money.

    Some cool addons here:

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

  5. #5
    contink's Avatar
    Join Date
    Jul 2006
    Location
    South Yorkshire
    Posts
    3,791
    Thank Post
    303
    Thanked 327 Times in 233 Posts
    Rep Power
    118

    Re: back up and restore mysql data (joomla-ravenswood)

    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

SHARE:
+ Post New Thread

Similar Threads

  1. Programatic data extraction from SIMS.net Data Base
    By NetworkGeezer in forum MIS Systems
    Replies: 108
    Last Post: 16th February 2010, 09:22 PM
  2. Joomla - mysql
    By smith1195 in forum Web Development
    Replies: 3
    Last Post: 13th November 2007, 04:16 PM
  3. Update Active Directory with mySQL table data?
    By netadmin in forum Windows
    Replies: 8
    Last Post: 30th October 2007, 10:43 PM
  4. Windows Back Up / Restore.
    By tickmike in forum Windows
    Replies: 24
    Last Post: 23rd August 2006, 03:20 PM
  5. Test Data not sent back to APS - can't do anything!!
    By indiegirl in forum ICT KS3 SATS Tests
    Replies: 10
    Last Post: 18th May 2006, 02:42 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •