create table t1 (pk int primary key, a int)
;
insert into t1 values (
1 ,
1 ),(
2 ,
2 ),(
3 ,
3 ),(
4 ,
4 )
;
alter table t1 engine=S3
;
#####
# mysqldump with --copy-s3-tables=
0 (by default)
###
/*M!999999\- enable the sandbox mode */
#####
# mysqldump with --copy-s3-tables=
0 (by default) XML
###
<?xml version=
"1.0" ?>
<mysqldump xmlns:xsi=
"http://www.w3.org/2001/XMLSchema-instance " >
<database name=
"database" >
</database>
</mysqldump>
#####
# mysqldump with --copy-s3-tables=
1
###
/*M!999999\- enable the sandbox mode */
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `t1` (
`pk` int(
11 )
NOT NULL,
`a` int(
11 ) DEFAULT NULL,
PRIMARY KEY (`pk`)
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=
1 ;
/*!40101 SET character_set_client = @saved_cs_client */;
SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, @@AUTOCOMMIT=
0 ;
INSERT INTO `t1` VALUES
(
1 ,
1 ),
(
2 ,
2 ),
(
3 ,
3 ),
(
4 ,
4 )
;
ALTER TABLE `t1` ENGINE=S3
;
COMMIT
;
SET AUTOCOMMIT=@OLD_AUTOCOMMIT
;
#####
# mysqldump with --copy-s3-tables=
1 XML
###
<?xml version=
"1.0" ?>
<mysqldump xmlns:xsi=
"http://www.w3.org/2001/XMLSchema-instance " >
<database name=
"database" >
<table_structure name=
"t1" >
<field Field=
"pk" Type=
"int(11)" Null=
"NO" Key=
"PRI" Extra=
"" Comment=
"" />
<field Field=
"a" Type=
"int(11)" Null=
"YES" Key=
"" Default=
"NULL" Extra=
"" Comment=
"" />
<key Table=
"t1" Non_unique=
"0" Key_name=
"PRIMARY" Seq_in_index=
"1" Column_name=
"pk" Col
lation="A" Cardinality="4" Null="" Index_type="BTREE" Comment="" Index_comment="" Ignored="NO" />
<options Name="t1" Engine="Aria" Version="10" Row_format="Page" Rows="4" Avg_row_length="4096" Data_length="16384" Max_data_length="17592186011648" Index_length="16384" Data_free="0" Create_time="--TIME--" Collation="utf8mb4_uca1400_ai_ci" Create_options="" Comment="" Max_index_length="9007199254732800" Temporary="N" />
</table_structure>
<table_data name="t1" >
<row>
<field name="pk" >1 </field>
<field name="a" >1 </field>
</row>
<row>
<field name="pk" >2 </field>
<field name="a" >2 </field>
</row>
<row>
<field name="pk" >3 </field>
<field name="a" >3 </field>
</row>
<row>
<field name="pk" >4 </field>
<field name="a" >4 </field>
</row>
</table_data>
</database>
</mysqldump>
drop table t1;
Messung V0.5 in Prozent C=79 H=100 G=90
¤ Dauer der Verarbeitung: 0.14 Sekunden
(vorverarbeitet am 2026-10-08)
¤
*© Formatika GbR, Deutschland