-->-Original Message-
-->From: Charles Cary [mailto:[EMAIL PROTECTED]
-->Sent: Monday, October 27, 2003 10:10 AM
-->To: [EMAIL PROTECTED]
-->Subject: Conversion
-->
-->My commercial online web application currently handles 1 users
with
-->peak
-->loadings of 100-500 concurrent hits.
On Thu, Mar 07, 2002 at 12:08:29AM -0500, Mr. Ozette Brown wrote:
>
> I'm in the process of converting all of my database tables from ISAM
> to MYISAM table format. I'll run the mysql_convert_table_format
> script which basically does an "Alter table". If during this
> conversion someone accesse
| he saves it as (.frm,.MYD,.MYI)anybody knows how in windows can i use the
| database from my LINUX?
simple, see mysql manual: mysqldump
in linux shell type:
mysqldump -uUSER -pPASSWORD --add-drop-table MYDATABASE >
dumpOfMyDatabase.sql
copy the file dumpOfMyDatabase.sql to your win computer,
Marchetti, Peter writes:
>
> Has anyone ever attempted, or succeded in converting a Btrieve database to a
> MySQL database?
>
> Peter Marchetti
> Media Visions, Inc.
> [EMAIL PROTECTED]
>
>
>
You will have to make CREATE TABLE statements yourself.
For the data use butil to get comma delimit
Thanks! I was able to work on the query today, and manually assemble a query
that did the same thing. And thus, was a lot faster. The main contention
MySQL seems to have is the "nested" joins, such as when Access does this:
FROM (((leg_version_hist RIGHT JOIN (leg_comm_hist RIGHT JOIN
leg_ac
As it is such a big query, I don't have time to look at it for you but it
may be easier if you convert the RIGHT JOINS to LEFT JOINS for starters.
The manual does recommend LEFT JOINS, mainly for portability.
First part would be something like
(leg_activity LEFT JOIN leg_comm_hist ON (leg_comm_h
bob,
first build the tables, to match your ascii database structure, Next use
LOAD_DATA INFILE option to load it up, See LOAD_DATA in the manual for a
detailed explanation.
g'luck
bob wrote:
> I'm looking for a way to translate a database in ASCII form throw a
> MySQL database.
> Could you tel
