Backup database tables into seperate files

[sj999]

Hi, rather than a whole mysql database backup, I want to backup each table seperately into its own file (easier to import if need be).

Does anyone know firstly how to do this from phpmyadmin? Or if not, any other easy way to do it (ie script or program). I dont know how to run command lines etc yet.

Have had a quick search but no luck, as I don't really know what Im looking for :)

Would be very much appreciated...thanks SJ :)

[rocknbil]

From phpMyAdmin, if you navigate to the table and use export, it **should** just export that table (untested.)

Though I've never tried it, you might be able to use the -tables [dev.mysql.com] option to dump specific tables using mysqldump.

[sj999]

Hi thanks rocknbil :)

Sorry should have said, I do know how to backup the tables one by one manually by going into each table and clicking export, that works, but I have alot of tables and many databases... So wondered if there was a more "automated" way of backing up the tables seperately for each database... either via phpmyadmin or a script/program ...

Cheers SJ

[Marino]

Hello,

There is a away using PHP/mysqldump. See this page of mine: [markup.fr...] It's written in french, but the script is plain PHP.

Feel free to ask if needed.

Marino