1

Topic: Import error.sql a file at change of the domain in a file

Hello dear participants of a forum. Prompt what to do please? At me is  a DB. I only changed a domain name in  by means of the text editor and now it is imported with errors and not completely. If not to change that of errors will not be. What to do?

2

Re: Import error.sql a file at change of the domain in a file

DOLG wrote:

Hello dear participants of a forum. Prompt what to do please? At me is  a DB. I only changed a domain name in  by means of the text editor and now it is imported with errors and not completely. If not to change that of errors will not be. What to do?

>> what to do?
Certainly it is necessary to rectify an error.

3

Re: Import error.sql a file at change of the domain in a file

But how? Errors that are not present - I simply changed a domain name - with http://site.ru on http://sites.ru javajdbc,

4

Re: Import error.sql a file at change of the domain in a file

DOLG wrote:

but how? Errors that are not present - I simply changed a domain name - with http://site.ru on http://sites.ru javajdbc,

...You  give information for what or council...
...That for a file. Whence, show the first 10 lines and
That place which is is specific changed...
...How you load?
...What it is not pleasant to you by result?
...The basis version

5

Re: Import error.sql a file at change of the domain in a file

**

6

Re: Import error.sql a file at change of the domain in a file

javajdbc, here the first lines short of  a fragment -
[spoiler] DROP TABLE IF EXISTS ` dle_admin_logs `;
/ *! 40101 SET @saved_cs_client = @@ character_set_client */;
/ *! 40101 SET character_set_client = utf8 */;
CREATE TABLE ` dle_admin_logs ` (
` id ` int (11) NOT NULL AUTO_INCREMENT;
` name ` varchar (40) NOT NULL DEFAULT ";
` date ` int (11) unsigned NOT NULL DEFAULT ' 0 ';
` ip ` varchar (40) NOT NULL DEFAULT ";
` action ` int (11) NOT NULL DEFAULT ' 0 ';
` extras ` text NOT NULL;
PRIMARY KEY (` id `);
KEY ` date ` (` date `)
) ENGINE=MyISAM AUTO_INCREMENT=19529 DEFAULT CHARSET=utf8;
/ *! 40101 SET character_set_client = @saved_cs_client */;
[/spoiler]
And here where we change the code - there I change only the domain address
[spoiler] LOCK TABLES ` dle_admin_logs ` WRITE;
/ *! 40000 ALTER TABLE ` dle_admin_logs ` DISABLE KEYS */;
INSERT INTO ` dle_admin_logs ` VALUES (1, ' admin1980 ', 1460213235, ' 95.83.33.14 ', 86, ' http://impalainc.ru/index.php? '), [/spoiler]
I load through phpmyadmin
Some lines (nearby 6-7) are imported only
The basis version - libmysql - mysqlnd 5.0.12-dev - 20150407

7

Re: Import error.sql a file at change of the domain in a file

DOLG wrote:

it is imported with errors and not completely

What was specific errors? Whether is at import any error messages?

DOLG wrote:

I load through phpmyadmin

Through  the console client mysql tried?

DOLG wrote:

some lines are imported only (nearby 6-7)

Show more precisely a problem place on which import is cut down.

8

Re: Import error.sql a file at change of the domain in a file

The text of an error what?

DOLG wrote:

5.0.12

irrespectively all a topic - why such antiquity?  (2005) a branch and even in it it yet release, and the beta version.

9

Re: Import error.sql a file at change of the domain in a file

