Download WP SQL¶
The database for my WP installation is provided by MariaDB. In order to download the data from the database I ran this:
ubuntu@ip-172-31-32-80:~$ mysqldump -u steve-wp -p wp > x1.sql
Enter password:
ubuntu@ip-172-31-32-80:~$ less x1.sql
The file created by running mysqldump
contains all the necessary SQL statements to recreate the SQL database.