our approach|new tutorials|contact us

MySQL Basics In Pictures

• Starting
• Administration
• Tables
• Queries
• Security
• Web

• us_presidents

  mysqldump -u root -p us_presidents > ./backups/us_presidents.sql

  us_presidents is the name of the database you want to back up.

• >

  mysqldump -u root -p us_presidents > ./backups/us_presidents.sql

  The > character is called a "pipe," and is a Linux command. Pipe is an apt name for what > does: it pipes, or places, the information provided by mysqldump into a file.

• ./backups/

  mysqldump -u root -p us_presidents > ./backups/us_presidents.sql

  ./backups/ is the directory path to us_presidents.sql.

  TIP: The period in front of the slash (./) represents the current directory you are working in.

• us_presidents.sql

  mysqldump -u root -p us_presidents > ./backups/us_presidents.sql

  us_presidents.sql is the name of the file you're piping the backup to.