Failure to import from dump in different versions of mysql



  • In my work PC, it's worth Server version: 10.1.14-MariaDB MariaDB Server

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

    He can't import from my dam. I don't have a problem importing, coding everywhere utf-8. Below is the log of mistakes:

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

    ERROR 1064 (42000) at line 135: 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) DEFAULT NULL, is_superuser tinyint(1) NOT NULL, username varchar(30)' at line 4 ERROR 1146 (42S02) at line 156: Table 'poglaota.auth_user' doesn't exist ERROR 1146 (42S02) at line 157: Table 'poglaota.auth_user' doesn't exist ERROR 1146 (42S02) at line 158: Table 'poglaota.auth_user' doesn't exist ERROR 1146 (42S02) at line 159: Table 'poglaota.auth_user' doesn't exist ERROR 1064 (42000) at line 226: 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, 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 (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 (session_key), KEYdjango_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' doesn't exist (pogladenota) laptop ~/Git/pogladenota $

    Is there any way we can create a Dump that works for him? Or what flags do he have to import?



  • Start at 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 there's no such tables in the bd pogladenota.

    We're going to PHPMyAdmin and we're going to every table, going to Export. We're pushing "The usual display of all possible settings." Looking for "structure and data." And then he, through the created Dump, hands through the SQL feed, will insert the tables manually, to make mistakes, different versions Google and decision is 2-3 reference It's also possible to do things differently from the tables, but with all the bells, it's faster, but I prefer to make dams separate tables.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2