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 creat
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 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 de
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
statement
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.
~|
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 is not
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 wrote:
>
> Windows Server 2008 R2
>
~~
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 Serv
>> -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?
>>
>>
40 AM, Scott Raley 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?
>
&g
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, 20
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 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 limits me to being
ebmas...@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'
.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.
>
> On Sat, Jun 2, 2012 at 4:11 PM, Bruce Sorge wrote:
>> I installed workbench this morning a
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 p
JJ turned me on to RazerSQL. Its not free but works pretty well.
On Sat, Jun 2, 2012 at 4:11 PM, Bruce Sorge wrote:
>
> I installed workbench this morning and had my fb done in a few hours. I
> like the tool.
>
>
>
~|
Order th
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:
http
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 wrote
MySQL is command line based there is a MySQL workbench that is a
separate download
On Jun 1, 2012 8:15 PM, "Bruce Sorge" 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 the file
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 in
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, li
20 matches
Mail list logo