Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Backup database tables into seperate files

9:29 am on May 15, 2012 (gmt 0)

New User

5+ Year Member

joined:Sept 16, 2008
votes: 0

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 :)
4:00 pm on May 15, 2012 (gmt 0)

Senior Member

WebmasterWorld Senior Member rocknbil is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Nov 28, 2004
votes: 0

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.
7:16 pm on May 15, 2012 (gmt 0)

New User

5+ Year Member

joined:Sept 16, 2008
votes: 0

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
8:30 pm on May 28, 2012 (gmt 0)

Junior Member

10+ Year Member

joined:Jan 7, 2005
posts: 94
votes: 0


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.