MySQL Forums
Forum List  »  InnoDB

Re: ibdata1 file getting huge
Posted by: jens verlinden
Date: October 20, 2014 06:08AM

They are on version 5.5.31 of mysql.

They use this command to import the xml files:
LOAD XML INFILE '/home/xxx/xxxx.xml'
INTO TABLE Test
ROWS IDENTIFIED BY '<match>'

The option of all seperate files will probably not help, because the problem is that they are running out of disk space because of this problem.

Options: ReplyQuote


Subject
Views
Written By
Posted
2549
October 17, 2014 06:57AM
1474
October 18, 2014 12:25PM
Re: ibdata1 file getting huge
1241
October 20, 2014 06:08AM
1225
October 21, 2014 09:57AM
1544
October 25, 2014 01:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.