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?
4
-
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.– AD7sixCommented Feb 23, 2012 at 9:10
-
what you actually wants..??structure of all tables that you have created..?or you want the database dump..?– Abdul ManafCommented Feb 23, 2012 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 DowneyCommented Feb 23, 2012 at 15:51
-
This question isn't clear enough as it stands– Jack DouglasCommented Apr 7, 2012 at 10:23
Add a comment
|
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.
answered Feb 23, 2012 at 10:11
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 .
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.
