homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Backup database tables into seperate files

 9:29 am on May 15, 2012 (gmt 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)

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)

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)


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.


Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved