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.

Cannot import my sql-files anymore using phpmyadmin since 1 week

Discussion in 'Database Discussions' started by Kookidooki, Jan 10, 2014.

  1. Kookidooki

    Kookidooki Registered

    Joined:
    Jan 10, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Hey guys,

    Specs:
    Hosting provider: Inmotionhosting.com
    cPanel Version 11.38.2
    MySQL version 5.5.32-cll

    Problem: cannot import sql-files anymore using phpmyadmin since 1 week. It's throwing the following errors:

    Code:
    Error There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below: ----BEGIN CUT---- eNo1zbEKwjAYBGCh2/8U9wAxNKlByBZKqEKaxKRWcBWHQskm6NubCt54fNzZlELS6AV6CWe9hoCE EJSnWjdE4ydfnIbiindy/1hXuuaEkBnMYP3EMNsKb0vBGO5n50ylLcXRaBx4yxXFU9wMC3lb6bg4 wi3l9SZn/KDxLPQ7oGb3zxcWUiEE ----END CUT---- ----BEGIN RAW---- ERROR: C1 C2 LEN: 1 2 11 STR: MySQL: 5.5.32-cll USR OS, AGENT, VER: Win MOZILLA 5.0 PMA: 4.0.5 PHP VER,OS: 5.3.17 Linux LANG: en SQL: ----END RAW---- SQL query: MySQL said: Documentation #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 ' ' at line 1 
    
    =================================================================================

    Piece of copy of the sql-dump:

    Code:
    -- phpMyAdmin SQL Dump
    -- version 4.0.5
    -- [url=http://www.phpmyadmin.net]phpMyAdmin[/url]
    --
    -- Host: localhost
    -- Generation Time: Jan 03, 2014 at 02:07 AM
    -- Server version: 5.5.32-cll
    -- PHP Version: 5.3.17
    
    SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
    SET time_zone = "+00:00";
    
    
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    ===================================================================================

    Please need help!

    Thanks in advance,
    Kookidooki
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Your access level is listed as "Website Owner". This indicates you do not have root access to the server. I suggest reporting this problem to your hosting provider so they can review the database dump and the logs on the server to determine why it's failing to import via phpMyAdmin.

    Thank you.
     
  3. Kookidooki

    Kookidooki Registered

    Joined:
    Jan 10, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Hello Michael,

    Thank you for replying.

    I do have complete control over my cpanel account with Inmotionhosting.com and also have access to my root and all my databases as a VPS-user, but the problem persist: problems at line 1, etc. See codes above.

    Any idea / suggestions?

    Thank you for your help.

    Kookidooki
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Please try importing the database via the command line using the "mysql" utility to see if you experience different results. EX:

    Code:
    mysql database_name < /path/to/file.sql
    Thank you.
     
Loading...

Share This Page