XF 1.4 Importing Error - Domain move

[Mark Thompson]

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:

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...???

 

[Paul B]

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:

mysqldump -udatabase_user -p --single-transaction --skip-lock-tables database_name > /path/to/backup/database_name_$(date +%d.%m.%y).sql

Zip:

tar -czf database_name_$(date +%d.%m.%y).tar.gz /path/to/backup/database_name_$(date +%d.%m.%y).sql

Restore:

mysql -udatabase_user -p database_name < backup.sql

 

[Mark Thompson]

Thanks.. (do you ever sleep??)

 

[Paul B]

Not if I can help it

 

[Mark Thompson]

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

 

[Paul B]

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

 

[Mark Thompson]

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

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

 

[Paul B]

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]

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.