Announcement

Collapse
No announcement yet.

Restore database question

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

  • Restore database question

    I moved servers and was able to dump and then restore the database on the new server. However, I just realized that I didn't close the old forum after I dumped the db and now there are new posts there. So, I closed those forums and backed up the db again.

    So, I've already imported the old database on the new server. But I want to replace that with the new database. The steps for moving servers in the manual refers to importing the database into a new and empty one. Since my db isn't emtpy, is there anything I need to do first, or can I just go ahead and import the new database? If I have to first empty the database, how would I go about doing that?

    Dave
    **********************************
    Golden Age Mysteries Forum
    - for fans of mysteries in the classic tradition.
    **********************************

  • #2
    You really cant just import the new info, unless you want to spend abit of time extracting the specific new data, i suggest restoring the whole new dump instead of specific info

    Comment


    • #3
      Yes, I would like to restore the whole new dump. Can I just use the command:

      mysql –uUSERNAME –p NEWDBNAME < /PATH/TO/NEW/DUMP.SQL

      Will this completely overwrite the current database? Do I first need to emtpy the database, and if so, how?

      Dave
      **********************************
      Golden Age Mysteries Forum
      - for fans of mysteries in the classic tradition.
      **********************************

      Comment


      • #4
        It should just overwrite the current dtabase

        Comment


        • #5
          thanks, I'll give that a try.
          **********************************
          Golden Age Mysteries Forum
          - for fans of mysteries in the classic tradition.
          **********************************

          Comment


          • #6
            That didn't work. I got the error:

            Error 1050 at line 11: Table 'access' already exists

            Do I first need to empty the database?
            **********************************
            Golden Age Mysteries Forum
            - for fans of mysteries in the classic tradition.
            **********************************

            Comment


            • #7
              I would guess so, most of the time when i do backups i have drop if exsists im guessing you dont :/

              Comment


              • #8
                How do I empty the database? I'm assuming with phpmyadmin, but I don't know the command.

                [edit]nm, I just deleted and recreated an empty db. was pretty simple, I should have tried that first.[/edit]
                Last edited by BustaCap; Sun 6 Jun '04, 2:11pm.
                **********************************
                Golden Age Mysteries Forum
                - for fans of mysteries in the classic tradition.
                **********************************

                Comment

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