Jump to content


Photo

DATABASE BACKUP USING PHP AND MYSQL


  • Please log in to reply
1 reply to this topic

#1 swanweb

swanweb
  • Members
  • Pip
  • Newbie
  • 1 posts
  • LocationScotland, UK

Posted 19 December 2003 - 11:22 PM

HELPPPP!!!!!!!!!!

I really need help to backup existing databases on my older server. So i can move them to the new server. My older server was hacked and is now having problems with Cpanel, there is some mysql bug. I can access databases etc using php but not through cpanel. How can i make a complete backup, e.g. take all the sql out so i can implement it into the new server.

Matt
Be The Best Be A Programmer

#2 rhysmeister

rhysmeister
  • Members
  • PipPipPip
  • Advanced Member
  • 51 posts
  • LocationEngland

Posted 20 December 2003 - 12:38 PM

Use mysqldump...

http://www.mysql.com.../mysqldump.html

This can be used from MySQL to MySQL or any other DB supporting standard SQL. I often simply copy the DB files onto a disk and put them onto the new server manually between my two windows server - with no problems yet. ALthough I am told mysqldump is the preffered way to do it.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users