GH wrote:
-- Forwarded message --
From: GH <[EMAIL PROTECTED]>
Date: Sun, 12 Sep 2004 02:49:02 -0400
Subject: Re: Best way to get Access DB structures into MySQL ??
To: Chris Martin <[EMAIL PROTECTED]>
Does this also allow for the importation of the data as well?
On
-- Forwarded message --
From: GH <[EMAIL PROTECTED]>
Date: Sun, 12 Sep 2004 02:49:02 -0400
Subject: Re: Best way to get Access DB structures into MySQL ??
To: Chris Martin <[EMAIL PROTECTED]>
Does this also allow for the importation of the data as well?
On Sat, 11
[EMAIL PROTECTED] wrote:
What is the best way to take the structure of multiple tables in Access
and get them re-created in MySQL without doing that all by hand?
Is there a way to do the equivalent of a Show Create Table in Access, that
I could then use in MySQL ??
Chris Hood
Investigator
Download yourself the trial version of Database Workbench
at www.upscene.com and try the Schema Migration tool.
Connect to Access via ADO and migrate the existing structure
to MySQL.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
U
Christopher,
>What is the best way to take the structure of multiple tables in Access
>and get them re-created in MySQL without doing that all by hand?
>Is there a way to do the equivalent of a Show Create Table in Access, that
>I could then use in MySQL ??
The only way I know is to use a tool l
What is the best way to take the structure of multiple tables in Access
and get them re-created in MySQL without doing that all by hand?
Is there a way to do the equivalent of a Show Create Table in Access, that
I could then use in MySQL ??
Chris Hood
Investigator Verizon Global Se
Hi,
> I need to do this behind the scenes. The user will need to press a
> button for the .mdb file to be imported. I can't use a thrid party
> program for this.
Then write your own.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Serve
I have a .mdb file which I need to import into MySQL. This needs to be
done behind the scenes and with code. Can I use LOAD DATA INFILE where
I use the .mdb file instead of a .txt file?
If not does anyone have any suggestions?
Thanks,
Jacque
> I have a .mdb file which I need to import into MySQL. This needs to be
> done behind the scenes and with code. Can I use LOAD DATA INFILE where
> I use the .mdb file instead of a .txt file?
An "mdb" file isn't exactly the same as text, is it?
You might as well use MS Word as the source ;-)
Hello
I use SQLyog (http://www.webyog.com/sqlyog) to import
data from my access db to MySQL.
Karam
--- Jacque Scott <[EMAIL PROTECTED]> wrote:
> I have a .mdb file which I need to import into
> MySQL. This needs to be
> done behind the scenes and with code. Can I use
> LOAD
.webyog.com/sqlyog) to import
data from my access db to MySQL.
Karam
--- Jacque Scott < [EMAIL PROTECTED] > wrote:
> I have a .mdb file which I need to import into
> MySQL. This needs to be
> done behind the scenes and with code. Can I use
> LOAD DATA INFILE where
> I use the
Randy Chrismon <[EMAIL PROTECTED]> wrote:
>>>Don't think this is the issue. If it were, I wouldn't be able to use
>>> MySQLCC on my own local database which is also 4.1.0 alpha, would I?
>
>
>> Do you use password when you connect to the local 4.1 MySQL server?
>
> Yes. No password, no entry.
Don't think this is the issue. If it were, I wouldn't be able to use
MySQLCC on my own local database which is also 4.1.0 alpha, would I?
Do you use password when you connect to the local 4.1 MySQL server?
Yes. No password, no entry.
Can you connect without --protocol option using 4.1 mysql com
Randy Chrismon <[EMAIL PROTECTED]> wrote:
> Victoria Reznichenko wrote:
>
>>MySQL 4.1 provides new password hashing mechanism. This error appears if you connect
>>with pre-4.1 client to the server 4.1. ook at:
>> http://www.mysql.com/doc/en/Password_hashing.html
>>
>>In the above section of
Victoria Reznichenko wrote:
MySQL 4.1 provides new password hashing mechanism. This error appears if you connect
with pre-4.1 client to the server 4.1. ook at:
http://www.mysql.com/doc/en/Password_hashing.html
In the above section of the manual you can find description of possible scenari
"Randy Chrismon" <[EMAIL PROTECTED]> wrote:
>
> This irritating rather than life-threatening: I can connect to the
> MySQL database on my Linux box, from my Win2K box, using the command
> line environment just fine:
>
> c:>mysql --protocol=TCP -h host_name -u my_name -p mysql
>
> No matter what
This irritating rather than life-threatening: I can connect to the
MySQL database on my Linux box, from my Win2K box, using the command
line environment just fine:
c:>mysql --protocol=TCP -h host_name -u my_name -p mysql
No matter what I try, however, I can't connect using MySQLCC. I
always
get
I wanted to move the Access Database to Mysql.. I downloaded
MysqlFront and that did the trick... Thanks so much
On Thu, 2002-11-14 at 00:27, Chris Couture wrote:
> When you say "port" are you asking to export the access DB to mysql? If
> so, Intelligent Converters makes one
When you say "port" are you asking to export the access DB to mysql? If
so, Intelligent Converters makes one and you can also do it with EMS
MySQL manager.
If you wanting to view the mysql data in access; you can do this using
myodbc and open it using external data using the O
Hello everyone
I was wondering if there are any tools that would allow me to port a
access database to mysql?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Does anyone know if the MyODBC binary for Solaris 2.7 will work ok on 2.8,
or will I need to
compile from source?
For anyone who's interested, we're in the process now of migrating from
Access/ColdFusion/NT
to MySQL/ColdFusion/Solaris in our web development environment.
As far as software to c
>
>- Original Message -
>From: "John Meyer" <[EMAIL PROTECTED]>
>To: "MySQL (E-mail)" <[EMAIL PROTECTED]>
>Sent: Friday, June 22, 2001 10:16 AM
>Subject: Re: ACCESS DB, and MySQL which one better to handle database driv
>en webpage
>
>
>&
t; <[EMAIL PROTECTED]>
To: "MySQL (E-mail)" <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 10:16 AM
Subject: Re: ACCESS DB, and MySQL which one better to handle database driv
en webpage
> It only corrupted your database twice?
>
> On Friday 22 June 2001 09:50, Patri
It only corrupted your database twice?
On Friday 22 June 2001 09:50, Patrick Calkins wrote:
> MySQL can handle infinately more concurent connections to it, and handle a
> much bigger load than MDB can even dream of doing. A few years back I used
> to write database apps in visual basic and MDB.
On Friday 22 June 2001 09:22, [EMAIL PROTECTED] wrote:
> MySQL has is used by alot of major players and there are pre made setup for
> building database driven websites like PHP-Nuke. Unsure on the strings
>
> I use Win2K and Mysql PHP and PHP Nuke with Apache for my site and it's
> working great!
//www.mysql.com/information/benchmarks.html
Hope this helps!
Patrick
# -Original Message-
# From: Colin TMC [mailto:[EMAIL PROTECTED]]
# Sent: Friday, June 22, 2001 6:56 AM
# To: [EMAIL PROTECTED]
# Subject: ACCESS DB, and MySQL which one better to handle
# database driven
# webpage
#
#
llent.
Cheers
Mike
-Original Message-
FROM: Colin TMC
TO: [EMAIL PROTECTED]
DATE: Fri 6/22/01 8:16
SUBJECT: ACCESS DB, and MySQL which one better to handle database driven webpage
Can anybody help with the question about which one is the best to handle =
database driven webpage, Since, w
Can anybody help with the question about which one is the best to handle database
driven webpage, Since, we are running on ACCESS DB, and MS SQL for a long time, but,
We just have our new Lynex server it is running MySQL, my question is:
1) What's the different between MDB and MySQL. I
Perl works beautifully with MySQL, as do PHP and Java, and
$SCRIPTING_LANGUAGE. Choose your poison.
Z
On Sunday, June 3, 2001, at 08:36 PM, Gary Bonham wrote:
> I've just joined this list as I'm considering using mysql. My databases
> are
> in Access format, and I don't wish to convert to SQL
I've just joined this list as I'm considering using mysql. My databases are
in Access format, and I don't wish to convert to SQL just yet (although long
range plans are indeed to do just that), but I need to be able to read them
in Perl CGI scripts, which is why the interest in mySQL. Is this a fe
- Original Message -
From: "Ed Carp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 11:17
Subject: Re: importing access db to mysql
> Rolf Hopkins ([EMAIL PROTECTED]) writes:
Rolf Hopkins ([EMAIL PROTECTED]) writes:
> Try http://www.accessmysql.com/
Oh. Yet another person trying to sell you something that can be downloaded freely
elsewhere.
Try http://www.mysql.com/downloads/gui-clients.html
Oh, sorry, that didn't answer the original poster's question, but I do
hello friends.
I am new to mysql, so pls bear with the silly questions.
I have exported an access database to .csv file. Now I need to import it
into mysql.
But guys, please do not waste your time telling me how to do this. Please
tell me where I can find the info and i will find it.
thanks fo
Try http://www.accessmysql.com/
- Original Message -
From: "Denis L. Menezes" <[EMAIL PROTECTED]>
To: "mysql list" <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 10:37
Subject: importing access db to mysql
> hello friends.
>
> I am
I suggest you read up on the GRANT syntax :)
http://www.mysql.com/doc/G/R/GRANT.html
What you need done can either be done through issuing a GRANT statement,
or modifying the mysql table manually. If you're not too familiar with
MySQL, I suggest you use the GRANT.
Atle
On Mon, 22 Jan 2001, A
What would I have to do (sql expression) if I want to have a user be able
to access database from anywhere (so I don't have to make additions for all
the hosts).
database=list
username=bigpapa
password=see5060
What would be the route to do that?
Thanx
--
36 matches
Mail list logo
