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