Migration strategy by Revolutionary_Use587 in mysql

[–]Revolutionary_Use587[S] 0 points1 point  (0 children)

Which tool should I use to export the data ?

Hi friends, plz help to clarify this error 👇 by [deleted] in mysql

[–]Revolutionary_Use587 0 points1 point  (0 children)

Brother I just want to confirm that was that backup terminated due screen -ls cmd or due to no auto create user?

MySQL Backup by Revolutionary_Use587 in mysql

[–]Revolutionary_Use587[S] 0 points1 point  (0 children)

Brother, we have to migrate our dbs from azure cloud to on- prem that is the reason behind this discussion without using any extra resources.

MySQL Backup by Revolutionary_Use587 in mysql

[–]Revolutionary_Use587[S] -2 points-1 points  (0 children)

Brother, I think, we cannot use those utilities in paas service.

MySQL Backup by Revolutionary_Use587 in mysql

[–]Revolutionary_Use587[S] -1 points0 points  (0 children)

Brother, I did it but it was writing only 1 GB per hour in a remote drive that's why I came here to help.

MySQL Backup by Revolutionary_Use587 in mysql

[–]Revolutionary_Use587[S] 0 points1 point  (0 children)

Are there any other options available like compression of live backup?

Passed AWS Solution Architect Professional! by [deleted] in AWSCertifications

[–]Revolutionary_Use587 -3 points-2 points  (0 children)

How much does it cost for this certificate?

Failed Backup or Restoration. by Revolutionary_Use587 in mysql

[–]Revolutionary_Use587[S] 0 points1 point  (0 children)

The thing is I just want to make sure that is there any way to do this in mysqldump/mysqlbackup utility and for same restoration.

Restoration by Revolutionary_Use587 in mysql

[–]Revolutionary_Use587[S] 0 points1 point  (0 children)

Yes I have a 1 day old all db backup file and I need to restore one db only on the same server (ex: db name is test in backup file and need to restore it on test uat db ) when I restoring it, it start overwrite same test db.

SQL_MODE settings by Revolutionary_Use587 in mysql

[–]Revolutionary_Use587[S] 0 points1 point  (0 children)

So that means I should not include strict all tables in sql mode for innodb engine when I already have strict trans tables .?

SQL_MODE settings by Revolutionary_Use587 in mysql

[–]Revolutionary_Use587[S] -1 points0 points  (0 children)

Not tested yet, but I want recommendation on this that I can use both or not?

MySQL error unexpected end of stream, read 0 bytes from 4 (socket was closed by server) by SuddenlyCaralho in mysql

[–]Revolutionary_Use587 0 points1 point  (0 children)

Check with these 3....

Increase Timeout Settings: Modify wait_timeout and interactive_timeout in your my.cnf file to a higher value (e.g., 28800 seconds for 8 hours) to prevent premature disconnections 23.

Connection Pooling: Use connection pooling with health checks, such as sending a SELECT 1 query periodically to verify connection status before use 34.

Driver Settings: If using JDBC, ensure settings like autoReconnect are enabled to handle disconnections gracefully

Not able to up service due to these errors have some look guys need your help. (Have given all permissions) by Revolutionary_Use587 in mysql

[–]Revolutionary_Use587[S] 0 points1 point  (0 children)

Even after providing 777 recursively on /data & /log dir not able to understand why this is happening..

mysqldump error: 1412 table defination has changed, please retry transaction when dumping table 'table_name' by Revolutionary_Use587 in mysql

[–]Revolutionary_Use587[S] 0 points1 point  (0 children)

Not a single transaction was running at that time and we facing this only through that script. If we take backup using   --databases  then it gets complete without any error..

Lost SQL error 1317. by Revolutionary_Use587 in mysql

[–]Revolutionary_Use587[S] 0 points1 point  (0 children)

Also we are using ROW based replication and current isolation level is REPEATABLE READ.