I am trying to make a script that has an admin and
search area. The admin area let's the user upload 10
photos and a discription for a property, then select
from drop down menus for bedrooms,bathrooms,price for
rental, golfing or not comunity,comunity name and code
number"each has it's own for fast
Michael Stassen wrote:
Before loading the file,
SET FOREIGN_KEY_CHECKS = 0;
after loading the file,
SET FOREIGN_KEY_CHECKS = 1;
That's it! Thanks :)
Even better, upgrade to a newer mysql (4.1.1+), where they are
automatically added to the dump file for you.
Not until the client lib
Hi Jonas,
>From the manual
A comment for a column can be specified with the COMMENT option. The
comment is displayed by the SHOW CREATE TABLE and SHOW FULL COLUMNS
statements. This option is operational as of MySQL 4.1. (It is allowed
but ignored in earlier versions.)
Regards
David Logan
Data
i think you can use -K on your mysqldump and it'll put the hints in there
for the mysql command to use as well
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To:
Sent: Thursday, September 29, 2005 7:45 PM
Subject: Backup / Restore database with foreign keys
Greetings
Daniel Kasak wrote:
Greetings.
I've just hit an interesting problem. Luckily I don't actually *need* to
restore from a backup right now - I'm just trying to create a database
dump to submit an unrelated bug report.
Anyway ...
I'm using the command:
mysqldump -K DATABASE_NAME > db.sql -p
H
Greetings.
I've just hit an interesting problem. Luckily I don't actually *need* to
restore from a backup right now - I'm just trying to create a database
dump to submit an unrelated bug report.
Anyway ...
I'm using the command:
mysqldump -K DATABASE_NAME > db.sql -p
However when I create
Martijn van den Burg wrote:
On Wednesday 28 September 2005 20:47, Siegfried Heintze wrote:
Other databases allow one to store comments describing each field in a
table definition. These are stored in the database. In addition, one can
store comments about the table. Examples include MS SQL S
hi Scott
> How do I run more than 1 queries in MySQL Query Browser?
The only way I've found is to put the queries in a .sql file and load it
via File > Open Script. It doesn't accept multiple typed in queries,
even if they are separated by semicolons.
hth
Rob
--
MySQL General Mailing List
George Herson said:
> James G. Sack (jim) wrote:
>
>>On Mon, 2005-09-19 at 13:14 -0400, George Herson wrote:
>>
>>
>>>James G. Sack (jim) wrote:
>>>
>>>
>>>
On Mon, 2005-09-19 at 12:15 -0400, George Herson wrote:
>Dear Jim,
>
>Re: your post at http://lists.mysql.
Hi
We have a database on MySql 4 and it contains many tables. In each field in
the table in the past were there was no data to display we simply left the
field blank, we now want to replace a null entry with No Data
I have no problem doing this on an individual field in each table like so
UPDA
Nick Hird <[EMAIL PROTECTED]> wrote on 09/29/2005 05:03:53 PM:
> Is there a way to have foreign keys and force referential integrity? I
have
> a main table and a lookup table, i want to be able to require that the
main
> table is using values from the lookup table. I am just not sure how in
> My
Is there a way to have foreign keys and force referential integrity? I have
a main table and a lookup table, i want to be able to require that the main
table is using values from the lookup table. I am just not sure how in
MySQL. Thanks
James G. Sack (jim) wrote:
On Mon, 2005-09-19 at 13:14 -0400, George Herson wrote:
James G. Sack (jim) wrote:
On Mon, 2005-09-19 at 12:15 -0400, George Herson wrote:
Dear Jim,
Re: your post at http://lists.mysql.com/mysql/189058, why bothe
Hello.
Have a look here:
http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
lu ming wrote:
>Who can tell me how to use the MySQL's test tool ("\MySQL\MySQL
> Server 5.0\bin\mysqltest.exe") ?I want to test the mysql server, and
> i find the test tool in the directory "\M
Hello.
At first, you should find out the root of the problem. Use 'SHOW
PROCESSLIST' or mysqladmin processlist (-i 1 -r options might be
helpful). See:
http://dev.mysql.com/doc/mysql/en/show-processlist.html
>1 query may be performed by mySQL at a time.
>is this true ?
It depend
> -Original Message-
> From: Devananda [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 29, 2005 14:56
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: MyISAM to InnoDB
>
>
> Jeff wrote:
> >
> > Well the applications with persistant connections is a
> touchy subject.
> > Our
Jeff wrote:
Well the applications with persistant connections is a touchy subject.
Our apps send and rec data over satelite links which are very expensive.
The shorter the duration of the link the less it costs us. So the
pervailing theory is that with persistant connections the apps will
spend
How do I run more than 1 queries in MySQL Query Browser?
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
Hi,
2005/9/23, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
> "Jeff" <[EMAIL PROTECTED]> wrote on 09/23/2005 09:57:06 AM:
>
>
> Yes, I meant exactly that. Within each MySQL server is a "special"
> database called `mysql`. That is the database that contains the tables of
> all of the user login and permi
To check for more than one channel-per-record in the table:
select channel,count(*) as cnt from ChannelStatus group by channel having cnt>1
should return zero records if you have no dups.
On 9/29/05, Hal Vaughan <[EMAIL PROTECTED]> wrote:
> I have a query like this:
>
> SELECT DISTINCT Channel,
Hi Jörg,
On Thursday 29 September 2005 12:09, you wrote:
> Hi Martijn, all!
>
> Martijn van den Burg wrote (reordered)
>
> > On Wednesday 28 September 2005 20:10, Gleb Paharenko wrote:
> >>Martijn van den Burg wrote:
> >>>Hi list,
> >>>
> >>>After the most recent reboot (which we used to increase
I have a query like this:
SELECT DISTINCT Channel, ChannelType, Source FROM ChannelStatus;
Each channel is supposedly listed in this table only 1 time, but just in case,
what I really want to do is make sure that no channels are duplicated. Is
there some way to make the keyword "DISTINCT" appl
Tony Leake wrote:
On Thu, 2005-09-29 at 16:15 +0100, Nuno Pereira wrote:
[EMAIL PROTECTED] wrote:
This one is interesting in terms of concurrency...
Is the app2 the one responsable for setting the flag? I supose that it is.
If that happens it's important that app2 doesn't mess with the fla
Marco Baar wrote:
of cause your right.
hello
dear Nuno Pereira,
I use mysql since 2 years and collected about 50 MB user data. I ve got a
performance problem during selecting the main table. The table has about
200.000 rows and I make a simple select. I only select over 4 attributes
with "="
Nuno Pereira <[EMAIL PROTECTED]> wrote on 09/29/2005 11:15:08 AM:
> [EMAIL PROTECTED] wrote:
> > Tony Leake <[EMAIL PROTECTED]> wrote on 09/29/2005 07:08:24 AM:
> >
> >
> >>Hi
> >>
> >>I have 2 applications communicating via a mysql database
> >>
> >>the db is 4.1.8 running on a debian linux sys
On Thu, 2005-09-29 at 16:15 +0100, Nuno Pereira wrote:
> [EMAIL PROTECTED] wrote:
>
> This one is interesting in terms of concurrency...
>
> Is the app2 the one responsable for setting the flag? I supose that it is.
> If that happens it's important that app2 doesn't mess with the flag, i
> mean
> "Jeff" <[EMAIL PROTECTED]> wrote on 09/29/2005 08:47:52 AM:
>
> >
> > > Jeff wrote:
> > > >
> > > > Ugh...
> > > > mysqladmin -uroot -ptelaurus processlist | grep -c
> "Sleep" And it
> > > > returned 200 sleeping connections, all persistant
> > > connections
> > > > from our app servers and
[EMAIL PROTECTED] wrote:
Tony Leake <[EMAIL PROTECTED]> wrote on 09/29/2005 07:08:24 AM:
Hi
I have 2 applications communicating via a mysql database
the db is 4.1.8 running on a debian linux system.
All tables are innodb
app 1 1 runs on a windows machine, is written in c# and talks to the
On Sep 28, 2005, at 4:03 PM, [EMAIL PROTECTED] wrote:
(1) is almost possible with 5.0. The Federated storage engine
creates the
equivalent of "linked tables" but it is MySQL-to-MySQL only. There are
other restrictions, too. As soon as they work out the kinks for
MySQL-to-ODBC, you will be in
On Thu, 2005-09-29 at 09:30 -0400, [EMAIL PROTECTED] wrote:
> The key here is
> that you are making multiple changes from app1 that really should be
> within a transaction. The entire process of writing sales data and
> unsetting a flag from app1 needs to be transacted. That way the other
>
"Jeff" <[EMAIL PROTECTED]> wrote on 09/29/2005 08:47:52 AM:
>
> > Jeff wrote:
> > >
> > > Ugh...
> > > mysqladmin -uroot -ptelaurus processlist | grep -c "Sleep"
> > > And it returned 200 sleeping connections, all persistant
> > connections
> > > from our app servers and 4 threads_running
> >
Tony Leake <[EMAIL PROTECTED]> wrote on 09/29/2005 07:08:24 AM:
> Hi
>
> I have 2 applications communicating via a mysql database
>
> the db is 4.1.8 running on a debian linux system.
> All tables are innodb
>
> app 1 1 runs on a windows machine, is written in c# and talks to the db
> with odb
> Jeff wrote:
> >
> > Ugh...
> >
> > mysqladmin -uroot -ptelaurus processlist | grep -c "Sleep"
> >
> > And it returned 200 sleeping connections, all persistant
> connections
> > from our app servers and 4 threads_running
> >
> > Also a show status gave me a max_used_connections of 236.
> >
Hi Marco, all,
this list uses English - I will translate the main points only:
Marco Baar wrote:
Hallo,
Ich benutze mysql seit 2 Jahren. Inzwischen haben sich 50MB Nutzdaten
angesammeln und hab ein Problem mit der Performance während der Abfrage
meiner "Haupttabelle".
| Using MySQL for 2 year
Hi
I have 2 applications communicating via a mysql database
the db is 4.1.8 running on a debian linux system.
All tables are innodb
app 1 1 runs on a windows machine, is written in c# and talks to the db
with odbc
app 2 runs on the same machine as the db and is writtin in php.
Here's the pro
Hi Thomas, all!
thomas Armstrong wrote:
Hi.
Working on Linux Fedora Core 2.
I'm programming an application which requires version 14 of the MySQL Client
libraries. Now I've got version 10:
---
[[...]]
/usr/src/mysql-3.23.58/libmysql/.libs/libmysqlclient.so.10
/usr/src/mysql-3.23.58
Marco,
Traurig - ich habe das googleübersetzungshilfsmittel benutzt, um zu
versuchen, Ihnen zu helfen.
Bevor Sie Benutzerprioritäten betrachten, schlage ich Sie Blick an vor, wie
Ihre Daten registriert werden. Mysql verwendet nur einen Index pro Frage,
also muß Ihre Tabelle einen Index auf jede
What?
Please post in english.
Marco Baar wrote:
Hallo,
Ich benutze mysql seit 2 Jahren. Inzwischen haben sich 50MB Nutzdaten
angesammeln und hab ein Problem mit der Performance während der Abfrage
meiner "Haupttabelle".
Die Tabelle hat ca 200.000 Datensätze und ich mache im verhältnis zu ander
Hi Martijn, all!
Martijn van den Burg wrote (reordered)
On Wednesday 28 September 2005 20:10, Gleb Paharenko wrote:
Martijn van den Burg wrote:
Hi list,
After the most recent reboot (which we used to increase the
ulimit/open_files_limit on our Solaris 8 machine running 4.1.10-log),
the follo
Who can tell me how to use the MySQL's test tool ("\MySQL\MySQL Server
5.0\bin\mysqltest.exe") ?
I want to test the mysql server, and i find the test tool in the
directory "\MySQL\MySQL Server 5.0\bin\" (my os is Windows2000), but it can
not be executed directly. Further more i can not fi
On Sep 28, 2005, at 5:05 PM, Atle Veka wrote:
I am planning on running some tests on a SATA server with a 3ware 9000
series RAID card to see if there's a stripe size that performs
better than
This might be able to help you out:
http://hashmysql.org/index.php?title=Opteron_HOWTO
These ar
41 matches
Mail list logo
