Max insert size on sql export of database

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

I was unclear. I am afraid something will be cut short upon reimporting. How do I avoid this.

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.

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.

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.

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.

Got it documented now. See the help document.

Hello, I need some may enter the private server and database / nekaishe here fghjhdmgh_1980@abv.bg /