How do I backup a website/databases? (10 points best answer)?
January 19, 2012 by
Filed under remote backup
I have a phpbb forum website, which I host with HostGator. I am moving to HyphyHost. I’ve moved regular html websites before through ftp, thats pretty simple, just download the files to my computer, then reupload them. But for this site, I have members and a mysql database. I read that you have to backup your database, but I dont know how to do it. I logged in to cpanel, and found where it says “Backup Wizard – Create a Full backup”, but I dont know what to do after that, or where the backup goes, and I dont know what to do with the backup once its created. How do I upload it or set it up on the new host (the new host has cpanel too)?
Its asking me for the following info, and I dont know if I have to fill it all in or what:
Backup Destination: (Choices: Home Directory, Remote FTP Server, Secure Copy)
Email Address:
Remote Server (FTP/SCP only):
Remote User (FTP/SCP only):
Remote Password (FTP/SCP only):
Port (FTP/SCP only):
Remote Dir (FTP/SCP only)
I have phpadmin, how do I use it to back up things?
Bottom line: IDK either.
But here;s my guess.
Youre on a UNIX system, so use dd (disk to disk) on the raw device. You’re likely on a raw device, but if not, ask to be moved to one temporarily.
cant go wrong with dd.
I’d ask your hosting service about the MYSQL backup. You should be able to backup to your own computer. Control Panel should give you access to your database where you can copy it as a text file and then paste it into your new database on your new hosting service.
There should be management progs in your control panel for MYSQL, mine has PHPMyADmin and you can view the dbase as a text file and copy it or paste in new data as text.