Importing a large BLOB file into MySQL
Posted: Fri Aug 22, 2008 3:16 pm
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!
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!