[DiscordArchive] mysqldump: Got error: 1114: The table '/tmp/#sq...
[DiscordArchive] mysqldump: Got error: 1114: The table '/tmp/#sq...
Original source
rektbyfaith
01-05-2025, 01:48 PM #1Archived author: Needle • Posted: 2025-01-05T13:48:03.002000+00:00
Original source
Original source
Thread automatically created by M'dic V in <#415944535718494208>
rektbyfaith
01-05-2025, 01:48 PM #2Archived author: Needle • Posted: 2025-01-05T13:48:03.523000+00:00
Original source
Thread automatically created by M'dic V in <#415944535718494208>
Original source
If they are getting massive try increasing the tmp file sizes :
```SET GLOBAL tmp_table_size = 256M;
SET GLOBAL max_heap_table_size = 256M;```
rektbyfaith
01-05-2025, 01:56 PM #3Archived author: Deleted User • Posted: 2025-01-05T13:56:48.506000+00:00
Original source
If they are getting massive try increasing the tmp file sizes :
```SET GLOBAL tmp_table_size = 256M;
SET GLOBAL max_heap_table_size = 256M;```
Original source
Might be worth checking what huge queries you or doing or optimize them
rektbyfaith
01-05-2025, 01:57 PM #4Archived author: Deleted User • Posted: 2025-01-05T13:57:06.925000+00:00
Original source
Might be worth checking what huge queries you or doing or optimize them
Original source
Alternatively don't use LOCK TABLES and use :
```START TRANSACTION;
-- code here
COMMIT;```
rektbyfaith
01-05-2025, 01:58 PM #5Archived author: Deleted User • Posted: 2025-01-05T13:58:21.799000+00:00
Original source
Alternatively don't use LOCK TABLES and use :
```START TRANSACTION;
-- code here
COMMIT;```
Original source
Where do I put this?
rektbyfaith
01-05-2025, 04:51 PM #6Archived author: RektByFaith • Posted: 2025-01-05T16:51:38.345000+00:00
Original source
Where do I put this?
Original source
I tried to set this, but just said
Query OK, 0 rows affected (0.00 sec)
and seems it didn't do much of a change
rektbyfaith
01-05-2025, 04:52 PM #7Archived author: RektByFaith • Posted: 2025-01-05T16:52:12.648000+00:00
Original source
I tried to set this, but just said
Query OK, 0 rows affected (0.00 sec)
and seems it didn't do much of a change
Original source
Is this a mysql export? Need more context
rektbyfaith
01-05-2025, 05:05 PM #8Archived author: Deleted User • Posted: 2025-01-05T17:05:31.755000+00:00
Original source
Is this a mysql export? Need more context
1 Guest(s)
1 Guest(s)