On 10/25/06, Jonathan Horne <[EMAIL PROTECTED]> wrote:
typical OT thread apologies, but the truth *really* is that this is the best and most intelligent list i read. so... i use veritas netbackup 5.1 to backup my bsd machines, and i would like to restore some mysql databases onto another machine. is restoring any mysql database, as simple as reloading the database directories in /var/db/mysql? do i need to create the blank database first, then do it? i do know how to import a .sql database dump, i was just wondering if i can do it via a restore job from netbackup. any opinions i can get, are greatly appreciated. i'm not a mysql guru but backing up and restoring a mysql database is just
like riding a bike, it's that easy :D to backup a mysql database: $ mysqldump -u user -p --opt databasename > database.bak.sql to restore a database from the backup: $ mysql -u user -p database < database.bak.sql just make sure user has privileges to do the necessary commands, if not you can use the root user of mysql. you can also use a gui tool like phpmyadmin for managing mysql. cheers _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
