How to backup a mySql database in Ubuntu?

Question: How to backup a mySql database in Ubuntu using the mysqldump utility?

Answer: 

1. Open a new Terminal Window.
2. Type in the following command:
   mysqldump -h localhost -u root -pPASSWORD database > backup.sql
3. This will backup the database to the file backup.sql
4. -h = Hostname
   -u = Username
   -p = Password, no space between the p and the password allowed

• Add New Search
• Comments

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.