Web Server Move

[rraehal]

I have a Windows 2000 Server running IIS 5. I use PHP 4 and MySQL. The server is a fairly old PC - P2 450 with 128 MB Ram. (It was the only available when we wanted to set upo the webserver.) Our corporate freeze on purchases has been lifted and we are going to replace the computer with a newer system.

My question is this:
After I install all of the software I need for the web server to work, can I simply copy the MySQL data bases and web files to the same directory structure and have the website work or do I need to backup and restore each database?

[rsfnatik]

You could look into mysqldump/mysqlimport scripts... you can find the MySQL documentation here (http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Disaster _Prevention).

There's the mysqlhotcopy but it's a *NIX script only...

[rraehal]

That is what I thought. I have never dumped multiple databases before. We have at least 3 SQL databases right now. One for a company forum, one for a calendar software, and one for a contacts management php program. The program is gone but not the database. We also have all of the default MySQL databases with the users. This could be interesting for me.

Thanks for the tip. I do not have the documentation here locally.

[ubes]

You could also create export files with PHPMyAdmin, a database management system for MySQL written in PHP.

can be found at: http://www.phpmyadmin.net/home_page/