PDA

View Full Version : mysql restore error


kgl
05-19-2008, 03:37 AM
I have been building a test site on a windows machine using xampp. I have done a mysql backup through phpmyadmin. Now I want to use that backup to restore to the database in the FQ servers.

I have been following the instructions using telnet and I am getting an error message: error at line 1640: Unknown command '\x'

Is there any incompatibility using phpmyadmin to back up and then restore using the telnet commands?

When I look inside my sql file, I notice some windows paths eg
C:\xampp\etc etc.
Would the \x of \xampp be causing the problem? I don't really know if this is on line 1640 but it is way down the file. I am using wordpad to look inside the file but it does not have line numbers.

Thanks

Greg

Tom E.
05-19-2008, 06:30 AM
If the sql file is not too big for notepad, you can select "Go To..." in the Edit menu, then type the line number.

You can also use the CNC file manager to view line numbers.

Kevin
05-19-2008, 11:09 AM
Also, within the telnet shell you can type 'sed -n 1640p' to see the line that it is complaining about.