mysqldump with mysql query browser

I need to dump data of specifc tables in a database so I can insert/resore it to a DIFFERENT database (different DB  name too)

I can't seem to figure out how to do this.  (And for some reson I CAN'T access the mysql via a command prompt.)

Need a sample query... Thanks.
PhotoMan2000Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

michofreihaCommented:
To dump 1 or several databases

mysqldump --user=XXXXXXXX --password=XXXXXXX --databases DB_NAME1 DB_NAME2 DB_NAME3 > /PATH/TO/DUMPFILE.SQL
0
PhotoMan2000Author Commented:
Where in the query too would I do that? in a Script Tab or a Query Tab?

WHAT ABOUT THE TABLE NAMES?
0
michofreihaCommented:
Login to your server using Putty by ssh or telnet and run this query on command shell directly...

Try this for a specific table

mysqldump -c -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

PhotoMan2000Author Commented:
ALL:   This local computer only.  need info on the admin too.. NO COMMAND LINE STUFF PLEASE.

THANK YOU.

(Unless you give me a way to restore my command prompt - ie get some sort of error and then the dos prompt close, and I can't read what it exactly says.)
0
michofreihaCommented:
you have to see where your MySQL is installed then go to mysql Follder/bin...You should see mysqldumo there...Just go there and run this commad
0
PhotoMan2000Author Commented:
I can't get a prompt to stay open!  SO I MUST do this via the MySQL Query Browser that comes with the Windows install.

0
michofreihaCommented:
phpmyadmin is a great tool to do what you are looking for
0
tkcinCommented:
You could try the free trial of Navicat (http://www.navicat.com/en/download/download.html).

After setting up both database connections, right-click on the source database and click 'Data Transfer'. You could then specify the target server and database and Navicat will transfer all of your tables across automatically.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PhotoMan2000Author Commented:
This actually will do what I need - grabbed the "lite" version and used the XML import / export feature.  Nice product for anyone who is reading this in the future.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.