Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to email a MYSQL database I created with all tables and queries to other person to check do I use the Import and Export Wizard or there are other ways?

share|improve this question
    
how is what you are going to do with the database dump relevant to how you generate a database dump? Just use mysqldump and zip/gzip/bzip2 the result. If by import export wizard you mean phpmyadmin - you're asking the wrong question in the wrong place. –  AD7six Feb 23 '12 at 9:10
    
what you actually wants..??structure of all tables that you have created..?or you want the database dump..? –  Abdul Manaf Feb 23 '12 at 9:14
    
Hi Sylvia, can you clarify your question regarding what OS you are running on, what version of MySQL and also what program you have an 'import and export wizard' in? –  Derek Downey Feb 23 '12 at 15:51
    
This question isn't clear enough as it stands –  Jack Douglas Apr 7 '12 at 10:23
add comment

closed as not a real question by Derek Downey, JNK, gbn, RolandoMySQLDBA, Jack Douglas Apr 7 '12 at 10:23

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

3 Answers

What I understand from your question I am answering on that basis. If you want database dump use mysqldump client utility.You can Execute it as

mysqldump -uuser -ppassword --all-databases > db_dump.sql

where db_dump.sql is file which contains your table structure and data being inserted to it.For various other options of mysqldump use mysqldump --help

If you only wants the structure of your tables then write Command as

mysqldump -uuser -ppassword --no-data --databases db1 db2 db3  > db_structure.sql

For more information about mysqldump please visit The Link.

If you asking any other thing please clearly update with your question.

share|improve this answer
add comment

SQLyog - MySQL GUI has a tool called SQL Scheduler & Reporting tool. You would need to specify a query and the result of this query will be emailed by the tool. Although this feature is available only in the paid version, I guess there is a trial version available. You might want to give it a shot.

share|improve this answer
    
Why was this post down-voted????? –  omggs Feb 27 '12 at 4:46
add comment

you can use phpmyadmin to export database. alternative , if you familiar with cli , use mysqldump to export your database schema .I guess that what you asked .

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.