using mysql from command line?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

using mysql from command line?

Postby steve02476 » 02. July 2009 19:30

xampp is working beautifully on my XP system. I can access mysql via phpmyadmin very well.

However, some things I am accustomed to doing with mysql directly - like importing large data sets (50MB). I think using PHP limits how much I can import via phpmyadmin.

Is there some way I can access the mysql inside xampp from the XP cmd command line?

Or is there another good way to import a 50MB sql dump into mysql?

Thanks for the help!
steve02476
 
Posts: 3
Joined: 02. July 2009 19:25

Re: using mysql from command line?

Postby steve02476 » 02. July 2009 19:45

I'm a moron... :oops:

Here's the answer, I think:

go into the XP command window, and type:

Code: Select all
F:\>\xampp\mysql\bin\mysql -u root


(of course, change the path for wherever your xampp directory is...)

Hope this helps someone else. -Steve

ADDITION: after you do the above, to do the actual data import:
Code: Select all
mysql> use databasename;
mysql> source C:\\Documents and Settings\\yourname\\My Documents\\yourdumpfile.sql;
Last edited by steve02476 on 02. July 2009 21:01, edited 1 time in total.
steve02476
 
Posts: 3
Joined: 02. July 2009 19:25

Re: using mysql from command line?

Postby Teratornis » 02. July 2009 20:03

If you are used to using Unix/Linux/GNU command-line tools, you might like to install Cygwin.
Teratornis
 
Posts: 2
Joined: 22. June 2009 21:16
Location: Cincinnati, Ohio

Re: using mysql from command line?

Postby steve02476 » 02. July 2009 21:02

Thanks, that's a good idea.
steve02476
 
Posts: 3
Joined: 02. July 2009 19:25


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 27 guests