Jump to content

Archived

This topic is now archived and is closed to further replies.

Horst Azeglio

MySQL table backup

Recommended Posts

Do you know a way to easily backup a MySQL database and/or table in PHP? I'm looking for something simmilar to what PHPMyAdmin does when it creates .SQL files. Thank you

Share this post


Link to post
Share on other sites
try this...

[a href=\"http://www.silisoftware.com/scripts/backupDB/backupDB.zip\" target=\"_blank\"]http://www.silisoftware.com/scripts/backupDB/backupDB.zip[/a]

info ( [a href=\"http://www.silisoftware.com/scripts/index.php?scriptname=backupDB\" target=\"_blank\"]http://www.silisoftware.com/scripts/index....ptname=backupDB[/a] )

it can do single DB's or a signle table in a DB.
Will save the data on server and can also email you a zip file of the DB...

Share this post


Link to post
Share on other sites
if you have access to the server command line, you can issue mysqldump to create .sql files, or mysqlhotcopy to quickly copy the MYI, MYD files to another location.
you can also try SELECT INTO LOAD FILE syntax, if you have the permission on the mysql side.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.