Jump to content

problem with importing database into mysql through the terminal


Recommended Posts

Hi every body ...

I'm beginner in using LAMPP,

I got the error while try to import a big SQL (184 MB) in to SQLMyAdmin ,
Fatal error: Maximum execution time of 300 seconds exceeded

I try to import the database through terminal window.
while use this command I got error as mysql : command not found

mysql -u "username" root -p "password" < filename.sql

can any one help to overcome this .
Hello sir ,,

Thank you for your instant reply. Yes sir , My database is in the same machine . Its in a text file with the extension of .sql.
its a 184MB database. And how can I import through terminal window. using mysql command I got the error of " mysql command not found .

for more details refer my previous question,

Thanks in advance
[quote author=thorpe link=topic=123104.msg509417#msg509417 date=1169347661]
Have you got mysql installed on this same machine? If the command [i]mysql[/i] is not found, chances are you don't have mysql installed.
[/quote]

Hello ,

Thank you for ur kind reply, I found the problem with your help , The problem is due to some configuration mismatch . Now I reinstalled mysql and now working properly

once again thank you for kind and very useful replies

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.