how to Import phpmyadmin in joomla database csv file

Relax and enjoy The Lounge. For all Non-Joomla! topics or ones that don't fit anywhere else. Normal forum rules apply.
Post Reply
User avatar
sheiksumon
Joomla! Intern
Joomla! Intern
Posts: 74
Joined: Sun Oct 26, 2008 6:08 am
Location: Dhaka,Bangladesh
Contact:

how to Import phpmyadmin in joomla database csv file

Post by sheiksumon » Sun Apr 08, 2018 3:50 pm

Also Format-Specific Options: Columns separated with, Columns enclosed with, Columns escaped with, Lines terminated with.

When i import csv file in phpmyadmin then following this error.

Code: Select all

Error
SQL query:

CREATE TABLE IF NOT EXISTS `dbname`.`TABLE 1` (`COL 1` varchar(26), `COL 2` varchar(48), `COL 3` varchar(2524), `COL 4` varchar(2055), `COL 5` varchar(86874), `COL 6` varchar(11014), `COL 7` varchar(367), `COL 8` varchar(847), `COL 9` varchar(47859), `COL 10` varchar(329), `COL 11` varchar(3470), `COL 12` varchar(3709), `COL 13` varchar(136), `COL 14` varchar(2289), `COL 15` varchar(202), `COL 16` varchar(2848), `COL 17` varchar(150), `COL 18` varchar(1371), `COL 19` varchar(1379), `COL 20` varchar(667), `COL 21` varchar(3), `COL 22` varchar(19), `COL 23` varchar(647), `COL 24` varchar(648), `COL 25` varchar(1), `COL 26` varchar(4), `COL 27` varchar(81), `COL 28` varchar(1), `COL 29` varchar(19), `COL 30` varchar(19), `COL 31` int(1), `COL 32` varchar(19), `COL 33` varchar(19), `COL 34` int(1), `COL 35` varchar(4), `COL 36` int(1), `COL 37` int(1), `COL 38` int(1), `COL 39` varchar(10), `COL 40` varchar(10), `COL 41` varchar(10), `COL 42` varchar(10), `COL 43` varchar(10), `COL[...]

MySQL said: Documentation

#1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs 
Image
Last edited by toivo on Sun Apr 08, 2018 4:29 pm, edited 1 time in total.
Reason: mod note: moved to The Lounge
Salekuddin Sheikh Sumon
Joomla Developer

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 11463
Joined: Thu Feb 15, 2007 5:48 am
Location: Suzhou, China

Re: how to Import phpmyadmin in joomla database csv file

Post by toivo » Sun Apr 08, 2018 4:28 pm

That table is not in core Joomla. The MySQL error message at the bottom explains the reason for the error.
Toivo Talikka, Global Moderator

User avatar
sheiksumon
Joomla! Intern
Joomla! Intern
Posts: 74
Joined: Sun Oct 26, 2008 6:08 am
Location: Dhaka,Bangladesh
Contact:

Re: how to Import phpmyadmin in joomla database csv file

Post by sheiksumon » Sun Apr 08, 2018 5:06 pm

The database was exported to CSV mode due to its large volume, but now do not import in this file. how to format csv file import in phpmyadmin.
Salekuddin Sheikh Sumon
Joomla Developer

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 11463
Joined: Thu Feb 15, 2007 5:48 am
Location: Suzhou, China

Re: how to Import phpmyadmin in joomla database csv file

Post by toivo » Sun Apr 08, 2018 5:57 pm

If the table was created by a third party extension, you could ask the developer of that extension which tool could be used.

On the other hand, according to the MySQL 5.7 manual the maximum row size is 65535 bytes in all storage engines. Therefore the developer should observe the recommendation in the suggestion in the error message and define certain columns as BLOB or TEXT instead.
Toivo Talikka, Global Moderator


Post Reply

Return to “The Lounge”