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 mapping such names to
* h...@tbbs.net 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 not
have used mysqldump 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
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 should explicitly exclude some of the tables from
the mysql database. If so, which? perhaps mysql.user
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 Mailing List
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 user added to the new partition
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 located
On 4/9/13 1:54 PM, Joe Kosinski joj...@gmail.com 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/run/lirc/lircd
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
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
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
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
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
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
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 machi...@rdc.co.zawrote:
Hi All
Sorry
...@lists.mysql.com%3e
*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 *should* take
care of everything between those versions, I think. Make sure you have a
backup in any case
How would I do an inplace upgrade?
-Original Message-
From: Johan De Meersman vegiv...@tuxera.be
To: Machiel Richards machi...@rdc.co.za
Cc: mysql mailing list mysql@lists.mysql.com
Subject: Re: Upgrading of mysql database
Date: Mon, 22 Nov 2010 15:25:44 +0100
That would work, yes.
You
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.7 Distrib
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 this database?
You
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 deleted (/ var/lib
: 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 deleted (/ var/lib/mysql
/database) when entering the mysql console shows that the database is
created but does
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
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,
RENAME
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.
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
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
...@tuxera.be
Cc: Waynn Lue waynn...@gmail.com; mysql mysql@lists.mysql.com
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
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 manasi.s...@artificialmachines.com wrote:
Hi All,
I have asked this question before But, I think I am not able to
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.
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 files is
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
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)
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)
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
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 (directory)
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 your
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
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
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. But
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
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 :
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
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,
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, Google did
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]
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 up
Thanks and Regards
Kaushal
--
MySQL
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 are
using
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
: 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
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 to backup a 20GB MySQL database
I would echo what Dan says
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
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:
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
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
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
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 is any to find
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.
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
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
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
-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:
|load data local infile '|/volumes
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
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, 2007, at 10:11 AM, Edward Kay wrote:
-Original
:[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 PROTECTED]
Sent: 09 August 2007 14:16
@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: http://lists.mysql.com/mysql
To unsubscribe:http
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.master.txt
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... Should
-
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 convert to just
about
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, which I
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/raider
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' ENCLOSED BY '' LINES TERMINATED BY '\n';
and here is the error I am getting
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 just
about anything) into a MySQL database... Should be easy
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' ENCLOSED BY '' LINES TERMINATED BY '\n';
and here is the error I
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
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
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]; mysql@lists.mysql.com
Sent: Sunday, August 05, 2007 4:01 AM
Subject: Re: MySQL database synchronizing from 2
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?
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 database synchronizing
[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
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 type
Myanmar
://blog.360.yahoo.com/alex.lurthu
On 7/9/07, Ananda Kumar [EMAIL PROTECTED] wrote:
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
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
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 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 can we do
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
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
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 database?
I have many tables like
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
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
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
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 seconds
.
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
: 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
How do I store multiple languages in the MySQL database. Is there any
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, without a
problem. Right now I'm working on adding Chinese data, but
my major
: 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
How do I store multiple 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
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 mysql@lists.mysql.com@ashcomp.net
Subject: RE: Access mySQL database across Internet Date: Fri, 11 Aug 2006
12:20:19 -0400 On Fri, 11 Aug 2006
:
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 mysql@lists.mysql.com@ashcomp.net Subject: RE: Access mySQL database across Internet Date: Fri, 11 Aug
2006 12:20:19 -0400 On Fri, 11 Aug 2006
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 establishing persistent
connections. Know it's
1 - 100 of 726 matches
Mail list logo