WordPress.org

Forums

[resolved] Given site files and database by client... no clue how to transfer to new server (5 posts)

  1. joltlogan
    Member
    Posted 9 months ago #

    Let me preface this by saying I've explored the WordPress documentation, several forum threads, and multiple youtube tutorials on how to transfer a site over form one server to another with databases in tow and what not. None of them have worked because either a) I'm doing it wrong or b) the stuff I have isn't enough. So here's the run down:

    1) Client wants to host their website on a colleague's server. They give him all the site files (wp-admin/content/include folders, etc.) and an SQL database file.

    2) They take the site down, and my colleague comes to me and asks me to install it on his server (since he doesn't handle web design stuff). I personally have only ever dealt with hosts who offer it on their cpanel. I've never personally done it through a server. whenever I transfer WordPress to other servers I just take the long route and install a fresh WordPress site on their server and take the exporty form the WordPress backend and import it and adjust it manually in the backend. I've never really messed with databases because it seems like every time I do something goes wrong. My colleague has a Windows Server.

    3) After having trouble getting it going on his Windows Server he eventually downloads and installs Plesk on his server (since CPanel is not available for Windows server). This is when I attempt to install WordPress and transfer files and SQL databases the way the tutorials tell me to. Except it doesn't work.

    4) Because of this I attempt to do it on my own hosting server (that I have with a third party host that uses CPanel) just to test it out to make sure it's not just a Plesk thing). When I go into PHPMyAdmin and import the SQL database, this is what I get in error:

    There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
    ----BEGIN CUT----
    eNo1jUEKwjAURIXu/inmAOnHJFYlu1BCu0ibmlQ9gUhB4krQ25sKznJ4b8bFGKJBK9EqeDcaSChI
    SWkudUU0fNLJGzTcsD7UumFZP553OqeIkARs58ZZ4OIKfV0y2j6GwRV8y3pP02ANdFGPrGjqp5UT
    Ia1zO1YafsmvN3k7dga3TL8nqjb/fAEvDiKm
    ----END CUT----
    ----BEGIN RAW----
    ERROR: C1 C2 LEN: 1 2 11
    STR: 
    
    MySQL: 5.5.37-35.1-log
    USR OS, AGENT, VER: Win CHROME 5.0.36
    PMA: 3.5.8.2
    PHP VER,OS: 5.4.23 Linux
    LANG: en
    SQL:
    
    ----END RAW----
    
    SQL query:
    
    
    
    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 '' at line 1

    However, all the sections and info shows up back in the main folder tree. I then adjust wp-config to match the new database settings, and I get the database error on WordPress. It was the same way on Plesk.

    I'm at a loss because this is the only way I can transfer the site and I've never done it before and all the tutorials I'm finding aren't helping much. I don't even know what the site actually looks like, so I'm expected to get it up and running just the way it was. It's daunting for me right now.

    I genuinely don't know where to start in this situation. I've got a .SQL database file and everything form their original FTP server. It seems like this should be easy but I haven't a clue what to do or where I'm going wrong. Please help someone?

  2. Mark Senff
    Member
    Posted 9 months ago #

    For WordPress to work, you will need a MySQL server.

    Although it's possible to get things running on a (Microsoft) SQL server, it will take a ridiculous amount of hacking and tweaking. Probably not worth all the hassle.

    I'm not 100% sure but it doesn't look like you have a MySQL database, so you're going to need that for starters. Being a Windows server, that will probably take some work as well. Maybe I have things backwards and you do have a MySQL database but a SQL export file.

    Plesk and CPanel are just tools to help you install things (it makes things easier but it's not a lot of trouble to import an .SQL file into an MySQL database without Plesk or CPanel), but without a MySQL database, those tools won't help you all too much.

  3. joltlogan
    Member
    Posted 9 months ago #

    We actually have MySQL running on the Windows server, and Plesk automatically creates an SQL database, much like an automated service like Mojo Marketplace or Fantastico would when installing WordPress. The tutorials I found told me to take the SQL database (it's literally "filename.sql") and import it in PHPMyAdmin under the proper database that the site uses. That's when I get that error.

    I can create Databases manually in Plesk, and I've tried, but to no avail.

    I was given these site files and this database file

    How I'm supposed to take them and get their site up and running is what's leading me to a road block. Did they not give me enough data to do that? Or am I going about this entirely the wrong way?

  4. joltlogan
    Member
    Posted 9 months ago #

    Figured this out. Client had sent over a corrupt database file. All is working. Sort of, but that's another post for a different section

  5. Mark Senff
    Member
    Posted 9 months ago #

    Client had sent over a corrupt database file.

    Don't you hate it when that happens.... ;)

    Glad it all worked out!

Reply

You must log in to post.

About this Topic