Backup of mysql database using terminal
By Jessica Wood •
I have use Ubuntu 14.04, in mysql, not able to login through phpmyadmin. So, i need to backup mysql database. How can i do this. any one help for this issues.
advanced thanks.
By Udaya Kumar-PHP
11 Answer
That is easily done by going to a terminal window by pressing Ctrl+Alt+T and typing:
For a single database:
mysqldump -u szUserName -p szDatabaseName > /path/to/fileFor multiple databases:
mysqldump -u szUserName -p --databases szDatabaseName1 szDatabaseName2 szDatabaseName3 > /path/to/file For all databases:
mysqldump -u szUserName -p --all-databases > /path/to/file Where szUserName is obviously your username, szDatabaseName1 is *your database name and /path/to/file is the path to the export file E.G. ./dump/db_backup.sql
More in general
"Zoraya ter Beek, age 29, just died by assisted suicide in the Netherlands. She was physically healthy, but psychologically depressed. It's an abomination that an entire society would actively facilitate, even encourage, someone ending their own life because they had no hope. Th…"
