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
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
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
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
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 MySQL'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)
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
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
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
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
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
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.
I
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
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
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 *
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
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
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,
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
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
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.
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
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
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 -
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
the boot
-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 having ALL
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 column name
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
-
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.
---
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 to get
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
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
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,
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
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
with
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
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 ignored
# 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
* 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);
--
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 ***
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
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
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
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
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
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,
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
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,
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
SS
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 |
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
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
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
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:
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 me know.
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]
-
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
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
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
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
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,
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, 2002
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
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
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:
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 -uuser -p I can connect, but if I do a mysql -hhost -uuser -p it
gives me this message. Also, I cannot connect from another machine at all.
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)
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
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
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
4
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.
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
don't
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?
--
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
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
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.
--- 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
binaries
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 =
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
diagnosing our
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 states look
like.
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,
After setting
[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,
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
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)
--- 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 well
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 gigs of ram --
--- Jeremy Zawodny [EMAIL PROTECTED] wrote:
Can you post the output of SHOW VARIABLES?
|
+-+
| back_log| 50
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
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
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
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
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 a
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
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,
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
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't
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
97 matches
Mail list logo