How To mysqldump

By far the easiest and best way to migrate a Drupal site is with the back up and migrate module.
 
However the module can't work with large databases.
 
Plus there are various other situations you will be found in which you can use the module.
 
It is key to remember our basics.
 
The good old mysqldump command can save the day.
 
 
 
mysqldump -u root -p DBname > newfile.sql