Method 1 - SFTP Only
Step One - Grabbing a copy of your database
- contacting your current host provider's support staff
- Hosts dashboard (CPanel in many cases)
- If you are unsure, it is best to contact your host's support team to find out what options are available for you to export the sql file. If Pagely has migrated a few of your applications already, we may know where to loo as well.
Step Two - connect to your host provider
Step Three - connect to your Pagely server
Method 2 - CLI (Command Line Interface)This is the more advanced option, and will require some command line interface knowledge to successfully undertake. Dot your i's and cross your T's on this one.
Step One - grabbing a copy of your database
Option 1: WP-CLI - Most host providers utilize WP-CLI, or WordPress Command line interface this is by far the easiest option as a simple method to grab a copy of your database is to run the following command in your webroot directory...
This will create a sql file, which contains a copy of your database.
Option 2: MySQL cli - An alternative to this that's often available is MySQL CLI the following command can be utilized in your host's webroot...
The suggested command to run may vary depending on your host provider. Please contact them to be certain you export the file properly.
BE ADVISED: You should NEVER leave a copy of your sql file in your webroot directory. this is a dangerous practice that we even scold ourselves for doing. Please clean up after yourself for your own security.
Step Two - transferring files over.
This will require knowledge of rsync, or some similar transfer utility command line tool to complete this task. Check "HowTo Use rsync For Transferring Files Under Linux or UNIX" for more information.
You'll also need to set up SSH access at Pagely. The following Pagely Article: Setting up SSH access for your new VPS Account will help.
You can also review our video for a visual a more visual tutorial...
Please note that Pagely handles WordPress core files. As such, the only directory that MUST be transferred over is the wp-content folder.
Please also note your SQL file should NEVER remain in your public directory. We're repeating this with good reason. To be doubly cautious, transfer your sql file one directory above in...
Step Three - importing your database
If you are temporarily leaving your sql file in...
Which is your webroot directory, you can simply run the following command...
wp db import db.sql
and your file will be imported. If you had placed your sql file in...
Then run the following command.
wp db import --path=/Sites/
and you're done!
Method 3 Hire help
Hire a Professional to help. We recommend using the following agencies: