largestew
Forum Replies Created
-
Forum: Installing WordPress
In reply to: Moving HostsThanks so much arkgroup. You are affirming that I’ve done everything right so far.
We moved hosts at the end of February, and everything is great except for the blog portion. I never had access to the old servers, the company’s designers & techs did it all. They sent me a zip file that when expanded had everything in it. I edited the site and uploaded it onto the new server, created a new wordpress installation, copied all the files from the folder I was sent. I have installed the template. So everything is working great except for the database content from the blog prior to the move. If I had access to their servers I’m pretty sure I would have been able to do the export (either in wordpress or phpmyadmin) and the import would have worked fine. However, I don’t know how they exported the database. (I’ve asked, but haven’t gotten a reply). What they sent me was a file named database.txt which I can’t get to import into wordpress, and when I try to import into mysql I get the syntax error.
Does anyone know how you would export a worpress database so that it’s exported as a text file? And more importantly, how to import that text file into a new wordpress installation?
Forum: Installing WordPress
In reply to: Moving HostsThanks esmi. Again, I’m very green at this, all I know how to do is install worpress with fantastico, login, do posts, and customize templates, so I’m completely out of my element when dealing with databases. I could completely be doing something wrong. When I tried importing using phpmyadmin this is what I’ve gotten:
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—-
eNrtzc1ugkAUBWDW8xR3YbpiJsyMtGVcTQy1JvyVsS66s5amJICokNS3L5q+hMnZ3Xz35Jy4LPPS
0FLSUlESZ4ZCeqS5VJq5zfTwGHPbSWfrL0PnY9PvTufqJJr6U/Q/PUkt5ROpIIi4lFyGE5gwMFp9
UFO1Ec1YenFvydQqAhFJvj+07djVw4W9u5Jy55NdxdnGp208jaW7PTn7Ysv1LR9qzYrUGtJCiTkr
XotrzM/dtU6JiJK6G39ZYrOVoarj4/DNn9lt7uE4HoaFJ73/YwEAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAMC9wx/y8STN
—-END CUT—-
—-BEGIN RAW—-
ERROR: C1 C2 LEN: 5 6 4123
STR:SVN: $Id: sqlparser.lib.php 13117 2009-11-15 13:50:32Z lem9 $
MySQL: 5.0.91-community
USR OS, AGENT, VER: Mac SAFARI 5.0.533
PMA: 3.2.4
PHP VER,OS: 5.2.9 Linux
LANG: en-utf-8
SQL: “1”;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;”1″;
—-END RAW—-SQL query:
“1”;
MySQL said:
#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