Q: What are the differences between the files in the formats such as CSV, SQL, DDL, CUT, POS, and MIX mentioned in this document?
A:
Q: What is the relationship between the format of a data file and the extension of the file?
A: OBLOADER support six formats: CSV, SQL, DDL, CUT, POS, and MIX. The default extension of a file in the CSV format is .csv. The default extension of a file in the SQL format is .sql. The default extension of a file in the DDL format is -schema.sql. You can use any extension for all data formats, except the DDL format. For example, you can use test.dat as the name of a file in the CSV format, but the content of the file must be in the standard CSV format. When you import a file, you must specify its extension by adding the
--file-suffix '.dat'option to the command. Otherwise, an error will be reported, indicating that the data file is not found. The file needs to be named in the format of table name.<any valid characters>.extension .
Q: After data in a large table is exported by partition into several files with indefinite extensions, how can I import them by using OBLOADER?
A: You can specify a regular expression for the file extensions in the command. For example, if the names of the data files that you want to import are test.tbl.0, test.tbl.1, and test.tbl., you can specify the following option in the command:
--table test --file-suffix '^.{1}\\w+.{1}\\d+'. Make sure that the specified regular expression is correct. Otherwise, an error will be reported, indicating that the data file is not found.
Q: What should I be mindful of when I use OBLOADER to import data that was exported by using a third party tool such as Mydumper or SQL Developer?
A:
Q: What should I be mindful of when I specify the
--tableoption?A: The
--tableoption specifies table names. Separate multiple names by commas (,). The table name and the file name must be capitalized in the same way. For example, in MySQL mode, table names are in lowercase by default. In this case, the table name specified by the--tableoption must be in lowercase, and the file name specified by the-foption should also be in lowercase. In Oracle mode, table names are in uppercase by default. In this case, the table name specified by the--tableoption must be in uppercase, and the file name specified by the-foption should also be in uppercase.