Export Multiple, Individual Databases?

[TechMistress]

Hi all, I'm hoping there's an answer to this!

 

I would like to export all of my databases. In phpMyAdmin, I selected the export, then chose all of the databases and of course then chose the standard filename structure.

 

It exported them all in one big file. Is there a way to export them all at once, but as individual .sql files (without doing it one by one).

 

Thanks!

[jskywalker]

i dont think phpMyAdmin can do this..

 

but

 

<?php
  echo exec('mysqldump db1 >db1.sql');
  echo exec('mysqldump db2 >db2.sql');
?>

 

might do what you want (maybe you have to add username/passwords)

[TechMistress]

thank you, I was able to write a script to do it with your help and using mysql dump!