Page 1 of 1

How to Import Large Database

PostPosted: 25. December 2007 09:57
by inidLinux
Hello All ,

Can any one please help me How to Import Large Database using phpmyadmin of Xampp 1.4.6 Version .

Kindly also let me know how can i import using command line of Xampp Mysql as it may be installed in /opt area.

Coz when ever i am trying

#mysql -u root -p database_name < file name.sql

its getting in to the systems Default mysql , how can i run same command for Xampp mysql from Command line , if its not possible to modify the defautl phpmyadmin Size restrictions of 2mb.

Plz help me here.

Thanks a lot to All

PostPosted: 26. December 2007 17:24
by sari42
see phpmyadmin/Documentation.html#faq1_16 or http://wiki.cihar.com/pma/FAQ_1.16
(especially the "UploadDir" feature)

[Solved] Thanks Sari42.

PostPosted: 27. December 2007 10:53
by inidLinux
Its Done as per urs URL Help.
Thanks