how to take mysql database backup using phpmyadmin and restore in another system code example Example: mysql dump restore mysql -u [user] -p [database_name] < [filename].sql