Trevor Sather wrote:
> Hello
>
> The following query used to work when I was using an Access database,
> but now that I've moved to MySQL I get a syntax error when I try and
> run it:
>
> SELECT *, (SELECT COUNT (*)
> FROM Links
> WHERE Links.CAT_ID = Categories.CAT_ID AND LINK_APPROVED = 'Yes'
Sheni R. Meledath wrote:
> Can any body provide me some details regarding migrating MySQL
> databases to MS SQL databases.
I recently got to do this. I built DTS packages on the MS-SQL database
to import my data from MySQL. I found it worked better to create the
tables manually and then import
[EMAIL PROTECTED] wrote:
> Can someone help
> point me in the right direction? Thanks
I just finished a practice upgrade (on a back-up server) myself and will
be upgrading the real server during off-peak hours soon. We are running
win2k servers so I can't speak directly to any linux issues, but
miguel solórzano wrote:
> Some program has locked C:\mysql\bin\libmySQL.dll, if you can
> delete it.
Indeed, my server didn't even want me to delete the file, until I checked the process
list and realized what was locking it: winmysqladmin. Duh... I shut that down and
everything went smoothly.
> Most probably you are running a server and the setup program
> fails to rewrite the file. Before run the setup.exe stop the
> current server.
Most probably you are correct. :)
I stopped the server and ran the set-up again, and this time it got much
further, but I then encountered a new erro
Ok now I've got my database completely copied on another server, so now
I'm doing a trial run of upgrading the copy-db to 3.23.56. I unzipped
the stuff and ran the SETUP.exe and after setting the parameters, the
SetUp programs runs a little bit and then pops up this error message:
An error occurr
Gerald R. Jensen wrote:
> I just ran your query (create and both inserts), and it
> worked like a charm on a Win32 MySQL 3.23.52.
>
> Just out of curiousity, why are putting the \r in?
>
Gerald (and all who were interested),
I didn't put the \r in, actually...mysqldump did. The solution to the
Stefan Hinz wrote:
> No really. But you could hit the communications buffer size
> (though that does not seem likely at all with your .sql
> file). Anyway, it can't help to try the following:
>
> C:\mysql\bin>>mysql --max-allowed-packet=32M < \dev_hotel_data.sql
>
> Regards,
Thanks, I'll try th
Stefan Hinz wrote:
>
> Are you running this from a script? Maybe it's just a script
> timeout which would stop with the following line when it gets the
> timeout:
Oops, no sorry for all those who don't know where I left off yesterday
(tee hee).. This is an import of a .sql file being run from th
Still trying to get all the way through my import batch file.
Now I'm getting a syntax error on a certain line of the file, and a
subsequent run produced the same exact error on the same exact line, but
I can't see anything wrong with that line.
Here's the line that produces the error:
INSERT
Me again, new problem further down the same road:
C:\mysql\bin>mysql < \dev_hotel_data.sql
ERROR 1030 at line 73106: Got error 28 from table handler
C:\mysql\bin>mysql < \dev_hotel_data.sql
ERROR 1030 at line 74097: Got error 28 from table handler
Yes, just as it looks, the same error occurred
Paul DuBois wrote:
>> Line 7 is:
>> USE `cm_central`;
> Try omitting the backticks from the database name.
>
> mysql has a slightly different parser than the server and
> that may be causing you a problem with the USE statement.
Thanks again Paul, that did the trick...which is kind of a BitterSw
Hehe.. I just got past this problem and on to the next. You need to
make sure you are executing the command from a DOS prompt..the response
you got indicates (I'm pretty sure) that you are executing it from a
mysql> prompt (ie: a mysql client prompt).
Yasen Petrov wrote:
> Hello,
>
> I'm using W
Thanks for the replies, Ryan and Paul.
I tried the suggestion of using the command prompt, and it did attempt
to run the .sql file. That's when it *really* gets troublesome:
C:\mysql\bin> mysql < \mysql\cm_central.sql
ERROR 1049 at line 7: Unknown database '`cm_central`'
Line 7 is:
USE `cm_cent
MySQL 3.23.54, Win2k Server:
I am trying to take a .sql file that I got from a mysqldump from one
mysql server, and use it to populate a new mysql server, as though I
were restoring a backup after a total system crash.
I am using the following command, following the only example I could
find in t
Benjamin Pflugmann wrote:
> If you have 256MB, the one may fit into memory,
> the other may not and therefore requires additional disk reads.
Ah, see.. I hadn't thought of disk reads. I was thinking if you do a
select on a char[50] and the whole field is indexed, wouldn't the search
algorith
>
> If you're indexing all 50 characters, index fewer of them.
>
Not that I think you're wrong, but help me understand, please:
It seems to me that this would cause the index creation to go faster,
but the execution of the SELECT query to, if anything, go slower...?
I'm probably wrong, though,
SELECT id,account FROM tablename WHERE detail LIKE '%pattern%' GROUP BY
Account;
-Original Message-
From: Jaime Teng [mailto:[EMAIL PROTECTED]]
I have a MySQL table:
...
It should only return *one* result per account.
I am trying to get a count of Distinct IP's from my homemade hit-log
database (don't ask). The db is MySQL. I'm trying this:
SELECT DISTINCT ClientIP, COUNT(*), Month(TimeStamp),
DayOfMonth(TimeStamp) FROM RedirectLog WHERE (TimeStamp BETWEEN
'2003013000' AND '2003013100') GROUP BY Month
Nice that this came up when it did.. I'm currently struggling with a
three-table join.
Table1.PK = Table2.FK1
Table3.PK = Table2.FK2
My last effort looks something like:
SELECT SomeStuff
FROM Table1 AS T1
LEFT JOIN Table2 AS T2 ON T1.PK = T2.FK1
RIGHT JOIN Table3 AS T3 ON T2.FK2 = T3.PK
WHERE T1
Thanks for the reply Egor.. This helps, but what I'm really hoping to
find is a GUI that updates itself on the fly, kind of like the Win2k
Task Manager processes tab. Anybody got anything like this?
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 1
Is there a tool out there for Windows that will let me monitor how many
connections to my MySQL database are currently open at any given moment?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I am looking into using the mysqlhotcopy.pl script to back-up my
databases. When I try to run it, I get the following error:
The getpwuid function is unimplemented at
C:\mysql\scripts\mysqlhotcopy.pl line 79.
I'm not familiar enough with perl to even begin debugging the script
myself.. Does a
Hi, can I do a sql query in MySQL that would do something like this:
UPDATE table SET SomeInteger=SomeInteger+1 WHERE (Some Condition)
I know that this exact syntax doesn't work, but is there a way to do
what I'm trying to do, which is to do a math function on an integer in
the table with a SQL
I want to write a batch file of sql statements so that I can schedule
this batch file to run at night automatically and send the sql commands
to a mysql database on a Win2K server. Does anybody have any experience
doing this? Any pointers in the right direction would be much
appreciated.
Tab
-
Anybody have any idea what kind of concurrent user load MySQL is (or at
least should be) capable of handling?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
What do you folks out there do to backup your MySQL databases? I'm new
to it and am wondering if there's a good utility for doing it, or some
simple procedure that is already known to be effective and efficient.
Thanks,
Tab
-
Does anyone know of any weird issues with getting the value of an
AutoIncrement Primary Index field into a recordset? I do a sql call
from an ASP page that loads the Index and one other field into a
recordset. The other field contains the expected data, but the Index
field in the recordset alwa
28 matches
Mail list logo
