Restoring MySQL
I have a mysql.sql dump file taken from /var/lib/mysql (on a RedHat 9 server with MySQL 4.x).Peeking in the mysql.sql file confirms it contains all the info on usernames and passwords.
What I want to know is if I restore this dump file using:
mysql -uUSERNAME -pPASSWORD mysql < /path/to/mysql.sql
will this recreate the usernames and passwords etc without damaging anything? Then I can go ahead and restore individual databases using the same idea on the individual sql dump files?
Just don't want to mess anything up...