Re: How transfer data from Paradox to mysql?
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?
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?
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