[solved] Migrate from Win2003 to Win2008

[oneDot]

Migrate from Win2003 to Win2008

I would like to migrate cacti from win2k3 to win2k8.
I transformed files with mysqldump, dump rrd files and with copy cacti directory excluding rra folder.

When I login at http://localhost/cacti/host.php, I do not see any Devices and Data Sources.

Any suggestions why?

Tnx for help.

WIN2003 R2 SP2
Cacti Version 0.8.7g
Cacti OS win32
SNMP Version NET-SNMP version: 5.4.2.1
RRDTool Version RRDTool 1.2.x

WIN2008 R2 SP1
Cacti Version 0.8.8a
Cacti OS win32
SNMP Version NET-SNMP version: 5.5
RRDTool Version RRDTool 1.4.x


win2003:
mysqldump -l --add-drop-table cacti --user **** --password=****** --dump-date > mysql-add-drop-table.cacti

rrd -> xml
for /R C:\Inetpub\wwwroot\cacti\rra %%f IN (*.rrd) DO C:\rrdtool\rrdtool dump %%f > %%~nf.xml

Copy the Cacti directory and subdirectories, excluding the RRA folder and files from 2003 to 2008.

win2008:
mysqldump -l --add-drop-table cacti --user **** --password=****** --dump-date < mysql-add-drop-table.cacti

xml -> rrd
for /R C:\Inetpub\wwwroot\cacti\rra %%f IN (*.xml) DO C:\rrdtool\rrdtool restore %%f %%~nf.rrd

[BSOD2600]

Try:
mysqladmin --user=root --password create cacti
mysql --user=root --password cacti < mysql-add-drop-table.cacti

[oneDot]

it works! tnx again.


C:\inetpub\wwwroot\cacti>mysqladmin --user=root --password create cacti
Enter password: *****
mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'cacti'; database exists'

C:\inetpub\wwwroot\cacti>mysql --user=root --password cacti < mysql-add-drop-table.cacti
Enter password: *****

C:\inetpub\wwwroot\cacti>