The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

URGENT !!! My SQL Error - Please

Discussion in 'Database Discussions' started by alkaleej, May 22, 2004.

  1. alkaleej

    alkaleej Registered

    Joined:
    Jan 27, 2004
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    151
    I have some customers in my server that having some problems in MySQL Commands using -bash-2.05b$

    I see this massege every time when I enter Mysql Command in Shell :

    bash-2.05a$ mysql -uUSER -pPASS XXXX <xxxx.sql

    ERROR 1064 at line 63266: 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 ''[ALIGN=CENTER]\r\n\r\nåáÇ Ýíß ÇÎæí áæÑäÓ\r\n\r\n\r\nÇá

    i'm tried some solutions without any result :mad:

    HOW CAN I FIX IT ??
     
    #1 alkaleej, May 22, 2004
  2. GeekPatrolMille

    GeekPatrolMille Well-Known Member

    Joined:
    Mar 12, 2004
    Messages:
    84
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    McKinney, Texas, USA
    I am guessing you can simply log in to the mySQL server by leaving the redirect off...

    $ mysql -uUSER -pPASS XXXX

    If this gives you the mySQL> prompt then you know it is not a login issue which I do not think you are having but want to clear the issue just in case.

    If this works then you know the problem is going to be in the xxxx.sql file being used on the command line.

    You could also try to import the xxxx.sql file via phpMyAdmin through a web browser instead of the command line. The only issue with this option will be the file size. I think 50MB is the limit for the phpMyAdmin method and a really fast connection.

    Hop this helps you in some way or another...
    -greg
     
    #2 GeekPatrolMille, May 22, 2004
(You must log in or sign up to post here.)
Loading...
Similar Threads - URGENT Error Please
  1. avanticreativos

    New Thread Unknown storage engine 'InnoDB' error

    avanticreativos, Jun 25, 2017 at 11:06 PM, in forum: Database Discussions
    Replies:
    0
    Views:
    1
    avanticreativos
    Jun 25, 2017 at 11:06 PM
  2. morrow95

    New Thread Upgraded to EA4 - error with multiPHP Manager when changing php version

    morrow95, Jun 25, 2017 at 12:19 AM, in forum: EasyApache
    Replies:
    3
    Views:
    43
    morrow95
    Jun 25, 2017 at 11:54 PM
  3. cachout58

    Dovecot error after recent kernel update for CVE-2017-1000364

    cachout58, Jun 23, 2017 at 12:01 PM, in forum: E-mail Discussions
    Replies:
    3
    Views:
    121
    cachout58
    Jun 23, 2017 at 10:26 PM
  4. angelOswap

    autoresponder send error message

    angelOswap, Jun 23, 2017 at 10:57 AM, in forum: E-mail Discussions
    Replies:
    1
    Views:
    35
    cPanelMichael
    Jun 23, 2017 at 11:04 AM
  5. neekfenwick

    Installed Imagick error class 'Imagick' not found

    neekfenwick, Jun 23, 2017 at 6:37 AM, in forum: EasyApache
    Replies:
    2
    Views:
    60
    neekfenwick
    Jun 23, 2017 at 10:30 PM

Share This Page