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.

[dolelcy]

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-wutx]

Got some. Knowledge from your video thank you

[SameerKhan-juxz]

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

[kusumtod.]

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

[drivers_]

thanks, now if my website gets hacked i will recover

[mr.RAND]

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

[kamelbe]

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