No announcement yet.

Question About Backing Up via PHPMyAdmin..

  • Filter
  • Time
  • Show
Clear All
new posts

  • Question About Backing Up via PHPMyAdmin..


    In a few days I will be moving servers due to some issues. I was wondering if someone could answer a few questions I have about doing so.

    Okay, I have included a screenshot of my phpmyadmin page where I perform the backup of my database..

    1. What boxes do I need to check to make sure that I save all the posts/threads/EVERYTHING on my forum, so that nothing is left behind?

    2. Should I just click "Save As File", or do I need to gzip it or another option listed?

    3. Also, in my AdminCP, do I need to download my xml style to make sure the layout stays the same? I have some pretty heavily hacked templates..and wasnt sure if those templates would stay the same if I downloaded it.

    I guess my main thing is, I am really really nervous about swithcing to another server...I am scared to lose everything..2+ years of work..

    I would appreciate any suggestion/guidelines/help any of you can provide

    Thanks for you time,


  • #2
    The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:



    This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Here's the instruction using phpMyAdmin:

    Backup with phpMyAdmin:

    Restore with phpMyAdmin:
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    • #3
      thank you very much, I am looking into this



      • #4
        You could just tarball everything up from the shell, gzip it, and FTP it down to your PC.


        • #5
          Select structure & data and check 'send as file' and select 'gzipped'.

          Give the browser time to back things up and zip it up .. after it will present you with a working name.gz file you can store on your hard drive.