1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.4 'ALTER TABLE `xf_admin_template_modification`

Discussion in 'Installation, Upgrade, and Import Support' started by sbj, Dec 30, 2014.

  1. sbj

    sbj Well-Known Member


    I hope this is the right section for my problem.

    So, I am moving from a cpanel shared hosting to a VPS hosting without cpanel.
    I installed phpmyadmin and created a database. So, after this I imported my old database and got this error:

    What to do here? First time dealing with this kind of problem.
    ericsonrange likes this.
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    I recommend using the command line for the restore:


    Phpmyadmin can work but it is less reliable for backup / restore tasks.

    If the command line produces the same MySQL error then we can be fairly certain that there is either a problem with the backup or maybe some incompatibility with your new MySQL server. Try a new backup + restore (using the command line for both). If the error persists then open up the backup file and isolate the specific command that is causing the error. Then try running that command directly using phpmyadmin and troubleshoot from there. Maybe there is some syntax that is not recognized by your new MySQL server.
    sbj likes this.
  3. sbj

    sbj Well-Known Member

    I have a question here. I am a bit confused. How can I restore the database, when I dont tell anywhere from which place to restore?
    The database I want to restore, I must upload it via ftp to some place, correct? Which place?
    How can I say "grab database from here, then overwrite the old one which is here"
    And then this "< /PATH/TO/backup.sql" will be the new place saved in?
  4. Brogan

    Brogan XenForo Moderator Staff Member

    The required commands are in the resource linked to above, and which you have quoted.

    You upload the backup .sql to the server then run the mysql command, entering the file path as necessary.
    sbj likes this.
  5. sbj

    sbj Well-Known Member

    And it doesn't matter where I upload the backup?
    Through the command, it will automatically find the backup, overwrite the old one and save this to the path I gave above?
  6. Brogan

    Brogan XenForo Moderator Staff Member

    All that matters is the path you enter for the command matches the location of the uploaded file.
    sbj likes this.
  7. sbj

    sbj Well-Known Member

    Ahhh, thanks, this is what I wanted to know.
    And does the path which I choose need special chmod rights like 0777?
  8. Brogan

    Brogan XenForo Moderator Staff Member

Share This Page