I try to take a backup of our phpbb forum database as often as I can.

It's always worked fine doing an export using PhpMyAdmin in the Cpanel. The backup files are usually around 200mb. However, when I tried to run a backup today the download said it was completed at 17.9mb.

I tried again. This time it said it was completed at 12.3mb. I tried again. 13.8mb.

What's going on here? Given all the problems we've been having recently, I could really do with being able to make a backup.

I tried to make a copy of the database using the 'copy to' section of the operations tab. It failed saying that racerxba@localhost has denied permission.

Are you guys having problems in general at the moment?


Thank you



Tom Hudson
www.racerxband.com

Dear customer, as the backup system influences server's stability, we recommend you to upload your files via FTP and save them on your home PC.

Excuse me? I'm sorry but, I think you need to re-read my question.

I want to make a backup of my database. As in, a mySQL database. In this case it happens to be the database I use for a phpBB forum.

What I usually do is use the export feature of PhpMyAdmin to save the database to a file. Usually it works. Now: it's not. I would like to know why please.


Thank you



Tom Hudson
www.racerxband.com

do you have shell access?

if so you can do a backup of your databases there...

mysql -uusername -ppassword < backup.sql

this should be more reliable for large datasets...

Thankyou!

I'll give it a try!

sorry n00by question here. I am trying to do the same thing. how and where would I go in to do this, a few more details would be great if you have time.

any help would be great thanks!

Well...you need shell access to your account.
Shell is a command prompt access to your files.
Kinda like how DOS is to windows.

You'll need a program like... putty
http://www.chiark.greenend.org.uk/~sgtatha...y/download.html
to access your account this way
and again you need to have shell access enabled by Hostony.

once you logon you can navigate around like you would in DOS.
http://www.ee.surrey.ac.uk/Teaching/Unix/

then you just type that command in ...
whoops had that wrong there... try this....

Usage: mysqldump [OPTIONS] database [tables]
OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help

mysqldump -uusername -ppassword --all-databases > output.SQL

this creates a file called output.SQL
which you can then FTP to your home computer

Hope this helps...

cool thanks for the additional info artrocity!

I'll take a look at those links and try it out