Announcement

Collapse
No announcement yet.

phpMyAdmin DB backup - settings

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • phpMyAdmin DB backup - settings

    im changing hosts, have a small DB. I know how to export but there are so many settings i can choose from. Can someone select the most optimal settings... and i cant use SSH, that's one of the reasons im changing hosts...

    database is very small so i wont have a timeout problems

    thanks

  • #2
    The default export settings should be fine. Just make sure you get both structure and data, as well as the autoincrement values.

    Comment


    • #3
      should i use compression when saving? under structure do i select ADD DROP TABLE, ADD IF NOT EXISTS??

      Comment


      • #4
        Compression doesn't matter. Just uncompress it afterwards.

        The DROP TABLE options don't matter if you are restoring to an empty database. The same goes for IF NOT EXISTS. I recommend an empty destination database anyways.

        Comment


        • #5
          is it possible to restore in an empty database using phpmyadmin? if so you know how?

          thanks

          Comment


          • #6
            Yes. Click the Import tab in phpmyadmin.

            Comment

            Loading...
            Working...
            X