phpmyadmin/mysql Import (Max: 2,048KB) txt size

dave`2005 · 06-13-2006, 12:14 PM

Hi all, I need to import a 7mb txt file, ive tried .zipping it but phpmyadmin says

Code:

Error in ZIP archive: File is encrypted, which is not supported from this class.

Can I import this file using the mysql console instead? Or using phpmyadmin, or any other way.

Any help greatly appreciated.

bathory · 06-14-2006, 05:22 AM

Open your php.ini, find the line:

Code:

upload_max_filesize = 2M

and change it to your like. I guess you have to restart your web server for the changes to take effect.

Regards

dave`2005 · 06-15-2006, 06:41 AM

Thanks, it worked

I have 1 more problem though, ive imported it but on the left side of the phpmyadmin page, after importing, it says

Code:

xca;
Warning: mysqli_query() [function.mysqli-query]: (HY000/12): Can't read dir of '.\xca;\' (Errcode: 2) in \libraries\dbi\mysqli.dbi.lib.php on line 113
(0)
No tables found in database.

Is this serious? how can i fix it?