Comments (9)
Please give more info:
- what version of MySQL you are using?
- what actions did you perform to run with InnoDB?
In version 5.6 and later, InnoDB is the default engine, so running mysql < employees.sql
would use InnoDB without additional action.
For older versions, you need to run explicitly
set global default_storage_engine="innodb";
from test_db.
UPDATE : I misread the question. The MyISAM
engine is only used explicitly in the two test files. However, its engine is immediately changed to memory
. Unless you are using MySQL earlier than 5.0.30, the test should work as expected.
from test_db.
Hi,
let me do this properly:
Server version: 8.0.21-u1-cloud MySQL Enterprise - Cloud
mysql -h 10.0.1.3 -u admin -p -t < test_employees_sha.sql
Enter password:
+----------------------+
| INFO |
+----------------------+
| TESTING INSTALLATION |
+----------------------+
ERROR 3161 (HY000) at line 38: Storage engine MEMORY is disabled (Table creation is disallowed).
mysql -h 10.0.1.3 -u admin -p -t < test_employees_md5.sql
Enter password:
+----------------------+
| INFO |
+----------------------+
| TESTING INSTALLATION |
+----------------------+
ERROR 3161 (HY000) at line 30: Storage engine MyISAM is disabled (Table creation is disallowed).
from test_db.
I created the employees DB using
mysql -h 10.0.1.3 -u admin -p < employees.sql
Enter password:
INFO
CREATING DATABASE STRUCTURE
INFO
storage engine: InnoDB
INFO
LOADING departments
INFO
LOADING employees
INFO
LOADING dept_emp
INFO
LOADING dept_manager
INFO
LOADING titles
INFO
LOADING salaries
data_load_time_diff
00:01:23
from test_db.
(of note, since I am using OCI MySQLaaS the OCI user created doesn't have RELOAD privileges, so employees.sql fails at line 110. Once I commented this out it ran just fine)
from test_db.
Thanks for the details.
I have changed the test files to not use specific engines, and added a test to make sure it works with all MySQL versions from 5.0 to 8.0.
Regarding the RELOAD privilege, I left line 110 in place because I know of at least one workflow where it is desirable to have the binary log of the schema definition separated from the data loading.
from test_db.
I am putting this in the same issue (I can't reopen this one):
mysql -h 10.0.1.3 -u admin -p -t < test_employees_sha.sql
Enter password:
+----------------------+
| INFO |
+----------------------+
| TESTING INSTALLATION |
+----------------------+
+--------------+------------------+------------------------------------------+
| table_name | expected_records | expected_crc |
+--------------+------------------+------------------------------------------+
| departments | 9 | 4b315afa0e35ca6649df897b958345bcb3d2b764 |
| dept_emp | 331603 | d95ab9fe07df0865f592574b3b33b9c741d9fd1b |
| dept_manager | 24 | 9687a7d6f93ca8847388a42a6d8d93982a841c6c |
| employees | 300024 | 4d4aa689914d8fd41db7e45c2168e7dcb9697359 |
| salaries | 2844047 | b5a1785c27d75e33a4173aaa22ccf41ebd7d4a9f |
| titles | 443308 | d12d5f746b88f07e69b9e36675b6067abb01b60e |
+--------------+------------------+------------------------------------------+
ERROR 3161 (HY000) at line 56: Storage engine BLACKHOLE is disabled (Table creation is disallowed).
from test_db.
Removed also blackhole engine. It seems that the Cloud edition is aiming to breaking more backward compatibility ...
from test_db.
Thanks, employees.sql, test_employees_md5.sql, and test_employees_sha.sql all work on my OCI based https://docs.cloud.oracle.com/en-us/iaas/mysql-database/
Server version: 8.0.21-u1-cloud MySQL Enterprise - Cloud
from test_db.
Related Issues (20)
- Execution stoped HOT 1
- Access/permissions rights denied HOT 1
- Illegal mix of collations HOT 5
- Loading employees.sql requires undocumented RELOAD privilege HOT 1
- Script execution failed
- As an HR advisor I want to produce a report on the salary of employees in a department so that I can support financial reporting of the organisation. HOT 1
- As an department manager I want to produce a report on the salary of employees in my department so that I can support financial reporting for my department. HOT 1
- Database Scehma is incompatible with Sqlboiler HOT 1
- primary keys for dept_manager and dept_emp are too strict HOT 3
- im a newbee HOT 2
- specifying column orders for .dump files HOT 6
- Inserting data on employees table HOT 1
- Test_db
- What is mean of more than one primary key in table HOT 2
- Replacing the deprected 'source' in employees.sql HOT 8
- Resest HOT 1
- Bases de datos
- corrupted salary files, script is buggy HOT 1
- ERROR at line 113: Failed to open file 'load_departments.dump', error: 2 HOT 7
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from test_db.