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

XF 1.4 Importing Error - Domain move

Discussion in 'Installation, Upgrade, and Import Support' started by Mark Thompson, Aug 28, 2015.

  1. Mark Thompson

    Mark Thompson Member

    I am trying to move my install to a new Domain on my server and I constantly get sql errors


    Copy Forum Files to New Domain

    Export Database In Phpmyadmin

    Create New Database

    Point config.php to new database

    Import Exported Sql file in phpmyadmin

    This is the latest error I am getting:

    SQL query:
    <!-- PMA-SQL-ERROR --> <div class="error"><h1>Error</h1> <p><strong>SQL query:</strong> <a href="tbl_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60yyyxxxx_xenforo%60+LIKE+%27xf_phrase_compiled%27&amp;show_query=1&amp;db=yyyxxxx_xenforo&amp;table=xf_phrase_compiled&amp;token=5c044be7f38b16d6be92f2b1b9df9b89"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> Edit</span></a> </p> <p> <span class="syntax"><span class="inner_sql"><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fshow.html&amp;token=5c044be7f38b16d6be92f2b1b9df9b89" target="mysql_doc"><span class="syntax_alpha syntax_alpha_reservedWord">SHOW</span></a> <span class="syntax_alpha syntax_alpha_reservedWord">TABLE</span> <span class="syntax_alpha syntax_alpha_reservedWord">STATUS</span> <span class="syntax_alpha syntax_alpha_reservedWord">FROM</span> <span class="syntax_quote syntax_quote_backtick">`yyyxxxx_xenforo`</span> <a href="./url.ph[...]
    MySQL said: Documentation
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<!-- PMA-SQL-ERROR -->
        <div class="error"><h1>Error</h1>
    <p><strong>SQL quer' at line 1 

    I honestly thought that this would be a straightforward process as everything is on the same server but I've been working on it since midnight last night and it's now 10am.

    Not sure why there would be a syntax error as it's just a straight import

    I export using quick as the export method and using SQL as the format

    Anyone have any idea what the problem could be...???
  2. Brogan

    Brogan XenForo Moderator Staff Member

    You will likely need to dump and restore using shell.

    Operations of that nature frequently fail when using phpMyAdmin.

    This is what I use to dump and restore on a regular basis

    mysqldump -udatabase_user -p --single-transaction --skip-lock-tables database_name > /path/to/backup/database_name_$(date +%d.%m.%y).sql
    tar -czf database_name_$(date +%d.%m.%y).tar.gz /path/to/backup/database_name_$(date +%d.%m.%y).sql
    mysql -udatabase_user -p database_name < backup.sql 
  3. Mark Thompson

    Mark Thompson Member

    Thanks.. (do you ever sleep??)
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Not if I can help it ;)
    Amaury likes this.
  5. Mark Thompson

    Mark Thompson Member

    Would the following work? as i am having trouble accessing the database via shell.. (way above my tech level!)

    Close the Current Forum

    Move the Files to the new Forum

    Leave the Database in place

    Connect up the new domain to the database

    Remove the old forum and redirect to the new forum

    Open Up the Forum
  6. Brogan

    Brogan XenForo Moderator Staff Member

    If they are on different servers that wouldn't work.
  7. Mark Thompson

    Mark Thompson Member

    Same server, even same IP address.. It's just a move from a .org to a .com
  8. Brogan

    Brogan XenForo Moderator Staff Member

    In that case it should be fine.
    As long as there is only one installation pointing to the DB.

    I actually missed that it was a domain change on the same server - I thought you were moving to a new server.

    Points 5 and 6 of the FAQ may help: Frequently Asked Questions
  9. borbole

    borbole Well-Known Member

    Do not forget to also update the Board URL option.

Share This Page