Re: Size limits of mysql

There is [max allowed packet] variable in mysql. The default is 1MB in my config. May be this is what stops you. Try increasing this value. On Wednesday 14 September 2005 01:07, mwestern@sola.com.au wrote: > Hi All, > > > > > > I have a simple database with one table with about 6 fields, just > holding filenames, filepaths and sizes. Very basic audit for management > here. Problem is I import a load of records into this table and it > seems to only allow me to put in about 550,000 records. Maybe it's > just mysqlFront that can only display that many records or something. > Anybody know of a size or record limit in mysql tables? The actual size > of the database is about 70Mb. Not huge really. > > > > > > Thanks > > > > Matthew