--0-1903250023-1270703548=:58799
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Hi,
I would like to export my table structure from MYSQL from a partic=
ular db. Is there any tool for doing this?
Please guide me.
Than=
k you
VIKRAM A
=0A
--0-1903250023-1270703548=:58799--
The MySQL ODBC driver?
/ Carsten
On Thu, 8 Apr 2010 10:42:28 +0530 (IST), Vikram A
wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular
db.
> Is there any tool for doing this?
>
> Please guide me.
>
> Thank you
>
> VIKRAM A
>
>
>
>
> !DSPAM:451,4bbd65f933049495715525!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--000e0cd6ad041b1f550483b47b64
Content-Type: text/plain; charset=ISO-8859-1
Hi Vikram,
You can use toad for mysql ( It's a free tool) to export table structure or
data.
Even you can use mysqldump also.
Krishna
On Thu, Apr 8, 2010 at 10:42 AM, Vikram A
> Hi,
>
> I would like to export my table structure from MYSQL from a particular db.
> Is there any tool for doing this?
>
> Please guide me.
>
> Thank you
>
> VIKRAM A
>
>
>
--000e0cd6ad041b1f550483b47b64--
You can also use HeidiSQL, another free tool to visually manage and export
structure/data etc (and a whole host of other stuff) I use it to manage
windows and linux hosted databases.
George
-----Original Message-----
From: Krishna Chandra Prajapati [mailto:prajapatikc@gmail.com]
Sent: 08 April 2010 08:18
To: Vikram A
Cc: MY SQL Mailing list
Subject: Re: Mysql - Tables Export to Excel!
Hi Vikram,
You can use toad for mysql ( It's a free tool) to export table structure or
data.
Even you can use mysqldump also.
Krishna
On Thu, Apr 8, 2010 at 10:42 AM, Vikram A
> Hi,
>
> I would like to export my table structure from MYSQL from a particular db.
> Is there any tool for doing this?
>
> Please guide me.
>
> Thank you
>
> VIKRAM A
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--001517447dd8f6ec4b0483b71c88
Content-Type: text/plain; charset=ISO-8859-1
Or MySQL Connector :)
On Apr 8, 2010 10:11 AM, "Carsten Pedersen"
The MySQL ODBC driver?
/ Carsten
On Thu, 8 Apr 2010 10:42:28 +0530 (IST), Vikram A
wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular
db.
> Is there any...
> !DSPAM:451,4bbd65f933049495715525!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
--001517447dd8f6ec4b0483b71c88--
Vikram A wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular db. Is there any tool for doing this?
>
There are several ways to get "structure" information from within MySQL:
the SHOW COLUMNS... command
the SHOW INDEXES... command
the SHOW CREATE TABLE... command
you can also write queries against the tables in the INFORMATION_SCHEMA
You can also use an external utility such as mysqldump. Use the
--no-data option to get just a dump of your table definitions. If you
also want to see triggers and events and stored procedures, you also
need to use the --triggers, --events, and --procedure options, too.
Details are in the fine manual:
http://dev.mysql.com/doc/refman/5.1/en/show.html
http://dev.mysql.com/doc/refman/5.1/en/information-schema.ht ml
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
I guess the final answer depends on which information are you looking
for and in what format you want to see it. Got any details you want to
share?
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--00163630f07379f2ed04848e8a87
Content-Type: text/plain; charset=ISO-8859-1
use can use mysqldump with option *-no-data*
eg.
*mysqldump -u user -ppassword wordpress user --no-data > Dumpdata.txt *
where wordpress is my database and user is my table.
Thanks
On Sun, Apr 18, 2010 at 9:48 PM, Shawn Green
> Vikram A wrote:
>
>> Hi,
>>
>> I would like to export my table structure from MYSQL from a particular db.
>> Is there any tool for doing this?
>>
>
> There are several ways to get "structure" information from within MySQL:
>
> the SHOW COLUMNS... command
> the SHOW INDEXES... command
> the SHOW CREATE TABLE... command
>
> you can also write queries against the tables in the INFORMATION_SCHEMA
>
> You can also use an external utility such as mysqldump. Use the --no-data
> option to get just a dump of your table definitions. If you also want to see
> triggers and events and stored procedures, you also need to use the
> --triggers, --events, and --procedure options, too.
>
> Details are in the fine manual:
> http://dev.mysql.com/doc/refman/5.1/en/show.html
> http://dev.mysql.com/doc/refman/5.1/en/information-schema.ht ml
> http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
>
> I guess the final answer depends on which information are you looking for
> and in what format you want to see it. Got any details you want to share?
>
> --
> Shawn Green
> MySQL Principle Technical Support Engineer
> Oracle USA, Inc.
> Office: Blountville, TN
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prabhat@gmail.com
>
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
--00163630f07379f2ed04848e8a87--
--0016363b806cc4dff304848e9773
Content-Type: text/plain; charset=ISO-8859-1
Note : if you table name it will export all tables from given database;
eg:*
mysqldump -u user -ppassword wordpress --no-data > Dumpdata.txt *
It will export all tables from db wordpress.
On Mon, Apr 19, 2010 at 8:57 AM, Prabhat Kumar
> use can use mysqldump with option *-no-data*
> eg.
> *mysqldump -u user -ppassword wordpress user --no-data > Dumpdata.txt *
>
> where wordpress is my database and user is my table.
>
> Thanks
>
>
> On Sun, Apr 18, 2010 at 9:48 PM, Shawn Green
>
>> Vikram A wrote:
>>
>>> Hi,
>>>
>>> I would like to export my table structure from MYSQL from a particular
>>> db. Is there any tool for doing this?
>>>
>>
>> There are several ways to get "structure" information from within MySQL:
>>
>> the SHOW COLUMNS... command
>> the SHOW INDEXES... command
>> the SHOW CREATE TABLE... command
>>
>> you can also write queries against the tables in the INFORMATION_SCHEMA
>>
>> You can also use an external utility such as mysqldump. Use the --no-data
>> option to get just a dump of your table definitions. If you also want to see
>> triggers and events and stored procedures, you also need to use the
>> --triggers, --events, and --procedure options, too.
>>
>> Details are in the fine manual:
>> http://dev.mysql.com/doc/refman/5.1/en/show.html
>> http://dev.mysql.com/doc/refman/5.1/en/information-schema.ht ml
>> http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
>>
>> I guess the final answer depends on which information are you looking for
>> and in what format you want to see it. Got any details you want to share?
>>
>> --
>> Shawn Green
>> MySQL Principle Technical Support Engineer
>> Oracle USA, Inc.
>> Office: Blountville, TN
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=aim.prabhat@gmail.com
>>
>>
>
>
> --
> Best Regards,
>
> Prabhat Kumar
> MySQL DBA
> Datavail-India Mumbai
> Mobile : 91-9987681929
> www.datavail.com
>
> My Blog: http://adminlinux.blogspot.com
> My LinkedIn: http://www.linkedin.com/in/profileprabhat
>
--
Best Regards,
Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
--0016363b806cc4dff304848e9773--