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.

Backup/Restore a large database

Discussion in 'Site & Server Administration' started by sarahk, Oct 30, 2007.

  1. #1
    A client has a large MySQL database and the existing backup & restore options provided through vBulletin are timing out as the database is large (596MB).
    SEMrush
    The hosting console has limited features - it's cpanel or direct admin or anything. We don't have shell access but will be able to use PHP's exec().

    Prior to software upgrades we need to be backing up the database and able to restore it if need be.

    Any recommendations?
     
    sarahk, Oct 30, 2007 IP
    SEMrush
  2. muks

    muks Member

    Messages:
    83
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    45
    #2
    do you have shell access?

    you can use mysqldump to backup the database
     
    muks, Nov 1, 2007 IP
  3. Teodor

    Teodor Banned

    Messages:
    382
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    58
    #3
    Hello.
    I think that you have to keep somewhere over your current server.
    I think that it is not a deal to have DB on your laptop or desctop computer. So in this case I would suggest you for solutions something like RazorServers.com offers.
    I guess few bucks for backup is not to many.
     
    Teodor, Nov 2, 2007 IP
  4. Sebastian Rametta

    Sebastian Rametta Peon

    Messages:
    13
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #4
    ya if you have the sql files.. just do this:

    connect to the server via shell...

    type mysql -u USERNAME -p DATABASENAME < dumpfile.sql

    you will be prompted for the password for the database user, after inserting the proper credentials the database import will begin, and it will not timeout like it is doing for you now. It should complete in a few minutes depending on the available resources on the machine.

    Sebastian Rametta
     
    Sebastian Rametta, Nov 4, 2007 IP
    sarahk likes this.
  5. inworx

    inworx Peon

    Messages:
    4,860
    Likes Received:
    201
    Best Answers:
    0
    Trophy Points:
    0
    #5
    inworx, Nov 6, 2007 IP
    sarahk likes this.