2 replies to this topic

[JuggoPop]

I'm trying to move a site that has been running 0.5.3 (Euryphaessa) and when I export from phpMyAdmin everything seems fine... when I go to import I get errors... no matter what I try I can't get this to work.

it says there are syntax errors when I try one way... and when I try something else I get an error stating:

Quote

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.

does anyone know if this is something to do with the old phase or if I'm doing something wrong... or anything that might help... thanks.

[Snuffkin]

Sounds like a limitation in phpMyAdmin; so executing the queries using another method might work.

If you have MySQL installed on your local machine, you can try:
- Login to CPanel -> MySQL
- Add your hostmask to the 'Allowed Hosts' list, use % for a wildcard. For example, if your hostmask is cli-11-22-33-44.sfba.igw.someisp.net, then it's probably going to always contain sfba.igw.someisp.net, so you want to enter %.sfba.igw.someisp.net.
- Run the following, assuming MySQL is installed on your machine at C:\MySQL\:
C:\MySQL\bin\mysql.exe -h websitehostname.com -u yourmysqlusername -p
- You'll be prompted for a password. Enter your mysql password.
- When connected, type "use database_name;", replacing the obvious, keeping the semicolon. You should be told the database has been selected.
- Now type:

\. <FULL_PATH_TO_YOUR_SQL_DATA_FILE>

This should load up your MySQL data file and send it to the server. This may take some time depending on the size of your site.
- Once it's done, exit by typing "exit;". Or is it "quit;"? Try both.

If these instructions screw anything up, don't blame me.

[JuggoPop]

yeah... I can't do that... I don't have anything locally setup.

I guess I'll just install a fresh etomite and copy paste all the info in...