I would like to change a Magento website, but before I do that I would like to create a local copy (not online) to make some changes without doing any mistakes, see the results (as a perfect copy of the real website). If in case, I would be satisfied with these changes, I would like to add them to the website in real-time. The company who developed it is no longer in contact with me. Is it possible to create a test version of the website? Someone did it before in an easy way?
I tried to transfer my website from remote to my local server but I found a lot of problems and errors on importing a sql 100MB db on phpmyadmin using the comand line 'mysql -u root -p test < mysqldatabase.sql' on command prompt. There is an easier solution instead to move the Magento website on the local server?