To everyone: I want to ask how to back up the databse in MYSQL. How to convert the database into text format. Like .sql. microsoft excel etc thanks
The easiest way I guess if you're using cpanel goto backup then back the db.. or you can do it in your hosting phpadmin export....
Here's the script I run to backup all of my MySQL databases: #!/bin/sh date=`date -I` mysqldump --all-databases -p | gzip > backup-$date.sql.gz Code (markup):