homepage Welcome to WebmasterWorld Guest from 54.226.173.169
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Backup database tables into seperate files
sj999




msg:4453656
 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 :)

 

rocknbil




msg:4453807
 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.

sj999




msg:4453873
 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

Marino




msg:4458742
 8:30 pm on May 28, 2012 (gmt 0)

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

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