problems backing up sql

[IAMWhitey]

when i try to backup the sql in the admin console it stops at 38% each time and it will get no further then that. although the script will not time out either.

any ideas?

thanks

John

[Zachery]

How big is your database? anything larger than 50~ megs generaly times out, and its time to start either backing up via the shell, or youll need to do table by table backups

[IAMWhitey]

its definitely larger the 50mb, any recommendations for the best method of backup on an NT box?

[Zachery]

Telnet, Via remote desktop or tight vnc, use the command line from c:\mysql\bin (or whever mysql is installed) you can use mysqldump just like you do in *nix. If you dont have access to this you should contact your host and ask them to preform the backup

[IAMWhitey]

its on a dedicated box so i can do this.

thanks for your help!