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

backup dump with phpMyAdmin - confirm details needed

Discussion in 'XenForo Questions and Support' started by otfordnet, Nov 8, 2010.

  1. otfordnet

    otfordnet Member

    Hi,

    just about to go from Beta1 > Beta2, could someone please give me some advice about settings for phpMyAdmin dump?

    I've got this ...
    phpmyadmin.jpg

    Do I need anything more?

    Many thanks
    JohnH
     
  2. Floris

    Floris Guest

    That's all you need.

    You select all the tables, say its sql, select to include structure, and include data, and to save as a file.

    The default are fine.

    If you can have shell access, ignore phpmyadmin completely and just use the shell to dump - no timeout limits, etc.
     
  3. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  4. otfordnet

    otfordnet Member

    Thanks Floris and Jake too .. here goes .. :)
     
  5. Lawrence

    Lawrence Well-Known Member

    I would select Add Drop Table. This way if a newer DB modified fields, when (if) you decide to Import your back-up, the importing process will drop any existing tables to replace them with the copy you are importing.
     

Share This Page