1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need help in Hostgator

Discussion in 'Web Hosting' started by samozain, Jul 11, 2012.

  1. samozain

    samozain Registered Member

    Joined:
    Jun 20, 2011
    Messages:
    79
    Likes Received:
    1
    Hi
    I want to add my sites to Hostgator
    But i tested new domain in this Host

    And i Want to know how can i backup and Restore SQL or Database in This Host
    Please tell me any topic about that because i searched on the internet and i didn't found any thing
     
  2. sonobby1

    sonobby1 Regular Member

    Joined:
    Mar 3, 2009
    Messages:
    236
    Likes Received:
    31
    Location:
    Uk
    Hostgator have video tutorials that will help you, and also they have live 24 hour chat, hope this helps
     
    • Thanks Thanks x 1
  3. redrubies

    redrubies Supreme Member

    Joined:
    Jan 17, 2011
    Messages:
    1,424
    Likes Received:
    2,560
    Location:
    USA
    here you go: https://support.hostgator.com/articles/cpanel/how-to-backuprestore-your-mysql-database

    [h=1]How to backup/restore your MySQL database[/h]


    If you run a database driven website, it is important to backup your databases, periodically. You can generate a full backup to do this, but you may decide it is unnecessary to backup everything. So, here is how to backup just your databases.
    To backup the databases please do the following:

    1. Login to your control panel and click Backups.
    2. Under Download a MySQL Database Backup, click the name of the database.
    3. Click Save As.
    4. Select a destination for where you would like the back up to be saved, locally.
    Once you have a backup, if you ever inadvertently lose your data, then you can restore the database easily and quickly.
    To restore a database, please do the following:
    1. Login to your control panel and click Backups.
    2. Click the Browse button next to the option which says Restore a MySQL Database.
    3. Select the .sql.gz file which you want restored.
    4. Click the Open button and click the Upload button.
    Your database driven website should be working again.
    [h=4]Related Articles[/h]
     
    • Thanks Thanks x 1
  4. samozain

    samozain Registered Member

    Joined:
    Jun 20, 2011
    Messages:
    79
    Likes Received:
    1
    ok thanks
    but in Videos they didn't told how can we backup and restore it
     
  5. samozain

    samozain Registered Member

    Joined:
    Jun 20, 2011
    Messages:
    79
    Likes Received:
    1
    yes
    I found it befor
    But i found MySQL was 23 Miga
    But in download Page i found it 1 Miga
     
  6. redrubies

    redrubies Supreme Member

    Joined:
    Jan 17, 2011
    Messages:
    1,424
    Likes Received:
    2,560
    Location:
    USA
    They might not have a video tutorial on that topic, but what I pasted should work fine for you.
     
  7. redrubies

    redrubies Supreme Member

    Joined:
    Jan 17, 2011
    Messages:
    1,424
    Likes Received:
    2,560
    Location:
    USA
    Hmmmmmm I think you should go in the hostgator chat and ask them why that happened and how you can correct it.
     
  8. adulthappy

    adulthappy Newbie

    Joined:
    Aug 3, 2012
    Messages:
    15
    Likes Received:
    1
    you can have a chat with their online customer service.
     
  9. ezine.writer

    ezine.writer Regular Member Premium Member

    Joined:
    Jan 9, 2011
    Messages:
    418
    Likes Received:
    51
    Gender:
    Male
    Occupation:
    Copywriter and SEO Analyst / Marketing Strategiest
  10. Kiopa_Matt

    Kiopa_Matt Registered Member

    Joined:
    Jun 3, 2011
    Messages:
    99
    Likes Received:
    11
    You can add new sites by logging into cPanel, and going to the Addon Domains menu. From there, you can easily add or delete domains.

    Then for the SQL backup, you can goto the phpMyAdmin menu within cPanel, and you'll see Import / Export menus in there. They'll let you save your entire database to an SQL file, and upload that SQL file later.