http://www.wallpaperama.com/forums/how-to-backup-and-restore-entire-whole-mysql-database-linux-shell-command-t730.html Subscribe and keep up to date with How To Backup And Restore Entire Whole MYSQL Database Linux Shell Command with the latest replies and comments from other people like you who are interested in How To Backup And Restore Entire Whole MYSQL Database Linux Shell Command at wallpaperama.com en http://www.wallpaperama.com/forums/how-to-backup-and-restore-entire-whole-mysql-database-linux-shell-command-t730.html today i wanted to backup a database but i had no idead had to backup and restore it again. I was moving a mysql database from one server to another. a customer was moving their server from another carrier to www.webune.com they had a dedicated server but wanted all the database also migrated. Linux make this task very simple. so today i will show you on this little tutorial on how to backup and then restored a database from a tarball gzip file. or zip file. ok so here we go. make sure you know the old and the new server's root mysql password <a href="http://www.wallpaperama.com/forums/how-to-backup-and-restore-entire-whole-mysql-database-linux-shell-command-t730.html">..... Read More </a> http://www.wallpaperama.com/forums/how-to-backup-and-restore-entire-whole-mysql-database-linux-shell-command-t730.html Fri, 02 Jan 2009 00:24:52 -0700 if you want to backup all the databases in one file, this is the command you would use: mysqldump --opt -u root -p --all-databases | gzip > all_databases_2_27_2007.sql.gz Enter Password: http://www.wallpaperama.com/forums/how-to-backup-and-restore-entire-whole-mysql-database-linux-shell-command-t730.html#632 http://www.wallpaperama.com/forums/how-to-backup-and-restore-entire-whole-mysql-database-linux-shell-command-t730.html#632