* h...@tbbs.net [140407 23:09]:
> 2014/04/07 08:02 -0800, Tim Johnson
> 2)mysqldump forces all database names to lower case in the "CREATE
> DATABASE" statement. I know, one shouldn't use upper case in
> database names, but :) tell that to my clients.
>
> Why not? That is
2014/04/07 08:02 -0800, Tim Johnson
2)mysqldump forces all database names to lower case in the "CREATE
DATABASE" statement. I know, one shouldn't use upper case in
database names, but :) tell that to my clients.
Why not? That is not mentioned in the section devoted to mapp
mysql on
> >>it. I have already set up a mysql user on the ubuntu OS.
> >>
> >>In the past I have used mysqldump with just the --all-databases
> >>option to transfer data across different linux partitions.
> >>
> >>I'm wondering if I
ldump with just the --all-databases
option to transfer data across different linux partitions.
I'm wondering if I should explicitly exclude some of the tables from
the mysql database. If so, which? perhaps mysql.user?
thoughts? Opinions?
thanks
I should add the following:
1)the only
l-databases
> option to transfer data across different linux partitions.
>
> I'm wondering if I should explicitly exclude some of the tables from
> the mysql database. If so, which? perhaps mysql.user?
>
> thoughts? Opinions?
> thanks
I should add the following:
1)the
linux partitions.
I'm wondering if I should explicitly exclude some of the tables from
the mysql database. If so, which? perhaps mysql.user?
thoughts? Opinions?
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com, http://www.tj49.com
--
MySQL General Ma
On 4/9/13 1:54 PM, "Joe Kosinski" wrote:
>Hi,
>
>I am trying to connect to a MySql database and I keep getting the
>following:
>
> Cannot find (ping) database host Joseph-Kosinskis-MacBook on the network
> Failed to connect to Unix socket '/var/
Hi,
I am trying to connect to a MySql database and I keep getting the following:
Cannot find (ping) database host Joseph-Kosinskis-MacBook on the network
Failed to connect to Unix socket '/var/run/lirc/lircd'
No such file or directory (2)
The database is lo
This might interest some that Google Cloud SQL is actually a MySQL database
that lives in Google's cloud
Source: https://developers.google.com/cloud-sql/docs/introduction
Dear MySQL users,
MySQL Server 5.1.59, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.1.59 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.1, please see
http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.
Dear MySQL users,
MySQL Server 5.1.59, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.1.59 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.1, please see
http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.
Dear MySQL users,
MySQL Server 5.1.59, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.1.59 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.1, please see
http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshel
Dear MySQL users,
MySQL Server 5.1.58, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.1.58 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.1, please see
http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.
Dear MySQL users,
MySQL Server 5.1.56, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.1.56 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.1, please see
http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.
How would I do an inplace upgrade?
-Original Message-
From: Johan De Meersman
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: Upgrading of mysql database
Date: Mon, 22 Nov 2010 15:25:44 +0100
That would work, yes.
You could also try to upgrade in place - the upgrade scripts
;
>
> -Original Message-
> *From*: Johan De Meersman
>
> >
> *To*: Machiel Richards
>
> >
> *Cc*: mysql mailing list
>
> >
> *Subject*: Re: Upgrading of mysql database
> *Date*: Mon, 22 Nov 2010 15:25:44 +0100
>
> That would wo
That would work, yes.
You could also try to upgrade in place - the upgrade scripts *should* take
care of everything between those versions, I think. Make sure you have a
backup in any case :-)
On Mon, Nov 22, 2010 at 12:57 PM, Machiel Richards wrote:
> Hi All
>
>Sorry for all my posts
Hi All
Sorry for all my posts today but this one client is keeping me
busy.
the version of MySQL installed on the ubuntu server is
5.0.51a-3ubuntu5.8-log as this was the latest one available in the
repository.
We will need to upgrade this to version 5.1.53.
Am I
>
> Jose Luis
>
> -Mensaje original-
> De: mos [mailto:mo...@fastmail.fm]
> Enviado el: Viernes, 21 de Mayo de 2010 11:24 a.m.
> Para: mysql@lists.mysql.com
> Asunto: Re: Recover accidentally deleted MySQL database files
>
> At 10:42 AM 5/21/2010, you wrote:
>
original-
De: mos [mailto:mo...@fastmail.fm]
Enviado el: Viernes, 21 de Mayo de 2010 11:24 a.m.
Para: mysql@lists.mysql.com
Asunto: Re: Recover accidentally deleted MySQL database files
At 10:42 AM 5/21/2010, you wrote:
>Dear sirs,
>
>
>
>Accidentally files in a database have been
At 10:42 AM 5/21/2010, you wrote:
Dear sirs,
Accidentally files in a database have been deleted (/ var/lib/mysql
/"database") when entering the mysql console shows that the database is
created but does not show any table, there is some method to recever the
information in thi
Dear sirs,
Accidentally files in a database have been deleted (/ var/lib/mysql
/"database") when entering the mysql console shows that the database is
created but does not show any table, there is some method to recever the
information in this database?
Centos 4.6
mysql Ver 14
You can try this one.
http://preetul.wordpress.com/2009/07/27/rename-database-in-mysql/
Note: I have not tested.
On Fri, Jan 8, 2010 at 5:04 PM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi All,
>
>
> I want to rename my database. but as per the mysql documentation it says,
> R
Hi All,I want to rename my database. but as per the mysql
documentation it says, RENAME DATABASE command has been removed from mysql
5.1.Can anyone help me with this, that is there any other
way I can rename it.
Thanks in advance.--Regards,
Manasi Save
Lue ; mysql
> Sent: Wed, November 25, 2009 8:12:25 PM
> Subject: Re: question regarding mysql database location
>
> Dear Johan,
>
> Need your help again in understanding How mysql reads symlink.
>
> As you said below, I have created symlinks in default mysql directory.
&
Hi Johan,
It worked perfectly. Thank you so much for this explanation.
I am really greatful.
--
Best Regards,
Manasi Save
Artificial Machines Pvt Ltd.
> On Wed, Nov 25, 2009 at 3:42 PM, Manasi Save <
> manasi.s...@artificialmachines.com> wrote:
>
>> Dear Johan,
>>
>> Need your help again in un
Is mysql the owner of the directories?
- Original Message
From: Manasi Save
To: Johan De Meersman
Cc: Waynn Lue ; mysql
Sent: Wed, November 25, 2009 8:12:25 PM
Subject: Re: question regarding mysql database location
Dear Johan,
Need your help again in understanding How mysql reads
On Wed, Nov 25, 2009 at 3:42 PM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Dear Johan,
>
> Need your help again in understanding How mysql reads symlink.
>
> As you said below, I have created symlinks in default mysql directory.
> and try to read that symlink file as a database. B
Dear Johan,
Need your help again in understanding How mysql reads symlink.
As you said below, I have created symlinks in default mysql directory.
and try to read that symlink file as a database. But mysql is not reading
that file as Database. Is there any settings which I need to change.
Thanks
Thanks Johan,
It was really a great help. I'll try to implement it. I dont want to opt
for multiple mysql instances option as thats not feasible.
I'll get back to you all if it works fine.
Thanks again.
--
Best Regards,
Manasi Save
Artificial Machines Pvt Ltd.
> On Wed, Nov 25, 2009 at 11:55
On Wed, Nov 25, 2009 at 12:05 PM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> At a time mysql can point to one data directory. For your task you can have
> n number of mysql installation with different data directory. After that
> you
> can use federated storage engine to perform y
On Wed, Nov 25, 2009 at 11:55 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi Johan,
>
> I am Sorry. If I have complicated the senerio But, this still not fix my
> purpose.
>
> What I want is - From your example :-
>
> /data/disk1/mysql/db1 (directory)
> /db2 (dir
Hi Manasi,
At a time mysql can point to one data directory. For your task you can have
n number of mysql installation with different data directory. After that you
can use federated storage engine to perform your task.
Thanks,
Krishna Ch. Prajapati
On Wed, Nov 25, 2009 at 12:19 PM, Manasi Save <
Hi Johan,
I am Sorry. If I have complicated the senerio But, this still not fix my
purpose.
What I want is - From your example :-
/data/disk1/mysql/db1 (directory)
/db2 (directory)
/db3 (directory)
/db4 (symlink to /data/disk2/mysql/db4)
You don't need to move any databases. Look at this structure:
/data/disk1/mysql/db1 (directory)
/db2 (directory)
/db3 (directory)
/db4 (symlink to /data/disk2/mysql/db4)
/db5 (symlink to /data/disk2/mysql/db5)
/db
Well Waynn,
In this case I need to move all the existing databases to new location
right. Which I don't want to do. Is it possible that I create sym link
between two and use both.
--
Thanks and Regards,
Manasi Save
Artificial Machines Pvt Ltd.
> On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save <
>
On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Thanks Waynn,
>
> I could not get your point of using symlinks. Because as per my knowledge
> symlink will store same data which is there in original directory.
> and What do you mean by "The limit for fil
Thanks Waynn,
I could not get your point of using symlinks. Because as per my knowledge
symlink will store same data which is there in original directory.
and What do you mean by "The limit for files is significantly higher than
> directories."
Can you elaborate it more.
Thanks in advance.
Rega
I fixed this by using symlinks for the directories for the underlying
databases. The limit for files is significantly higher than
directories.
Waynn
On 11/24/09, Manasi Save wrote:
> Hi All,
>
> I have asked this question before But, I think I am not able to describe
> it better.
>
> Sorry for a
Also I forgot to mention that I have gone through the innodb option of
innodb_data_file_path but I can just specify it as :
innodb_data_file_path=ibdata1:2048M:autoextend:max:1024M;ibdata1:2048M:autoextend:max:1024M;
But not as :
innodb_data_file_path=/var/lib/mysql/data/ibdata1:2048M:autoextend
Hi All,
I have asked this question before But, I think I am not able to describe
it better.
Sorry for asking it again.
I have multiple databases but there is a limit on the folders getting
created in one folder.
I have mysql default directory set as /var/lib/mysql/data.
Now, After 32000 folder c
hi All
how we can allocate memory for mysql database. since we have different
storage. each having its own buffer for running the query.
in oracle we have some calculation for allocating sga size,like this any
method is exist for mysql.
i am seeing mysql is using default 8m for all (myisam and
Hello everybody,
the MySQL application I'm building needs to be ported from my current site
to the hosting site - which is based on another nation.
The problem I'm having is that the login doesn't work as the password
doesn't match in the charset of the new hosting site.
To address this problem, I
Hi,
I'm trying to extract texts from MySQL database (phpbb). Please, could anybody
explain which format is used to store texts? I mean binary structure.
I know the sources are open, but I don't like to go throught the sources
to find answer for such common question. And, you know, Goog
On Wed, Apr 2, 2008 at 1:09 PM, Kaushal Shriyan
<[EMAIL PROTECTED]> wrote:
> hi,
>
> Is there a step by step guide to set up Master - Slave MySQL Database Server
>
> Thanks and Regards
>
> Kaushal
>
Hi,
what are the different test cases used for this set u
hi,
Is there a step by step guide to set up Master - Slave MySQL Database Server
Thanks and Regards
Kaushal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi
Iam very new user of MySQL. Can anyone help me in guiding me that how
can I dimension and design the MySQL Database Server. If some one can
provide the guidelines and the critical parameters that are required to
dimension the MySQL Server. Iam looking for scaling the database for at
least 5
manually apply
bin-logs from one site to other, but this is little complicated and need
precise scripting taking care of all the bin-log position.
regards
anandkl
On Jan 25, 2008 4:17 AM, C K <[EMAIL PROTECTED]> wrote:
> I have a problem related with 2 mysql database synchronization. We ar
I have a problem related with 2 mysql database synchronization. We are using
a 256kbps internet at our mfg. site and a 2mbps internet connection at our
HO. We are using MySQL5.0.45 for our ERP application. We want to work from
both locations at a time through ERP software. For this we are trying
but perhaps
> there is something I should know...?
>
> Thanks
>
> Jonathan Trahair
> - Original Message -
> From: B. Keith Murphy
> To: Dan Buettner
> Cc: David Campbell ; MySql
> Sent: Wednesday, November 28, 2007 2:55 AM
> Subject: Re: preferred way t
: David Campbell ; MySql
Sent: Wednesday, November 28, 2007 2:55 AM
Subject: Re: preferred way to backup a 20GB MySQL database
I would echo what Dan says. In addition, from the slave server, you
might look at running the new mysql-parallel-dump tool that Baron
Schwartz has developed
I would echo what Dan says. In addition, from the slave server, you
might look at running the new mysql-parallel-dump tool that Baron
Schwartz has developed. It essentially does a dump with a thread
running (by default) for each CPU core you have. A dual core box will
run two threads and dum
I'd strongly recommend setting up replication, and then taking your backups
from the replica.
mysqlhotcopy works great, I used it for years myself, but it does require
"freezing" your database while the copy happens. And no matter how you do
it, copying 20 GB takes a little bit of time.
Dan
On
Andras Kende wrote:
Hi,
What is the preferred way to backup a 20GB database daily,
without taking offline ?
MySQL 4.1 MyISAM - (will be updated to MySQL 5)
133 table(s) Sum 115,416,561 latin1_swedish_ci 20.1 GB
Mysqlhotcopy
--
MySQL General Mailing List
For list archives: http://list
Hi,
What is the preferred way to backup a 20GB database daily,
without taking offline ?
MySQL 4.1 MyISAM - (will be updated to MySQL 5)
133 table(s) Sum 115,416,561 latin1_swedish_ci 20.1 GB
Thanks,
Andras
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
Krishna Chandra Prajapati schrieb:
> Hi All,
>
> The production server on which mysql database was running, get
> shutdown on one day. Then we have to manually start it. The server is
> hpdl585. What can be the reason of shutdown. What has gone wrong with the
> server. Is there
Hi All,
The production server on which mysql database was running, get
shutdown on one day. Then we have to manually start it. The server is
hpdl585. What can be the reason of shutdown. What has gone wrong with the
server. Is there is any to find the reason for shutdown.
Thanks,
Krishna
Recover your files first and then you can see where you can go. I
suppose you now have backup plans in place now?
Keith
David Winslow wrote:
Hey,
Environment:
Windows 2003 server
Mysql 5.0 server
Problem:
Our server crashed and the c drive was formatted. Unfortunately we did not
Hey,
Environment:
Windows 2003 server
Mysql 5.0 server
Problem:
Our server crashed and the c drive was formatted. Unfortunately we did not
have a backup of the mysql databases which we were using. We can hopefully
retrieve the file structure through a file system recovery utility.
What
hi everyone,
i am looking to find a MySQL guru to come work full time at a passionate mobile
technology/ communications company in the heart of London.
This truly is the place to be!
They have global footprint - everyone in the company are technically competent
and extremely passionate about
Jerry Schwartz
> Cc: mysql@lists.mysql.com
> Subject: Re: Import file into MySQL Database..
>
> The Extra commas at the end of some of the lines need to be there to
> keep everything in the right order, they represent empty fields...
--
MySQL General Mailing List
For list archives: h
From: Jason Pruim [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 09, 2007 10:54 AM
To: Edward Kay
Cc: mysql@lists.mysql.com
Subject: Re: Import file into MySQL Database..
On Aug 9, 2007, at 10:11 AM, Edward Kay wrote:
-Original Message-
From: Jason Pruim [mailto:[EMAIL PROTECT
s.com
www.etudes-marche.com
> -Original Message-
> From: Jason Pruim [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 09, 2007 10:54 AM
> To: Edward Kay
> Cc: mysql@lists.mysql.com
> Subject: Re: Import file into MySQL Database..
>
>
> On Aug 9, 200
On Aug 9, 2007, at 10:11 AM, Edward Kay wrote:
-Original Message-
From: Jason Pruim [mailto:[EMAIL PROTECTED]
Sent: 09 August 2007 14:16
To: Gary Josack
Cc: mysql@lists.mysql.com
Subject: Re: Import file into MySQL Database..
On Aug 8, 2007, at 5:19 PM, Gary Josack wrote:
Try
> -Original Message-
> From: Jason Pruim [mailto:[EMAIL PROTECTED]
> Sent: 09 August 2007 14:16
> To: Gary Josack
> Cc: mysql@lists.mysql.com
> Subject: Re: Import file into MySQL Database..
>
>
>
> On Aug 8, 2007, at 5:19 PM, Gary Josack wrote:
>
>
On Aug 8, 2007, at 5:19 PM, Gary Josack wrote:
Try:
|load data local infile '|/volumes/raider/aml.master.8.6.07.|csv'
into table test fields terminated by ',' enclosed by '"' lines
terminated by '\n' |ignore 1 lines
|(First, Last, Add1, Add2, City, State, Zip, XCode, Reason, Date);
If
this out...
All I want to do is load a excel file (Which I can convert to just
about anything) into a MySQL database... Should be easy right?
Here is the command that I have tried: LOAD DATA LOCAL INFILE
'/volumes/raider/AML.master.txt' INTO TABLE current FIELDS
TERMINATED BY '\t&
me line
terminators that MySQL expects by default and leave out the optional
"terminated by"
cj
On 8/8/07, Jason Pruim <[EMAIL PROTECTED]> wrote:
> Okay, so I have been going crazy trying to figure this out...
>
> All I want to do is load a excel file (Which I can convert to ju
All I want to do is load a excel file (Which I can convert to just
about anything) into a MySQL database... Should be easy right?
Here is the command that I have tried: LOAD DATA LOCAL INFILE '/
volumes/raider/AML.master.txt' INTO TABLE current FIELDS
TERMINATED BY '\t' ENCLOSE
Jason Pruim wrote:
Okay, so I have been going crazy trying to figure this out...
All I want to do is load a excel file (Which I can convert to just
about anything) into a MySQL database... Should be easy right?
Here is the command that I have tried: LOAD DATA LOCAL INFILE
'/volumes/r
Hi.
On Wednesday 08 August 2007 18:39, Jason Pruim wrote:
> Did some more testing, made a new table and matched the field names,
> now it will load it without any errors, it's just only importing the
> first row... Not the rest of the 934 records...
You are using ENCLOSED BY '"' in your SQL, whic
Original Message-
From: Jason Pruim [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 1:15 PM
To: mysql@lists.mysql.com
Subject: Import file into MySQL Database..
Okay, so I have been going crazy trying to figure this out...
All I want to do is load a excel file (Which I can con
EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 1:15 PM
To: mysql@lists.mysql.com
Subject: Import file into MySQL Database..
Okay, so I have been going crazy trying to figure this out...
All I want to do is load a excel file (Which I can convert to just about
anything) into a MySQL database... Shou
Okay, so I have been going crazy trying to figure this out...
All I want to do is load a excel file (Which I can convert to just
about anything) into a MySQL database... Should be easy right?
Here is the command that I have tried: LOAD DATA LOCAL INFILE '/
volumes/raider/AML.maste
please notify
the sender immediately by telephone or email and destroy the original
message without making a copy. Thank you.
- Original Message -
From: "Richard" <[EMAIL PROTECTED]>
To: "C K" <[EMAIL PROTECTED]>;
Sent: Sunday, August 05, 2007 4:01 AM
Subject:
Sorry maybe this is completly out of topic, but why do you need it to
synchronise in two locations, can't you just get both servers to connect
to the same database?
And then if you need you can set a cron to backup your database hourly
or daily to the other server using mysql dump and scp.
I d
Hello,
As per your suggestions I tried to get some correct solution for the
problem, but there is a big problem for replication and it is network
connection. Though Internet is available to the Mfg. Site, it is not having
good speed and continuous. So that replication may not be a good choice. As
[mailto:[EMAIL PROTECTED]
Sent: Thursday, August 02, 2007 2:08 PM
To: mysql@lists.mysql.com
Subject: MySQL database synchronizing from 2 locations
Hello,
My client has a mfg. unit at 65 Km from a city in India. He wants to
connect to his corporate office in the city. Both offices will use same
data
ure" OR just do MySQLDumps each night (depending on the volume).
It all depends on the degree and need for whatever level of
synchronicity.
Tim...
-Original Message-
From: C K [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 02, 2007 2:08 PM
To: mysql@lists.mysql.com
Subject: MySQL da
Hello,
My client has a mfg. unit at 65 Km from a city in India. He wants to connect
to his corporate office in the city. Both offices will use same data and
same ERP system. He is using Win 2K3 server and MySQL 5.0.17. Is it possible
to make them synchronized at a particular or regular intervals?
H
Hello everybody,
I want to store Myanmar unicode data in MySQL
database. Then, I want to make data manipulation with it. Firstly, i
tried to input Myanmar characters in MySQL's GUI tool. i chose Myanmar
keyboard and installed Myanmar font in tool. But, i couldn't ty
;
> We have crisis. Disk with MySQL database is full. Now we want to move
> database to another disk. How can we do it?
>
> --
> Thanks,
> Rajan
>
n-logs to a different disk and release some
free space on the current drive.
regards
anandkl
On 7/9/07, Ace <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> We have crisis. Disk with MySQL database is full. Now we want to move
> database to another disk. How can we do it?
>
> --
> Thanks,
> Rajan
>
Hi Ace,
Can't you zip or move old bin-logs to a different disk and release some free
space on the current drive.
regards
anandkl
On 7/9/07, Ace <[EMAIL PROTECTED]> wrote:
Hi,
We have crisis. Disk with MySQL database is full. Now we want to move
database to another disk. How c
backup and restore would be what i would do.
using either mysql administrator or mysqldump.
On 09/07/2007, at 3:45 PM, Ace wrote:
Hi,
We have crisis. Disk with MySQL database is full. Now we want to
move
database to another disk. How can we do it?
--
Thanks,
Rajan
Regards
Hi,
We have crisis. Disk with MySQL database is full. Now we want to move
database to another disk. How can we do it?
--
Thanks,
Rajan
I have many tables like the table Person:below, in mysql database.
person_id, first_name,last_name, mi, gb_first_name, gb_last_name,
b5_first_name, b5_last_name, gender, dob
where different columns storing strings in different encodings.
All the strings/fields etc. need to be in the *same
nformation Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: YL [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 04, 2007 10:19 AM
> To: mysql@lists.mysql.com
> Subject: multilanguage web application with mysql databas
I have many tables like the table Person:below, in mysql database.
person_id, first_name,last_name, mi, gb_first_name, gb_last_name,
b5_first_name, b5_last_name, gender, dob
where different columns storing strings in different encodings. At anytime, a
web user can switch the language and the
a MySQL database in the hope that the MySQL
database would be better suited to the large size of some tables, and
would therefore return queries more quickly. It is now populated with the
data from the old Access tables.
So far, the MySQL speed has been very slow. I'm talking about 30 se
Jonathan Trahair wrote:
Hi Everyone.
I have just upgraded a Visual Basic 6 project which used an Access database as
a data back end, using DAO and SQL strings. The Access database was exceedingly
slow, and prone to glitches. I have changed the VB code to ADO, and set up a
MySQL database in
Hi Everyone.
I have just upgraded a Visual Basic 6 project which used an Access database as
a data back end, using DAO and SQL strings. The Access database was exceedingly
slow, and prone to glitches. I have changed the VB code to ADO, and set up a
MySQL database in the hope that the MySQL
ards,
> >
> > Jerry Schwartz
> > Global Information Incorporated
> > 195 Farmington Ave.
> > Farmington, CT 06032
> >
> > 860.674.8796 / FAX: 860.674.8341
> >
> >
> > > -Original Message-
> > > Wrom: DUL
y, September 28, 2006 9:58 AM
> To: Jerry Schwartz
> Cc: krishna; mysql@lists.mysql.com
> Subject: Re: Mmultiple languages in the MySQL database
>
> On 9/28/06, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
> > We have multiple Western languages in our UTF-8 data base, withou
rmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> Wrom: DULHPQQWOYIYZUNNYCGPKYLEJGDGVCJVTLBXFGGMEPYO
> Sent: Thursday, September 28, 2006 1:36 AM
> To: mysql@lists.mysql.com
> Subject: Mmultiple languages in the MySQL database
>
armington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: krishna [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 28, 2006 1:36 AM
> To: mysql@lists.mysql.com
> Subject: Mmultiple languages in the MySQL database
>
>
>
>
How do I store multiple languages in the MySQL database. Is there any
configuration in MySql database server to support multilingual data.
Normally if I use UTF-8 character encoding in database, it supports multiple
languages. But it is not happening in MySql.
Thanks
Krish
--
View this
Neil Tompkins wrote:
The problem appears to be retrieving the data which is slow.
Are you sure it's not the actual query that's slow?
If you run the query in mysql (ie through the command prompt) is it fast?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
The problem appears to be retrieving the data which is slow.
> Date: Tue, 15 Aug 2006 11:32:23 -0500> From: [EMAIL PROTECTED]> To: [EMAIL
> PROTECTED]> Subject: Re: Access mySQL database across Internet> CC:
> mysql@lists.mysql.com> > You could look into establishin
AIL PROTECTED]> wrote:
The connection time to my mySQL database is OK from the ASP page. Are there
any ways to speed this up though ?
> From: [EMAIL PROTECTED]> To: My.SQL " "@ashcomp.net> Subject: RE: Access mySQL database across Internet> Date: Fri, 11 Aug
2006 12:20:19
1 - 100 of 767 matches
Mail list logo
