🙈🙉🙊

im creating the following table in mysql 5.7.44: CREATE TABLE `test_max_row_size` ( `log_counter` int NOT NULL AUTO_INCREMENT, `insert_date` datetime NOT NULL, `log_desc...

im getting this warning in mysql 8 after upgrade: [InnoDB] Cannot add field in table because after adding it, the row size is 8789 which is greater than maximum allowed size (...

can i point mysql datafile to multiple directories? in EC2 max size is 16TB and very almost there

Hi, I installed mysql 8 like this: wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.11-1_all.deb sudo dpkg -i mysql-apt-config_0.8.11-1_all.deb sudo apt-get install mysq...

Hi there, regard migrate mysql from windows to linux -> we're having some issues to mount the drive into linux (15TB disk) due to filesystem issues im trying to create the db ...

is it possible to create a replica from a working mysql without dump-restore / snapshot of disk / Xtrabackup? Like connecting a fresh instance to master and replicate all the ...

Hope someone can help: I stopped mysql (which is replica) and copied the datafiles to another machine, but i didn't take note of the binlog/position . if i run start replica o...

i have mysql master with 3 replicas in windows with lot of data (10-20 terabyte), we want to move to linux. how should i do that?

Anyone knows how to use mysqldump to dump: CREATE TABLE (without indexes), then INSERT INTO TABLE, then CREATE INDEX?

does someone has tutorial how to upgrade mysql 5.6 to 8 when it's replication (master+slave)? should i first upgrade 1 slave to 5.7 then have another slave of 5.7 to this 5.7 ...

is it possible to create mysql replica from zero? without dump/restore or snapshot?

Yeah I understand that this might not work but worth the try :) Just to understand - You stop winslave3 —> export structure,tables(1by1) from winslave3 —> import in linslave1 ...

Anybody knows how to export table from mysql to mysql? I know Dbeaver has such option but i don't know how it's done

is anyone ever created a replica using mysqlpump? i know mysqldump has the option for --master-data but couldn't find anything like this in pump

Я перехожу с Windows на Linux. Какое значение теперь должно быть у lower_case_table_names?

i dump data like the following: FIELDS TERMINATED BY '~' ENCLOSED BY '' ESCAPED BY '' LINES TERMINATED BY '\n' but when i have string column that has '~' inside it the whole l...

i have table that looks like this ``` CREATE TABLE public.vendor_category ( vendor_category_id serial4 NOT NULL, vendor_id int4 NULL, category_id int4 NULL, vendor_catego...

i have a list of 800k id’s that I need to update a single column for each of them? what’s the best approach doing this? create 800k update statments and run them? update table...

I tried to run dump on my replica (running on GCP) but I got this error - mysqldump: Couldn't execute 'SHOW FIELDS FROM `view_active_opportunities`': SELECT command denied t...

ok ok so the only reason taking winslave3 off (stop slave) is to reduce load and make sure this node is safe?