limit on size of SQL files?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

limit on size of SQL files?

Postby BeemerPaul » 01. January 2005 21:35

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
BeemerPaul
 
Posts: 2
Joined: 31. December 2004 18:11

Postby Wiedmann » 01. January 2005 21:50

This is a limitation of PHP.

But, MySQL restores should be best make with a console client like "mysql.exe".
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

What?

Postby ptomter » 02. January 2005 16:35

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".
ptomter
 
Posts: 5
Joined: 26. December 2004 17:29

Postby Wiedmann » 02. January 2005 16:56

Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby BeemerPaul » 03. January 2005 11:33

Thanks for your help guys!

Paul
BeemerPaul
 
Posts: 2
Joined: 31. December 2004 18:11


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 167 guests