[go: up one dir, main page]
Menu ▾ ▴

#35 Re-test DB migration with endpoints

QMRF Editor 2.0.0
closed
Luchesar ILIEV
None
2012-05-14
2012-05-08
Luchesar ILIEV
No

Re-test the DB migration with endpoints.

Discussion

  • Luchesar ILIEV

    Luchesar ILIEV - 2012-05-12

    Testing with freshly downloaded SQL files from the SVN repository:

    mysql> drop database qmrf;
Query OK, 14 rows affected (0.16 sec)

mysql> create database qmrf character set utf8;
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL ON qmrf.* TO 'guest'@'localhost';
Query OK, 0 rows affected (0.01 sec)

mysql> use qmrf;
Database changed
mysql> source /tmp/qmrf.sql;
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.01 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 1 row affected (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

mysql> source /tmp/migrate.sql;
Database changed
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.02 sec)

Query OK, 60 rows affected (0.01 sec)
Records: 60  Duplicates: 0  Warnings: 0

Query OK, 39 rows affected (0.01 sec)
Records: 39  Duplicates: 0  Warnings: 0

Query OK, 121 rows affected (0.02 sec)
Records: 121  Duplicates: 0  Warnings: 0

Query OK, 160 rows affected (0.01 sec)
Records: 160  Duplicates: 0  Warnings: 0

Query OK, 157 rows affected (0.21 sec)
Records: 157  Duplicates: 0  Warnings: 0

Query OK, 70 rows affected (0.02 sec)
Records: 70  Duplicates: 0  Warnings: 0

Query OK, 157 rows affected (0.51 sec)
Records: 157  Duplicates: 0  Warnings: 0

Query OK, 276 rows affected (0.06 sec)
Records: 277  Duplicates: 1  Warnings: 0

Query OK, 28 rows affected (0.01 sec)
Rows matched: 276  Changed: 28  Warnings: 0

ERROR 1064 (42000): 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
ERROR 1064 (42000): 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
mysql>

    • status: accepted --> open

    • status: open --> accepted

     

  • Luchesar ILIEV

    Luchesar ILIEV - 2012-05-13

    Testing with the fixed files from trunk:

    mysql> drop database qmrf;
Query OK, 14 rows affected (0.59 sec)

mysql> create database qmrf charset utf8;
Query OK, 1 row affected (0.01 sec)

mysql> GRANT ALL ON qmrf.* TO 'guest'@'localhost';
Query OK, 0 rows affected (0.09 sec)

mysql> use qmrf;
Database changed
mysql> source /tmp/qmrf.sql;
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 1 row affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> source /tmp/migrate.sql;
Database changed
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.01 sec)

Query OK, 60 rows affected (0.10 sec)
Records: 60  Duplicates: 0  Warnings: 0

Query OK, 39 rows affected (0.02 sec)
Records: 39  Duplicates: 0  Warnings: 0

Query OK, 121 rows affected (0.02 sec)
Records: 121  Duplicates: 0  Warnings: 0

Query OK, 160 rows affected (0.02 sec)
Records: 160  Duplicates: 0  Warnings: 0

Query OK, 157 rows affected (0.28 sec)
Records: 157  Duplicates: 0  Warnings: 0

Query OK, 70 rows affected (0.07 sec)
Records: 70  Duplicates: 0  Warnings: 0

Query OK, 157 rows affected (0.49 sec)
Records: 157  Duplicates: 0  Warnings: 0

Query OK, 276 rows affected (0.30 sec)
Records: 277  Duplicates: 1  Warnings: 0

Query OK, 28 rows affected (0.13 sec)
Rows matched: 276  Changed: 28  Warnings: 0

ERROR: 
Failed to open file 'template.sql', error: 2
ERROR: 
Failed to open file 'dictionary.sql', error: 2
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql>
     

  • Luchesar ILIEV

    Luchesar ILIEV - 2012-05-13

    When template.sql and dictionary.sql are downloaded as well:

    mysql> drop database qmrf;
Query OK, 0 rows affected (0.00 sec)

mysql> create database qmrf charset utf8;
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL ON qmrf.* TO 'guest'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> use qmrf;
Database changed
mysql> source /tmp/qmrf.sql;
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.04 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.04 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 1 row affected (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> source /tmp/migrate.sql;
Database changed
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.02 sec)

Query OK, 60 rows affected (0.01 sec)
Records: 60  Duplicates: 0  Warnings: 0

Query OK, 39 rows affected (0.01 sec)
Records: 39  Duplicates: 0  Warnings: 0

Query OK, 121 rows affected (0.02 sec)
Records: 121  Duplicates: 0  Warnings: 0

Query OK, 160 rows affected (0.02 sec)
Records: 160  Duplicates: 0  Warnings: 0

Query OK, 157 rows affected (0.19 sec)
Records: 157  Duplicates: 0  Warnings: 0

Query OK, 70 rows affected (0.01 sec)
Records: 70  Duplicates: 0  Warnings: 0

Query OK, 157 rows affected (0.50 sec)
Records: 157  Duplicates: 0  Warnings: 0

Query OK, 276 rows affected (0.03 sec)
Records: 277  Duplicates: 1  Warnings: 0

Query OK, 28 rows affected (0.01 sec)
Rows matched: 276  Changed: 28  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 355 rows affected (0.02 sec)
Records: 355  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 556 rows affected (0.02 sec)
Records: 556  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 141 rows affected (2.73 sec)
Records: 141  Duplicates: 0  Warnings: 0

Query OK, 16 rows affected (0.04 sec)
Records: 16  Duplicates: 0  Warnings: 0

mysql>
     

  • Luchesar ILIEV

    Luchesar ILIEV - 2012-05-13

    Conclusion: The fact that dictionary.sql and template.sql need to be in the same directory as migrate.sql should be expressed in the manual.

     

  • Luchesar ILIEV

    Luchesar ILIEV - 2012-05-14

    All problems are solved now.

    • Description has changed:

    Diff:

    --- old 
+++ new 
@@ -1,1 +1,1 @@
-Re-test DB migration with endpoints
+Re-test the DB migration with endpoints.
     

  • Luchesar ILIEV

    Luchesar ILIEV - 2012-05-14
    • status: accepted --> closed
     

Log in to post a comment.