Is there any way to backup/dump/export all the databases in one step and vice-versa (import all databases into MySQL) in MySQL ? If yes, then how I can do this..?
However, I came across this: https://www.servage.net/wiki/Create_MySQL_dumps_with_PHP
Haven't tried it.
Also PDO (and I think mysqli) can run multiple queries. SO you may be able to fiddle something with that.
dear in one step i think it is not possible. you can google it
i would suggest you that just go to database and export files or backup it to your email. or you can just ask your hosting company for it.
You have to download every database. This can be easily done using PHP-MY-ADMIN.
If you use
mysqldump, then you can use the
--all-databases parameter. Note that you should use a user which has access to them all.
You can use mysqldump option, then you can use --all-databases parameter.
For more information refer the following link :