CPanel: DB Too Big to Download

I operate some forums, and whenever I try to download the forums database via Cpanel, the transfer complete, but the file is always too small and there is lots of entries left out. (DB is about 70MB, but the downloaded file is always about 8MB).

I guess this is a bug in Cpanel, but now I have a problem. I need to edit one particular table so that all the URLs in it go from http://www.domain.com/ to http://www.domains.com/forums.

Is there a particular SQL query I can run on the DB through Cpanel to achieve this? Like select where http://www.domains.com/ and change to http://www.domains.com/forums/

Please post details of how to specify the particular table within the DB as well, since my SQL command skills arent up to scratch.


Thanks, Matt.

 

 

 

 

Top