Mysql Database Backup Question

Home Forums Other Misc Mysql Database Backup Question

Viewing 1 post (of 1 total)
  • Author
  • Avatar

    i need to backup my MYSQL DB

    i found the following at
    but i dont realy understand it.

    Example: mysqldump –add-drop-table -u dbuser -pPW DBNAME > /tmp/examp-back.sql

    1. what is “–add-drop-table”? what does it do? do i need it?
    2. is it possible to just stop the DB and then copy the MYSQL DB folder? and how is the restore if i just copy? there a switch to backup all DB’s? like “–alldatabases”?


Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.