miksoft;
Here the such
[spoiler]
Static analysis:
7 errors are found at the analysis.
The unexpected beginning of expression. (near "MySQL" at position 0)
The unexpected beginning of expression. (near "dump" at position 6)
The unexpected beginning of expression. (near "10.13" at position 11)
The unexpected beginning of expression. (near "Distrib" at position 18)
The unexpected beginning of expression. (near "5.5" at position 26)
The unexpected beginning of expression. (near ".34" at position 29)
Unrecognized statement type. (near "for" at position 34)
SQL request:
MySQL dump 10.13 Distrib 5.5.34, for Linux (x86_64) - - Host: 10.0.2.15 Database: a160837_kinozall------------------------------------------------------- - Server version 5.5.34-32.0-log / *! 40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
Answer MySQL: the Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' MySQL dump 10.13 Distrib 5.5.34, for Linux (x86_64)
--
-- Host: 10.0.2.15 Da ' at line 1
[/spoiler]

10

Re: Import error.sql a file at change of the domain in a file

DOLG wrote:

SQL request:
MySQL dump 10.13 Distrib 5.5.34, for Linux (x86_64) -

It is the comment should be. In the beginning "-" were lost?

11

Re: Import error.sql a file at change of the domain in a file

vkle, commented out but all the same produces an error at import

12

Re: Import error.sql a file at change of the domain in a file

DOLG wrote:

Server version 5.5.34-32.0

about, here it is more similar to truth. Though all the same old cotton wool.

13

Re: Import error.sql a file at change of the domain in a file

DOLG wrote:

all the same produces an error at import

On the same place or on other?
Yes, from here it is completely not visible neither the error text, nor that text on which import stumbles. It is difficult to advise something so... The Gap after "-" precisely is?

14

Re: Import error.sql a file at change of the domain in a file

vkle;
Yes there is a gap.
It is all text of an error that produces.

15

Re: Import error.sql a file at change of the domain in a file

DOLG;
Yes that you so persistently pretend to be the guerrilla, in the childhood in  did not play enough? ;-)
Show a problem piece of a file and show the error text.

16

Re: Import error.sql a file at change of the domain in a file

vkle;
I in a spoiler thrust simply an error here -
And that  a file of basis that it simply large on 75 and on all basis this ill-fated  is present
.................................
Static analysis:
7 errors are found at the analysis.
The unexpected beginning of expression. (near "MySQL" at position 0)
The unexpected beginning of expression. (near "dump" at position 6)
The unexpected beginning of expression. (near "10.13" at position 11)
The unexpected beginning of expression. (near "Distrib" at position 18)
The unexpected beginning of expression. (near "5.5" at position 26)
The unexpected beginning of expression. (near ".34" at position 29)
Unrecognized statement type. (near "for" at position 34)
SQL request:
MySQL dump 10.13 Distrib 5.5.34, for Linux (x86_64) - - Host: 10.0.2.15 Database: a160837_kinozall------------------------------------------------------- - Server version 5.5.34-32.0-log / *! 40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */
Answer MySQL: the Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' MySQL dump 10.13 Distrib 5.5.34, for Linux (x86_64)
--
-- Host: 10.0.2.15 Da ' at line 1
-----------------------------------------

17

Re: Import error.sql a file at change of the domain in a file

Well to you already told:.

18

Re: Import error.sql a file at change of the domain in a file

DOLG;
Well, continue to hide persistently... More I will Not insist.

19

Re: Import error.sql a file at change of the domain in a file

vkle;
Then I do not understand that else from me is necessary

20

Re: Import error.sql a file at change of the domain in a file

DOLG;
Which word caused problems with understanding?

vkle wrote:

Show a problem piece of a file

DOLG wrote:

on all basis this ill-fated  is present

At the error report there are no hints on this yours .

21

Re: Import error.sql a file at change of the domain in a file

Than correct a file?
Probably, the editor adds line foldings, or damages long lines.
As import starts to swear before reaches till a corrected line, your method of editing means damages a file format.

22

Re: Import error.sql a file at change of the domain in a file

NIK.2017;
Normal notepad. I did not think at all of it. Thanks
The moderator: I ask to track the lexicon

23

Re: Import error.sql a file at change of the domain in a file

Wildly I apologize for a subject for I  and did not know as correctly to make. Huge gratitude to companion NIK.2017
Yes business was in the editor and notepad ++ helped. I would not guess