Welcome to WebmasterWorld Guest from 54.146.171.44

Forum Moderators: open

Message Too Old, No Replies

Backup database tables into seperate files

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

5+ Year Member



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)

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



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)

5+ Year Member



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)

10+ Year Member



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