Moving databases

2003-10-22 Thread David Wilson
We are running MySQL 3.23.47 on a AIX Risc System. It is IBM's compiled version of MySQL, it does everything as far as installing and compiling it for us. But what we found is that is stores the databases where it wants and would like to move them but cant seem to figure it out. Does anybody hav

Getting started (again)

2003-07-05 Thread David Wilson
Hi. I'm a relative MySQL newbie. A few weeks ago, I installed MySQL 4.0.13 on my WinXP Home box. After some use, the system began to run very slowly, e.g, the login box, start menu, and other apps were taking a few seconds to respond to my mouse. Rebooting did not solve the problem. By trial an

Correction: mysql daemon pegging my system

2003-07-04 Thread David Wilson
I left out a paragraph in my last message. Here is the full message: I am running WinXP Home, upgraded from Win 98, on an AMD 1G. After I installed MySQL 4.0.13, my system began to degrade. Eventually, things got so slow that it took several seconds for Windows, including the login screen and s

mysql daemon pegging my system

2003-07-04 Thread David Wilson
I am running WinXP Home, upgraded from Win 98, on an AMD 1G. After I installed MySQL 4.0.13, my system began to degrade. Eventually, things got so slow that it took several seconds for Windows, including the login screen and start meny, to respond to my mouse clicks. Rebooting did not help; if a

Re: LOAD DATA command error

2003-06-23 Thread David Wilson
I ran into this too. I assume it is a limitation on the free version of MySQL, and that you have to pay to use "load data" in an SQL script. To import my data files, I use the "mysqlimport" function from the command line or batch file. It seems to support most of the "load data" options. -