MySql backup and restore large database quickest way

Notice: A non well formed numeric value encountered in /customers/b/b/d/puddinq.com/httpd.www/wp-content/plugins/crayon-syntax-highlighter/crayon_formatter.class.php on line 118Notice: A non well formed numeric value encountered in /customers/b/b/d/puddinq.com/httpd.www/wp-content/plugins/crayon-syntax-highlighter/crayon_formatter.class.php on line 119Notice: A non well formed numeric value encountered in /customers/b/b/d/puddinq.com/httpd.www/wp-content/plugins/crayon-syntax-highlighter/crayon_formatter.class.php on line 118Notice: A non well formed numeric value encountered in /customers/b/b/d/puddinq.com/httpd.www/wp-content/plugins/crayon-syntax-highlighter/crayon_formatter.class.php on line 119

Backing up MySql databases can be a horror, phpMyAdmin does not handle large databases well and it takes for ever..

Backing up

 

Restoring