• 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

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

Process:

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:

Code:
Error
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...???
 

Brogan

XenForo moderator
Staff member
#2
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

Dump:
Code:
mysqldump -udatabase_user -p --single-transaction --skip-lock-tables database_name > /path/to/backup/database_name_$(date +%d.%m.%y).sql
Zip:
Code:
tar -czf database_name_$(date +%d.%m.%y).tar.gz /path/to/backup/database_name_$(date +%d.%m.%y).sql
Restore:
Code:
mysql -udatabase_user -p database_name < backup.sql
 
#5
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
 

Brogan

XenForo moderator
Staff member
#8
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
 

borbole

Well-known member
#9
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
Do not forget to also update the Board URL option.