View Issue Details

Jump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0002743OXID eShop (all versions)4.06. Language and translationspublic2011-04-13 16:292011-08-08 20:27
ReporterHelmut L. Assigned To 
PriorityurgentSeveritymajorReproducibilityalways
Status resolvedResolutionnot fixable 
Product Version4.5.0 revision 34568 
Fixed in Version4.5.1 revision 38045 
Summary0002743: mysqldump does not work with many languages
DescriptionIf you have 15 languages there is a view oxv_oxarticles with over 120 cols. When you use mysqldump, before the create view statement, there is a create table statement with all columns of the view.
When you execute the sql, during creation of the table the maximum columns limit for the table is reached and thus the execution of the sql is aborted.
Steps To ReproduceAdd 15 languages in the shop.
Use mysqldump to create a sql file.
Try to execute the sql file.
Additional InformationEnterprise Edition

Occurs probably also with fewer languages.
TagsNo tags attached.
ThemeBoth
BrowserAll
PHP Versionany
Database Versionany

Relationships

related to 0003163 resolvedLinas Kukulskis Impossible to use admin without views 

Activities

birute_meilutyte

2011-05-20 16:59

reporter   ~0004634

Reminder sent to: Helmut L.

Hello,

sorry, but i can not reproduce the case. i have tried to export database with 19 languages and then was able import it again. could you please let us know, what options are are you using while executing mysqldump and what mysql version you are working with?

greetings,

Helmut L.

2011-05-23 08:43

reporter   ~0004638

Here is the mysqldump command I used to create the dump:
mysqldump --hex-blob --create-options -u username -p databasename > dump.sql

I tested it with MySQL Version 5.0.67, charset UTF-8, Storage Engine InnoDB

birute_meilutyte

2011-06-09 11:35

reporter   ~0004725

@developers: investigate from source code side. somehow, i can not export db with given options. i get error:
mysqldump: Got error: 1016: Can't open file: './oxid_fe_ee/oxv_oxobject2attribute_a9.frm' (errno: 24) when using LOCK TABLES

alfonsas_cirtautas

2011-06-29 13:02

reporter   ~0004783

This is just a limitation of mysqldump view export, try create database dump without views and regenerate them later

Helmut L.

2011-07-27 11:36

reporter   ~0004892

mysqldump has no option to not dump the views. The only way would be to add an --ignore-table=... for every single view. With 1510 views (shop + sub shop + 31 languages) this is no practical solution.

alfonsas_cirtautas

2011-08-08 20:27

reporter   ~0004953

You are right, mysqlbump does not have option to ignore all views and does not allow usage of wildcard characters, try searching another tool or script.