mysql - Copy all the Database - Tables,Stored Procedures into a file and save on a flash disk -

is there way re-create database - tables,stored procedures file , save on flash disk?

i want able open anywhere.

also there anyway can pass permission while so?

if have mysql database name "mydatabase" backup have execute next code command line:

mysqldump -u root -p mydatabase > mydatabase.sql

and after set password

to restore on server, re-create mydatabase.sql , execute command line:

mysql -u root -p mydatabase < mydatabase.sql

mysql sql database ssms

Five