need to move 4.x database to 3.x database

2004-07-09 Thread Joseph Norris
Group, I have a project where I need to move a 4.x database to 3.x database. Are there any issues with doing the following: mysqldump 4.x mysqladmin create 3.x database mysql 3.x database < 4x.dump Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To uns

sql join statement that I do not understand

2004-06-28 Thread Joseph Norris
Group, First of all thanks to anyone who can respond to this - I am really stumped. I have been trying to figure this one out and maybe someone out there with a little deep understanding of joins in sql can give me a hand. I am working on a system that creates these sql statements on the fly

Optimizing Mysql for large tables

2003-08-21 Thread Joseph Norris
are the options that I have to speed my queries on the mysql side with regards to the my.cnf file. I have a fair understanding of sql optimization and I understand explain. I just want to see if there is something that I can do with the server also. Thanks to all. #Joseph Norris (Perl - what else