I am trying to import another database I have from another host and I am getting this error during the import.
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 @ 7
STR: ><
SQL:
<html><head><title>IPS Driver Error</title>
<style>P,BODY{ font-family:arial,sans-serif;
SQL query:
I am a n00b with mysql so any help is appreciated.
thank you,
Is that the beginning of the dump? It looks like straight html.
Did you create the backup in phpMyAdmin?
it happens after the dump has been running for approx 2-3 minutes so i would say towards the end.
here's the scenario. i am part of a forum and the owner hasn't been around for over a year and the domain name ends in about a week. i am an admin on the forum which is ipb so i can only do an export of the database thrugh my admin panel in ipb. i'm hoping i can get it to work. any suggestions??
thanks jason
So the 2-3 minute timeout is when you're taking the backup or when you're trying to restore it here?
How big is the database dump file?
(I'm travelling today so I may be slow to respond until tomorrow)
i was able to get the 22mb dbbackup.sql file from the ipb board. it's when i'm restoring the info to the db i created here on cw that i get that error.
In theory that size is within upload limits but I personally wouldn't use a webbased utility like phpmyadmin at that size. If you want to ftp it up somewhere and open a ticket or email me I can do the restore in shell and see if that works better. I'd need the db connection settings you want used as well.
Edit, my first sentence should've said "I personally wouldn't use"
That's what I get for typing on a blackberry!
sounds good, i'll ftp it up and include the link in my ticket i will open.
thanks jason