SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot themissingelf's Avatar
    Join Date
    Nov 2001
    Location
    UK
    Posts
    165
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQLadmin - "Add 'Drop tables' in Export Options

    MySQLadmin export options includes a checkbox to "Add 'Drop tables'"

    Is this to add in a line to the export file that deletes the table if it happens to still exist after a crash etc?

    Should it be used for routine backups?

    Cheers

  2. #2
    SitePoint Member
    Join Date
    Jun 2004
    Location
    Sydney
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    if you tick the box add drop tables the script will have the statement

    DROP TABLE TABLENAME

    at the top of the script. This is to delete the table in case there is a table with that name in the database. I always tick the box when I make a backup...


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •