For those who looking for way to backup mysql database,
you can use mysqldump to backup mysql database.
Below is the script example to backup mysql database in command line:-
$ mysqldump -h localhost -u username -p database_name > backup_db.sql
If your mysql database is very big, you might want to compress your sql file.
Just use the mysql backup command below and pipe the output to gzip,
then you will get the output as gzip file.
$ mysqldump -u username -h localhost -p database_name | gzip -9 > backup_db.sql.gz
If you want to extract the .gz file, use the command below:-
$ gunzip backup_db.sql.gz
Very good! I’ll use it in my backup script:
#create (if not exist) backup folder
mkdir -p /home/aus/project_bak
cd /home/aus/project_bak
# backup the project software
tar cvf $(date +%Y-%0m-%0d_%0H%0M.CPP.bak.tar) /home/aus/Project
# backup the web application
tar cvf $(date +%Y-%0m-%0d_%0H%0M.WEB.bak.tar) /var/www
# Thanks to Techie Corner, back up the database
mysqldump -hlocalhost -uroot -proot users > $(date +%Y-%0m-%0d_%0H%0M.sql)
what kind of ass says not helpful? geeks. I liked this and was helpful.
obvious but still helpful, thanks
works for me … thank you …
Thanks bro!
well, im using mysql query browser, and i want to update fields and tables, so.. how can i back up my old field contents?? i dont want to retype them
well, im using mysql query browser, and i want to update fields and tables, so.. how can i back up my old field contents?? i dont want to retype them
was helpful
not helpful at all!