there is a separate command line program, mysqldump, that handles mass import and export, including data and/or structure (and users and other things)
I cannot go 2 days in a row without using mysqldump. http://linuxcommand.org/man_pages/mysqldump1.html "The dump contains SQL statements to create the table and/or populate the table" It generates .sql files that I often use to move WordPress databases from one server to another (mainly for localdev) On Wed, Jun 13, 2012 at 6:54 AM, morchella <morchella.delici...@gmail.com> wrote: > > i found: > show create table tablename; > > but there has to be a way to do a db with all tables and data. > > > On Tue, Jun 12, 2012 at 11:26 PM, Maureen <mamamaur...@gmail.com> wrote: > >> >> There are some tools that do that. I use SQLyog - just right click on >> the table name and it will create the select, insert, update or delete >> SQL for you. >> >> I also have CF scripts that you can point at a MySQL database and >> generate input forms and all the select, insert, update and delete >> statements based on the table structure if that would be helpful. >> >> On Tue, Jun 12, 2012 at 7:22 PM, morchella >> <morchella.delici...@gmail.com> wrote: >> > >> > hey in mysql, once you create your db and every thing is all hunky dory, >> > can it spit out scripts on how to replicate the structure and separate >> > scripts for data? ms sql server and oracle does. >> > just got back into a mySql env. >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:351911 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm