I tried to Create a table by importing data from data source . My Excel file is 19.7 MB. In the "Select an Excel or CSV file" page, it states "Maximum upload file size: 8 MB."

What can I do to upload my 19.7 MB file.

No problem. 

I used the "Add From Server" plugin and imported an Excel file with 18.8 MB. However, I got the error "There was an error while trying to generate the table". The excel file has ~500,000 rows and 6 columns.

I used the "Add From Server" plugin and imported an Excel file with 785 KB (~170,000 rows and 6 columns) without any problems.

How can "import that files directly on database"? 

The options available are

1. Create a table linked to an existing data source

2. Create a table manually

3. Create a table by importing data from data source (what I used and encountered error)

Could you please give me more detail steps on how to do that?

My steps so far are as follows:

1. goto phpAdmin

2. choose ffhc_wpdatatables

3. click Import

4. choose my csv file and GO

Got "Invalid column count in CSV input on line 1. I used this CSV file to create a table successfully using "Create a table by importing data from data source ." in the Create a Table manual.

I have made another attempt:

1. Separate my CSV file to 2 files: first one contain first row only - column headings and the second contain the remaining rows.

2. Use "Create a table by importing data from data source" using the first file in 1 above

3. goto phpAdmin

4. choose ffhc_wpdatatable_8 (the table created in 2 above)

5. click Import and choose my csv file (second file in 1 above and GO

6. Got " Invalid column count in CSV input on line 313."

I got the following error when I import the attached csv file.

Error

Static analysis:

3 errors were found during analysis.

1. A symbol name was expected! A reserved keyword can not be used as a column name without backquotes. (near "varchar" at position 244)
2. Unexpected beginning of statement. (near "10" at position 252)
3. Unrecognized statement type. (near "DEFAULT CHARACTER SET" at position 257)

SQL query:

CREATE TABLE IF NOT EXISTS `u221116913_abyzy`.`TABLE 23` (`Contributor` varchar(29), `Internal ID` varchar(11), `Title` varchar(53), `Publisher` varchar(50), `Game Platform` varchar(29), `Date Published` varchar(4), `Content Type` varchar(8), varchar(10)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL said: 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchar(10)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1

Thanks, Milan. Your file works. However, I can't see the table in Worpress wpDataTables. What should I do next?

Also, when I try to import a table with 200,00 rows, I got 

504 Gateway Time-out. 

Any advise?

Using the file you sent me:

1. I renamed the new table as ""ffhc_wpdatatable_12" (make it consistent with our tables created by wpDataTable)

2. In wpDataTables, choose "Generate a query to MySQL database.", there is no place to input "SELECT * FROM TABLE_1" as recommended. Instead, it allow me to choose which table I want to work on. I choose ffhc_wpdatatable_12

3. I selected everything in the "All MySQL columns" and click NEXT,

4. I got the following (see attached file)

No results found. Please check if this query is correct! Table Constructor needs a query that returns data to build a wpDataTable.
Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ';, ffhc_wpdatatable_12.Content Type FROM ffhc_wpdatatable_12 LIMIT 5' at line 7

Using the file I created with ~500,000 rows and format you recommended,

1, I  choose the IMPORT function; choose my file, upload seems successful, then system prompt "Please be patient, the file is being uploaded. Details about the upload are not available "Waiting for auth-db148.hostinger.com", for ~2 min, i got "504 Gateway Time-out"

I can use option 1 to create the table. One minor issue is that I have to delete the last column which contains ";" in the file you provide.

I really appreciate your help.

Now, I can create table from MySQL. I need to resolve the  "504 Gateway Time-out" issue so that I can create the 500,000 rows table I need.

When the time 504 Gateway Timeout message appear, the console became blank (see attached). When I backward the browser, I got the message in the console (see attached).