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.
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.
You'll also want to beware of capitalisation issues.