Accessing my MYSQL from a command prompt

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

Accessing my MYSQL from a command prompt

Postby esender » 15. January 2009 00:45

I am a bit of a newbie here and although I searched google and the whole forums, I have come up short on the following issues:

I would like to access my local Apache XAMPP MYSQL server on the command prompt. At my work, we connect remotely with PuTTy and it works fine. How do I connect to my local MySQL server and run the Unix and Mysql commands?

With that said, how would I overwrite a full database under the XAMPP MySQL server (this database is huge, about 1 GB, so using phpmyadmin won't suffice).

I.e., will this command work:
mysqldump -u [user] [database_name] | mysql -u [user] [new_database_name]



Appreciate any help :)
esender
 
Posts: 10
Joined: 15. January 2009 00:40

Re: Accessing my MYSQL from a command prompt

Postby esender » 15. January 2009 00:53

esender
 
Posts: 10
Joined: 15. January 2009 00:40


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 31 guests