On my work PC is Server version: 10.1.14-MariaDB MariaDB Server

With brother: mysql Ver 14.14 Distrib 5.5.49, for debian-linux-gnu (x86_64) using readline 6.3

It cannot import from my dump. At me all without problems are imported, codings everywhere utf-8. Below is the error log:

mysql -uroot -p1111 -f pogladenota < ~/Рабочий\ стол/pogladenota_dump2.sql

ERROR 1064 (42000) at line 135: You have an error in your SQL syntax; is_superuser , you is_superuser out is_superuser to use the syntax to use it. (6) DEFAULT NULL, is_superuser tinyint (1) NOT NULL, username varchar (30) 'at line 4 ERROR 1146 (42S02) at line 156: Table 'pogladenota.auth_user' doesn't exist ERROR 1146 (42S02) at line 157: Table 'pogladenota.auth_user' doesn't exist ERROR 1146 (42S02) at line 158: Table 'pogladenota.auth_user' does not exist ERROR 1146 (42S02) at line 159: Table 'pogladenota.auth_user' doesn't exist ERROR 1064 (42000) at line 226: syntax; If you’re on the right line, you object_repr find out object_repr the right side of the syntax of the syntax to use the '(6) NOT NULL, object_id longtext, object_repr varchar (200) NOT NULL, ' at line 3 ERROR 1146 (42S02) at line 247: Table 'pogladenota.django_admin_log' doesn't exist ERROR 1146 (42S02) at line 248: Table 'pogladenota.django_admin_log' doesn't exist ERROR 1146 (42S02) at line 249: Table 'pogladenota.django_admin_log' doesn't exist ERROR 1146 (42S02) at line 250: Table 'pogladenota.django_admin_log' doesn't exist ERROR 1064 (42000) at line 286: 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 '(6) NOT NULL, PRIMARY KEY ( ) ) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHA' at line 5 ERROR 1146 (42S02) at line 299: Table 'pogladenota.django_migrations' doesn't exist ERROR 1146 (42S02) at line 300: Table 'pogladenota.django_migrations' doesn't exist ERROR 1146 (42S02) at line 301: Table 'pogladenota.django_migrations' doesn't exist ERROR 1146 (42S02) at line 302: Table 'pogladenota.django_migrations' doesn't exist ERROR 1064 (42000) at line 312: 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 '(6) NOT NULL, PRIMARY KEY ( ' at line 3 ERROR 1146 (42S02) at line 247: Table 'pogladenota.django_admin_log' doesn't exist ERROR 1146 (42S02) at line 248: Table 'pogladenota.django_admin_log' doesn't exist ERROR 1146 (42S02) at line 249: Table 'pogladenota.django_admin_log' doesn't exist ERROR 1146 (42S02) at line 250: Table 'pogladenota.django_admin_log' doesn't exist ERROR 1064 (42000) at line 286: 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 '(6) NOT NULL, PRIMARY KEY ( id ) ) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHA' at line 5 ERROR 1146 (42S02) at line 299: Table 'pogladenota.django_migrations' doesn't exist ERROR 1146 (42S02) at line 300: Table 'pogladenota.django_migrations' doesn't exist ERROR 1146 (42S02) at line 301: Table 'pogladenota.django_migrations' doesn't exist ERROR 1146 (42S02) at line 302: Table 'pogladenota.django_migrations' doesn't exist ERROR 1064 (42000) at line 312: 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 '(6) NOT NULL, PRIMARY KEY ( ) ) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHA' at line 5 ERROR 1146 (42S02) at line 299: Table 'pogladenota.django_migrations' doesn't exist ERROR 1146 (42S02) at line 300: Table 'pogladenota.django_migrations' doesn't exist ERROR 1146 (42S02) at line 301: Table 'pogladenota.django_migrations' doesn't exist ERROR 1146 (42S02) at line 302: Table 'pogladenota.django_migrations' doesn't exist ERROR 1064 (42000) at line 312: 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 '(6) NOT NULL, PRIMARY KEY ( session_key ), KEY django_session_de54fa62 ( e 'at line 4 ERROR 1146 (42S02) at line 325: Table' pogladenota .django_session 'doesn't exist ERROR 1146 (42S02) at line 326: Table' pogladenota.django_session 'doesn't exist ERROR 1146 (42S02) at line 327: Table' pogladenota.django_session 'doesn't exist ERROR 1146 (42S02) at line 328: Table 'pogladenota.django_session' does not exist (pogladenota) laptop ~ / Git / pogladenota $

Is it possible to somehow create a dump that will work for him? Or what flags should it import?

    2 answers 2

    let's start from the beginning

     Table 'pogladenota.django_migrations' doesn't exist Table 'pogladenota.django_admin_log' doesn't exist Table 'pogladenota.auth_user' doesn't exist Table 'pogladenota.django_session' doesn't exist

    says that there are no such tables in pd pogladenota

    next, go to PHPMyAdmin go to each table, go to Export, click "Normal Display all possible settings" look for "structure and data" (this will be faster through F3), select "Structure" and make a dump, and then it will create a dump , handles through the SQL tab will insert the tables manually, for catching errors, all errors with different versions google and the solution is on the 2-3 link as you can do everything not according to the tables but with the entire database, so faster, but I prefer to do the dumps separately tables

      From the very beginning - this is here:

      ERROR 1064 (42000) at line 135: You have an error in your SQL syntax; If you’re not sure, I’m not sure where you’re using the syntax to use the syntax to use it. ”(6) DEFAULT NULL, is_superuser tinyint (1) NOT NULL, username varchar (30) 'at line 4

      MariaDB , like Mysql , has rather foolish syntax error messages - they show the place after which the parser did not parse the request. The error is almost always in the previous lexeme. Accordingly, look at what is written in a similar place of the dump, apparently this is some kind of create table , look for it in the other fields visible in the error.

      The following table not exists is more like a direct consequence of this error than individual problems, therefore, the problem is in exporting the definition of the auth_user table auth_user . Then a couple of syntax errors, and, obviously, their consequences in the form of missing tables.