MSQL Installed and running in background

2008-03-22 Thread AndrewMcHorney
Hello I have successfully install mysql and is is running in the background as a service ( I believe) as in msconfig lists it in the services. Is there something I should see in the task bar down at the bottom. Now what should I do next? Do i need a gui to log in and created databases? If so,

Re: Extremely slow queries on large database

2008-03-22 Thread m3m63r . 0f . 61a9 . p3ar1
Sorry my question may have been bad. MySQL version is 5.0.37. I tried slow query logging with long query set to 1 sec. I came up with 3 sec and 6 sec queries and both of them are select query. When I searched google it said that I need to use paging but since it was working on the old server I do

Re: MQSQL Installed - Now what

2008-03-22 Thread Craig Huffstetler
Please go to: Start > Run Type in: msconfig Click the SERVICES tab and check MySQL * if it is listed on there. Is it not already listed as "Automatic" and "Running." (Didn't you already enable this to start when Windows starts up in the previous e-mail steps, by the way?)... And -- MySQL should

Re: not allowing empty strings

2008-03-22 Thread Rob Wultsch
On Sat, Mar 22, 2008 at 5:03 PM, Ferindo Middleton <[EMAIL PROTECTED]> wrote: > Is there a way to not allow empty strings in the database for a data type. I > have a column set to not null but sometimes users enter empty strings which > are also unacceptable. How can I force MySQL to disallow em

not allowing empty strings

2008-03-22 Thread Ferindo Middleton
Is there a way to not allow empty strings in the database for a data type. I have a column set to not null but sometimes users enter empty strings which are also unacceptable. How can I force MySQL to disallow empty strings in addition to not null. Ferindo

Re: MQSQL Installed - Now what

2008-03-22 Thread Craig Huffstetler
Andrew, During installation did you choose to run it automatically when Windows starts up (as a service or application)? If you're not sure, read on...either way, we'll get it figured out. You can easily add it to your startup applications. I would check this page out for information on the GUI

MQSQL Installed - Now what

2008-03-22 Thread AndrewMcHorney
Hello I just successfully installed the server. I would like to know how to start up the server as I see no icon or pull down to start it. I would like to start up the server with a gui and not from a command line. What do I need to do this and what would I need to download. Also is there a

Re: Server Instance Setup Error

2008-03-22 Thread AndrewMcHorney
I will rerun later today At 08:04 2008-03-10, you wrote: That error message is usually when you try to login to MySQL by whatever means (the Windows install Wizard may be attempting this in the final steps upon starting up? But it should not be starting up as root...). Can you complete the inst

Extremely slow queries on large database

2008-03-22 Thread m3m63r . 0f . 61a9 . p3ar1
Hello Recently I changed my servers. The old server spec is Core2Duo E6600 with 4gb ram and 320gb SATA. The new server spec is Dual Opteron 2.1ghz with 4gb ram and 73gb 15kRPM SAS. Now here comes the problem. I generated 3gb forum backup (sql format) and putted it back in to the new server. It to

Re: Optimize db update

2008-03-22 Thread Velen
Thanks for your advice. I found another way of doing it. from DatabaseB: Select * into outfile 'data.txt' from TableB then on DatabaseA: Load data infile 'data.txt into TableB then on DatabaseA, I can run any validation on TableB before inserting it in TableA. Velen - Original Message --