larger database import to mysql
Posted by: john.ou (---.5.68.3.ptr.us.xo.net)
Date: August 25, 2009 03:14AM

my server is: Apache/2.2.11 (Win32) PHP/5.2.9-2 MySQL client version: 5.0.51a
After I upgrade WAMP, I re-install all my data to Apache easily, but my back up sql database is larger then 2048 kb. so I can not import it through phpmyadmin.
in old version of WAMP, I can import the database by running command 'mysql' under \WAMP\mysql\bin, but in the new version, I can not find the command 'mysql'
How can I import a 3MB database size into the mysql?
Thanks

Options: ReplyQuote
Re: larger database import to mysql
Posted by: yfastud (Moderator)
Date: August 25, 2009 03:19AM

you can either through wamp tray icon or navigate to mysql folder to run consol from there

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: larger database import to mysql
Posted by: c2dan (---.15-1.cable.virginmedia.com)
Date: August 25, 2009 06:41PM

john.ou Wrote:
-------------------------------------------------------
> my server is: Apache/2.2.11 (Win32) PHP/5.2.9-2
> MySQL client version: 5.0.51a
> After I upgrade WAMP, I re-install all my data to
> Apache easily, but my back up sql database is
> larger then 2048 kb. so I can not import it
> through phpmyadmin.

BY default PHP only allows uploads of 2MB max. To increase this limit left click WAMP tray icon and select PHP > php.ini

Scroll down and find
upload_max_filesize = 2M
Change 2M to something higher, eg 10M for uploads of 10MB max.

EDIT Dont forget to restart Apache service after modifying the php.ini



Edited 1 time(s). Last edit at 08/25/2009 07:07PM by c2dan.

Options: ReplyQuote


Sorry, only registered users may post in this forum.