Answers.Body: <p>I have only used CiviCRM at WPE on test sites.   </p>
  
  <p>You will have to share the same DB as WP.  </p>
  
  <p>You need to prepare teh backup for restore offline.   That said, I mean that if backed up from another server, the DEFINER (used in Triggers and Routines) have to be stripped out, and the database should be compressed.   You'll need to restore via phpmyadmin from my.wpengine.com</p>
  
  <p>A word of warning, WP Engine reserves the right to change the database user.   When they do this they will update wp-config.php, but not civicrm.settings.php.   This has not happened to me on CiviCRM (keep in mind I only use WPE for testing on CiviCRM) , but it has happened on WP sites I have supported at WPE.   </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-12-03T20:59:22.020Z
Answers.Text: Thank you, Kevin..... So I export my database from the current host and then I have to edit it to remove the DEFINER statement(s). What's the best tool/application for editing the .sql file? Will any text editor work?
  
  Thanks for the heads-up about the potential for a database user change! Of course, that only matters if I actually get things up and running on WPE.
Answers.UserDisplayName: kzburn
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-12-03T22:42:03.063Z
Answers.Text: we use the following perl script in case it helps your situation: perl -pi -e 's#\/\*\!5001[7|3].*?`[^\*]*\*\/##g'
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-12-03T20:23:57.100Z
Answers.LastActivityDate: 2018-12-03T20:23:57.100Z
Answers.UserDisplayName: Kevin Cristiano
Body: <p>I'm working on migrating our Wordpress site to WPEngine, and I don't know how to get the civi database onto WPEngine. WPEngine doesn't allow the creation of a new database for civi. Has anyone done this before? I have found other topics regarding WPEingine here, but for now I just want to get the database onto WPEngine.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-12-03T20:54:23.877Z
Comments.Text: I would do extensive testing of all your current civicrm uses and all possible future civicrm uses - you may run into a ton of issues. Any reason why you chose WPEngine? (besides that they are a great WP host?)
Comments.UserDisplayName: themak
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-12-03T21:11:06.283Z
Comments.Text: WPE was recommended to us and it looked great until now. We're actually moving to a new CRM so using civi on WPE would be temporary. I may want to rethink moving to WPE before changing the CRM because it may be more trouble than it's worth.
Comments.UserDisplayName: kzburn
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-12-03T22:28:01.467Z
Comments.Text: WPEngine is great for WordPress hosting. Thats not to say that there arent alternatives that are great too and would work fine with CiviCRM. If you are leaving CiviCRM - **tears** - you may want to consider making that transition first.
Comments.UserDisplayName: themak
Tags: <wordpress><migration>
Title: Migrating to WPEngine
ThreadText: # Migrating to WPEngine
  
  (Asked by: username_0 on 2018-12-03)
  
  I'm working on migrating our Wordpress site to WPEngine, and I don't know how to get the civi database onto WPEngine. WPEngine doesn't allow the creation of a new database for civi. Has anyone done this before? I have found other topics regarding WPEingine here, but for now I just want to get the database onto WPEngine.
  
  **Tags:** wordpress, migration
  
  > **Comments:**
  > **username_1**: I would do extensive testing of all your current civicrm uses and all possible future civicrm uses - you may run into a ton of issues. Any reason why you chose WPEngine? (besides that they are a great WP host?)  
  > **username_0**: WPE was recommended to us and it looked great until now. We're actually moving to a new CRM so using civi on WPE would be temporary. I may want to rethink moving to WPE before changing the CRM because it may be more trouble than it's worth.  
  > **username_1**: WPEngine is great for WordPress hosting. Thats not to say that there arent alternatives that are great too and would work fine with CiviCRM. If you are leaving CiviCRM - **tears** - you may want to consider making that transition first.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2018-12-03. Score: 1
  
  I have only used CiviCRM at WPE on test sites.
  
  You will have to share the same DB as WP.
  
  You need to prepare teh backup for restore offline. That said, I mean that if backed up from another server, the DEFINER (used in Triggers and Routines) have to be stripped out, and the database should be compressed. You'll need to restore via phpmyadmin from my.wpengine.com
  
  A word of warning, WP Engine reserves the right to change the database user. When they do this they will update wp-config.php, but not civicrm.settings.php. This has not happened to me on CiviCRM (keep in mind I only use WPE for testing on CiviCRM) , but it has happened on WP sites I have supported at WPE.
  
  > **Comments:**
  > **username_0**: Thank you, username_2..... So I export my database from the current host and then I have to edit it to remove the DEFINER statement(s). What's the best tool/application for editing the .sql file? Will any text editor work?  Thanks for the heads-up about the potential for a database user change! Of course, that only matters if I actually get things up and running on WPE.  
  > **username_3**: we use the following perl script in case it helps your situation: perl -pi -e 's#\/\*\!5001[7|3].*?`[^\*]*\*\/##g'  
  
  ---
  
  