Re: How transfer data from Paradox to mysql?

2001-09-16 Thread Fredrick Bartlett

Hello, Miguel!

I have Paradox and copy Paradox tables to mySQL all the time.  Just use the copy 
table
function.  This is assuming you have installed the MySQLODBC and have created an ODBC
mySQL DSN.  Most all data types will copy correctly.  You will have to alter the tables
to recreate the keys.  When you say move your apps, I'm assuming your just referring to
the tables.  But yes,  you can just change your table alias to point to a mySQL table
instead of your Paradox table.  Very little change to your Pal code will be 
necessary.

Fredrick

Fredrick

Miguel Enriquez Alvarado wrote:

 i use the paradox and i want move my apps to mysql, but how?

 Regards
 otro correo: [EMAIL PROTECTED]

 ---
 Runbox Mail Manager - www.runbox.com
 Free online email application

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




How transfer data from Paradox to mysql?

2001-09-15 Thread Miguel Enriquez Alvarado

i use the paradox and i want move my apps to mysql, but how?

Regards
otro correo: [EMAIL PROTECTED]




---
Runbox Mail Manager - www.runbox.com
Free online email application

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: How transfer data from Paradox to mysql?

2001-09-15 Thread Chris Johnson

Paradox should allow you to export your data in some sort of flat file
format, such as comma separated values (CSV).  If so, you can use the MySQL
mysqlimport program or the MySQL load data infile 'filename' into
table... statement to load the flat files into your MySQL database.


- Original Message -
From: Miguel Enriquez Alvarado [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, September 15, 2001 3:40 PM
Subject: How transfer data from Paradox to mysql?


i use the paradox and i want move my apps to mysql, but how?

Regards
otro correo: [EMAIL PROTECTED]




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php