frankd
11/22/2017 - 10:57 AM

Export Wordpress Database using WP-CLI

export-wordpress-database.md
content_copyfile_download
  • Rendered
  • Source

EXPORT WORDPRESS DABATABE

SSH INTO SERVER
$ ssh www-data@{IP ADDRESS HERE}
- Are you sure you want to continue connecting (yes/no)? yes 
www-data@178.79.163.166's password:
CD INTO WEBSITE REPO
$ www-data@1minus1:~$ ls 
    html mod_cloudflare
other-examples
$ www-data@1minus1:~$ cd html/

$ www-data@1minus1:~/html
RUN DB EXPORT USING WP-CLI
wp db export db.sql
www-data@1minus1:~/html$ exit
logout
DOWNLOAD DATABASE VIA SFTP (FILEZILLA), or run:
$ www-data@139.162.239.177: /var/www/html/db.sql ~/Desktop
DELETE DB FILE
rm db.sql