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
There is no "best" or "perfect" 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
Bottom line: There is no "best" or "perfect" 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
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 mas
- Original Message -
> From: "Joey L"
>
> 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 heightens the com
ily recover
> >>> all of your data.
> >>>
> >>> If you are not aware of Percona XtraDB Cluster, it might be
> >>> interesting for you. (I work for Percona.) There is also Continuent
> >>> Tungsten to consider.
> >>>
> >&g
t aware of Percona XtraDB Cluster, it might be
>>> interesting for you. (I work 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
>> 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 im
ight be
> interesting for you. (I work 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
pic 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
trust it to a mailing list, I'd hire someone. It's we
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 ar
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 wrote:
> That's not a description of 'load balancing'
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 wrote:
> On 6/11/2012 10:36 AM, Ananda Kumar wrote:
>>
>> ...
>> Master-master allows lo
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 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 server
> will b
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 wrote:
> when u
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 failur
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 Mo
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
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 wrote:
> On 2/17/2012 4:01 AM
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 regard
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 wrote:
> Where are your domain experts? You *are* consulting with t
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
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,
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
riginal Message -
> From: "Andrés Tello"
> To: "Mailing-List mysql"
> 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 de
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 hardw
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 experie
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)"
wrote:
Hi Neil,
On 10/5/2010
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 ap
Wonder if anyone can help me ?
-- Forwarded message --
From: Tompkins Neil
Date: Tue, Oct 5, 2010 at 10:07 AM
Subject: Design advice
To: "[MySQL]"
Hi
I have a number of tables of which I use to compute totals. For example I
have
table : players_master
rec_id
pl
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.
ginning 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
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 tra
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 VARC
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 th
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 h
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 contains
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
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
arbi
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 t
[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 exce
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 sla
T01 - 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
, July 14, 2008 3:34 PM
To: Ahmadbasha Shaik (WT01 - 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
abc.def.com' is not allowed to connect 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
ovation Group)
Subject: FW: Problem - "Host '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 result
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 allow
ulate expire date by :
Total "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
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
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 longt
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. (...)
>
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 fro
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
env
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
> -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
<[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 sho
> -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 m
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
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 im
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 expert in database design but I
> si
ggins <[EMAIL PROTECTED]> wrote:
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 li
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
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
> 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 man
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
lobal 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 mu
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
with persistent connections and PHP, you can easily trip over your own
connections.
- Original Message -
From: "Gregory T Pelle" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, September 12, 2006 12:50 PM
Subject: MySQL tuning advice
Hello,
I am looking for some advice regardi
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
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 to
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.
--
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 Tecnolo
--- 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
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 | 2005-1
OTECTED] On Behalf Of jay
Sent: 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 w
t two servers etc.
3. I 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
ill allow the user to view all his posts 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.
iew will allow the user to view all
his posts 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.
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 beli
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
FROM
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]
D]
> Sent: 10 January 2006 14: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
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. Ther
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 PO
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
[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 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
-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
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 bac
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 numbe
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?
>
> Anyone have advice or know
yone have 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-numbe
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]
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 co
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 co
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 conver
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 othe
ySQL 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&#
1 - 100 of 327 matches
Mail list logo
