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,
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
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.
~|
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
Yep I have 5.5. I will download the MSI again and see what is going on.
-Original Message-
From: Maureen [mailto:mamamaur...@gmail.com]
Sent: Sunday, June 10, 2012 10:02 PM
To: cf-community
Subject: Re: Where is MySQL
MySQL 5.1 and 5.5 are supported on Windows Server 2008
5.0
2008R2.
-Original Message-
From: Maureen [mailto:mamamaur...@gmail.com]
Sent: Saturday, June 09, 2012 9:01 PM
To: cf-community
Subject: Re: Where is MySQL
What type of server are you trying to install it on?
I've never had any problems getting it to install.
On Sat, Jun 9, 2012
, Scott Raley sra...@itc-llc.com wrote:
2008R2.
-Original Message-
From: Maureen [mailto:mamamaur...@gmail.com]
Sent: Saturday, June 09, 2012 9:01 PM
To: cf-community
Subject: Re: Where is MySQL
What type of server are you trying to install it on?
I've never had any problems getting
-
From: Maureen [mailto:mamamaur...@gmail.com]
Sent: Saturday, June 09, 2012 9:01 PM
To: cf-community
Subject: Re: Where is MySQL
What type of server are you trying to install it on?
I've never had any problems getting it to install.
On Sat, Jun 9, 2012 at 5:28 PM, Scott Raley sra...@itc
Windows Server 2008 R2
-Original Message-
From: Jerry Milo Johnson [mailto:jmi...@gmail.com]
Sent: Sunday, June 10, 2012 11:35 AM
To: cf-community
Subject: Re: Where is MySQL
That is Microsoft SQL Server (2008 R2), isn't it, and not MySQL (5.5.3 M3).
Microsoft SQL Server
MySQL 5.1 and 5.5 are supported on Windows Server 2008
5.0 is not. Make sure you have the latest version of MySQL and it
should install with no problems.
On Sun, Jun 10, 2012 at 9:24 AM, Scott Raley sra...@itc-llc.com wrote:
Windows Server 2008 R2
...@sstwebworks.com]
Sent: Thursday, June 07, 2012 12:31 PM
To: cf-community
Subject: Re: Where is MySQL
errr..
The MySQL Community Edition:
http://dev.mysql.com/downloads/mysql/5.1.html
On 6/7/2012 8:09 AM, Scott Raley wrote:
Since MySQL isn't free anymore what other db's are people using?
-Original
What type of server are you trying to install it on?
I've never had any problems getting it to install.
On Sat, Jun 9, 2012 at 5:28 PM, Scott Raley sra...@itc-llc.com wrote:
Yes that's what I have on my desktop but it would not install on a server.
Even a play server in my own house. That
Since MySQL isn't free anymore what other db's are people using?
-Original Message-
From: Larry C. Lyons [mailto:larrycly...@gmail.com]
Sent: Saturday, June 02, 2012 4:15 PM
To: cf-community
Subject: Re: Where is MySQL
JJ turned me on to RazerSQL. Its not free but works pretty well
02, 2012 4:15 PM
To: cf-community
Subject: Re: Where is MySQL
JJ turned me on to RazerSQL. Its not free but works pretty well.
On Sat, Jun 2, 2012 at 4:11 PM, Bruce Sorge sor...@gmail.com wrote:
I installed workbench this morning and had my fb done in a few hours.
I like the tool
You may want to install MySQL Workbench. That will give you a gui,
http://www.mysql.com/products/workbench/
for starting and stopping there's a control panel app included in the
download. If you can't find it I have a copy for OSX Mountain Lion.
On Fri, Jun 1, 2012 at 8:14 PM, Bruce Sorge
I installed workbench this morning and had my fb done in a few hours. I
like the tool.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
JJ turned me on to RazerSQL. Its not free but works pretty well.
On Sat, Jun 2, 2012 at 4:11 PM, Bruce Sorge sor...@gmail.com wrote:
I installed workbench this morning and had my fb done in a few hours. I
like the tool.
OK, another question,
I just installed MySQL. Once it successfully installed I looked for it in
Finder but could not find it. It said that it was installing on my HD. Any idea
where it is?
Thanks again,
Bruce
~|
Order the
are you looking for where the files are?
probably in the /usr/local directory.
if you are looking for the app, there isnt a gui interface. there is
a command line interface you should be able to start up from terminal
using the command mysql.
But to keep sane, install a gui of some sort, like
Yeah, I was looking for a gui. Thanks Jerry. I'll do that.
On Jun 1, 2012, at 6:10 PM, Jerry Milo Johnson wrote:
are you looking for where the files are?
probably in the /usr/local directory.
if you are looking for the app, there isnt a gui interface. there is
a command line interface
MySQL is command line based there is a MySQL workbench that is a
separate download
On Jun 1, 2012 8:15 PM, Bruce Sorge sor...@gmail.com wrote:
Yeah, I was looking for a gui. Thanks Jerry. I'll do that.
On Jun 1, 2012, at 6:10 PM, Jerry Milo Johnson wrote:
are you looking for where
21 matches
Mail list logo