ssh restore help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aky
    Senior Member
    • Sep 2003
    • 133
    • 3.5.x

    ssh restore help

    typing in this command

    mysql -u dbusername -p databasename < backupname.sql

    and im getting this error
    PHP Code:
    Access denied for user 'xxx'@'localhost' (using passwordYES)
    xxxxx@ethan [~/public_html]
    can anyone tell me what im doing wrong?

    thanks
    Last edited by aky; Wed 18 Oct '06, 9:43am.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    Most likely the password is wrong. Either that or this db user does not have full permissions to this database.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • aky
      Senior Member
      • Sep 2003
      • 133
      • 3.5.x

      #3
      Originally posted by Steve Machol
      Most likely the password is wrong. Either that or this db user does not have full permissions to this database.
      password is corrent and user has full permission

      host (ASO) said

      In that case you probably don't have permissions to use the mysql client utility.


      anyone know what that means, that the computer i'm on doesnt have permission or permission from host?

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        I don't know what they mean by that either. Best to ask them.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        • aky
          Senior Member
          • Sep 2003
          • 133
          • 3.5.x

          #5
          Originally posted by Steve Machol
          I don't know what they mean by that either. Best to ask them.
          ok they tried restoring and they get this error

          ERROR 1062 (23000) at line 3208: Duplicate entry 'finaplix' for key 2

          anyone know?

          Comment

          • Steve Machol
            Former Customer Support Manager
            • Jul 2000
            • 154488

            #6
            That doesn't look like a vB field or table. Did you install any hacks, products or plugins?

            Unfortunately this means that this backup is bad. I'm not sure if there is anyway to fix this. They are trying to restore this to an empty database, right?
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment

            • aky
              Senior Member
              • Sep 2003
              • 133
              • 3.5.x

              #7
              yes they are trying to put this into an empty db, what should i do now? Will making another backup of my db fix this? im using phpMyAdmin

              thanks

              Comment

              • Steve Machol
                Former Customer Support Manager
                • Jul 2000
                • 154488

                #8
                Sorry, I don't know how to fix that. Again I do not know of any field in vB named 'finaplix'. Do you know which table this is in and what add-on this is from?
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment

                • aky
                  Senior Member
                  • Sep 2003
                  • 133
                  • 3.5.x

                  #9
                  i have no idea. can i just delete this table?

                  when i try restoring using phpmyadmin it goes through. whne i connect to my site, i get this error

                  Database error
                  The database has encountered a problem.
                  Please try the following:

                  * Load the page again by clicking the Refresh button in your web browser.
                  * Open the www.mysite.com home page, then try to open another page.
                  * Click the Back button to try another link.

                  The www.mysite.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

                  We apologise for any inconvenience.

                  besides the db username and the db name is there anything else that i need to change in the config.php file?

                  Comment

                  • Steve Machol
                    Former Customer Support Manager
                    • Jul 2000
                    • 154488

                    #10
                    I thought this wwas about restoring a backup. What are you doing now?

                    Also we need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.
                    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                    Change CKEditor Colors to Match Style (for 4.1.4 and above)

                    Steve Machol Photography


                    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                    Comment

                    • Rick Grunwald
                      Senior Member
                      • Feb 2005
                      • 211
                      • 3.0.6

                      #11
                      Originally posted by aky
                      password is corrent and user has full permission

                      host (ASO) said

                      In that case you probably don't have permissions to use the mysql client utility.


                      anyone know what that means, that the computer i'm on doesnt have permission or permission from host?
                      Like Steve said - ask them. One question - do they use Cpanel? If so your username is prefixed to everything. IF your username for example is "aky1" then the database name will be "aky1_databasename" and the user for the database will be "aky1_aky1". If you added ME my name would be"aky1_rick". i.e everything is prefaced by the account name

                      If you use cpanel to administer your website then check that if no diregard
                      Rick Grunwald
                      http://grunwalds.com
                      XP home SP2, Celeron 2gb, 2GB RAM, Zone Alarm Security Suite

                      Comment

                      • aky
                        Senior Member
                        • Sep 2003
                        • 133
                        • 3.5.x

                        #12
                        ya they do use cpanel and im prefixing with my username_xxxx

                        im staring over.

                        -Deleting everything from my public html folder (do i need anything besides my /forums folder in here?)
                        -Doing a backup of my database using phpMyAdmin
                        -restoring using phpMyAdmin (how do i restore into an empty database using this program?)

                        i hope this works

                        thanks

                        Comment

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