Forum

Thread tagged as: Question, Configuration, Hosting

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 ?

DEVAUX Nicolas

DEVAUX Nicolas 0 points

  • 7 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

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...

Drew McLellan

Drew McLellan 2638 points
Perch Support

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 ?

Drew McLellan

Drew McLellan 2638 points
Perch Support

Do you see any users in your local perch2_users table?

Yes, i have the user in the table...

Drew McLellan

Drew McLellan 2638 points
Perch Support

Can you add the following to your perch/config/config.php file and let me know what it outputs after submitting the login form?

define('PERCH_DEBUG', true);