1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to export databse from godaddy

Discussion in 'Site & Server Administration' started by Kaiti, May 20, 2019.

  1. #1
    How to export large database from godaddy please?
     
    Kaiti, May 20, 2019 IP
  2. newbie191

    newbie191 Notable Member

    Messages:
    1,959
    Likes Received:
    99
    Best Answers:
    1
    Trophy Points:
    245
    #2
    If you are talking about godaddy auctions then there are already sites like expireddomains.net from where you can download databases for free in csv or excel format.
     
    newbie191, May 20, 2019 IP
  3. Kaiti

    Kaiti Active Member

    Messages:
    123
    Likes Received:
    7
    Best Answers:
    1
    Trophy Points:
    68
    #3
    No, I'm not talking about it.
     
    Kaiti, May 21, 2019 IP
  4. mmerlinn

    mmerlinn Prominent Member

    Messages:
    3,197
    Likes Received:
    818
    Best Answers:
    7
    Trophy Points:
    320
    #4
    It would definitely help if you would explain what you are trying to do.

    Without more info, I would say to FTP the database, but that may not do what you want to do.
     
    mmerlinn, May 21, 2019 IP
  5. dedikart

    dedikart Greenhorn

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #5
    If it's website database you are trying to export, you should do it from their control panel and phpmyadmin.
     
    dedikart, May 24, 2019 IP
  6. Kaiti

    Kaiti Active Member

    Messages:
    123
    Likes Received:
    7
    Best Answers:
    1
    Trophy Points:
    68
    #6
    this does not work, I'm sorry.
     
    Kaiti, May 24, 2019 IP
  7. JEET

    JEET Notable Member

    Messages:
    3,825
    Likes Received:
    502
    Best Answers:
    19
    Trophy Points:
    265
    #7
    I think godaddy offers CPANEL now.
    In cpanel, you can either use phpmyadmin, which has export database feature.
    You can export individual tables also.
    Second option, again in cpanel is "backup and downloads", or something like that.
    Using this, you can either download full zip file of all files,
    or a database dump, which is gz extension I think...

    Then you can import this database to another site using the same cpanel feature which you used for download.
     
    JEET, May 24, 2019 IP
  8. newbie191

    newbie191 Notable Member

    Messages:
    1,959
    Likes Received:
    99
    Best Answers:
    1
    Trophy Points:
    245
    #8
    Inside cPanel you can take a backup of your database and download it using ftp.
     
    newbie191, May 25, 2019 IP
  9. qwikad.com

    qwikad.com Illustrious Member Affiliate Manager

    Messages:
    7,151
    Likes Received:
    1,656
    Best Answers:
    29
    Trophy Points:
    475
    #9
    It doesn't work because you don't have access to the DB or what? In cPanel: phpMyAdmin -> your_database -> Export (in the menu) -> Go
     
    qwikad.com, May 26, 2019 IP
  10. JEET

    JEET Notable Member

    Messages:
    3,825
    Likes Received:
    502
    Best Answers:
    19
    Trophy Points:
    265
    #10
    @qwikad.com it doesn't work on my other shared server too, with large database. Only partial tables are backed up, 25-50 MB filesize, depending on PHP memory_limit

    For him that direct Cpanel option will work, "Backup and restore"
     
    JEET, May 26, 2019 IP
  11. dedikart

    dedikart Greenhorn

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #11
    If you are unable to export from the cPanel or phpmyadmin, you should ask their support to create a dump file your database and you can download it using the FTP.
     
    dedikart, Jul 14, 2019 IP
  12. Ron Peters

    Ron Peters Greenhorn

    Messages:
    56
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    23
    #12
    Hey there!

    I think I can help you with this.

    To export database content, you should perform the following steps: Log into your hosting account and scroll down to see the Databases section. Click on MySQL button.
    1 The pop-up window with the list of your databases appears. Select your required database name from the list. Then click on the phpMyAdmin button on the right side.
    2 Log in to the phpMyAdmin section with your database access details. Then click on the Go button to proceed.
    3 In the phpMyAdmin control panel window click on your database name on the left side. Then go to the Export tab at the top middle.
    4 Make sure to Select all database tables. Then choose the format of your exported file I recommend that you use SQL one.
    5 Check the fields in the Options section as on the screenshot below
    6 Check the Save as file field. You may set your custom name for the exported file here or leave the default settings. By default, file with backup data is named the same as your database.
    7 Click on the GO button in the right bottom corner after you have finished all the preparations. Save file to your computer.
    8 Now you are ready with the site data backup. You may proceed with working with your database or use the Exit button to leave the PHPMyAdmin section.

    Regards,
    Ron Peters
     
    Ron Peters, Aug 28, 2019 IP