Forum
export database to LOCAL server
I deployed my website to my liveserver (i am learning perch and it was a test). All worked fine. But now, i edited some pages and i want to export the live server's database to have the content locally.
So i exported the database and uploaded it in my local server. But then i can't log in (i checked the config file several times and it's ok).
What is the process to inverse the migration to live server, i mean to import the database locally the right way ?
What message do you get when you try to log in?
"Sorry, those details are incorrect. Please try again."
I don't understand. I am using the right user and password, but obviously not...
Was the database empty before you imported?
yes, it was, i deleted the legacy one and created a new one. (if i try to update the existing database with the SQL file it throws an error "#1062 - Duplicate entry '1' for key 'PRIMARY' ")
Maybe it's an issue with the export of my livehost ?
Do you see any users in your local
perch2_users
table?Yes, i have the user in the table...
Can you add the following to your
perch/config/config.php
file and let me know what it outputs after submitting the login form?