Announcement

Collapse
No announcement yet.

problems backing up sql

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • problems backing up sql

    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

  • #2
    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

    Comment


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

      Comment


      • #4
        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

        Comment


        • #5
          its on a dedicated box so i can do this.

          thanks for your help!

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X