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 .
Link to comment
Share on other sites

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
Link to comment
Share on other sites

[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
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.