Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

URGENT !!! My SQL Error - Please

Discussion in 'Database Discussion' 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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 GeekPatrolMille, May 22, 2004
(You must log in or sign up to post here.)
Loading...
Similar Threads - URGENT Error Please
  1. segun_nira

    Urgent need to Recover mistakenly deleted files

    segun_nira, Jul 24, 2017, in forum: E-mail Discussion
    Replies:
    7
    Views:
    1,241
    24x7server
    Jul 25, 2017
  2. cPanelBenny

    Urgent DCV Updates

    cPanelBenny, Jul 10, 2017, in forum: cPanel Announcements
    Replies:
    3
    Views:
    5,133
    linux4me2
    Jul 20, 2017
  3. lahmar amine

    New Thread mysql error

    lahmar amine, Nov 17, 2018 at 3:56 PM, in forum: Database Discussion
    Replies:
    0
    Views:
    31
    lahmar amine
    Nov 17, 2018 at 3:56 PM
  4. mehdix92

    New Thread Strange Error Terminal for accounts

    mehdix92, Nov 16, 2018 at 11:04 AM, in forum: General Discussion
    Replies:
    0
    Views:
    34
    mehdix92
    Nov 16, 2018 at 11:04 AM
  5. cPanelAlex

    SOLVED [Defect] MySQL Connection Failures and 500 Errors; CloudLinux + Imunify360

    cPanelAlex, Nov 15, 2018 at 6:45 AM, in forum: General Discussion
    Replies:
    2
    Views:
    552
    HostXNow_Chris
    Nov 15, 2018 at 12:17 PM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice