wrote:
- Original Message -
From: "Rafael Ribeiro"
Subject: Remote Access to MySQL
After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost
the ability to connect to mysql remotely, from external IPs.
"It doesn't work" is not a helpful comm
- Original Message -
> From: "Rafael Ribeiro"
> Subject: Remote Access to MySQL
>
> After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost
> the ability to connect to mysql remotely, from external IPs.
"It doesn't work"
and also make sure tcp port of your DB instance has been added to firewall
expeption.
check the iptables for this to verify.
On Mon, Mar 9, 2015 at 2:13 PM, Florian Schaal
wrote:
> Am 08.03.2015 um 01:49 schrieb Rafael Ribeiro:
>
>> Hello List,
>>
>>
>> I'm not an expertise on MySQL and we are
Am 08.03.2015 um 01:49 schrieb Rafael Ribeiro:
Hello List,
I'm not an expertise on MySQL and we are facing a strange issue:
We had a Virtual Machine, running CentOS + MySQL 5.0 with IP (1.1.1.1).
After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost
the ability to co
On Sat, 07 Mar 2015 21:49:10 -0300, Rafael Ribeiro wrote:
> I read a lot of tutorials and tips without success.
>
> What I need to do, to come back to working configuration like oldest
> machine, allowing remote connections?
By no means am I an expert, but, while not specific to your question:
Hello List,
I'm not an expertise on MySQL and we are facing a strange issue:
We had a Virtual Machine, running CentOS + MySQL 5.0 with IP (1.1.1.1).
After move this Virtual Machine to a new one (got a new IP - 2.2.2.2), we lost
the ability to connect to mysql remotely, from external IPs.
I r
>-Original Message-
>From: Shawn Green (MySQL) [mailto:shawn.l.gr...@oracle.com]
>Sent: Friday, December 17, 2010 10:35 AM
>To: Jerry Schwartz
>Cc: j...@consultorweb.cnt.br; mysql@lists.mysql.com
>Subject: Re: Access to MySQL
>
>Hi Jerry,
>
>On 12/17/20
Hi Jerry,
On 12/17/2010 09:34, Jerry Schwartz wrote:
-Original Message-
From: Jo�o C�ndido de Souza Neto [mailto:j...@consultorweb.cnt.br]
Sent: Friday, December 17, 2010 6:11 AM
To: mysql@lists.mysql.com
Subject: Re: Access to MySQL
What about this?
date_format(now(), "%Y/
>-Original Message-
>From: João Cândido de Souza Neto [mailto:j...@consultorweb.cnt.br]
>Sent: Friday, December 17, 2010 6:11 AM
>To: mysql@lists.mysql.com
>Subject: Re: Access to MySQL
>
>What about this?
>
>date_format(now(), "%Y/%m/%d")
>
[JS]
>-Original Message-
>From: Jesper Wisborg Krogh [mailto:my...@wisborg.dk]
>Sent: Friday, December 17, 2010 6:07 AM
>To: Jerry Schwartz
>Cc: 'MySQL'
>Subject: Re: Access to MySQL
>
>On 17/12/2010, at 9:02 AM, Jerry Schwartz wrote:
>
>> I have to mo
What about this?
date_format(now(), "%Y/%m/%d")
--
João Cândido de Souza Neto
""Jerry Schwartz"" escreveu na mensagem
news:011201cb9d6c$eccc1e60$c6645b...@co.jp...
I have to move the back-end of an Access application to MySQL, and I've run
into one issue that I haven't been able to solve y
On 17/12/2010, at 9:02 AM, Jerry Schwartz wrote:
> I have to move the back-end of an Access application to MySQL, and Iâve run
> into one issue that I havenât been able to solve yet.
>
> The Access database stores dates as text in a â/mm/ddâ format. The
> problem is that the default
I have to move the back-end of an Access application to MySQL, and Iâve run
into one issue that I havenât been able to solve yet.
The Access database stores dates as text in a â/mm/ddâ format. The problem
is that the default value is a formula that generates the current date,
for
> I have taken a Microsoft Access database and have basically copied the
> structure of it and rebuilt it in MySQL, however, I have encountered
> some problems with formatting of data. I need to ask what is the most
> suitable field type to use to retain the content from Access field types
>
> The
I have taken a Microsoft Access database and have basically copied the
structure of it and rebuilt it in MySQL, however, I have encountered
some problems with formatting of data. I need to ask what is the most
suitable field type to use to retain the content from Access field types
The MS A
"Jesse" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Wednesday, January 17, 2007 5:23 PM
Subject: ASP.NET Access to MySQL BIT field-Help
OK. I don't recall having a problem with this before, but, how do I
assign
a variable to a MySQL Bit field? I'm trying to set
OK. I don't recall having a problem with this before, but, how do I assign
a variable to a MySQL Bit field? I'm trying to set up a CheckBox that is on
my form, and I've tried variations of the following:
FirstTime.Checked = CBool(RS("FirstTime"))
FirstTime.Checked = CBool(RS("FirstTime").ToStri
rname/password might be wrong .
[EMAIL PROTECTED] wrote:
hi,
I'm trying to access to mysql on dedicated web server (hosted by hosting
company) using MySQL Administrator. Right now I'm getting error message
2003 (Can't connect to the server...).
On users table I can see in user col
o:[EMAIL PROTECTED]
Sent: Wednesday, 20 September 2006 4:30 a.m.
To: Praj
Cc: mysql@lists.mysql.com
Subject: Re: how can I access to mysql fro m"outside"?
I can connect using Putty to the server using port 22.
When I try to connect to the server using port 3306 and got "Connect
t; Error message looks like username/password might be wrong .
>
> [EMAIL PROTECTED] wrote:
>
>>hi,
>>I'm trying to access to mysql on dedicated web server (hosted by hosting
>>company) using MySQL Administrator. Right now I'm getting error message
>>200
U can chk firewall by doing a telnet to the remote host on 3306 (
default ) port .
Error message looks like username/password might be wrong .
[EMAIL PROTECTED] wrote:
hi,
I'm trying to access to mysql on dedicated web server (hosted by hosting
company) using MySQL Administrator. Righ
I don´t think it´s a problem with firewall.
The error figured out below seems it´s been a username or password problem.
<[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
> hi,
> I'm trying to access to mysql on dedicated web server (hosted by hosting
>
hi,
I'm trying to access to mysql on dedicated web server (hosted by hosting
company) using MySQL Administrator. Right now I'm getting error message
2003 (Can't connect to the server...).
On users table I can see in user column 'root' and 'admin' as users and
b
You ought to conect on localhost and create a new user with the specific ip
in the Host field.
<[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
> what I have to do to be able to access to mysql on my web server from
> other computer?
> e.g., I want to access to w
what I have to do to be able to access to mysql on my web server from
other computer?
e.g., I want to access to web server using MySQL Administrator?
I have root access to web server.
As far as I know, mysql server is set up by edfault to be acessed only
through "localhost" and I h
Hello all,
I just recieved a mysql server box from another department within my
company.. I would like to get the password for the mysql database for
mysql.. Is this possible in any other way other then using mysql -u
admin -p ?
--
Antoine W. Solomon Jr.
--
MySQL General Mailing List
For list
> The only way to link tables in MySQL (to use the term from Access) is to
> use the Federated database engine. A Federated table physically exists on
> one server but virtually exists on another. This is exactly like creating
> a linked table.
>
> However, AFAIK, the Federated database engine only
"Bing Du" <[EMAIL PROTECTED]> wrote on 04/04/2006 12:20:23 PM:
> Hello everyone,
>
> Please correct me if my understanding is wrong. Does the implementation
> of linked table mentioned on "18.1.11.3. How to Import or Link MySQL
> Database Tables to Access?"
> (http://dev.mysql.com/doc/refman/4.1
Hello everyone,
Please correct me if my understanding is wrong. Does the implementation
of linked table mentioned on "18.1.11.3. How to Import or Link MySQL
Database Tables to Access?"
(http://dev.mysql.com/doc/refman/4.1/en/import-of-data.html) means that
data is actually stored in MySQL and tab
http://www.webyog.com/forums/index.php?s=7a01772d367884257ac1c2f12b792027&showtopic=1536&view=getnewpost
Karam
--- Bing Du <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I've been looking around for a while. Seems there
> are many options and
> tools that can help do it. Guidance and directions
> ar
> Hello,
>
> I've been looking around for a while. Seems there are many options and
> tools that can help do it. Guidance and directions are highly welcome.
>
> We need to move the contents of a bunch of tables from Access to the
> existing tables on MySQL. The target tables in MySQL already hav
cript that copies the records directly
from Access to mySQL via ODBC. It uses DoCmd.TransferDatabase, if you'd
like to write your own.
I'd be happy to share it.
-- Brett
- Original Message -
From: "Bing Du" <[EMAIL PROTECTED]>
To:
Sent: Thursday, July 28, 200
Make a select query in Access whose result mimics the table layout of
the target table in MySQL. Then export the query as tab-delimited text
and import into the MySQL table using LOAD DATA INFILE.
On Jul 28, 2005, at 12:32 PM, Bing Du wrote:
Hello,
I've been looking around for a while. Seem
Hello,
I've been looking around for a while. Seems there are many options and
tools that can help do it. Guidance and directions are highly welcome.
We need to move the contents of a bunch of tables from Access to the
existing tables on MySQL. The target tables in MySQL already have some
infor
Export as CSV.
MySQL command line client.
Run a script with LOAD DATA INFILE.
Chris
On 5/23/05, Andrew Dixon - MSO.net <[EMAIL PROTECTED]> wrote:
> Hi Adam.
>
> I need to get all the data.
>
> Andrew
>
>
> Adam wrote:
>
> >Drew,
> >
> >That's vague. Specifically what do you want from th
Hi Adam.
I need to get all the data.
Andrew
Adam wrote:
Drew,
That's vague. Specifically what do you want from the Access database (e.g.
schema, data, etc.)?
A-
Hi All.
Does anyone know of any tools to convert a MS Access file to MySQL from
the Linux command line?
Thanks.
Andrew
Hello.
It is a frequently asked question. Search in the list. For example see
thread:
http://lists.mysql.com/mysql/160391
Sebastian Luque <[EMAIL PROTECTED]> wrote:
> Dear List members,
>
> Having relatively recently moved to GNU/Debian Linux from Windows, I'd
> like to move my M
Dear List members,
Having relatively recently moved to GNU/Debian Linux from Windows, I'd
like to move my MS Access databases to MySQL. I'm using the latest
unstable MySQL version and am all setup with user, passwords, and
privileges, so can create and modify databases in MySQL. Searching for
tool
Hi all, does anyone use this program MySQL Front 2.8 to convert access to
mysql? I have been looking in the menus and cant see anything to do it. Any
other programes that do the job?
Thanks a lot for any advice
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Rodney,
Did you EVER get a response to your question ?
Im keenly interested to know the answer.
M i l e s
+++
President & Toolbox Architect
MagicMiles Software
(413) 374 - 5161
PO Box 414, Northampton, MA 01060
http://www.magicmiles.com/
[EMAIL PROTECTED]
aim/yahoo/msn: magi
I am new to MYSQL and I want to set-up a database with two or more tables that
need to be "linked". I come from a basic MS Access background, and in Access
linking two tables is done by creating a relationship. Is it done the same
way in MYSQL? If so, could someone please shed some light on this
Mehta" <[EMAIL PROTECTED]> 3/29/04 12:18:37 AM >>>
please include the query, you are using with no success and also
specify the
version of your mysql.
Nitin
- Original Message -
From: "Ed Reed" < [EMAIL PROTECTED] >
To: < [EMAIL PROTECTED] >
S
Mehta" <[EMAIL PROTECTED]> 3/29/04 12:18:37 AM >>>
please include the query, you are using with no success and also
specify the
version of your mysql.
Nitin
- Original Message -
From: "Ed Reed" < [EMAIL PROTECTED] >
To: < [EMAIL PROTECTED] >
S
please include the query, you are using with no success and also specify the
version of your mysql.
Nitin
- Original Message -
From: "Ed Reed" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 29, 2004 1:27 PM
Subject: Access to MySQL query proble
I'm coverting an Access database to MySQL 4.1.1 and I need help with a
near impossible query. In the Access DB I used a stored procedure; I
think I should be able to solve this problem with a subselect in MySQL
but so far I'm not having any luck.
Here's the problem; In my stored precedure query I
I'm coverting an Access database to MySQL 4.1.1 and I need help with a
near impossible query. In the Access DB I used a stored procedure; I
think I should be able to solve this problem with a subselect in MySQL
but so far I'm not having any luck.
Here's the problem; In my stored precedure query I
I'm coverting an Access database to MySQL 4.1.1 and I need help with a
near impossible query. In the Access DB I used a stored procedure; I
think I should be able to solve this problem with a subselect in MySQL
but so far I'm not having any luck.
Here's the problem; In my stored precedure query I
At 02:32 2/25/2004, Jonas Lindén wrote:
>Hello, Could someone help me with a tip on how I can convert my old Access
>DBs to MySQL?
>
>Regards
>/Jonas
I've had some success with Cynergi.net's ExportSQL script
http://www.Cynergi.net/exportsql/
Start Here to Find It Fast! -> http://www.US-Webmaste
indén [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 25. Februar 2004 09:33
An: [EMAIL PROTECTED]
Betreff: Transfering from access to MySQL?
Hello, Could someone help me with a tip on how I can convert my old Access
DBs to MySQL?
Regards
/Jonas
--
MySQL General Mailing List
For list archives:
I use SQLyog - http://www.webyog.com/sqlyog
It has a pretty good ODBC Import Wizard.
Karam
--- Jonas_Lindén <[EMAIL PROTECTED]> wrote:
> Hello, Could someone help me with a tip on how I can
> convert my old Access DBs to MySQL?
>
> Regards
> /Jonas
__
Do you Yah
Jonas Lindén wrote:
Hello, Could someone help me with a tip on how I can convert my old Access DBs to MySQL?
Hello Jonas, I managed to do this out of Access by exporting the tables
to a MyODBC DSN.
Please check the column types later - don't know if they are all
converted correctly.
Regards,
Fr
Hello, Could someone help me with a tip on how I can convert my old Access DBs to
MySQL?
Regards
/Jonas
On Friday, January 30, 2004, at 03:12 AM, [EMAIL PROTECTED] wrote:
There was some discussion in December of converting MS Access
databases to Mysql and the DBManager program was recommended.
I have recently converted access to mysql. I used access to import a
CSV file and ensured all data was
There was some discussion in December of converting MS Access databases to
Mysql and the DBManager program was recommended. I have DBManager running
and select "Tools=>Data Management=>Import/Export Wizards," but the
command is greyed out and won't activate. I am using Office 2000 and I
have m
ssues?
Thanks again
Arthur
-Original Message-
From: Thomas Trutt [mailto:[EMAIL PROTECTED]
Sent: Monday, December 22, 2003 12:40 PM
To: [EMAIL PROTECTED]
Subject: Re: AW: Convert MS Access to MySql
question... does anyone know how it sets up the indexes, security
preferences , relation
://www.dbtools.com.br/EN/dbmanagerpro.php
There is a wizard which can do this conversion for you
Freddie
> -Ursprüngliche Nachricht-
> Von: Arthur Klimowicz [mailto:[EMAIL PROTECTED]
> Gesendet: Sonntag, 21. Dezember 2003 19:00
> An: [EMAIL PROTECTED]
> Betreff: Convert MS
003 19:00
> An: [EMAIL PROTECTED]
> Betreff: Convert MS Access to MySql
>
> I need to convert an MS Access database to MySql. I would
> like to know the best way to do this. I was going to write an
> asp or php script that would read the MS Access db row by row
> and inser
: Sunday, December 21, 2003 11:00 AM
To: [EMAIL PROTECTED]
Subject: Convert MS Access to MySql
I need to convert an MS Access database to MySql. I would like to know
the best way to do this. I was going to write an asp or php script that
would read the MS Access db row by row and insert into the MySql db
Arthur
On converting data from MS Access. I've done this several times myself, and
found the easiest way is to:
1. Create your mySQL database tables
2. Define a DSN (ODBC Connection) from your workstation to the mySQL
database
3. Link the mySQL tables into your MS Access database
4. Copy the conte
<[EMAIL PROTECTED]>
Sent: Sunday, December 21, 2003 2:30 PM
Subject: Convert MS Access to MySql
> I need to convert an MS Access database to MySql. I would like to know the
> best way to do this. I was going to write an asp or php script that would
> read the MS Access db row by row an
I need to convert an MS Access database to MySql. I would like to know the
best way to do this. I was going to write an asp or php script that would
read the MS Access db row by row and insert into the MySql db row by row. Is
that the only way to move the data from the one db to the other?
Many th
Hello all,
Has anybody had experience accessing MySQL tables via MyISAM library?
I'm working on an application that has to have both SQL-like and ISAM-like
(file-level) access to the table data. I thought that using MyISAM
directly would be a good idea. If anybody has any better suggestions, I am
Jeremy Proffitt wrote:
Dumb Question. I need to move my data from their current access database to my new MySQL server through an ODBC connection. The tables on both ends are set up identially. I have added a linked table to the access database called EXPARTAB1. The data is in EXPARTAB. I tri
Dumb Question. I need to move my data from their current access database to my new
MySQL server through an ODBC connection. The tables on both ends are set up
identially. I have added a linked table to the access database called EXPARTAB1. The
data is in EXPARTAB. I tried: INSERT INTO EXPA
Has anyone ever used a non-ODBC, 3rd party ADO connector to MySQL?
Any suggestions would be greatly appreciated. My client does not wish to use
ODBC.
/tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
-Original Message-
> From: Stephan Samuel [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 07, 2003 5:39 PM
> To: [EMAIL PROTECTED]
> Subject: Delete user/no access to mysql db
>
>
> Hi.
>
> I'm using MySQL on my web host. I'm a dba of the db's that
Hi.
I'm using MySQL on my web host. I'm a dba of the db's that I create, but I
have no access to the mysql db. I can create users (GRANT USAGE ON my_db ...
works), but I don't know how to get rid of them.
I searched the manual, and the only reference to removing users that I could
find was deleti
FIED BY 'password';
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 16日 月曜日 08:28、Renato さんは書きました:
> I have installed MySQL in Win98SE, with connection ASDL and Fixed IP.
>
> In the same machine, works web server (Apache2+PHP) and e-mail e ftp
> server.
>
> Everything
t;[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 12:11 PM
Subject: RES: Remote access to MySQL
I have all privileges to all the databases and tables, with user
'root'.
User 'root' likely doesn't have access from the desired IP.
Users are configured by
"Renato" <[EMAIL PROTECTED]>
Cc: "MySQL LIST" <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 12:42 PM
Subject: Re: Remote access to MySQL
> Yes, indeed. You don't have a firewall.
> But the firewall from the Internet Service Provider's computer p
configuration, as I recall it was
something commented out, perhaps the port number if I recall correctly.
-Shane
- Original Message -
From: "Renato" <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, J
ming Digital" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 9:11 PM
Subject: RES: Remote access to MySQL
> >> I have all privileges to all the databases and tables, with user
'root'.
> >User 'root' likely doesn't have a
assword';
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Renato" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 15 June, 2003 19:28
Subject: Remote access to MySQL
I have installed MySQL in Win98SE, with connecti
I have installed MySQL in Win98SE, with connection ASDL and Fixed IP.
In the same machine, works web server (Apache2+PHP) and e-mail e ftp server.
Everything works perfectly accessing from my INTRANET (local network). I
obtain access to MySQL without problems.
In Internet, all servers works
On Friday 28 March 2003 01:02, Rich Allen wrote:
> i found in the ODBC faq how to link from mysql to access, can this be
> done in reverse? link from access to mysql?
What do you mean by that?
MySQL can be used as a backend for Access, i.e. you can create an Access
application that co
iH
i found in the ODBC faq how to link from mysql to access, can this be
done in reverse? link from access to mysql?
thanks
- hcir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
gt;
Sent: Tuesday, February 11, 2003 4:54 PM
Subject: Migrating Microsoft Access to MySQL
> I am with a small business in Southern California that would like to
migrate
> our MS Access databases to MySQL server. Are their any computer se
IL PROTECTED]>
Sent: Wednesday, February 12, 2003 1:24 AM
Subject: Migrating Microsoft Access to MySQL
> I am with a small business in Southern California that would like to
migrate
> our MS Access databases to MySQL server. Are their any computer service
I am with a small business in Southern California that would like to migrate
our MS Access databases to MySQL server. Are their any computer service
companies who can help me?
-
Before posting, please check:
http://www.mysql.
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "mc 02" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, Januar
Hi Bob hall,
I do apologize for being unclear in my previous message.
To answer your question:
>Does the MySQL server run on your FreeBSD system?
Yes MySQL runs prefectly with my FreeBSD 4.6 system.
> How are you trying to export your Jet tables? I assume that's
what you mean when you refer
AIL PROTECTED]>
Subject: RE: Connection ms access to mysql
> What errors are you seeing when you try to perform the
export?
--
__
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signu
On Fri, Jan 17, 2003 at 03:15:05AM -0500, mc 02 wrote:
> I've downloaded the necessary application MySQL 3.51 and myODBC for
> freeBSD. On the XP side i only downloaded myODBC. I played around the
> configuration but i still cant seem to export the files to my FreeBSD
> box.
>
> What am i doing w
Hi !!!
I'm new with mysql database.
I have to migrate the data from access to mysql, is it posible? How can I
do it?
Thanks for your help
La información contenida en este correo es para uso exclusivo de
los destinatarios del mismo. Está prohibido a las personas o entidade
Hi,
I'm New to the networking world so bare with me. Now i know im
suppose to look through the manual in the mysql website but i still
cant make it work. So i need all the help i can get.
What i want to do:
===
I want to export my MS Access (2000) files (.mdb)in my WinXP Box to
M
PM
To: 'Charles Mabbott'; [EMAIL PROTECTED]; '1Mysql'
Subject: RE: Access to MySQL
There are many tools. Use a gui. mysql front (free), premium soft (my
pick
but has a 29 day trial). There are also many small window applications
to do
this. Do a search at one of the famou
]]
Sent: Monday, December 16, 2002 1:45 PM
To: [EMAIL PROTECTED]; '1Mysql'
Subject: RE: Access to MySQL
Yves,
I am always open for cleaner method, but what I did was in MySQL created
a table 'member' for data.
In Access exported as .txt make sure tab sequential.
Back in M
:21 PM
To: 1Mysql
Subject: Access to MySQL
Hello,
Is there a small program that would transfer the contents of an Access
database to MySQL?
TIA,
Yves Arsenault
Carrefour Infotech
5,promenade Acadian
Charlottetown, IPE
C1C 1M2
[EMAIL PROTECTED]
(90
Search the archive!
Short answer:
export to .txt and import in mysql or use ODBC
B.
At 13:20 16-12-2002 -0400, Yves Arsenault wrote:
Hello,
Is there a small program that would transfer the contents of an Access
database to MySQL?
TIA,
Yves Arsenault
-
Hello,
Is there a small program that would transfer the contents of an Access
database to MySQL?
TIA,
Yves Arsenault
Carrefour Infotech
5,promenade Acadian
Charlottetown, IPE
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
ICQ #117650823
SELECT @myvar := 1 ;
> -Original Message-
> From: Gerald Norman [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 01, 2002 10:37 PM
> To: [EMAIL PROTECTED]
> Subject: Converting Access to MySQL
>
>
> I have an application that currently is using an Access
I have an application that currently is using an Access database and am
in the process of converting over to MySQL. I downloaded the ODBC
driver and have been using ADO and have had no problems at all up to
this point. I have a number of parameterized SQL statements that
worked fine in Acces
x27;ll find all kinds of converters (including Access to MySQL) at:
http://www.mysql.com/doc/en/SEC669.html
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
I'm very new to mysql and haven't got much of a background in databases
generally, so thanks in advance to any who have the patience to deal with my
question.
I'm trying to get data from ms access 97 to mysql by exporting to a text
file then using the "load data" command to import it.
The data in
nal Message -
From: "Steve Jackson" <[EMAIL PROTECTED]>
To: "MySQL General Mailing list" <[EMAIL PROTECTED]>
Sent: Tuesday, November 26, 2002 3:37 PM
Subject: Is it possible to export data from access to MySQL?
> Is it possible to export data from MS Access
r 26, 2002 12:50 PM
To: MySQL General Mailing list; [EMAIL PROTECTED]
Subject: Re: Is it possible to export data from access to MySQL?
you're gonna get lots of neat high tech answers
to your problem, so here's a low tech answer just
because it's fun.
construct the database i
you're gonna get lots of neat high tech answers
to your problem, so here's a low tech answer just
because it's fun.
construct the database in mysql.
copy the access database to a working copy to be
safe.
in the working copy, link to the mysql tables.
open the access table a and copy the dat
I used MyAccess to convert my 40mb .mdb file into MySQL and it works
great. You can find it and a whole bunch of other conversion tools on
the MySQL site in Downloads/Other. Here's the link,
http://www.mysql.com/downloads/os-win32.html
Good Luck
>>> "Steve Jackson" <[EMAIL PROTECTED]> 11/26/02 6
Hi!
Yes, it's possible. Export your Access data to standard csv files, and then
use mysqlimport with appropriate parameters to import the csvs into MySQL.
The MySQL manual has excellent guidance on using mysqlimport or LOAD DATA
INFILE statements (which can do the same as mysqlimport).
Iikka
On
1 - 100 of 239 matches
Mail list logo