RE: Front end for MySQL databases

2002-11-27 Thread Ian Zabel
I personally prefer MySQL-Front, even though its development has been suspended. You can get it here: http://mysqlfront.venturemedia.de/index.php?&act=ST&f=2&t=328 MySQLCC is ok: http://www.mysql.com/downloads/gui-mycc.html SQLyog seems ok: http://www.webyog.com/sqlyog/index.html As to connecting

RE: access->mysql

2002-12-04 Thread Ian Zabel
The only one I found that creates a good schema that only needs minimal massages, and imports all the data correctly is Access-To-MySQL. It's not free though, but they have a trial. Once I went through my access database and removed certain invalid records (some rows had a screwed up primary key in

RE: MySQL: Select HELP!

2002-12-04 Thread Ian Zabel
select * from processo_arquivos order by DATE desc limit 10 -Original Message- From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 12:42 PM To: [EMAIL PROTECTED] Subject: MySQL: Select HELP! Importance: High Hi List Users, I want to know i

RE: Automatically start MySQLServer on RedHat Linux 7.3

2002-12-04 Thread Ian Zabel
I'd suggest installing the MySQL RPMs from the MySQL.com website. They will setup all of the init.d scripts to handle startup/shutdown of the service. Download all the RPMs to a directory on your server, then as root type, rpm -Uvh MySQL*.rpm Then you can stop/start it like this: service mysql (s

Importing into MySQL from Access

2002-08-12 Thread Ian Zabel
I already have my table structure in place in MySQL, and I just want to import the data from my Access 2000 database. (the .mdb is about 50 megs) The MySQL server is on a Linux system. I've been using DBTools to do the import, because it allows me to import just the data, and not create the tabl