DB from Live not importing on local machine

Permalink
Hi

I have built a website online and I am trying to move the files and DB back to my local machine to do some more work.

I have tried to link my local Concrete5 version directly to the DB on my hosting, but it does not work, so, I downloaded the live DB and tried to upload it to MySQL.

When I create a new database and try and import the file I get the attached error.

I am using the latest concrete 5 version and using PHP 7.1.12. I use MAMP to set up the databases and host my files. I have attached the PHP MyAdmin details too.

On the live site, the PHP MyAdmin is using 4.9.5, whereas mine is using 4.7.7 so I am not sure if the difference in versions may be the issue.

2 Attachments

moonshark
 
Gondwana replied on at Permalink Reply
Gondwana
database does not appear to have been empty.
You'll also want to beware of capitalisation issues.
moonshark replied on at Permalink Reply
moonshark
Hi, I tried numerous times with a brand new database and imported the dB in, but it says the same error.

How do you mean capitalization issues? Would I need to edit the file? If so, do you know what I would need to do?