Topic: 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!