Hi Paul,
I does not matter if you use the my.ini in the Windows directory or the
my.cnf in the c: root, but the last one will be used first.
You my.cnf (and my.ini also) should look like this:
---stat of my.cnf
[mysqld]
default-character-set=hungarian
default-table-type=InnoDB
innodb_data_file_p
Thanks Daniel,
I've looked for the "my.cnf" file but couldn't find it but I found a
"my.ini" under the c:\Winnt directory, with the following content:
[WinMySQLAdmin]
Server=c:/mysql/bin/mysqld-nt.exe
I've tried appending the line "default-character-set=big5" to it and
restarted MySQL but doesn
Hi,
Shut your database down, backup all files, and restart it
If you use InnoDB you can do a hot backup like Oracle (the implementation of InnoDB is
near of Oracle), but it's not free. I can't say more about this, but it's in the
documentation about InnoDB.
You can also keep a differenti
Hi
You have to write a line like this into your my.cnf (in the C: root directory):
default-character-set=...
or whatever you like. You can find examples in your mysql directory for the
my.cnf file.
Oh, yes! You're from Hong Kong. So maybe you need this:
default-character-set=big5
Bye,
Hi all,
I've checked the doco and found that it can be changed by ./configure under
Linux, but how do I change the default charset of MySQL under Win2K. Do I
have to re-compile the source or better yet can I change it on the fly or
using WinMySQLAdmin or something?
TIA
Paul
--
MySQL does not have a boolean type. For yes/no or true/false information, I
usually use an enumerator (enum) and define the "false" value first and the
"true" second. (So "no" would be first and "yes" second.) Then, when I
query for the value in that field, I can ask for it minus one, and I get
HI All
I am new to mysql. We have a small application which runs on mysql db. We
want to backup the database for mysql. What is the easiest method to that ?
Do we have to move datafiles or import export like oracle ? If you can send
me a specific link or article for backup and recovery for mysq
On Wed, Oct 30, 2002 at 05:56:52AM +0100, Mark wrote:
>
> Is this all true? Bummer. :( I just upgraded to 3.23.53 (from
> .49). I cannot afford to get these huge load averages on my news
> server. Nor can I afford thread thrashing. I just had to let myself
> be talked into upgrading. See if I still
Is this all true? Bummer. :( I just upgraded to 3.23.53 (from .49). I cannot
afford to get these huge load averages on my news server. Nor can I afford
thread thrashing. I just had to let myself be talked into upgrading. See if
I still have the .49 binary.
Seriously, are there any MySQL developers
On Tue, Oct 29, 2002 at 08:25:00PM -0800, heath boutwell wrote:
> --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> > Can you post the output of SHOW VARIABLES?
> |
> | key_buffer_size | 402649088
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> Can you post the output of SHOW VARIABLES?
|
+-+
| back_log| 50
On Tue, Oct 29, 2002 at 07:37:09PM -0800, heath boutwell wrote:
> > --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> >You're disk-bound, not CPU bound. Notice all the idle CPU time? And
> >the fact that the "b" column always has one process listed, while "r"
> >only does once in a while.
>
> 2 gi
> --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
>You're disk-bound, not CPU bound. Notice all the idle CPU time? And
>the fact that the "b" column always has one process listed, while "r"
>only does once in a while.
2 gigs of ram -- don't really know why we'd be disk bound. The my.cnf is
pretty
Hi people,
what is the best type to substitute the boolean type of msaccess tables.
Or mysql databases support the boolean type?
Angelo.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
SQL ...
I have a myisam table that registers documents in my database ..
There is a longtext field for the actual document data in HTML
the table (file , MYD) is about 1.2 MB, but from 300 records it had
only reports 6 ...
I use repair table extended and works fine until I get and error
no en
[EMAIL PROTECTED] wrote:
Hi all,
After setting the field data type in MySQL to Text, which is the same data
type for Access data type where the data is being imported from, the import
process was succeful and the same number of rows was imported, BUT I
don't see any data in the MySQL, all
I use MySQLFront and is creats the tables and imports the data with one
click
never had a problem
Alan
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:Sam4Software@;aol.com]
> Sent: Wednesday, 30 October 2002 9:15
> To: [EMAIL PROTECTED]
> Subject: Access2MySQL
>
>
> Hi all,
>
> Aft
On Tue, Oct 29, 2002 at 03:56:04PM -0800, heath boutwell wrote:
>
> --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> > Well, "load average" can be misleading.
> >
> > Can you maybe share the output of "vmstat 1" or "vmstat 5" for a
> > minute's worth of time? It's be good to see what the CPUs sta
On Tue, Oct 29, 2002 at 02:34:44PM -0800, heath boutwell wrote:
> --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> > I've read others who've said it fixed the problem
> > for them. Did you
> > check the archives?
>
> Jeremy,
>
> Thanks for mytop. Its a great tool and its been a great help in
> d
Here's what I did. Based on the same query (the one you provided) as below
I executed the following:
select mgrname, pjname from managers, projects, pocs
WHERE pjid = 'x'
AND pocs.pjid = projects.pjid
AND pocs.pmyid = 'x'
AND pocs.altid = 'x'
AND (pocs.pmyid = managers.pmyid OR pocs.altid = manag
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> I've read others who've said it fixed the problem
> for them. Did you
> check the archives?
Jeremy,
Thanks for mytop. Its a great tool and its been a
great help in diagnosing our problems.
I saw where a few of the others claimed the latest
binari
Hi all,
After setting the field data type in MySQL to Text, which is the same data
type for Access data type where the data is being imported from, the import
process was succeful and the same number of rows was imported, BUT I
don't see any data in the MySQL, all I see is Null, Null. a
In Jannie's problem,
CREATE TABLE pub_access_type(
access_type_id INT UNSIGNED NOT NULL,
access_type_name VARCHAR(25),
PRIMARY KEY(access_type_id)
) TYPE=INNODB;
CREATE TABLE pub_user(
user_id INT UNSIGNED,
parent_id INT,
user_fname VARCHAR (25),
user_lname VARCHAR (25),
user_password VAR
What are the possible causes for this error message ?
This problem occured right after I restarted mysqld on my machine. I can
access mysql on localhost without any failure, either in command mode,
telnet or via httpd with PHP, but connection via PHP on remote machine
fails.
Here's what I see if
On Tue, Oct 29, 2002 at 01:28:01PM -0800, heath boutwell wrote:
>
> Can anyone that was experiencing the thread thrashing problems with
> the other binaries confirm that this has been with resolved with
> 53a?
I've read others who've said it fixed the problem for them. Did you
check the archives?
On Tue, Oct 29, 2002 at 02:38:49PM -0600, Don Arnett wrote:
>
> I can't find any info on this, so doubt that it's possible. Is there a way
> to have General Logging enabled, but not log every database on the server?
> I have one database that I'd like to not be logged (too much activity), but
> d
Can anyone that was experiencing the thread thrashing
problems with the other binaries confirm that this has
been with resolved with 53a?
I have installed the new binaries and will report what
is observed here after periods of heavy load.
Others on the list experienced the same occurances.
Previ
SELECT ... ORDER BY score LIMIT 10
PB
-
- Original Message -
From: "Kevin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 1:11 PM
Subject: Query - Top Ten
> Hello,
>
> I have a table with the following structure and values:
>
> CustomerIDScore
>
>
> Hello,
>
> I have a table with the following structure and values:
>
> CustomerIDScore
>
> 4 8
> 2 6
> 3 2
> 3 8
> 4 7
> 2 7
>
> I would like to query
Hello,
I have a table with the following structure and values:
CustomerIDScore
4 8
2 6
3 2
3 8
4 7
2 7
I would like to query for the top ten customer ave
>Description:
When a slave is pointing to a non-existing master, doing "slave start/slave
stop"
will sometimes cause the MySQL server to crash
>How-To-Repeat:
mysql> change master to master_host='bogus', master_log_file='';
Query OK, 0 rows affected (0.00 sec)
I am receiving an error 2013: Lost Connection to MySQL server during query
when I try to remotely log onto mysql. If I am at the Linux box, and I type
mysql -u -p I can connect, but if I do a mysql -h -u -p it
gives me this message. Also, I cannot connect from another machine at all.
Stopping mys
Then, why..., if I wait a little longer, does the alter command work? I do
not change the the permissions in the meantime. I just wait.
Alan
> -Original Message-
> From: gerald_clark [mailto:gerald_clark@;suppliersystems.com]
> Sent: Tuesday, 29 October 2002 1:38
> To: Alan McDonald
> Cc:
Perhaps a simple question. The solaris server we have has an older mysql. I
don't know which version since I did not install it. The mysql main file is
now segment faulting for some reason. I restored a backup but its not
working either. It just worked a few days ago. I assume the file is now
c
I can't find any info on this, so doubt that it's possible. Is there a way
to have General Logging enabled, but not log every database on the server?
I have one database that I'd like to not be logged (too much activity), but
don't have the option of moving it to a separate server.
Thanks
Don
S
Jannie,
In CREATE TABLE ... TYPE=InnoDB with a foreign key ref, MySQL seems to want
a type def and NOT NULL in the definition of the column to be used as a
foreign key.
PB
-
- Original Message -
From: "Jannie Qu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 29,
i also figured out that load_file only works on the local server, not from
clients...duh!
thanks!
-Original Message-
From: Egor Egorov [mailto:egor.egorov@;ensita.net]
Sent: Tuesday, October 29, 2002 12:19 PM
To: [EMAIL PROTECTED]
Subject: re: using load_file...problems
Shon,
Tuesday, O
I have been successful (after days of trying) with Apache 2.0.43 ,
PHP 4.2.3 on Redhat 7.3
I compiled php with ./configure --with-mysql --with-apxs2=/apth/to/apxs
(apxs is under /path/to/apache2/bin)
After 'make' and 'make install' you will find libphp4.so in
/path/to/apache2/modules
Then I add
Have you looked at using the Microsoft DTS tool with the MyODBC? Setting
this up should be straightforward.
I hope this helps
-Original Message-
From: Gator [mailto:gator@;acs.bz]
Sent: Tuesday, October 29, 2002 12:34 PM
To: [EMAIL PROTECTED]
Subject: Replication from MS SQL to MySQL
Do
Does anyone know of a way to have automatic replication of a MS SQL database
to MySQL?
I have an active database in MS SQL and I need one of the tables replicated
over into a MySQL database on Linux. It would be nice to have real time
replication, but even if it was updated every 10 minutes would
sql, query, mysql
Hi, all,
I met a problem with creating the following table: pub_user.
-- Parent table
CREATE TABLE pub_access_type(
access_type_id INT UNSIGNED NOT NULL,
access_type_name VARCHAR(25),
PRIMARY KEY(access_type_id)
) TYPE=INNODB;
-- Child table
CREATE TABLE pub_user(
user_id INT UNS
Hi,
It's possible, to have some software/scripts which run in out of environment
space.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Origin
Don,
- Original Message -
From: "Don Arnett" <[EMAIL PROTECTED]>
To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 8:12 PM
Subject: logging
>
> I'm new to this list. I couldn't find a search facility for searching
> previous answers. If there is one, please let m
Hi!
Just specify different ports, data and base directories for those instances
(using command-line parameters -P, --basedir and --datadir respectively, for
example).
Instance 1 startup:
mysqld-nt -P=3306 --basedir=e:/mysql1 --datadir=e:/mysql1/data --console
--standalone
Instance 2 startup:
mys
Instead of
echo htmlspecialchars( stripslashes($row["$i"]));
use
echo htmlspecialchars( stripslashes($row[0]));
In fact , if you increase $i you increase the column thus , in the first
cycle you see col 0 , in the second col 1
for more information visit
http://www.php.net
From: Heikki Tuuri
To: Serdioukov Edouard
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 29, 2002 7:23 PM
Subject: Re: InnoDB, Foreign Key
Edouard,
I tested this on Linux using mysql-max-3.23.51, the .tar.gz distro. It
worked ok.
Are you sure you were using 3.23.51? Starting from 3.23.50, InnoDB
Group,
We have been running along with little or no problems with mysql installed
on windows 2000. Just recently I have been noticing a creation - great qty
of creation of temp files in my script directories.
I have all of my scripts on C drive with mysql on my D drive using junction
to make a l
Sorry to have bothered the list, for anyone's info...
You have to have the CDF files on `all' servers, not just the MASTER in
order for the mysqlimport to work.
Robert B.
On Tue, 29 Oct 2002, zxcv wrote:
>
> Hello all,
>
> I have a cron job that:
>
> 1 - truncates some working tables [WORKS
Shon,
Tuesday, October 29, 2002, 7:01:47 PM, you wrote:
SS> i am trying to insert data into a blob column. its not working. i have tried
SS> setting --local-infile=1. i tried granting file to my user and got an error.
SS> i have read the manaul (for all you smarties who like to rtfm everyone) and
Hi Wim,
I'm no expert with compilers and mysql either, but I have gotten mysql
to compile sucessfully on Solaris 9 using gcc 2.95.2.
If you look at http://www.mysql.com/downloads/mysql-3.23.html , in the
source code download section, you'll see that they recommend using the
compiler gcc-2.95.2, ho
sql/mysql
i am trying to insert data into a blob column. its not working. i have tried
setting --local-infile=1. i tried granting file to my user and got an error.
i have read the manaul (for all you smarties who like to rtfm everyone) and
still don't get it. here is what i did for grant
grant fi
> How can i extract names of columns from table? I am doing select *
> from table, then i want to get name of columnsis it possible?
"show columns from XXX" where XXX is the name of the table.
sql, query
-
Before posting, pl
Hello all,
I have a cron job that:
1 - truncates some working tables [WORKS | BOTH]
2 - does a mysqlimport on some CDF files [WORKS | MASTER_ONLY]
3 - truncates a selection of production tables [WORKS | BOTH]
4 - select from working into production tables [WORKS | BOTH]
Step 4 doesn't work on
If you know the total number of amenities, n, then you could try this:
SELECT h.ID, count(*) as total
FROM AmenityLink al, Hotels h
where al.HotelID=h.ID
AND ShowHotel = 1
AND PostCode = '$postcode'
group by h.ID
having total=n
Hope it helps.
Cheers,
Clemente Zamora
GlobalReservas
(http://www.c
Hi,
I'm a new user of MySQL (but not of databases...), and new member of this mail-list,
and I hope I don't bother anyone with a question already asked (and with my
english...).
I'm interested in the InnoDB part of MySQL because I thing it's more reliable than
other table's type, and because i
Insanely Great wrote:
Hi!
If you want to traverse two result set in the same time then use the
mysql_store_result(). If you don't have a big resultset coming then probably
mysql_store_result() in the same connection is a better option.
Otherwise you have to use two connections.
Thanx,
just wa
I currently have an authentication server on my home
network setup to do LDAP authentication. However, I
would like to modify the LDAP server to use MySQL to
store the information on the backend. I know that
OpenLDAP supports SQL back-ends (I believe through
ODBC, but I could be wrong) but I can'
If you have Excell you can use the Get External Data to get the data from
MySQL using MyODBC.
Also you can use MSQuery to query the database and send the result to Excel.
Another way would be to write a macro that uses ADO and process the results
into the workbook.
HTH
JFernando
*** sql ***
---
* blah
> Hi,
> I want to use MySQL to store ESM (Symantec Enterprise
> Security Manager)
> data. The problem is that in one of their table, there is a field named
> "FullText".
"FULLTEXT" is a reserved word in mysql. Use backticks:
mysql> create table ESMMessage2 (`FullText` text NOT NULL);
> # Query_time: 17 Lock_time: 6 Rows_sent: 207550
> Rows_examined: 207550
> SELECT ID FROM sys_users;
If this is really the query that you want to do, there really isn't
much you can optimize. You're asking for every ID in the table,
so MySQL has to examine every row, and send every row.
You
At 7:58 -0600 10/29/02, Chris Boget wrote:
I see the above referenced throughout the documentation
in the context of foreign keys. What are the possible
choices for "CONSTRAINT symbol". I've searched the
docs and have come up empty in this regard.
It doesn't much matter, given that it's ignore
Hi,
from my slow queries logfile:
# Query_time: 17 Lock_time: 6 Rows_sent: 207550 Rows_examined: 207550
SELECT ID FROM sys_users;
1 row = 1 user. mySQL gets queried through PHP.
I'd like to optimize this. 17 seconds is too much. How do you guys judge
the actual CPU impact of the process tha
Many Thanks ... now works fine!
Natale Babbo
--- Joseph Bueno <[EMAIL PROTECTED]> ha
scritto: > Hi,
>
> Make sure that your system starts at runlevel 3 on
> boot. If you start your machine with X11, chances
> are
> that its runlevel is 5.
>
> Check your /etc/inittab file and look for a line
>
Hi,
Make sure that your system starts at runlevel 3 on
boot. If you start your machine with X11, chances are
that its runlevel is 5.
Check your /etc/inittab file and look for a line
with "initdefault" keyword:
id:3:initdefault:
If you start at runlevel 5, you should create a symbolic
link in /e
> How can i extract names of columns from table? I am doing select *
> from table, then i want to get name of columnsis it possible?
Use desc or describe.
http://www.mysql.com/doc/en/DESCRIBE.html
David
-
Before posting,
Are you sure you boot into run level 3, and not 5?
Check your /etc/inittab for
id:3:initdefault
Natale Babbo wrote:
Many Thanks
No problems with mysql.server script ... it works fine
if i start it manual like this:
shell> mysql.server start
or
shell> mysql.server stop
... also symbolic li
Hello,
How can i extract names of columns from table? I am doing select *
from table, then i want to get name of columnsis it possible?
--
Best regards,
Martin mailto:corwin@;corwin.sk
for filter - sql and query
--
Try:
Desc name_table
- Original Message -
From: Martin Hudec <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 12:31 PM
Subject: getting name of columns
> Hello,
>
> How can i extract names of columns from table? I am doing select *
> from table, then i want t
Many Thanks
No problems with mysql.server script ... it works fine
if i start it manual like this:
shell> mysql.server start
or
shell> mysql.server stop
... also symbolic link in /etc/init.d/rc3.d is ok.
The only problem is that MySQL service doesn't start
at boot.
Natale Babbo.
--- Ii
I see the above referenced throughout the documentation
in the context of foreign keys. What are the possible
choices for "CONSTRAINT symbol". I've searched the
docs and have come up empty in this regard.
Chris
sql,query
-
B
Courrier recu par moi-meme. ; 29 Oct 2002 03:57:13 -
Message recu de: unknown (helo CAGMAW200710) par 207.35.122.83 avec SMTP; 29 Oct 2002
03:57:13 -
Message-ID: <002301c27f52$dc1cb570$[EMAIL PROTECTED]>
From: "blah" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: "FullTest" as the co
> -Original Message-
> From: Chris Mason [mailto:masonc@;masonc.com]
> [...]
> The problem is, it is easy to test for one amenity, but I need to test
> that the hotel has all of the amenities. The query above
> returns all the
> hotels that have ANY of the amenities, I need the hotels hav
On Tue, 29 Oct 2002, Natale Babbo wrote:
> Hi all,
>
> I'm using Linux Suse 8.0.
> I copied the file mysql.server located in
> /usr/local/mysql/support-files to /etc/init.d
> directory.
> I made a simbolic link to mysql.server script in
> /etc/init.d/rc3.d but MySQL doesn't appear to start at
> th
Greetings...
Yes.
If you want to traverse two result set in the same time then use the
mysql_store_result(). If you don't have a big resultset coming then probably
mysql_store_result() in the same connection is a better option.
Otherwise you have to use two connections.
Rgds
Insane
SQLyog - The
Edouard, you have a foreign key referencing a column in its own table.
PB
-
- Original Message -
From: "Serdioukov Edouard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 3:23 AM
Subject: InnoDB, Foreign Key
Hello
I use Linux Red Hat 7.3 and MySQL-max
Are you adding a row per click?
I have just done the same and my table looks like this...
===
CREATE DATABASE marketing;
CREATE TABLE bsafeLinks
(date DATE NOT NULL,
clicks INT(255) NOT NULL);
ALTER TABLE bsafeLinks
ADD PRIMARY KEY (
Hi all,
I'm using Linux Suse 8.0.
I copied the file mysql.server located in
/usr/local/mysql/support-files to /etc/init.d
directory.
I made a simbolic link to mysql.server script in
/etc/init.d/rc3.d but MySQL doesn't appear to start at
the boot time.
Anyone can help me?
Thank in advance.
Natal
So I have question.
is it ok if I put all data in one table by days (by date)
in resul I will have lot of rows
day 20021025 - 45000 rows
day 20021026 - 23445 rows
day 20021027 - 389023 rows
day 20021028 - 78632 rows
total = 536100 rows of data
I count web page hits and hosts by hourly rotat
I would appreciate it if some one can do a hand hold on this one. I need to convert
from Access to mysql but still using MS Access Front End, I understand this is done
via ODBC link to the mysql server and this is my problem. Due to my lack of command
line knowledge and no GUI on the Cube for MY
Whoops - sorry...
I meant use "select field1,field2 into outfile '/somepath/somename.xls' from
table1 where this=that;"
Select into outfile is explained here
http://www.mysql.com/doc/en/SELECT.html
Please don't use mysqldump - that was my mistake (writing two emails at once
- sorry!)
Andrew,
S
Hello
I use Linux Red Hat 7.3 and MySQL-max version 2.23.51. I have one problem.
I created table:
CREATE TABLE Folders (
FOLDER_ID INTEGER NOT NULL,
FOLDER_NAME VARCHAR(50) NOT NULL,
PARENT INTEGER NULL,
PRIMARY KEY (FOLDER_ID),
KEY XIE1_Folders (PARENT),
FOREIGN KEY (PAR
Hi,
I have MySQL version 3.23.41 and when I connect from localhost, it's OK.
Hovewer, when I connect via IP (f.e. mysql -h IP, or from other computer in
Internet), then MySQL resut error ERROR 2013: Lost connection to MySQL
server during query.
This is a part of variable from MySQL on the my server
Hi All
I have a database named "bugs" on server and and a user assigned for it named
"bugs" only. This database is used for Bugzilla database and till today it
was running fine. However there were some changes done by system
administrator and then the connectivity from the application stopped.
Alan,
Monday, October 28, 2002, 10:13:45 PM, you wrote:
AM> But after a while it does, cause I only have to wait a while with no
AM> activity on the database, and the command executes. So it's not permissions
Do you use MySQL server on Windows? There was a bug with
lower_case_table_names=1 on Win
Hello,
see below...
--
Best regards,
Martinmailto:corwin@;corwin.sk
Tuesday, October 29, 2002, 10:51:17 AM, you wrote:
PL> Hi
PL> If the records are all independant - ie travel agent (TA) A has their own
PL> records and so does TA B then REPLACE INTO MainDB SELECT
mike,
Tuesday, October 29, 2002, 4:21:40 AM, you wrote:
maddn> After upgrading mysql to 3.23.53, mysqld would segfault every time
accessing a certain database. After running checks
maddn> on the database and making sure everything was okay, I started mysqld up in
gdb.
maddn> Program re
Hi,
You can use mysqldump (http://www.mysql.com/doc/en/mysqldump.html) to dump
the file into a tab delimited text file or cvs. You will be able to open it
in excel in those formats.
Alternatively (if you want to get a bit more involved) there is a perl
module you could use called Spreadsheet::Wr
Marco,
Tuesday, October 29, 2002, 7:22:44 AM, you wrote:
MB> I need your expert and slow guided assistance.
MB> I would like someone to explain to me the correct mysql commands
MB> monitor to achive the following correctly.
MB> It would greatly help if you work for a hosting company.
MB> The qu
sbs,
Tuesday, October 29, 2002, 7:31:03 AM, you wrote:
samdldlds> Description:
samdldlds> Special case: using SELECT with truncation doesn't return some
records
samdldlds> when the searched query appears at the end of the line. Note that
the last record will
samdldlds> be
Hi
If the records are all independant - ie travel agent (TA) A has their own
records and so does TA B then REPLACE INTO MainDB SELECT * FROM
Travel_agent_A_DB so the main database is just receiveing updated records
from the TAs.
Travel agent logs in to master php driven site .
master php driven s
hi all,
my problem is, do you know how can i query and export a file in Excel format
except use third parties software.
regards,
Billy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
On Tue, Oct 29, 2002 at 01:02:51AM -0800, Lalit Chandwani wrote:
> Hi all,
>
> i have a mysql database on my local machine , the same database is
> my server i want to synchronize the datbases both side.
>
> is there any login or tool or mysql support for database
> synchronization
How about MyS
Hello Peter,
okay :)))so far I understand...buthmmm let me explain
I have server of travel agencies records (we need to update this, so
it is slave) with stable IPand then bunch of other computers (from
these we are updating...so they are all masters) in various travel
agencies...
Hi ,
i have a mysql database , can i store the query
defination as a table in the databse ?
As we use save query in MS access as tables or like
views in Ms SQL SERVER
thanks
__
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yah
Hello Peter,
okay :)))so far I understand...buthmmm let me explain
I have server of travel agencies records (we need to update this, so
it is slave) with stable IPand then bunch of other computers (from
these we are updating...so they are all masters) in various travel
agencies...
Assume my db will have millions of records and frequent selects.
If I plan on have a field that can be one of multiple states (A, B, C or
All), is it better to store as ENUM or TINYINT (as a mask, such that A =
1, B = 2, C = 3 and if I know that, then All = 6, and none = 0). I'm
only talking SPEED
Hi all,
i have a mysql database on my local machine , the same
database is my server
i want to synchronize the datbases both side.
is there any login or tool or mysql support for
database synchronization
thanks in advance.
=
---
Dream Team Network Solutions Pvt. Ltd.,
C-97
97 matches
Mail list logo
