CheapWebHosting.co.nz

Domain Search | www. .com .net .org .nz Check ALL

and im back in the php mysql web hosting cli

if I want to export db that was in mysql 4, but will be used in mysql5, do I need to specify any compatibility mode when exporting ?

can anyone help me connect to my database host using mysql admin

eagles0513875, read the error message people in here cannot guess

ok
Could not connect to host 'database1'.
MySQL Error Nr. 2005
Unknown php mysql web hosting server host 'database1' (1)

obviously you ignored the valid help feiichi gave you

no i havent
this is my first time setting one of these up
im a total mysql noob

server host is not a database name

ok so its localhost
Could not connect to host 'localhost'.
MySQL Error Nr. 1045
Access denied for user 'jonathan@localho'@'localhost' (using password: YES)

typo

the password im putting in i know is correct
where
ok i got it

that sort of self checking you should manage

lol true
thanks for the help

Hi, my app use MyISAM talbes with lots of locks now. so I want to change it to InnoDB. but I heard InnoDB is slower than MyISAM. is it ture ?

I'm having a problem setting replication on debian etch, i can set replication up with CHANGE MASTER TO but cms mysql hosting does not load the configuration from /etc/mysql/my.cnf any clues?

i dont know whether its like kubuntu where u have to sudo to have read write access that could be it

hi, is a boolean field actually tinyint(1)?

chylli, app dependent which is faster
eagles0513875, that makes no sense
goneinwind, yes afaik

in kubuntu to have read write access u have to sudo everything
otherwise its just read access
and the kubuntu ubuntu distros r debian based that is y i suggested it

eagles0513875, I think you may well be miss understanding unix host permissions and running as the wrong user, but that has no affect on mysql as the server runs as its own user

i know but it seems like they lock the root account so that u have to log in as a regular user and u sudo when ever u need root permissions

mysql user is NOT the same as system user

ok

ok, thanks archivist

good morning everybody :-)
http://pastebin.co.uk/17102 (#1054 - Unknown column 'sq.ae_pro_bearbeiter' in 'field list')
can anybody help me?

hi there, I have a table with 9000 entries, which have an auto-incrment id. The id starts at 9000, is it possible to "reset" that id so that it starts at 1?

usually not a good idea to reset id's

archivist, I know but in this case, it doesn't matter because they are not linked to another table.
it's just so our boss sees a 1 instead of 9000

hehe

I know it actually doesn't matter but to him, it does

!man alter table

see http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

For InnoDB, you can use ALTER TABLE ... AUTO_INCREMENT = value as of MySQL 5.0.3, but if the value is less than the current maximum value in the column, no error message is given and the current sequence value is not changed.
that's a little bit.... not so sexy.

and then the phb asks why the order is odd and then...

ah, I have an idea haha, I just do a update table SET id = id-9000
HAHA

watch how you do that
any overlap and ......

I just did
there's no overlap
it would give me a duplicate entry error

does it start at 0 now then?

so the first one would have autoincremented from 18000+ hehe

I have a table that basically tells me "X is a part of Y". And I have to get all X,Y pairs for Xs which are part of a set Y="foo". How do I do that?
Here's what I've tried:
select x,y from table where x = any (select x from table where y = "foo") and y != "foo";

simmerz, no, it starts at 1 now, I did id-8999 of course and did alter the table to set the auto increment value to 9001

Hi ! I have several entries in a SQL table with id as primary key. Each entries can be populated by a user (table users) I need another a sequence so that it match each user entrie. Is there a simple way to do it ... If it is not clear just tell me
I mean eaxh user has its sequence
*each

fair enough! just checking!

simmerz, yep, thx for the heads up
nice weekend to you all

http://pastebin.com/929519

you too

how i can grouped by weeks. example: i have a table with 100 entries, and a date-field. (2007-07-15). .how i can grouped by week one, week two?

: search date function
There should be one for week number in a year

hmm, but how? i have 11,12,13,14,15,16,17 then i would like the result, grouped: 11...

user groupBy
*use

!man week(

see http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

but grouping by a function wont use an index

hm

Any idea for my sequence problem ?

archivist, progzy
SELECT min( scheine.datum ) AS w, week( scheine.datum ) AS wk
FROM scheine
WHERE scheine.datum LIKE '2006%'
GROUP BY wk
ORDER BY `wk` ASC
yes?

tias

Try it and see, its quicker to type it on your system and try it than wait for one of us to tell you its ok

tias?
du spricht deutsch? )

^^^

no #mysql.de for deutsch

Related Topic: