Question Details

Browse

Can I use WorkBench like phpmyadmin in a WAMP or XAMPP?

By Jin Tan - Oct. 07, 2008

I have experience with phpmyadmin. Now I'd like to use WorkBench where it enables to be connected to the MySQL I use to create db/table--Modify and all that. Just like how in wamp. I realize there isn't a package like that. I am trying out RoR and I have no problems with command line, but just gonna figure out a better UI.

I came to realize that I can only import .SQL from somewhere I'd already created and saved to, probably exported from somewhere. But is there a way I can create the tables and all that from command line and at the same time be able to view the tables afterwards--Again like xampp or wamp.


Answers

Add Answer
  1. By Randy Clark on Oct. 08, 2008

    Okay, if I understand your question correctly, you want to use the command line to set up and manage your database tables, and do this, ideally, in tools that are not necessarily the same that were used to dump the tables?


    If you have ANY standard sql, you should be able to import it from your mysql command line (you mentioned XAMPP/WAMP and phpmyadmin, so I'm assuming you're using MySQL) by simply issuing the "import ".


    You can also use mysqldump to generate your tables and populate them with data.


    0 Votes
Share your knowledge