Normally, a MySQL database can be exported and imported using these simple SSH commands:
Export:
mysqldump -u USERNAME -p DATABASE_NAME > filename.sql
Import:
mysql -u USERNAME -p DATABASE_NAME < filename.sql
But it's not that simple when it comes to WordPress. From what I see, additional parameters need to mentioned, such as --add-drop-table
for instance.
The WordPress Codex does provide some info, but it looks cluttered and not clear enough.
It would be great if someone who uses command-line can share the proper commands to export and import a WordPress database, with some explanation (of any new parameters used).
Also, are there any reasons why it wouldn't be advisable to use command-line when dealing with database, and instead go with a GUI like phpMyAdmin?