Hi
I passed Oracle SQL Expert and working on MySQL 5.6 developer exam. I work
5% of my job with SQL but I am searching for a full time SQL job.
http://shop.oreilly.com/product/0790145363466.do
Is the Excel exam (Microsoft Office Specialist - MOS) useful for getting a
junior SQL pro job? What do
...@gmail.com]
Sent: Monday, June 11, 2012 7:26 AM
To: mysql@lists.mysql.com
Subject: i need advice on redundancy of mysql server.
I am running a site with about 50gig myisam databases which are the
backend to different websites.
I can not afford any downtime and the data is realtime.
What
- Original Message -
From: Joey L mjh2...@gmail.com
It sounds like you are all consultants.
Hehe. I'm not :-p
A lot are, though, because the combined technical knowledge on this list draws
in consultants looking for stuff, and having experienced consultants on the
list in turn
Does really Master-Master replication provide load balancing feature?
since, each node need to replicate to other node, and MySQL replication
still a is single threaded replication , it mean there is only single
replication thread sql_thread for DML queries.
eg.
There is two node with master
solution. First decide what
'keeps you up at night'.
-Original Message-
From: Joey L [mailto:mjh2...@gmail.com]
Sent: Monday, June 11, 2012 7:26 AM
To: mysql@lists.mysql.com
Subject: i need advice on redundancy of mysql server.
I am running a site with about 50gig myisam databases
Tungsten to consider.
Frankly, though, I'd step back a bit from such microscopic focus on
technologies. It looks like you need advice from someone who's done
this before, to get the high-level things right before you dive deeply
into details. If it's really this important, I personally wouldn't
to consider.
Frankly, though, I'd step back a bit from such microscopic focus on
technologies. It looks like you need advice from someone who's done
this before, to get the high-level things right before you dive deeply
into details. If it's really this important, I personally wouldn't
I am running a site with about 50gig myisam databases which are the
backend to different websites.
I can not afford any downtime and the data is realtime.
What is the best method for this setup? master-master or master-slave?
What are the best utilities to create and maintain this setup? as far
when u say redudency.
Do u just want replication like master-slave, which will be active-passive
or
Master-master which be active-active.
master-slave, will work just a DR, when ur current master fails you can
failover the slave, with NO LOAD balancing.
Master-master allows load balancing.
On
On 6/11/2012 10:36 AM, Ananda Kumar wrote:
...
Master-master allows load balancing.
Why do people keep replication rings as if they are the best possible
configuration? A master-slave relationship also permits load balancing
and is easier to maintain and recover in the event of a node
I understand ..I am looking for load balancing - something that i do
not have to worry about if one server goes down - the other server
will be up and running by itself and i can bring back the other server
later on when i have time.
On Mon, Jun 11, 2012 at 10:36 AM, Ananda Kumar
That's not a description of 'load balancing'; it is a high availability
solution you're looking for.
On Mon, Jun 11, 2012 at 4:43 PM, Joey L mjh2...@gmail.com wrote:
I understand ..I am looking for load balancing - something that i do
not have to worry about if one server goes down - the other
You listed a lot of things - but no solution - i am looking for master
- master configuration.
Any tools you have used ?
Anything concrete you can offer?
thanks
On Mon, Jun 11, 2012 at 11:39 AM, Shawn Green shawn.l.gr...@oracle.com wrote:
On 6/11/2012 10:36 AM, Ananda Kumar wrote:
...
Sorry new to this part - but I am looking for both.
I have setup similar configuration using other technologies.
I was asking the group for recommendations - concrete ones ?
Can you offer up any ?
On Mon, Jun 11, 2012 at 11:54 AM, Andrew Moore eroomy...@gmail.com wrote:
That's not a description
On 6/11/2012 12:02 PM, Joey L wrote:
You listed a lot of things - but no solution - i am looking for master
- master configuration.
Any tools you have used ?
Anything concrete you can offer?
There is no one-size-fits-all approach to the problem you are
attempting to solve. However, there are
. It looks like you need advice from someone who's done
this before, to get the high-level things right before you dive deeply
into details. If it's really this important, I personally wouldn't
trust it to a mailing list, I'd hire someone. It's well worth it.
There's Percona again, of course, but there's
for Percona.) There is also Continuent
Tungsten to consider.
Frankly, though, I'd step back a bit from such microscopic focus on
technologies. It looks like you need advice from someone who's done
this before, to get the high-level things right before you dive deeply
into details. If it's really
you need advice from someone who's done
this before, to get the high-level things right before you dive deeply
into details. If it's really this important, I personally wouldn't
trust it to a mailing list, I'd hire someone. It's well worth it.
There's Percona again, of course, but there's also
Verify the regulation that a Hotel should submit, read the part of the
occupation reports, information gathering, ask management for their
currents report...
Remember the data output should came from the data stored...
On Mon, Feb 20, 2012 at 4:42 PM, Chaim Rieger li...@up-south.com wrote:
On
Where are your domain experts? You *are* consulting with them, no?
If you don't know the answers, and don't have access to domain experts to help
you, I would design for the most general case, and factor out exceptions as
they prove to be so. Pre-optimization for exceptions almost always turns
Hi,
Nobody answers because this is a very wide question about software
engineering,
Trust me, It seems like a simple question but it is not.
The only advice I can give you is to try to imagine all possible
scenarios/use-cases before starting the design.
Cheers
Claudio
2012/2/20 Jan Steinman j
Hi
I am trying to get some background information with regards the design. I have
a fair idea but would like advice from anyone that has previously worked on
similar projects.
On 20 Feb 2012, at 17:22, Jan Steinman j...@bytesmiths.com wrote:
Where are your domain experts? You
On 2/17/2012 4:01 AM, Tompkins Neil wrote:
Hi,
I'm in the process of starting to design a hotel booking system that will
eventually consist of over 10,000 hotels all with different room types,
rates and availability for different dates. My question is does anyone
have any experience with
Hi,
I'm in the process of starting to design a hotel booking system that will
eventually consist of over 10,000 hotels all with different room types,
rates and availability for different dates. My question is does anyone
have any experience with regards the best way to store the daily rates. Am
I'm running into some deadlocks issues.
I have this structure
accounting
|---movements
To know the balance of the account, I usualy do a sum(movements.amount)
where accounting.id=someid
The issue is that the sum is starting to run very slow due hardware
constraints, and I can't trow more
-
From: Andrés Tello mr.crip...@gmail.com
To: Mailing-List mysql mysql@lists.mysql.com
Sent: Wednesday, 20 April, 2011 9:15:09 PM
Subject: How to avoid deadlocks.. advice needed also insight, illumination
and a bit of hallucination...
I'm running into some deadlocks issues.
I have
On 10/8/2010 3:31 PM, Neil Tompkins wrote:
Hi Shawn
Thanks for your response. In your experience do you think I should still
retain the data used to generate the computed totals ? Or just compute
the totals and disregard the data used ?
In my experience, the details matter. Also in my
Hi Neil,
On 10/5/2010 5:07 AM, Tompkins Neil wrote:
Hi
I have a number of tables of which I use to compute totals. For example I
have
table : players_master
rec_id
players_name
teams_id
rating
I can easily compute totals for the field rating. However, at the end of a
set period within my
Hi Shawn
Thanks for your response. In your experience do you think I should
still retain the data used to generate the computed totals ? Or just
compute the totals and disregard the data used ?
Regards
Neil
On 8 Oct 2010, at 19:46, Shawn Green (MySQL)
shawn.l.gr...@oracle.com wrote:
Wonder if anyone can help me ?
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Tue, Oct 5, 2010 at 10:07 AM
Subject: Design advice
To: [MySQL] mysql@lists.mysql.com
Hi
I have a number of tables of which I use to compute totals. For example I
have
Hi
I have a number of tables of which I use to compute totals. For example I
have
table : players_master
rec_id
players_name
teams_id
rating
I can easily compute totals for the field rating. However, at the end of a
set period within my application, the values in the rating field are
changed.
of
the string, and the results will include all subdomains for the given domain
you're looking for.
Regards,
Gavin Towey
-Original Message-
From: Alexander Kolesen [mailto:kolese...@mail.by]
Sent: Saturday, August 01, 2009 11:10 AM
To: mysql@lists.mysql.com
Subject: Re: Table advice.
Hello.
Your
I have a database that I am (will) be using to track URL's. The table
structure looks like this:
CREATE TABLE event
(
eid INT UNSIGNED NOT NULL AUTO_INCREMENT,
timestamp INT(10) UNSIGNED NOT NULL DEFAULT 0,
ipINT(10) UNSIGNED NOT NULL DEFAULT 0,
fqdn
Hello.
Your query performs a full table scan, because if you match text with '%...'
wildcard, MySQL can't using index. Try to use external full-text
search engines like Sphinx (http://www.sphinxsearch.com/) or Lucene
(http://lucene.apache.org).
I have a database that I am (will) be using to
I've been reading High Performance MySQL today and got some great
tips
from that which will help a lot.
Yes it is a good book. I hope you have the 2nd edition.
I do, I should have read this years ago (well.. the 1st edition then
at least). So many caveats to using indexes.
So why not
mo...@fastmail.fm (mos) writes:
At 08:06 PM 7/12/2009, Morten wrote:
If you can get rid of the DateTime and switch to just Date it may
speed up the indexes.
While not as pretty it's more compact to convert timestamp values into
an bigint. For example: seconds since epoch. If you know the
Hi,
I'm working on a table that has about 12 columns against which
arbitrary queries must perform really well. Currently there are a lot
of indexes on the table, but I'm hitting some problems - and adding
more indexes seems a slippery slope (there are ~15 multi-column
indexes, I'd like
Morten,
Perhaps you could also add how many rows are in the table, how many
rows are added each day, what are the column types, and what do the search
queries look like?
Mike
At 11:39 AM 7/12/2009, Morten wrote:
Hi,
I'm working on a table that has about 12 columns against which
Mike, you're right - sorry.
I've been reading High Performance MySQL today and got some great tips
from that which will help a lot. I think the fundamental challenge
now, is that the table contains a lot of timestamps, and querying
against these involves multiple range queries which makes
At 08:06 PM 7/12/2009, Morten wrote:
Mike, you're right - sorry.
I've been reading High Performance MySQL today and got some great tips
from that which will help a lot.
Yes it is a good book. I hope you have the 2nd edition.
I think the fundamental challenge
now, is that the table
I have recently become responsible for a LAMP site which has a decent
MySQL install (v5.0.24a). The database is around 40GB with a single
master to single slave replication scheme, although all activity goes to
the master at this time, with the exception of backups which are taken
from the
[EMAIL PROTECTED] (Josh Miller) writes:
I have recently become responsible for a LAMP site which has a decent
MySQL install (v5.0.24a). The database is around 40GB with a single
master to single slave replication scheme, although all activity goes
to the master at this time, with the
Hi All,
I am facing a particular problem which i have explained here. Can
you please let me know a solution for this.
From my web application, I am trying to connect the MySQL server by
using the IP address as the server name, and it says the following
error:
Host 'abc.def.com' is not
'abc.def.com' is not allowed to connect to
this MySQL server, Please advice..
Importance: High
Hi all,
First try checking out the grant for the particular user ?
Show grants for user@'abc.def.com';
If u don't find the results u can give grant as :-
Grant select on *.* to user@'abc.def.com' identified
to this
MySQL server, Please advice..
Hi,
I did that too,
I executed the command - GRANT ALL PRIVILEGES ON *.* to
'root'@'localhost' ;
I tried also GRANT ALL PRIVILEGES ON *.* to 'root'@'abc.def.com' ; where
abc.def.com is my machine name
But both of these did not work, I did not mention
- E-ENABLING); Raghavendra Hosabettu (WT01 -
Innovation Group)
Subject: FW: Problem - Host 'abc.def.com' is not allowed to connect to
this MySQL server, Please advice..
Ok It means that DNS not configured so better give the IP address
instead of hsostname and check using in mysql as
Show grants
)
Subject: FW: Problem - Host 'abc.def.com' is not allowed to connect to
this MySQL server, Please advice..
Ok It means that DNS not configured so better give the IP address
instead of hsostname and check using in mysql as
Show grants for [EMAIL PROTECTED];
This should show u the grants
lengths + date_begin
Which gives me the expire date.
However all this seems alot of queries and resources for such a small
list and as I have not started the programming yet and have not
created the tables either, I thought I might ask your advice to see
if you think this is the best way
On 10/10/07, Ramsey, Robert L [EMAIL PROTECTED] wrote:
I'm looking for a best practices way of creating tables to store both
one time and regularly repeating events. These are classes, so for the
most part the have a regularly recurring time, but we do have some one
off events. (...)
The
I've been working with Drupal for some time, and there is a module that
allows you to create event-based content with a repeating schedule. The
schema that it uses may be of some help to you.
CREATE TABLE IF NOT EXISTS event_repeat (
rid int(10) unsigned NOT NULL default '0',
repeat_data
This and Frederic Wenzel's suggestions were exactly what I was looking
for.
Thanks!
Bob
-Original Message-
From: Erich C. Beyrent [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 11, 2007 6:10 AM
To: mysql@lists.mysql.com
Subject: Re: need advice on how to design tables
Hi,
I'm looking for a best practices way of creating tables to store both
one time and regularly repeating events. These are classes, so for the
most part the have a regularly recurring time, but we do have some one
off events. For example, let's say the following:
Class-A Mon,Wed,Fri 8-9 from
This one time, at band camp, [EMAIL PROTECTED] wrote:
I don't feel the implementation direction this article takes is good. It
uses single row binary storage, which anyone who has had to deal with
large files knows is a definate issue.
According to your method of storing binary data in
I would love to see an implementation with 1 row for large data that works
well. The main issues I had were that mysql has a default max packet size
limit (I think it used to be like 16MB (mysql 3.23) - 1GB Mysql 4 - Not
sure v5. Alot of people don't have control over those settings in their
] wrote:
So before I just jump in and go like I usually do, does anyone have any
quick advice, things to consider, links, must-RTFMs or the like to help a
newbie out?
This tutorial deals with images and BLOBs. It should get you on the
right path.
http://www.phpro.org/tutorials/Storing-Images
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
I don't feel the implementation direction this article takes
is good. It uses single row binary storage, which anyone who
has had to deal with large files knows is a definate issue.
Just wanted to thank
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Friday, April 20, 2007 3:16 PM
To: Michael Higgins
Cc: mysql@lists.mysql.com
Subject: Re: advice for blob tables?
At any rate - based on my experience with the Sybase system I managed, I
would advise you
up a database for document storage. I've never worked
with
binary files stored in tables.
So before I just jump in and go like I usually do, does anyone have
any
quick advice, things to consider, links, must-RTFMs or the like to
help a
newbie out?
I feel like I need to become a bit more
Hello, all --
I want to set up a database for document storage. I've never worked with
binary files stored in tables.
So before I just jump in and go like I usually do, does anyone have any
quick advice, things to consider, links, must-RTFMs or the like to help a
newbie out?
I feel like I need
want to set up a database for document storage. I've never worked with
binary files stored in tables.
So before I just jump in and go like I usually do, does anyone have any
quick advice, things to consider, links, must-RTFMs or the like to help a
newbie out?
I feel like I need to become a bit
in tables.
So before I just jump in and go like I usually do, does anyone have any
quick advice, things to consider, links, must-RTFMs or the like to help a
newbie out?
I feel like I need to become a bit more expert in database design but I
simply don't really know where to start. Like, what 'engine
This one time, at band camp, Michael Higgins [EMAIL PROTECTED] wrote:
So before I just jump in and go like I usually do, does anyone have any
quick advice, things to consider, links, must-RTFMs or the like to help a
newbie out?
This tutorial deals with images and BLOBs. It should get you
Hi all,
Just wondering how people are dealing with tables that are used for logging,
ie: insert only tables supporting occasional queries used for audit or event
logs.
These tables will keep growing and there is no need to keep them that large
so what is the best strategy in managing the data
Hi all,
Just wondering how people are dealing with tables that are used for
logging, ie: insert only tables supporting occasional queries used for
audit or event logs.
These tables will keep growing and there is no need to keep them that
large so what is the best strategy in managing the
On 2/6/07, Yong Lee [EMAIL PROTECTED] wrote:
Hi all,
Just wondering how people are dealing with tables that are used for
logging, ie: insert only tables supporting occasional queries used for audit
or event logs.
These tables will keep growing and there is no need to keep them that
large
I'd like some advice on setting up databases that contain entries for
the same item in more than one language. For instance, here's what I
currently do for a table that contains the same topics translated into
English and Arabic:
CREATE TABLE `TOPIC` (
`TopicID` int(11) NOT NULL auto_increment
Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Zembower, Kevin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 10, 2006 9:36 AM
To: mysql@lists.mysql.com
Subject: Advice on multilingual databases?
I'd like
Hello,
I am looking for some advice regarding the tuning of a dedicated MySQL
database server.
The machine in questions is a Dell 2850 with dual Xeon procs and 4GB of
memory running FreeBSD 6.1. Its sole purpose in life is to run the
MySQL 5.0.x database engine serving out databases
I highly recommend Jeremy Zawodny's High Performance MySQL
from O'Reilly.
Dan
On 9/12/06, Gregory T Pelle [EMAIL PROTECTED] wrote:
Hello,
I am looking for some advice regarding the tuning of a dedicated MySQL
database server.
The machine in questions is a Dell 2850 with dual Xeon procs
with persistent connections and PHP, you can easily trip over your own
connections.
- Original Message -
From: Gregory T Pelle [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, September 12, 2006 12:50 PM
Subject: MySQL tuning advice
Hello,
I am looking for some advice
Hello everybody!!
I've a problem synchronizing a master mysql to a slave:
When my master make a rotate in binlog my slave can follow up it and catch.
What should I do ?
--
__
Alguns caminham pelo arco,
eu caminho pela reta.
Alexandre Gonçalves Jacarandá
Assessor de
I've 3 machines that I use with mysql. One is used for BI consulting and
other two for operational consulting. Which one is indicated to be an
master server ? Is there possible, with 2 nics in machines, use one for
replication and other for receive clients consulting ?
Thanks.
--
--- Russell Horn [EMAIL PROTECTED] wrote:
Hi,
I'm storing data against a bunch of people and want to track how it
changes. So, I have a person table where everyone has a person ID and
a
results table a bit like this:
| personID | classification | date |
| 1| 0
Russell -
This should basically work for selecting the most recently selected
preference...
SELECT DISTINCT personID, classification FROM results_table ORDER BY date
DESC
On 4/10/06, Russell Horn [EMAIL PROTECTED] wrote:
Hi,
I'm storing data against a bunch of people and want to track how
Hi,
I'm storing data against a bunch of people and want to track how it
changes. So, I have a person table where everyone has a person ID and a
results table a bit like this:
| personID | classification | date |
| 1| 0 | 2005-11-10 |
| 2| 3 |
: Monday, February 27, 2006 6:06 PM
To: Philip Hallstrom
Cc: mysql@lists.mysql.com
Subject: [SPAM] - Re: MYSQL: Unlimited Forums, Scalablity Issues, advice
please? - Bayesian Filter detected spam
Hi Philip, thanks for the reply.
Single master + many read only slaves would only solve the problem
across all the forums.
Does anyone have advice that could point me in the right direction?
I have solved the scalability issue WITHIN a forum (code can handle
million + posts easy), but I havent solved the issue of scaling MULTIPLE
separate forums.
I dont think putting EVERYTHING on one single DB
across
all the forums.
Does anyone have advice that could point me in the right direction?
I have solved the scalability issue WITHIN a forum (code can handle million +
posts easy), but I havent solved the issue of scaling MULTIPLE separate
forums.
What about having a single write master with many
will be providing a user with a dashboard that allows him to
view all his subscribed posts across ALL forums. So lets say a user
is a member of 25 forums, this dashboard view will allow the user to
view all his posts across all the forums.
Does anyone have advice that could point me in the right
Jon Miller wrote:
Jon,
I'm currently running MySQL on RedHat 7.2 and now I'm in the processing of
finishing testing a new server which has SUSE Linux Enterprise Server 9.
My question is my database currently resides on RH7.2 and
MySQL-server-4.0.13-0. I want to install the latest version on
I'm currently running MySQL on RedHat 7.2 and now I'm in the processing of
finishing testing a new server which has SUSE Linux Enterprise Server 9.
My question is my database currently resides on RH7.2 and
MySQL-server-4.0.13-0. I want to install the latest version on the SUSE system
but I
Ben Clewett wrote:
Hi,
I have a need to locate (x,y) coordinates from mysql where they are
close to another coordinate. For instance, all pizza bars near my car.
Example: Searching for points closer than z to (i,j) using Pythagoras:
SET i = 10;
SET j = 10;
SET z = 30;
SELECT x, y
Hi,
I have a need to locate (x,y) coordinates from mysql where they are
close to another coordinate. For instance, all pizza bars near my car.
Example: Searching for points closer than z to (i,j) using Pythagoras:
SET i = 10;
SET j = 10;
SET z = 30;
SELECT x, y
FROM coordinates
WHERE
If you visualise your search area as a circle around your 'target' coordinates,
then you can eliminate many of the irrelevant rows by search for coordinates
that fall within a square surrounding that circle.
So, imagine a simple grid with target coordinates of 6,8 and a search radius of
3.
:27
To: Ben Clewett
Cc: mysql@lists.mysql.com
Subject: Re: Geographical advice
If you visualise your search area as a circle around your 'target'
coordinates, then you can eliminate many of the irrelevant rows by search
for coordinates that fall within a square surrounding that circle.
So
Sorry, subject corruption, my last email should have had this subject,
not 'temporary table issue'...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am creating an application in Visual Basic 6.0 which will require a
centralised database server. All this while I had been planning to use
MS-Access. But then I found out that MS-Access is ok to be a desktop
rdbms but not for an enterprise level rdbms. So I am planning to use
MySQL as the
-Original Message-
From: Vinayak Mahadevan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 27, 2005 9:25 AM
To: mysql@lists.mysql.com
Subject: Advice Required
I am creating an application in Visual Basic 6.0 which will require a
centralised database server. All this while I had been
Vinayak Mahadevan [EMAIL PROTECTED] wrote on 27/09/2005 04:55:13:
I am creating an application in Visual Basic 6.0 which will require a
centralised database server. All this while I had been planning to use
MS-Access. But then I found out that MS-Access is ok to be a desktop
rdbms but not
[EMAIL PROTECTED] wrote:
Vinayak Mahadevan [EMAIL PROTECTED] wrote on 27/09/2005 04:55:13:
I am creating an application in Visual Basic 6.0 which will require a
centralised database server. All this while I had been planning to use
MS-Access. But then I found out that MS-Access is ok to
Vinayak Mahadevan [EMAIL PROTECTED] wrote on 27/09/2005 11:28:51:
[EMAIL PROTECTED] wrote:
Vinayak Mahadevan [EMAIL PROTECTED] wrote on 27/09/2005 04:55:13:
I am creating an application in Visual Basic 6.0 which will require a
centralised database server. All this while I had been
advice or know of best-practice on this subject?
Thanks,
Scott
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
advice or know of best-practice on this subject?
Well, there was a long thread on this last week.
Anyway, given that a phone-number IS NOT an integer (eg: leading zeros),
it simply cannot be stored into a numerical column.
Also, these days, you might have character-based phone-numbers:
0800-AOLUSA
of phone numbers. I am not sure what
is common practice on the database side. Talking to some co-workers, some
feel it would be fine to use a varchar and others think there should be 3
integer columns in the database for each number?
Anyone have advice or know of best-practice on this subject
Scott Purcell wrote:
I am waffling on how to handle a column of phone numbers. I am
not sure what is common practice on the database side. Talking to
some co-workers, some feel it would be fine to use a varchar and
others think there should be 3 integer columns in the database
for each number?
On 7/15/05, Bruce Dembecki [EMAIL PROTECTED] wrote:
This process has worked for us taking our latin1 4.0 databases and
turning them into utf8 4.1 databases. UTF8 data we had already
put in
our 4.0 database despite it's latin1 encoding was correctly exported
out of 4.0 and correctly
On 7/15/05, Bruce Dembecki [EMAIL PROTECTED] wrote:
This process has worked for us taking our latin1 4.0 databases and
turning them into utf8 4.1 databases. UTF8 data we had already
put in
our 4.0 database despite it's latin1 encoding was correctly exported
out of 4.0 and correctly
running 3.23 that are all using the default encoding.
I want to update all their data to 4.1 with UTF-8 encoding.
Anyone done this kind of dump-and-update?Any advice to share or
good URLs you've seen with others' advice about this?
--
For technical support contracts, goto https
I've got some years-old MySQL databases mostly in 4.0, but one server
running 3.23 that are all using the default encoding.
I want to update all their data to 4.1 with UTF-8 encoding.
Anyone done this kind of dump-and-update?Any advice to share or
good URLs you've seen with others' advice
On 7/15/05, Bruce Dembecki [EMAIL PROTECTED] wrote:
This process has worked for us taking our latin1 4.0 databases and
turning them into utf8 4.1 databases. UTF8 data we had already put in
our 4.0 database despite it's latin1 encoding was correctly exported
out of 4.0 and correctly converted
1 - 100 of 320 matches
Mail list logo