Page 1 of 1

limit on size of SQL files?

PostPosted: 01. January 2005 21:35
by BeemerPaul
Hi,

I'm running the latest version of Minixamp for windows to host a development version of my phpBB forum site. I have taken a backup from the production forum site which gives a 30mb SQL file. I try to restore this on my development system but it just hangs or fails. I also tried to execute the SQL file using myphpadmin, but that warns of a file size limit for the SQL files. Is there some underlying mySQL limitation on the size of file I can load and process? Is there any way I can increase that file size to cope with my database restore?

If I split the file into smaller portions it will load. That worked OK with files of up to about 1mb, but fails with larger files.

Hilfe!

Paul

PostPosted: 01. January 2005 21:50
by Wiedmann
This is a limitation of PHP.

But, MySQL restores should be best make with a console client like "mysql.exe".

What?

PostPosted: 02. January 2005 16:35
by ptomter
What is the limit on?
Wiedmann wrote:This is a limitation of PHP.

But, MySQL restores should be best make with a console client like "mysql.exe".

PostPosted: 02. January 2005 16:56
by Wiedmann

PostPosted: 03. January 2005 11:33
by BeemerPaul
Thanks for your help guys!

Paul