 | | | MySQL General | | hi again
I have to restart as soon as possible mysql and apache on our web server
(mandrake cooker 10) - since our admin is "out of office " for today.
if someone can ive me some instructions pleasehi again
I have to restart as soon as possible mysql and apache on our web server
(mandrake cooker 10) - since our admin is "out of office " for today.
if someone can ive me some instructions pleaseYup! Got it..
Thanks guys to all of you for REALLY fast help!
)
-afan
> Yeah pretty much but I would keep cust_id around and start over with a
> true autoincrement from 1.
>
> On 5/9/06 af
----- Original Message -----
From "Chris Sansom " <chris@(protected) >
To "MySQL List " <mysql@(protected) >
Sent Tuesday May 09 2006 11 47 AM
Subject Sum of counts
> Here comes a newbieIn the last episode (May 09) Alla-amin said
> I am trying to capture my server time automatically using php and
> insert it in a mysql table.
>
> Can the timestamp or time data type capture this in
----- Original Message -----
From "Mohammed Sameer " <msameer@(protected) >
To <mysql@(protected) >
Sent Tuesday May 09 2006 9 56 AM
Subject Order by leads to an empty set.
> Hi all
>
> I hI would drop the primary key off of your cust_id and add a new field like
customer_id and relink using the old fk.
I 'd probably do this by creating a new table and doing an INSERT INTO SELECT
FROM toBarry wrote
> Hello everyone!
>
> I have a slight problem matching rows.
>
> My problem is the Value in a textfield is "87682 <next >39857 "
>
> I created that with concat.
> Is there a way to match?????? schrieb
> Hi
>
> There is a schema example below (From "A first course in database system ")
>
> Product (maker model type)
> Pc (model speed ram hd rd price)
> Laptop (model speed rHi
I have bought the MySQL certification study guide (v 5.0) and am almost
ready for the exams does anyone know if the questions in the self study
guide are very similar to the ones that you get i
I 'd be surprised if things actually turned out to be quite as simple as you
describe. For example let 's say that your column actually contained book
titles or names of people. Would you really wanMarcus
> I just noticed that a key field (emailaddress) in my db is case
> sensitive when it should not have been so now I 've got a bunch of
> what are effectively duplicate records. I 'm having tr
Has anyone converted from Unidata db to Mysql? How easy/difficult
is it to do? Does the Mysql Migration toolkit help with that process?
an old consulting company setup a website with Unidata andromyd misc said
> Hi Everyone
>
> I 'm developing an application using C# .NET and mysql as database. It 's a
> multithreaded application we open a mysql database connection at the very
> beginning wDear Friends
I have a database with approximately 10 tables with about 1 lakh records
each in 3 tables I need to know that on what factors does the speed of
mysql depends
1)Does a table having recoHi Johan
> I need to extract some data to a textfile from a big database.
>
>
> If I try to do like this
> mysql < queryfile.sql > outfile.txt
>
> "outfile.txt " it looks something like
> "OrderOn 5/9/06 balaraju mandala <balaraju.mandala@(protected) > wrote
> Hi Dilip
>
> I got two binary logs in Server. I don 't know how to find server uptime?
>
> mysql > show master logs
> + > I need the birthdays from yesterday today and the next 4 or 5
birthdays.
You don t need to manually compute every date component. Try something
like ...
SELECT ...
WHERE DATE_SUB(NOW() INT
Is there any way to optimize a range query that includes
an ORDER BY with keys from two different tables? I 'm running
MySQL 4.1.18 on FreeBSD.
I 've been struggling with some queries that are _incredHi All
Didn 't know there was an "optemizer " for mySQL.
Where can I get it from?
Thanks
Jim
Best regards
Jim Clark
Project Manager
Multilink Systems
Ph 03 9425 9400
Fax 03 9425Hi Payne
This should have all the info you need there is also another command
myisamchk which requires the server to be down while it repairs.
mysqlcheck does not.
http //dev.mysql.com/doc/refman/5Hi Luke
> When mysql is doing a dump do the updates that happen during the dump
> get included in the dump.
I assume you mean 'mysqldump '.
> I have a dump that starts at 11pm and goes for 2 hourIt looks like MySQL installed but when it tried to start the server
the server crashed. Can you confirm that?
If so try starting it with the startup script -- you should get the
same error. If ittony yau wrote
> Hello
>
> I can get a select result like the following (SELECT ID Changes FROM
> mytable WHERE somecondition )
>
> ID Changes
> Hi Greg
Maybe similar features to that of bacula (my current backup software of
choice for my wifes business servers). This is a very comprehensive open
source solution that has many of the featuresYou may want to consider automating the synchronization of your databases
via replication. Check out the Replication chapter in the MySQL manual
(chapter 6 in the MySQL 5.0 manual).
I don 't know if
----- Original Message -----
From "Stephen Cook " <sclists@(protected) >
To "MySQL List " <mysql@(protected) >
Sent Sunday May 07 2006 3 53 AM
Subject PRINT statement?
> Is there a statement sOn Sat May 06 2006 at 12 55 55PM +0100 Peter Rosenthal wrote
> Out of interest is there any time on the roadmap to improve the query
> optimizer 's handling of sub-queries as specified in
> http //jehova villa martinez schrieb
> Hi as newbie and with some trubles understanding English language i
> have a question that I don?t know howto put on search engines (I don?t
> know technical keywo
> -----Original Message-----
> From sheeri kritzer [mailto awfief@(protected)]
> Sent Friday May 05 2006 2 37 PM
> To Duzenbury Rich
> Cc mysql@(protected)
> Subject Re blank user names i |
|
|
