10up / MU-Migration

This WP-CLI plugin makes the process of moving sites from single WordPress sites to a Multisite instance (or vice-versa) much easier. It exports everything into a zip package which can be used to automatically import it within the desired Multisite installation.
MIT License
329 stars 47 forks source link

Error establishing a database connection #69

Closed derekPrivate closed 4 years ago

derekPrivate commented 4 years ago

Just trying this tool for the first time. I have successfully exported my multi-site Wordpress to a zip file. I have copied the zip file to a (completely) new Wordpress installation. I run the command

wp mu-migration import all site.zip --new_url=dev.xxxxxxxx.com/wordpress --path=/var/public/sites/wordpress

and get the message Error establishing a database connection

Any ideas how I can investigate the issue? I have checked usernames etc using phpMyAdmin

nicholasio commented 4 years ago

Does the site work properly outside of MU-Migration? This seems to be an issue within your database connection since MU-Migration does not handle connections to the database directly.

derekPrivate commented 4 years ago

Yes - it is a brand-new site (clean install. wp setup) and I can connect to the server with my browser - the site just has the default content.

-- Derek

On 27 Nov 2019, at 11:42, Nícholas André notifications@github.com wrote:

Does the site work properly outside of MU-Migration? This seems to be an issue within your database connection since MU-Migration does not handle connections to the database directly.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/10up/MU-Migration/issues/69?email_source=notifications&email_token=ABU4OWHS5LVGO3XCOFKJK7LQVZMKHA5CNFSM4JSFCQVKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEFJHSAA#issuecomment-559053056, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABU4OWDZRLER4IEXWBOCXFDQVZMKHANCNFSM4JSFCQVA.

derekPrivate commented 4 years ago

P.S.

To confirm the connection, I just added this to a file and then opened with the browser and received “Connected successfully”

<?php $link = mysqli_connect('localhost', 'root', 'root'); if (!$link) { die('Could not connect: ' . mysqli_error()); } echo 'Connected successfully'; mysqli_close($link); ?>

-- Derek

On 27 Nov 2019, at 11:42, Nícholas André notifications@github.com wrote:

Does the site work properly outside of MU-Migration? This seems to be an issue within your database connection since MU-Migration does not handle connections to the database directly.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/10up/MU-Migration/issues/69?email_source=notifications&email_token=ABU4OWHS5LVGO3XCOFKJK7LQVZMKHA5CNFSM4JSFCQVKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEFJHSAA#issuecomment-559053056, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABU4OWDZRLER4IEXWBOCXFDQVZMKHANCNFSM4JSFCQVA.

derekPrivate commented 4 years ago

OK, I eventually found the issue. I was having the same problem with wp core update and tracked it down (eventually!) to using the native php instead of the one supplied with MAMP.

Thanks for your help.