Tell me more ×
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.
up vote -1 down vote favorite

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

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, see the FAQ.

3 Answers

up vote 1 down vote

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
up vote 0 down vote

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
up vote -1 down vote

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

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