HI, can you advise if it is possible to run multiple instances of HeidiSQL on the same server. I have a backup of a database that was created in a different instance which had a different root password. What I would like to do is to be able to load the older backup to a new instance but I do not seem to be able to do this unless the new instance is created using the same root credentials as the old instance. Hope hat makes sense?
OR, is it possible to load the old backup to a new instance of HeidiSQL and still access the old backup somehow? I tried restoring the SQL file to a new instance but it doesn't appear to work, the database appears to be empty?