Backing up of database? Recommendations?

O

Onoredone

New Member
I am having trouble backing up my DB via ACP an phpmyadmin. When I try to download it on my HD, the download finishes with a random size of db like 111kb or 18MB. But my db is like 160MB and I am really worried. I have tried a third party software which is SQL Dumper [ MySQLDumper - smart backup for all your web projects ] and it also gets stuck while taking the back up to the server [ it does not have the option to download the db back up straight to the HD ]. I am assuming my badass slow as hell connection is timing out or refreshed. So are there any ways to back up my vbulletin database? Please i dont want my forum to be messed up. Its started to look good. Thank you to anyone who can help me..Please do leave a reply.

-Odo
 
Yeah I used it successfuly to transfer a 100mb database and it worked perfectly fine after backup and restore. But you need to know the IP of the database.
 
backing up my DB via ACP
Click to expand...

This is as good as shooting your self in the head! Don't do it!

You shouldn't be trying to download it to your local system while it backing up. Get a cPanel Full System back and download the zip file to your local system. It will contain everything you need to reconstruct your site if you need it. Sometimes, phpMyAdmin using the .gz format works but if you connection is slow, you are better off trying to download the cPanel backup. PHP backups will time out on you as you have already seen.
 
:3 I recommend mysqldumper It saves your database in a .tar file even if its too big you just have to upload it to the work path and that's it it will restore your file perfectly :3 actually i always do backups with mysqldumper xDU and i have never had a problem
 
Itsuki Minami said:
:3 I recommend mysqldumper It saves your database in a .tar file even if its too big you just have to upload it to the work path and that's it it will restore your file perfectly :3 actually i always do backups with mysqldumper xDU and i have never had a problem
Click to expand...

Well when I check select tables, and click start new back up it gets stuck in table 2.Overall progress 1%. it doesnt continue. I really need to have a way to back up my db. Yeah and i have a slow connection.

bluescorpion said:
This is as good as shooting your self in the head! Don't do it!

You shouldn't be trying to download it to your local system while it backing up. Get a cPanel Full System back and download the zip file to your local system. It will contain everything you need to reconstruct your site if you need it. Sometimes, phpMyAdmin using the .gz format works but if you connection is slow, you are better off trying to download the cPanel backup. PHP backups will time out on you as you have already seen.
Click to expand...

cPanel Full System back? Can you be more specific. I am very new to database and more new to backing them and restoring.Thanks for any help.

-Odo
 
in cpanel > databases > My sql databases , you have options to :
1 - Download a Home Directory Backup witch generate a full backup contains your files on root directory and databases
2- Download a MySQL Database Backup witch you could select your DBs from a table and get db backups as ziped sql files
...
 
You must log in or register to reply here.
Back
Top