MySQL syntax error
Jan 20, 2005 | 08:21 AM
Thread Starter
Joined: Jul 2001
Posts: 24,057
Likes: 0
From: deep inside your imagination
MySQL syntax error
Running the this SQL in phpMyAdmin 2.6.1-rc1 returns a syntax error. I've tried running it as a cronjob too, with no joy.username -ppassword account_database > backup.sql
Jan 20, 2005 | 10:09 AM
Joined: Jan 2001
Posts: 2,710
Likes: 1
From: behind twin turbos
What error are you getting?
Jan 20, 2005 | 10:16 AM
Thread Starter
Joined: Jul 2001
Posts: 24,057
Likes: 0
From: deep inside your imagination
#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......
Jan 20, 2005 | 10:20 AM
Joined: Jan 2001
Posts: 2,710
Likes: 1
From: behind twin turbos
What if you add a "--quote-names" option to the dump command line?
Jan 20, 2005 | 10:36 AM
Thread Starter
Joined: Jul 2001
Posts: 24,057
Likes: 0
From: deep inside your imagination
Comes back with the same error. If it's of any relevance, the error message shows the command line with the hyphens and > symbols all highlighted red
Jan 20, 2005 | 11:04 AM
Joined: Jan 2001
Posts: 2,710
Likes: 1
From: behind twin turbos
Strange. Your syntax is fine, can you get the entire error message? Do you have command line access via something like ssh you can try from?
Jan 20, 2005 | 11:57 AM
Thread Starter
Joined: Jul 2001
Posts: 24,057
Likes: 0
From: deep inside your imagination
Unfortunately not. I'll raise a help ticket with the host and see what gives.
Thanks for your help
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Sam Witwicky
Engine Management and ECU Remapping
17
Nov 13, 2015 10:49 AM
Nick_Cat
Computer & Technology Related
2
Sep 26, 2015 08:00 AM
airhead
Non Scooby Related
3
Oct 8, 2001 08:02 AM
SDB
Non Scooby Related
2
May 26, 2001 11:55 PM
gregh
Non Scooby Related
6
May 16, 2001 11:17 PM
MySQL syntax error
