Page 1 of 1

Importing a large BLOB file into MySQL

Posted: Fri Aug 22, 2008 3:16 pm
by emmbec
Hi everyone, I am having problems trying to move my DB information to another server. I am using MySQL, and currently I have a lot of information (Plain Text) which I can seem to dump and insert in another DB, but there is one table which stores some Excel file, each file holding 600Kb, and I have 200 records (you do the math). Now that is a lot of information and for some reason I am just not able to import it using PHPMYADMIN into my other server. I have even tried creating a dump with only 3 records and I still cannot import it, I get a:

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

Can anyone help me please, I just don't know what to do anymore to import that information, I am about to download each of the excel files through the application and insert each of them mannually into the other server....

Thanks a lot!

Re: Importing a large BLOB file into MySQL

Posted: Fri Aug 22, 2008 5:42 pm
by jaoudestudios
You need to increase the execution time. I think it is in the php.ini file, I cant remember. If you change anything in the php.ini file for apache dont forget to restart apache. It looks like you are using WAMP, I am not sure how it works on windows but if you can import the dump through the command line you might avoid the Fatal error.

Re: Importing a large BLOB file into MySQL

Posted: Fri Aug 22, 2008 6:40 pm
by JAB Creations
The beautiful thing about MySQL when you have hands on access to the server: just copy the files to the MySQL database directory and restart the MySQL service. I did the same thing with Windows 98 and two hard drives back in the day when it would go bad. I'd just book from D:\ and copy over the bad copy on C:\. But importing large amounts of MySQL data in all other circumstances has never been fun for me.

Re: Importing a large BLOB file into MySQL

Posted: Fri Aug 22, 2008 6:46 pm
by Eran
For importing such large dumps of SQL I would go directly to the shell and run it from there. This will not only be faster, but it will have none of PHP's memory and runtime limitations.