Article mysql backup how to upload?

Discussion in 'Site & Server Administration' started by kojakfilth, Oct 5, 2006.

  1. #1
    Hi i want to upload the mysql backup of my article site to my new article site which is this www.articlesauce.com .. I want to restore all of the articles from my previous site transfer to my new article site.. please advice. Im using cpanel.:confused:
     
    kojakfilth, Oct 5, 2006 IP
  2. Pat Gael

    Pat Gael Banned

    Messages:
    1,331
    Likes Received:
    68
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Cpanel has an option to restore a full site but it's more likely the script be installed outside the public_html

    The advisable is unpack your backup, upload manually your files and using phpMyAdmin for dumping your database.

    However, if it is big in size, you should better try bigdump: www.ozerov.de/bigdump.php
     
    Pat Gael, Oct 6, 2006 IP
  3. cpsitesaver.com

    cpsitesaver.com Peon

    Messages:
    20
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    If your mysql backup is not too big, try to use the Restore feature of Cpanel. Its on the same page as the backups.

    If its big enough and you know how to navigate via Phpmyadmin, better use it after unpacking your backup for the dump.

    Normally, the restore function with CPanel works. So try it first.
     
    cpsitesaver.com, Oct 8, 2006 IP
  4. kojakfilth

    kojakfilth Notable Member

    Messages:
    3,000
    Likes Received:
    213
    Best Answers:
    0
    Trophy Points:
    210
    #4
    kojakfilth, Oct 9, 2006 IP
  5. Marneo

    Marneo Peon

    Messages:
    31
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I've just followed someone's instructions to create a backup of my website's database using the mysldump command. What is not clear now is this. The backup file which I saved to Desktop is a .sql file but appears just the same as and has the same icon as an ordinary text file. Is this the way it's supposed to be and if a disaster were to strike my website, would this be all that's needed to restore it to its configuration at the time this backup was performed? Thanks for any knowledge shared.
     
    Marneo, Oct 11, 2006 IP