Timeout when trying to import database backup

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

Timeout when trying to import database backup

Postby bluequensh » 20. November 2011 21:41

Hello,

I have recently switched from an older XAMPP Version to the most recent one 1.7.7.

I did not use the installer version, but the zip archive.

I can start/stop XAMPP just fine - but the problem I am having is, that when I create a new DB and want to import a backup, the browser status says "waiting for localhost" for ~5minutes..
and then I get following error message:

Fatal error: Maximum execution time of 300 seconds exceeded in D:\xampp\phpMyAdmin\libraries\dbi\mysql.dbi.lib.php on line 175


When I check the database in which I wanted to import, I can see that it actually did import some stuff.. just not all of it..
I did not have this problem with the older version.
Can anyone help me out ?

P.S.: The backup file is 4 MB big, so the limit of 8 MB is not reached.
bluequensh
 
Posts: 2
Joined: 20. November 2011 21:24
Operating System: Win7 64bit

Re: Timeout when trying to import database backup

Postby Sharley » 20. November 2011 22:56

In the \xampp\mysql\data folder is an error.log file.
See if there are any clues why you are timing out.
You may have an error in your database that MySQL can't get passed.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Timeout when trying to import database backup

Postby bluequensh » 20. November 2011 23:08

no, the error logs only states normal stuff like after start and stop
111120 22:30:09 [Note] Plugin 'FEDERATED' is disabled.
111120 22:30:09 InnoDB: The InnoDB memory heap is disabled
111120 22:30:09 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111120 22:30:09 InnoDB: Compressed tables use zlib 1.2.3
111120 22:30:09 InnoDB: Initializing buffer pool, size = 16.0M
111120 22:30:09 InnoDB: Completed initialization of buffer pool
111120 22:30:09 InnoDB: highest supported file format is Barracuda.
111120 22:30:10 InnoDB: Waiting for the background threads to start
111120 22:30:11 InnoDB: 1.1.8 started; log sequence number 41532728
111120 22:30:11 [Note] Event Scheduler: Loaded 0 events
111120 22:30:11 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16' socket: '' port: 3306 MySQL Community Server (GPL)
111120 22:36:18 [Note] mysql\bin\mysqld.exe: Normal shutdown


nothing there
bluequensh
 
Posts: 2
Joined: 20. November 2011 21:24
Operating System: Win7 64bit

Re: Timeout when trying to import database backup

Postby Sharley » 21. November 2011 00:13

At what point in the import does it stall - you have a part imported database file in the \mysql\data folder, compare it with the sql file you are trying to import and it may reveal at what point it stalls as 5 minutes should be enough time for a 4M database to be imported.

You could try using BigDump.

MySQL Workbench is also another useful GUI tool.
MySQL WB Admin wrote:New! Export/Import

MySQL Workbench also includes visual tools for mysqldump. Easily export/import data by selecting the database schemas and/or tables from the Object Browser. Advanced configurations are available for concurrency controls, backup type, and output formatting.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 39 guests