Local Community

Push local database to wpengine staging

I imported my staging site from wp engine to localhost with Local. worked great.

when i attempt to push my localhost to wp engine and include database, the files gets updated but there are no changes to remote wpe database. I’m not getting any errors either.

I had to export the sql, find-and-replace the domains and import to wpe with phpmyadmin.

Are some additional steps i need to set up database pushes? (v6.5.1)

Hi there, @fatlinesofcode - welcome to the Local community! :wave:

Thank you for your question, have you had a chance to review this Troubleshooting guide for Local Connect + WP Engine?

Let me know!

Sam

hi @sammunoz thanks for the reply. I’ve removed the credentials, recreated and reconnected via Local. The same issue persists. Files are updated, wpengine backup is created, database is not updated.

Are there any logs available with Local to see where its failing ?

Hi there @fatlinesofcode -

Yes, you can obtain Local logs by following this Help doc:

You can feel free to drop that Local file and we can see if we can figure it out together!

Sam

thanks @sammunoz here is log from loca-lightning-verbose.log

{"thread":"main","class":"CAPIService","message":"Creating backup for install 93edddc9-938e-4eed-bded-8a245816a40e","level":"info","timestamp":"2022-11-22T21:46:01.794Z"}
{"thread":"main","service":{},"serviceBinVersion":{},"message":"Database responded to ping.","level":"debug","timestamp":"2022-11-22T21:46:03.053Z"}
{"thread":"main","service":{},"serviceBinVersion":{},"message":"Database responded to ping.","level":"debug","timestamp":"2022-11-22T21:46:03.053Z"}
{"thread":"main","class":"DevKitService","message":"PHP Warning:  Use of undefined constant E_WARNINGS - assumed 'E_WARNINGS' (this will throw an Error in a future version of PHP) in phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(1296) : eval()'d code on line 120\nPHP Warning:  A non-numeric value encountered in phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/WP_CLI/Runner.php(1296) : eval()'d code on line 120\n","level":"warn","timestamp":"2022-11-22T21:46:22.943Z"}
{"thread":"main","class":"DevKitService","message":"PHP Notice:  Trying to access array offset on value of type null in /sites/[CLIENT]/wp-content/plugins/svg-support/functions/mime-types.php on line 22\n","level":"warn","timestamp":"2022-11-22T21:46:28.912Z"}
{"thread":"main","class":"DevKitService","level":"info","message":"\nNotice: Trying to access array offset on value of type null in /sites/[CLIENT]/wp-content/plugins/svg-support/functions/mime-types.php on line 22\nhttps://[CLIENT].wpengine.com\n","timestamp":"2022-11-22T21:46:29.768Z"}
{"thread":"main","class":"DevKitService","level":"info","message":"\u001b[1;31m\rError: \u001b[0mRemote siteurl is not a valid URL.\n","timestamp":"2022-11-22T21:46:29.829Z"}
{"thread":"main","class":"DevKitService","message":"attempting to read the remote table prefix","level":"info","timestamp":"2022-11-22T21:46:29.831Z"}
{"thread":"main","class":"DevKitService","level":"info","message":"wp_\n","timestamp":"2022-11-22T21:46:41.908Z"}
{"thread":"main","class":"CAPIService","message":"Flushing cdn cache for install 93edddc9-938e-4eed-bded-8a245816a40e","level":"info","timestamp":"2022-11-22T21:46:41.922Z"}
{"thread":"main","class":"CAPIService","message":"Flushing object cache for install 93edddc9-938e-4eed-bded-8a245816a40e","level":"info","timestamp":"2022-11-22T21:46:41.922Z"}
{"thread":"main","class":"CAPIService","message":"Flushing page cache for install 93edddc9-938e-4eed-bded-8a245816a40e","level":"info","timestamp":"2022-11-22T21:46:41.923Z"}
{"thread":"main","service":{},"serviceBinVersion":{},"message":"Database responded to ping.","level":"debug","timestamp":"2022-11-22T21:46:43.053Z"}