No matter what I do I cannot restore my database!

[scotch33]

Hi,

I have a site that I am copying to another place.  I am running Canary on this site and have the database backup module installed.  having installed cmsms canary on the new place and added in all the appropriate modules etc, I have tried to restore the database from the old site into the new.  Despite the fact that permissions are correctly set, the module reports success in the restoraion and I then clear the cache, I cannot see the restored database pages in either the admin area (shows original pages) or the front end (the same).

Having asked about this and followed all instructions to the letter I am still having no luck.  Thus I have tried an experiment of mysql dumoing the old database into an sql file and then trying to run that in the new database.  This resulits in a blank frontpage on the new site - but I can at least see in the mysql admin that the database now contains the correct tables / fields. 

So my question is this - what is happening in the mysql dump restore that would make the new site blank?  this is getting increasingly frustrating - i can't see what I am doing wrong in either of the methods I am using to complete what I thought would be a relatively simple job. 

Thanks!

John

[Dr.CSS]

Database backup, made backup on original site, FTP to old site found backup.txt downloaded it to comp. FTP to new site uploaded backup.txt into backup folder went to new site backup module, Restore a Previous Backup Set found backup.txt in dropdown, WARNING!! RESTORING A DATASET WILL OVERWRITE ALL THE CURRENT DATABASE CONTENTS!! click Restore This Backup Set then clear cache...

Should be good to go, need to have all the same modules on both sites...

Did you do something diff.?

I've never used MYSQLDump just the backup module with no problems...