Commit graph

10 commits

Author SHA1 Message Date
Ocean Li
eedbb901e5 [MDEV-14978] Client programs to use $MARIADB_HOST consistently
Only `mysql` client program was using $MYSQL_HOST as the default host.
Add the same feature in most other client programs but using
$MARIADB_HOST instead.

All new code of the whole pull request, including one or several files that are
either new files or modified ones, are contributed under the BSD-new license. I
am contributing on behalf of my employer Amazon Web Services, Inc.
2024-10-04 06:44:39 +01:00
Vladislav Vaintroub
45d99ea105 Workaround MDEV-34890 2024-09-12 17:36:54 +02:00
Vladislav Vaintroub
7fd73f9ac9 mariadb-import, multithreading - improve error handling
In case of error in one connection, issue KILL CONNECTION for all others,
or server will still do LOAD FILE, possibly for hours, after we exited.
2024-09-12 17:36:44 +02:00
Vladislav Vaintroub
19cea73834 Cleanup - make sure all members of table_load_params are initialized
Alexey Botchkov complains there are problems with empty curly brackets
initializer in old-ish gcc(4.9)

Can't verify, but making all members are initialized by
default constructor is easy enough.
2024-09-05 13:24:22 +02:00
Oleksandr Byelkin
492a7c2430 Merge branch '11.5' into 11.6 2024-08-21 15:13:47 +02:00
Vladislav Vaintroub
ff865b088f MDEV-34741 - remove LOCK TABLE from mariadb-import
It currently serves no real purpose, but is suspected to cause occasional
error when foreign keys are used.
"Error: 1100, Table 'child' was not locked with LOCK TABLES, when using table: parent"
as seen on CI
2024-08-12 21:30:32 +02:00
Vladislav Vaintroub
c175f4988a Disable innodb bulk load, because of MDEV-34703 2024-08-05 11:52:26 +02:00
Vladislav Vaintroub
9e25d6f0cc MDEV-33627 : Implement option --dir in mariadb-import
With that, it is possible to restore the full "instance" from a backup
made with mariadb-dump --dir

The patch implements executing DDL (tables, views, triggers) using
statements that are stored in .sql file, created by mariadb-dump
--dir .

Care is taken of creating triggers correctly after the data is loaded,
disabling foreign keys and unique key checks etc.

The files are loaded in descending order by datafile size -
to ensure better work distribution when running with --parallel option.

In addition to --dir option, following options are implemented for
partial restore

include-only options:
--database             -  import one or several databases
--table                -  import one or several tables

exclude options:
--ignore-database      -. ignore one or several databases when importing
--ignore-table         -  to ignore one or several tables when importing

All options above are only valid together with --dir option,
and can be specified multiple times.
2024-07-16 15:16:29 +02:00
Vladislav Vaintroub
04988d87aa MDEV-33627 refactor threading in mariadb-import
Use threadpool, instead of one-thread-and-connection-per-table
2024-07-16 15:14:28 +02:00
Vladislav Vaintroub
59167c567b MDEV-33627 preparation - compile mysqlimport as C++ 2024-07-16 14:56:01 +02:00
Renamed from client/mysqlimport.c (Browse further)