Jump to content


Photo

MySQL table backup


  • Please log in to reply
3 replies to this topic

#1 Horst Azeglio

Horst Azeglio
  • Members
  • PipPip
  • Member
  • 24 posts

Posted 15 May 2006 - 09:27 PM

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

#2 ikmyer

ikmyer
  • Members
  • PipPipPip
  • Advanced Member
  • 109 posts
  • LocationIowa

Posted 15 May 2006 - 09:35 PM

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...

#3 ryanlwh

ryanlwh
  • Staff Alumni
  • Advanced Member
  • 511 posts

Posted 15 May 2006 - 10:08 PM

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.
Please use EDIT * 100...
Please use
or [php] * 1000...

PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...

#4 Horst Azeglio

Horst Azeglio
  • Members
  • PipPip
  • Member
  • 24 posts

Posted 15 May 2006 - 11:16 PM

thank you guys, I'll try your ideas




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users