Announcement

Collapse
No announcement yet.

restoring a backup problem via ssh

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

  • restoring a backup problem via ssh

    hi there im trying to restore a backup of my database i am using the command mysql -u(username) -p(password) (database name) < dump.sql (the backup is in the root dir)

    and I am getting the error:

    ERROR 1050 at line 11: table 'access' already exists

    I know its prolly summet silly im missin along the lines, it always is

    hope u can help
    http://

  • #2
    You will need to drop all the existing vBulletin tables from the database before attempting to restore a backup.

    Comment


    • #3
      can i do this thru ssh? if so what commands will i need to use as i was having problems installing phpmyadmin so i binned it

      cheers for ur help
      http://

      Comment


      • #4
        Okay, first put phpMyAdmin back on to the system, then go through all the tables in the database and click the 'drop' link for each table.

        Next open up an SSH prompt and run this:
        Code:
        /usr/local/mysql/bin/mysql -u[b]username[/b] -p[b]password[/b] [b]database[/b] < yourdumpfile.sql

        Comment

        Loading...
        Working...
        X