Announcement

Collapse
No announcement yet.

Just backed up my first vB3 database

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

  • Just backed up my first vB3 database

    Half the size of my vb2 database, moderated all attachments pre 2003
    MCSE, MVP, CCIE
    Microsoft Beta Team


  • #2
    Wow sounds very efficient. Does it have a restoring option in the ACP?

    - miSt
    Dean Clatworthy - Web Developer/Designer

    Comment


    • #3
      restore database? no, just run queries and the normal backup, but i would still use ssh for backup to be safe
      Last edited by Joe Gronlund; Sat 8th Mar '03, 10:09am.
      MCSE, MVP, CCIE
      Microsoft Beta Team

      Comment


      • #4
        Originally posted by Mist
        Wow sounds very efficient. Does it have a restoring option in the ACP?

        - miSt
        PHP runs as "www". So far I haven't seen anyone come up with a way to give PHP the necessary permissions to do a restore with mysql.

        Comment


        • #5
          Can't it just exec the mysql process, logging in with the proper rights?
          --filburt1, vBulletin.org/vBulletinTemplates.com moderator
          Web Design Forums.net: vB Board of the Month
          vBulletin Mail System (vBMS): webmail for your forum users

          Comment


          • #6
            You really want to use telnet to restore MySQL dump files. I remember reading somewhere that phpmyadmin could restore backup files, but I doubt it's as reliable as telnet.

            Comment


            • #7
              What situation would someone be in that they can't Telnet or SSH in?

              And if such a situation existed, I'd be uncomfortable running anything more complicated than a web server on it.

              Considering webhosts are $7 a month...

              Comment


              • #8
                Originally posted by feldon23
                What situation would someone be in that they can't Telnet or SSH in?
                That's a bad situation. Try to find a host that gives you telnet access.

                If you don't have telnet access, and you need to restore a MySQL dump file, try asking the host to restore it for you.

                Comment


                • #9
                  Actually, I did just think of a situation. 200MB webhost, you have 180mb of stuff on there. Forum backup is 30MB. That's a problem!

                  Comment


                  • #10
                    No host in their right mind about security gives telnet - ssh works the smae way but much much more secure .

                    AS far as web based restore function, is feasible (an dis availible in phpmyadmin) but it is unreliable since restoring a backup takes time - and php tends to timeout after 30 seconds.

                    Comment


                    • #11
                      Getting SSH configured and set up for each user seems to be beyond the capability of my webhost. They want a driver's license number or some such nonsense.

                      Comment


                      • #12
                        Originally posted by feldon23
                        Getting SSH configured and set up for each user seems to be beyond the capability of my webhost. They want a driver's license number or some such nonsense.
                        please tell me your joking, whos your host?
                        MCSE, MVP, CCIE
                        Microsoft Beta Team

                        Comment


                        • #13
                          Web66.

                          Comment


                          • #14
                            Originally posted by Asendin
                            please tell me your joking, whos your host?
                            It's not that strage... My host does the same thing...

                            Comment


                            • #15
                              Originally posted by Jakeman
                              You really want to use telnet to restore MySQL dump files. I remember reading somewhere that phpmyadmin could restore backup files, but I doubt it's as reliable as telnet.
                              PHPMyAdmin is not nearly as reliable, especially for larger databases, becuase it tends to time out as expected, so yeah telnet is the best way for sure.
                              Webmaster / Administrator
                              www.MegaGames.com
                              www.MGForums.com

                              Comment

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