Yet another backup queston

[timgerr]

I am migrating a mysql database server from Fedora Core 1 to a Debian Sarge install. I need to get all the data + users and their database rights. I have been having problems just transferring the databases from 1 box to another, I think this might have to do with the different os's. What tool can migrate or at least backup everything without recreating the users and databases by hand.

Thanks,
Timgerr


-How important does a person have to be before they are considered assissinated instead of just murdered?

 

[Castor66]

mysqldump --quick --single-transaction --user=<admin-user> --password=<admin password> --opt > /homt/fullbackup

That should do the job for you.