111 reputation
3
bio website
location Copenhagen/Warsaw
age 28
visits member for 2 years
seen Feb 17 at 14:32

Web developer with 4 years proffesional experience. My main language + framework is Ruby on Rails, however recently I have been working with Grails as well. (X)HTML, CSS, Javascript (Jquery, Prototype) - easy.


Sep
24
awarded  Autobiographer
Jan
7
awarded  Supporter
Oct
7
comment How to import big sql file in Phpmyadmin
text between * is depending on your settings, most likely you use default settings, and the default username is root. Let's assume that you do not have password for mysql, and your database's name is my_database. If your sql file name is 'file.sql', then the proper command is mysql -u root my_database < file.sql. You must be inside directory, in which the file exists, if it is on your desktop for example and your username is Roy, then before this command you should type cd C:/Users/Roy/Desktop [cd = change directory]
Oct
4
comment How to import big sql file in Phpmyadmin
If you need to use phpymadmin we need to localize php.ini or create one [ default setting might b applied ]. I believe there should be config directory, which should include php.ini ? You also had to manually installed php5, for example in C:/php5 - php.ini should be there.
Oct
4
comment How to import big sql file in Phpmyadmin
@RajdeepRoy do you really need to use phpmyadmin after that? Can't you just write in the comand line mysql -u *username-probably_root* -p *your_database_name* < *sql_file* ? If you do not have password you do not need to use -p option. That will be simpler approach :)
Oct
3
awarded  Teacher
Oct
3
comment How to import big sql file in Phpmyadmin
@RajdeepRoy you might find this answer useful - it should help you localize php.ini . If it will not help you, please come back to me. It will be useful to know what OS you are using
Oct
3
answered How to import big sql file in Phpmyadmin