Question about Wordpress backup and "Add DROP TABLE"

Discussion in 'MySQL' started by MTbiker, Sep 28, 2007.

0
  1. #1
    Can anyone tell me why you check "Add DROP TABLE" in phpMyAdmin when backing up a Wordpress database? I've heard of the SQL command 'drop' a table, but I'm not sure how that applies in this case...

    Also, do you know if the WP DB Backup plugin creates as good of backup as just going through phpmyadmin?

    Thanks :)
     
    MTbiker, Sep 28, 2007 IP
  2. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #2
    Checking this checkbox adds the line at the top of the backup

    DROP TABLE IF EXISTS `tablename`;

    While importing, this automatically checks if a table exists.
    If it exists, it is deleted. This way you donot have to
    delete a table before importing.
     
    Kuldeep1952, Sep 30, 2007 IP
    MTbiker likes this.
  3. MTbiker

    MTbiker Well-Known Member

    Messages:
    2,536
    Likes Received:
    123
    Best Answers:
    0
    Trophy Points:
    170
    #3
    Thanks, now it all makes sense :)
     
    MTbiker, Oct 1, 2007 IP
  4. Bryce

    Bryce Peon

    Messages:
    1,235
    Likes Received:
    93
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I always recommend my hosting clients who are working with any MySQL databases to use the software Navicat to do your database backups, edits, etc.

    phpMyAdmin isnot the greatest method for working on a database.
     
    Bryce, Oct 1, 2007 IP
  5. Paul8368

    Paul8368 Well-Known Member

    Messages:
    614
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #5
    Sounds interesting so how do you link in with Navicat?

    Is it straightforward?
     
    Paul8368, Oct 2, 2007 IP
  6. kendo1979

    kendo1979 Peon

    Messages:
    208
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    what does navicat have that phpmyadmin dont?

    why is it better?
     
    kendo1979, Oct 2, 2007 IP
  7. Bluering Creative

    Bluering Creative Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Thanks guys, as someone who's migrating from Web Design to Web Development finding information explained in plain English makes the transition so much easier. What online resources would you recommend for an overview on MySQL & PHP?
     
    Bluering Creative, May 16, 2012 IP
  8. locke815

    locke815 Peon

    Messages:
    480
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #8
    I suggest you to look for a Total Managed WordPress Hosting management people. They will definitely be able to assist you.
     
    locke815, May 16, 2012 IP