1. Welcome! Please take a few seconds to create your free account to post threads, make some friends, remove a few ads while surfing and much more. ClutchFans has been bringing fans together to talk Houston Sports since 1996. Join us!

Backing up a database via FTP client

Discussion in 'BBS Hangout' started by finalsbound, Nov 6, 2011.

Tags:
  1. finalsbound

    finalsbound Member

    Joined:
    Aug 31, 2000
    Messages:
    12,333
    Likes Received:
    927
    for a Wordpress site.

    Is this possible? I know I need an SQL file copy of my database, but as far as I understand, you need access to the GoDaddy Hosting Control Center for that server.

    I don't have access to the GoDaddy login information, but I do have all the info to connect to the server in Filezilla. Is it at all possible to export a backup to an SQL file just in the FTP? If not, is there any way around it?

    ----------------

    EDIT: NEW QUESTION :)

    I got the file! BUT, I'm getting an error when trying to move the site over.

    ERROR 1062 (23000) at line 387: Duplicate entry '1' for key 1

    I found line 387 in the SQL file, but there are a lot of "1"s. Can anyone explain how I can identify the error more specifically?
     
    #1 finalsbound, Nov 6, 2011
    Last edited: Nov 7, 2011
  2. rockbox

    rockbox Around before clutchcity.com

    Joined:
    Jul 28, 2000
    Messages:
    22,987
    Likes Received:
    12,844
    the database file is not on the same server as you wordpress files. You need the login info to the database to back it up.
     
  3. finalsbound

    finalsbound Member

    Joined:
    Aug 31, 2000
    Messages:
    12,333
    Likes Received:
    927
    k thanks. poop.
     
  4. Turpis

    Turpis Member

    Joined:
    Apr 3, 2009
    Messages:
    444
    Likes Received:
    54
    Or you can use a Wordpress plugin to do backup of your database.
     
  5. rockbox

    rockbox Around before clutchcity.com

    Joined:
    Jul 28, 2000
    Messages:
    22,987
    Likes Received:
    12,844
  6. finalsbound

    finalsbound Member

    Joined:
    Aug 31, 2000
    Messages:
    12,333
    Likes Received:
    927
    it's funny (well infuriating), I added the Wordpress plugin to the hosting account of my new domain and it completely took away my ability to login to the old site. Such a bummer.

    Thanks for the help.
     

Share This Page