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') AS
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
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
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
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 error
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.
[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
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
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\binmysql --max-allowed-packet=32M \dev_hotel_data.sql
Regards,
Thanks, I'll try that... But
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
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
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
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 BitterSweet
Me again, new problem further down the same road:
C:\mysql\binmysql \dev_hotel_data.sql
ERROR 1030 at line 73106: Got error 28 from table handler
C:\mysql\binmysql \dev_hotel_data.sql
ERROR 1030 at line 74097: Got error 28 from table handler
Yes, just as it looks, the same error occurred on
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,
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
algorithm
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
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
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
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
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/
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
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
27 matches
Mail list logo