Mysql Database Backup Question

Home Forums Other Misc Mysql Database Backup Question

Viewing 1 post (of 1 total)
  • Author
    Posts
  • Avatar
    yaniv
    Member
    #110178

    Hi
    i need to backup my MYSQL DB

    i found the following at http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
    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?
    3.is there a switch to backup all DB’s? like “–alldatabases”?

    thanks

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.