Cannot import my sql-files anymore using phpmyadmin since 1 week
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:
================================================================================= Piece of copy of the sql-dump:
=================================================================================== Please need help! Thanks in advance, Kookidooki
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:
-- phpMyAdmin SQL Dump
-- version 4.0.5
-- [url=http://www.phpmyadmin.net]phpMyAdmin
--
-- 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
-
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. 0 -
[quote="cPanelMichael, post: 1546811">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.
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. Kookidooki0 -
Please try importing the database via the command line using the "mysql" utility to see if you experience different results. EX: mysql database_name < /path/to/file.sql
Thank you.0
Please sign in to leave a comment.
Comments
3 comments