Best Practice to Export and Import Drupal Website?

Can you clarify the dump process?

Can I do this via phpMyAdmin. I have more experience with GUI than using MySQL command line.

But I can do whichever is best practice. With command line, I need specific steps.

Thanks

You can with PhpMyAdmin but best to do it with mysqldump as follows

mysqldump

backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

Select allOpen in new window

To restore you can use PhpMyAdmin as well or you can do it on the command line by logging in to MySQL and using source

mysql -u root -p[root_password] [database_name] 
use DATABASENAME;
source dumpfilename.sql

Select allOpen in new window

You can do it in one command like so

mysql -u root -p[root_password] [database_name] < dumpfilename.sql

Select allOpen in new window

But then you need to make sure that dumpfilename.sql has a USE database statement for the target database if it exists already otherwise a create database and use database if it does not.

PhPmyAdmin - will depend on your server setup (hosted) as to what functions are available.

You can also look at tools like SQLYog which if you have direct access to the database is far superior to PHPMyAdmin.