#mysql
06 October 2007
Total 16 pages. You are browsing page 2/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
00:42 <****> so, the actual definition for the table is in a different format between those two versions, and you can't do a binary downgrade
00:43 <****> dump from 5.0 and restore into 4.1 should work fine, though
00:43 <****> or from 5.1
00:43 <****> but I'm now dealing with .frm files, just a .sql file.
00:43 <****> you did an SQL dump from 5.1 and now you try to load it into 4.1 and you get that error?
00:44 <****> can you put the CREATE TABLE sttement up on some pastebin?
00:44 <****> dfas dump using --compatible=mysql41
00:44 <****> I already loaded it without error, I inserted lots of into the database, but displaying the data gives this error.
00:46 <****> if i'm using tables with myisam, how can i make foreign keys?, if i cant, how i reference two tables?, should i use innodb?
00:46 <****> hey all
00:46 <****> niuq: you can't use foreign keys with myisam. what do you mean by "reference two tables". do you simply want to do a join?
00:46 <****> !man join syntax
00:46 <****> see http://dev.mysql.com/doc/refman/5.0/en/join.html
00:47 <****> does anyone know... from command line mysql. in the '--execute=' parameter if you can execute a query without quotes ' or ". e.g. --execute=select * from table
00:47 <****> tias
00:47 <****> 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
00:47 <****> Cluber: of course you have to use quotes. otherwise, the shell would interpret all of the wildcards and it would be impossible to see where the query stopped
00:48 <****> litheum: well keeping a integrated database references between tables, allowing me to cascade updates, and things like that
00:48 <****> innodb then
00:48 <****> niuq: myisam doesn't support that
00:49 <****> there is any disadvantage using innodb?
00:49 <****> no fulltext
00:49 <****> who jsut answered that i got d/c
00:49 <****> huh?
00:50 <****> no fulltext
00:50 <****> not sure what you mean with that
00:51 <****> an index type for text searching
00:51 <****> who just answered my question about quotes in shell
00:51 <****> well i won't use that kind of indexes, i think
00:52 <****> hmm
00:52 <****> innodb behaves completely differently than myisam
00:52 <****> they're fundamentally very different
00:52 <****> is there a way from this php command
00:52 <****> and how can i be affected?
00:52 <****> Cluber: of course you have to use quotes. otherwise, the shell would interpret all of the wildcards and it would be impossible to see where the query stopped
00:52 <****>
00:52 <****> hmm
00:53 <****> Cluber, learn to connect directly
00:53 <****>
00:53 <****> becasue im trying to send it the command through that
00:53 <****> but _GET adds extra unwanted quotes
00:53 <****> so DON'T USE IT
00:53 <****> use mysql(p)connect()
00:54 <****> never pconnect
00:54 <****> whats that
00:54 <****> no ?
00:54 <****> the php file is on remove server
00:54 <****> so ? grant its user access to the db
00:54 <****> from *that* machine
00:54 <****> and thats the only way i can interact with the shell
00:54 <****> litheum: in what cases should i use innodb or mysisam?
00:55 <****> hmm
00:55 <****> isnt there something i can use alterative to quotes
00:56 <****> Cluber: what are you trying to do?
00:56 <****> is there another 'value/code' i can sue in palce of the " or '
00:56 <****> --execute="query here"
00:56 <****> adapter no connections get left mysal does not drop when the php proc dissapears, it ends up with a too many connections/cant connect situation
00:56 <****> but i cant send the quotes from the client im using
00:56 <****> Cluber: why in heaven's name can't you use quotes
00:56 <****> Cluber: and why is the client you're using calling the mysql command-line executable
00:56 <****> the client filters the quotes
00:56 <****> ecape the quotes
00:56 <****> niuq: there are extensive documents on when one should use innodb and myisim
00:56 <****> a question if i'm logging in the mysql_query.log and i dont want it mre...but without restart the server...may i do a link from mysql_query.log to /dev/null?
00:57 <****> escape
00:57 <****> \"
00:57 <****> but then it would send --execute=\"query here\"
00:57 <****> niuq: main differences is table and row level locking, speed of reads, and transactions
00:57 <****> and it wouldnt execute would it
00:57 <****> i was thinking
00:57 <****> wnorrix: mmm a small application for making payrolls
00:57 <****> is tehre something else that shell reads as quotes
00:58 <****> niuq: if your looking at small data sets etc
00:58 <****> #quote query #quote
00:58 <****> just go for innodb
00:58 <****> you can sit and change things later.. too :)
00:58 <****> also myisiam has fulltext support for searchs
00:58 <****> hehe when everything crashes ^^
00:58 <****> i guess theres no way around it lol
00:58 <****> i've never used that before
00:59 <****> niuq: innodb has recovery
00:59 <****> else what use would transactions be :)
00:59 <****> concurrency
01:00 <****> why myisam doesnt support foreign keys?
01:00 <****> Cluber why don't you write normal PHP queries ?
01:00 <****> this php pdo is pretty cool
01:00 <****> adaptr - the system() is on a remote server
01:00 <****> which i do not have access too
01:01 <****> and therefore trying to make the most of what i have
01:01 <****> Cluber so ? you do have access to the mysql db - GRANT * ON db.* to phpuser@this_machine
01:01 <****> Nope
01:01 <****> you would be correct in that
01:01 <****> what does the option 'ROW_FORMAT=DYNAMIC' do?
01:01 <****> is there a command that adds myself to grant list?
01:01 <****> When you guys have internal servers behind a firewall, and grant permissions, do you just do: GRANT ... TO replication; and that way you can throw in new servers, or do you create new replication@hostname accounts for each slave?
01:01 <****> ah, you don't have GRANT option ?
01:02 <****> is tehre a commandline GRANT command?
01:02 <****> !man grant
01:02 <****> see http://dev.mysql.com/doc/refman/5.0/en/grant.html
01:02 <****> _obviously_ there is
Total 16 pages. You are browsing page 2/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last