Horst Azeglio Posted May 15, 2006 Share Posted May 15, 2006 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 Quote Link to comment Share on other sites More sharing options...
ikmyer Posted May 15, 2006 Share Posted May 15, 2006 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... Quote Link to comment Share on other sites More sharing options...
ryanlwh Posted May 15, 2006 Share Posted May 15, 2006 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. Quote Link to comment Share on other sites More sharing options...
Horst Azeglio Posted May 15, 2006 Author Share Posted May 15, 2006 thank you guys, I'll try your ideas Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.