No announcement yet.

how do u knwo if sql backup is successful ?

  • Filter
  • Time
  • Show
Clear All
new posts

  • how do u knwo if sql backup is successful ?

    i read somewhere that sometimes sql backups get timeouts and do not save properly, therefore leaving u with a half-complete backup.

    how can it be know when a backup is done SUCCESSFULLY ???

    and does the writing in the pic look ok the way it is set ?? i saved it like that as a .doc and renamed it to .sql

    thanx all

  • #2
    If it didn't come up with an error, then you can be fairly sure it worked.
    But if you want to be certain then paste the last 5 or so lines from the sql file into a post in this thread.


    • #3
      here they r ...

      i didnt seem to get any errors but i left it on all night to backup because im on a slow conenction so i cannot be sure ....

      soo , here r the last 7 lines of the backup

      thank you


      INSERT INTO word VALUES('6968','oooo');
      INSERT INTO word VALUES('6969','go..');
      INSERT INTO word VALUES('6970','footprints');
      INSERT INTO word VALUES('6971','hearts...');
      INSERT INTO word VALUES('6972','attachment');
      INSERT INTO word VALUES('6973','awwww');
      INSERT INTO word VALUES('6974','nice.');


      that seems to be the last of the bit of the database bacup

      pls let em know if its fine

      thank u


      • #4

        ^ bump


        • #5
          do you have telnet access to your server? If so just do a mysql backup command


          • #6
            The only way to be sure is to reimport your backup into an empty datbase.
            Motorsport Forums


            • #7
              You'd know if it wasn't sucessful, trust me. Yours is fine though.


              • #8

                thanx all, and also Ed.

                i wouldve been still thinking what to do but seeing this is THE Ed who replied, ill take it on board.


                btw, whatts the command to backup a database in telnet ?


                • #9
                  mysqldump -uUSERNAME -pPASSWORD DATABASENAME > PATH/TO/DUMP.txt

                  anything in caps needs to be changed to your information.


                  • #10
                    "mysqldump -uUSERNAME -pPASSWORD DATABASENAME > PATH/TO/DUMP.txt "

                    Susan, I am having problems as well. I keep getting an error when telnetting and running mysqldump. I gather that I am not specifying the path correctly so thought I'd ask. Here you have the last part of the command as path/to/dump.txt and in another posting others list the command as path/to/dump.sql

                    Which is the correct format? .txt or .sql for labeling the file?




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