Tag Info

New answers tagged


The only way you could mysqldump a mysql system database from one MySQL instance into another without any issues is if the major versions of MySQL are the same. You can mysqldump MySQL 5.0.x systems tables and load into MySQL 5.0.x You can mysqldump MySQL 5.1.x systems tables and load into MySQL 5.1.x You can mysqldump MySQL 5.5.x systems tables and load ...


You could use the -r flag to tar to append a file to an existing archive. Since it's legal to append to an empty or non-existent archive, you could modify the looped instruction to be something like $MYSQLDUMP --force --opt --user=$MYSQL_USER -p$MYSQL_PASSWORD --databases $db > "$BACKUP_DIR/mysql/$db" tar rvf /path/to/tar.file "$BACKUP_DIR/mysql/$db" ...

Top 50 recent answers are included