MySQL Server

Backing Up MySQL

  • Great article on this topic by Vinu Thomas over at devshed.
  • The basic command is mysqldump -u username -p databasename > nameofbackup.sql
    • Note you could enter your password after -p but it is better security wise to allow mysql to prompt you to enter the password (which it will do with the -p switch).
    • An example using this syntax might look like: mysqldump -u sql_john -p forfundb > mybackup.sql