Announcement

Collapse
No announcement yet.

How do I use mysqldump on Windows 2000?

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • How do I use mysqldump on Windows 2000?

    I have forums, some very large, that I'd like to backup and they timeout with the admin area backup.

    How do I do a mysqldump in Windows 2000? I have no clue how to use this!

    Using the latest mysql (3.23?) and php 4.x

    Thanks!
    Neal Culiner
    President, NC Software, Inc.
    Logbook Pro Pilot Flight Logbook Software
    Visual Basic Developer Forums

  • #2
    I don't have Windows 2000 but I suppose you could use something like phpmyadmin to make a MySQL Dump.

    http://www.phpmyadmin.net
    ManagerJosh, Owner of 4 XenForo Licenses, 1 vBulletin Legacy License, 1 Internet Brands Suite License
    Director, WorldSims.org | Gaming Hosting Administrator, SimGames.net, Urban Online Entertainment

    Comment


    • #3
      Go to Start > Run, type command and hit enter

      Change to your bin directory:

      cd c:\path\to\mysql\bin

      Run the following command, after changing USERNAME, PASSWORD and DATABASE_NAME to your username, password and the name of the database you want to dump. Also remember to change the path where you want the file to be created:

      Code:
      mysqldump --opt -uUSERNAME -pPASSWORD DATABASE_NAME > "C:/path/to/dump/file.sql"
      Sean
      SitePoint Advisor (seanf)
      http://sitepointforums.com
      Harry Potter

      Comment


      • #4
        Following on this, if your server is remote, you will still need to log in via SSH or using some remote desktop application like PCAnywhere or Citrix Terminal.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment


        • #5
          Originally posted by seanf
          Go to Start > Run, type command and hit enter

          Change to your bin directory:

          cd c:\path\to\mysql\bin

          Run the following command, after changing USERNAME, PASSWORD and DATABASE_NAME to your username, password and the name of the database you want to dump. Also remember to change the path where you want the file to be created:
          Code:
          mysqldump --opt -uUSERNAME -pPASSWORD DATABASE_NAME > "C:/path/to/dump/file.sql"
          Sean
          Thanks. I'll give this a try. How long will it take to backup a 250 meg DB?
          Neal Culiner
          President, NC Software, Inc.
          Logbook Pro Pilot Flight Logbook Software
          Visual Basic Developer Forums

          Comment


          • #6
            that depends on how fast your computer is

            if it isn't ready after 30mins, try again
            Dutch vBullletin users social group!

            Comment


            • #7
              Originally posted by neal007
              Thanks. I'll give this a try. How long will it take to backup a 250 meg DB?
              Should just be a few minutes

              Sean
              SitePoint Advisor (seanf)
              http://sitepointforums.com
              Harry Potter

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X
              😀
              🥰
              🤢
              😎
              😡
              👍
              👎