Mysql Database Backup Question Share on Facebook Post on reddit Tweet on Twitter Share on LinkedIn Home › Forums › Other › Misc › Mysql Database Backup Question This topic has 0 replies, 1 voice, and was last updated 14 years, 8 months ago by yaniv. Viewing 1 post (of 1 total) Author Posts yanivMember Feb 16, 2006 at 3:37 am #110978 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 Author Posts Viewing 1 post (of 1 total) You must be logged in to reply to this topic.