Max insert size on sql export of database

[expired user #4881]'s profile image [expired user #4881] posted 9 years ago in Import/Export Permalink
Has this always been there? Mine says Max insert size of 1024 kb, then it says 0= single inserts.

Could you please tell me what it should say, so that what I am backing up is what is actually restored.

Thanks
[expired user #4881]'s profile image [expired user #4881] posted 9 years ago Permalink
I was unclear. I am afraid something will be cut short upon reimporting. How do I avoid this.
jfalch's profile image jfalch posted 9 years ago Permalink
you avoid this by leaving the default (1024). Other values have been introduced for rare special cases, where inserts would not work in the standard configuration. normally, except when using really large imports (GB), everything will be fine; if you do not get any error message dialog from the import, everything has been imported.
[expired user #4881]'s profile image [expired user #4881] posted 9 years ago Permalink
Thanks jfalch. I have varchars of several thousand characters, where I have saved articles from web pages in the database. I was afraid I might get them cut off if I ever had to restore.

I really don't remember seeing that option there before, it had me worried. The table is under 5 mb, so I should be good.
Thanks for letting me know.
ansgar's profile image ansgar posted 9 years ago Permalink
Let me say I was hesitating before introducing this new setting. Especially newbies are not aware of what this max insert size is doing. See this thread for a discussion about that.
[expired user #4881]'s profile image [expired user #4881] posted 9 years ago Permalink
It is great that you add features like that for those who need it. I asked about it and jfalch cleared it up. I also did a test import just to be sure. It would not be good if you had to dumb down the program due to newbies.

Keep up the good work.
ansgar's profile image ansgar posted 9 years ago Permalink
Got it documented now. See the help document.
[expired user #8812]'s profile image [expired user #8812] posted 9 years ago Permalink
Hello, I need some may enter the private server and database / nekaishe here fghjhdmgh_1980@abv.bg /

Please login to leave a reply, or register at first.