Backup MySQL Database - Use SQL and PHPMyAdmin to backup and restore a database

In this MySQL database tutorial I show you how to make a backup of a database and restore the database using both PHPMyAdmin and SQL

[@MattCurney]

this is my favorite accent for learning anything.

[@wisdomcube7789]

Thank you bro, i badly need this...

[@user-do9le6lc8y]

Anybody having trouble importing their exported db can follow these steps.
In the 'Export Tab'
Choose from Export method:
1. Custom - display all possible options
2. Format: SQL
Output:
3. In Compression - choose the option zipped
Then click go.

[@amitsingh-wu9tx]

Got some. Knowledge from your video thank you

[@SameerKhan-ju1xz]

How to do this on another host? Because you can't rename it,, initial values are auto selected while generating new database...

[@kusumtod.9198]

May I know why i cannot run the command at my XAMPP Shell?

[@francoisjunior.]

Thanks it's easy to save

[@drivers_1]

thanks, now if my website gets hacked i will recover

[@mr.RAND5584]

The auto increment is not included if i export a database using phpmyadmin. Why is that? Makes me headache.

[@kamelbe9132]

is there an easier way to do this for multiple databases ?

[@jazibyt555]

Thanks

[@ari802002]

thanks