Hints on import big sql 50GB above to MariaDB or MySQL

MySQL /

Access to MySQL You have to be root to set those settings # mysql -u root -p Maximize all Buffer and Packet Set network buffer length to a large byte number and set maximum allowed packet size to a large byte number set global net_buffer_length=1048576; set global max_allowed_packet=1073741824; SET foreign_key_checks = 0; SET UNIQUE_CHECKS = 0; SET AUTOCOMMIT = 0; Import your SQL file Import your sql dump file, you can import more than one file source file-to-import.sql; Set back to default Reme[…]

Hints on import big sql 50GB above to MariaDB or MySQL Read More »

Unauthorized dropDatabase in MangoDB

MongoDB /

Normally when you want to drop a database in MongoDB, you just need these command. > use mydatabase; switched to db mydatabase > db.dropDatabase(); Error message with Unauthorized But when you see this error, it mean you are not authorized and not enough level access to run the command. Drop database in MongoDB, you need MongoDB root role. { “ok” : 0, “errmsg” : “not authorized on mydatabase to execute command { dropDatabase: 1.0, writeConcern: { w: \”majority\”, wtimeout: 600000.0 }, lsid[…]

Unauthorized dropDatabase in MangoDB Read More »