Quote:
Originally Posted by Peter Shepard
I have an old filesystem on an external hd that I was using as a mysl database I have since installed a new distro and would like to reload my old mysql files into a new mysql database?
Any ideas?
TIA
|
if your "old mysql files" were generated by mysqldump, it's simply a matter of creating a database with the same name on the new machine, then:
mysql -uuser -ppass db_bname < saved_file.sql
If your "old mysql files" are the actual filesystem in your mysql directory, then you can simply copy the directories you want (databases you want) into the mysql directory "var" on the new machine.