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

XF 1.4 Transferring tables

Discussion in 'Troubleshooting and Problems' started by epic_ninj4, May 12, 2015.

  1. epic_ninj4

    epic_ninj4 Member

    Hey everyone,
    I am trying to transfer my XF tables to my new server. I used mysqk workbench to dump them into a folder and connected to the new server to start importing them. Except I got a number of errors:
    ERROR 1045 (28000): Access denied for user '****'@'*****' (using password: NO)
    Operation failed with exitcode 1

    Dedicated centos 6.6 server with phpmyadmin. Any help is appreciated
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    The credentials you are using to connect to the database are incorrect.
     
  3. epic_ninj4

    epic_ninj4 Member

    It let me connect to the server with mysql workbench though :/. I am using a password so i dont understand why it says im not...
     
  4. epic_ninj4

    epic_ninj4 Member

    got this error now:
    Error
    There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

    ERROR: Unknown Punctuation String @ 48
    STR: ><
    SQL:

    <!-- PMA-SQL-ERROR -->
    <div class="error"><h1>Error</h1>
    <p><strong>SQL query:</strong>
    <a href="server_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60shady_Xenforo%60+WHERE+Name+%3D+%27xf_admin_template_compiled%27&amp;show_query=1&amp;token=**************************************"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> Edit</span></a> </p>
    <p>
    <code class="sql"><pre>
    SHOW TABLE STATUS FROM `shady_Xenforo` WHERE Name = 'xf_admin_template_compiled'
    </pre></code>
    </p>
    <p>
    <strong>MySQL said: </strong><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Ferror-messages-server.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a>
    </p>
    <code>
    #2006 - MySQL server has gone away
    </code><br />
    </div>


    SQL query:



    Error
    SQL query: [​IMG] Edit


    SHOW TABLE STATUS FROM `shady_Xenforo` WHERE Name = 'xf_admin_template_compiled'



    MySQL said: [​IMG]

    #2006 - MySQL server has gone away


    MySQL said: [​IMG]

    #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 '&lt;! &lt;div class=&quot;error&quot;&gt;&lt;h1&gt;Error&lt;/h1&gt;
    &lt;p&gt;&lt;strong&gt;SQL query:&lt;/strong&gt;
    &lt;a href=&quot;' at line 1
     
  5. Brogan

    Brogan XenForo Moderator Staff Member

    I suspect your dump and restore is corrupt.

    I recommend using SSH.
     

Share This Page