Back Up Prior To Reinstall

[EvilAsh]

Hi all.

I am preparing to install a new test server on my Windows XP machine using XAMPP, to upgrade from the very old PHPTRIAD version I put on years ago.

I have copied HTDocs to an external hard drive but was wondering if there is a way I could transfer the 40-50 databases I have in MYSQL without having to save them and reinstall them individually?

Thank you for any help you can offer.

 

[hvass]

Probably depends how old the version of mysql in PHPTRIAD and your use of storage engine. You may well get away with simply copying the physical database files from your datadir.

In addition MYISAM files are bit level independent so for example you can just take the directory structure datadir=/somediretory/ off a Linux box and simply copy it to another operating system say windows.