chillywilly (danielb@d167.as9.nwbl0.wi.voyager.net) joined #gnuenterprise. Nick change: ajmitch -> ajbusy Mr_You (rouzer@mankind.boredom.org) left irc: night mdean (mdean@arc10x16.kcnet.com) left irc: Ping timeout for mdean[arc10x16.kcnet.com] ra3vat (ds@195.239.66.36) joined #gnuenterprise. chillywilly: i'd bet someone knows in #phpgroupware, or else maybe something like webmin can do it knows what? ra3vat (ds@195.239.66.36) left irc: Ping timeout for ra3vat[195.239.66.36] chillywilly: how to export a mysql db er dump it dtm rm -rf mysql/ thats best way to 'dump' mysql ;) yeah that'l dump it chillywilly: there ya go chillywilly: man mysqldump cat: man: No such file or directory well I don't need to do it anymore cat: mysqldump: No such file or directory I ike da masta way better though yeorp rm -r /usr/lib/mysql cat: invalid option -- h rm -r /etc/mysql Try `cat --help' for more information. heheh mysqldump: option requires an argument -- h mysqldump Ver 7.1 Distrib 3.22.32, for pc-linux-gnu (i686) By Igor Romanenko, Monty, Jani & Sinisa. This software is in public Domain This software comes with ABSOLUTELY NO WARRANTY Dumping definition and data mysql database or table Usage: mysqldump [OPTIONS] database [tables] -a, --all Include all MySQL specific create options don't worry dude -#, --debug=... Output debug log. Often this is 'd:t:o,filename` -?, --help Display this help message and exit. -c, --complete-insert Use complete insert statements. -C, --compress Use compression in server/client protocol -e, --extended-insert Allows utilization of the new, much faster INSERT syntax --add-drop-table Add a 'drop table' before each create --add-locks Add locks around insert statements --allow-keywords Allow creation of column names that are keywords --delayed-insert Insert rows with INSERT DELAYED -F --flush-logs Flush logs file in server before starting dump -f, --force Continue even if we get an sql-error. -h, - - host=... Connect to host. -l, --lock-tables Lock all tables for read. -t, --no-create-info Don't write table creation info. -d, --no-data No row information. -O, --set-variable var=option give a variable a value. --help lists variables --opt Same as --add-drop-table --add-locks --all --extended-insert --quick --lock-tables -p, --password[=...] Password to use when connecting to server. If password is not given it's solicited on the tty. -P, --port=... Port number to use for connection. -q, --quick Don't buffer query, dump directly to stdout. -Q, --quote-names Quote table and column names with ` -S, --socket=... Socket file to use for connection. -T, --tab=... Creates tab separated textfile for each table to given path. (creates .sql and .txt files). NOTE: This only works if mysqldump is run on the same machine as the mysqld daemon. we're getting creative here eh? -u, --user=# User for login if not current user. -v, --verbose Print info about the various stage s . -V, --version Output version information and exit. -w, --where= dump only selected records; QUOTES mandatory! EXAMPLES: "--where=user='jimf'" "-wuserid>1" "-wuserid<1" dnWork: yeah i think that oughtta do it Use -T (--tab=...) with --fields-... --fields-terminated-by=... Fields in the textfile are terminated by ... --fields-enclosed-by=... Fields in the importfile are enclosed by ... --fields-optionally-enclosed-by=... Fields in the i.file are opt. enclosed by ... --fields-escaped-by=... Fields in the i.file are escaped by ... --lines-terminated-by=... Lines in the i.file are terminated by ... Default options are read from the following files in the given order: apt-get --purge remove mysql-server /etc/my.cnf ~/.my.cnf The following groups are read: mysqldump client The following options may be given as the first argument: --print-defaults Print the program argument list and exit --no-defaults Don't read default options from any options fil e --defaults-file=# Only read default options from the given file # Possible variables for option --set-variable (-O) are: max_allowed_packet current value: 25165824 net_buffer_length current value: 1047551 thats how you dump Action: chillywilly wonder what possessed him to do it Nick change: dnWork -> derek how about apt-get --purge remove mysql-server coz he's neat :P alright guys, let's take a vote who thinks i oughtta shave (my face) right now why would you fo that? that hair is there for a reason ya know dont argue! just tell me to do it! don't shave!!!! good grief! why is life so complex! someone just tell me what to do!!!!! !?!!? don't shave!!!! [01:54] MSG541 @)K#K:MJlj derek: ?!? it might seem that PHP Choco GNUe has immediately lulled on the phpgw mailing list lulled? no more discussion it si dead? uhh no cause no one has the time to look at it well i think they probably have to implement the supporting arch first like soap/xml-rpc I had a discussion with Milosch (sp?) CORBA us better damnit :P also i think it might help if you guys give some guiding light to phpgw's general infrastructure corba is like my whore or something i see she's damn goof at what she does i dont know if yall have any input on phpgw's architecture but they can always use mature input good yeah i hear ya ok i'm taking a contrarian stance against chillywilly's contrarian stance on my face shaving he's not the boss of me. then don't ask fewl do what you wanna do and tell everyone to fuck off :P hmmm so do you think i should tell you that, dan? is that what you're ordering me to do/ ? yep nope heheh coz if you want me to do it , just say so i swear i'll do it dan do what you want to do yeah so just tell me what i want to do it is a free world or something reinhard (rm@62.47.44.46) joined #gnuenterprise. where? I dunno dan stop being so vague! in my wildest fabtasies i can't handle all this pressure! fantasies eh? reinhard: you are making me look bad commiting all of that code reinhard: yeah cut it out when did you rewrite the parser? Action: chillywilly waits for reinhard to read his email ;) chillywilly: rewrote since tuesday iirc but it's not finished well I read your comments you were not happy with the current one? it was too much fun to read? or have you been learning flex and bison I am still trying to make sense of GEAS what exactly is a GEAS_object_reference? you know that one? a CORBA ref? a string? / Opaque datatype: do not attempt to interpret the contents, as it may // be changed arbitrarily typedef string ObjectReference; Action: chillywilly is smoking crack I am thinking this an id madd from th oid and somerthing else made make_dataobject_reference() is what creates it? dtm: ??? i never saw any of the discussion on the list (im not on phpgw list) he was talking their list we need a collaboration list imho gnue-phpgw@somewhere.whatever dcl-gnue-phpgw, right derek? ;) however first, phpgw needs to implement enough in order to collaborate and afaik they haven't done much with xml-rpc/soap they should just use GEAS ;) yeah well you should convince them of that ok and you should convince them to seriously objectively consider it if you're going to do a sample implementatoin sample implementation? GEASwork now works now onyl thing needs improving is methods reinhard: yuou here? wtf is a sessionid? sometimes sample implementations are good but they oughtta seriously convey that they'll seriously and objectively consider it chillywilly: yeah but i mean, a sample implementation of phpgw/gnue so I should port their code for them? CORBA_Object make_dataobject_reference (const char *objectclass, const char *objectid, const char *username, const char *sessionid, CORBA_Environment * ev); Action: chillywilly needs to run GEAS and see what it does wrt the oid chillywilly: there is something in the doc/ directory about the different types of references ah oid, corba reference, memory pointer etc I hate those docs though there are like 5 ways to reference an object metoo they need to be organized into something coherent they are just like friggin notes chillywilly: the reason why i rewrote the parser is s/rewrote/started to rewrite/ we have a lot of TODO's for the parser most of them are top priority k and neither neilt nor me dared to touch the current code heheh I thought so because it's coded in a way when you change something you can't know what you break on the other side :) andrewm's code can be scary ick you like flex and bison? yeah ask sabine (my wife) i am addicted to them :) well just as an example lex input file from andrewm has exactly 800 lines (lparser.l) my new version does nearly the same except that it doesn't decide if something is a built-in type or not and it has 265 lines and i think you can't say it has less comments ;) well I am glad someone got into it but you could do me big favour I did not want to learn them :P if you looked at the new code and told me if it is understandable or where it should be explained (= commented) better it looked pretty clean or what could be still improved but I did not try to wrap my head around it ok sorry chillywilly that's my personal illness i don't want things to be good i want them to be perfect er? heheh you are in for some hard times then nothing is perfect ;) somewhere i read a wise word something is perfect when not when there is nothing more to add but when there is nothing more to remove hmmmm which directly relates to 800 lines vs 265 lines :) well if thse 800 lines are more readbale readable even then nothing is left to remove bah ok you win :) ;P um to be fair i have to add that the new lex source doesn't handle includes because the new parser will magically parse the files in the correct order you ever see gcds going xml? say we wanna store thing in the database evertually wouldn't it be nice if all our home grown formats were xml and we had GNUe Intergrator that would pump them intot and extract them form the database? and handle object updates etc? or am I smoking crack? chillywilly: as long as we author gcd's with a text editor and view them with a text editor i don't see them xml and have our own object designer like the forms one well this is my personal view now i am a friend of pure human readable text files xml as data exchange format as I said before on the list xml is not human readable imho xml is readable xml is ok as data exchange format some on now try to write an xml in gcd and give both to somebody derek (derek@cpe-24-221-112-50.az.sprintbbd.net) left irc: Ping timeout for derek[cpe-24-221-112-50.az.sprintbbd.net] and see which file he reads quicker ok but you don't need to read it ubless you want too we should have a nice tool you ever hear of xml-rpc if we _want_ vi/emacs to be our tool to author gcd's we need an easy format it is the same thing...it is just easily parsed and varified derek (derek@cpe-24-221-112-50.az.sprintbbd.net) joined #gnuenterprise. if we want a nice gcd maintaining tool it's no matter any more forms guys had to deal with this too we could store even in database and use no matter what for data exchange but to build up the basic applications i think authoring as text files (not xml but gcd) is better look at the discussions on the supply chain or accounting list dude say I want to add a field to an object I do an xml transform then hand it off to intergrator we exchange parts of gcd files in mails everybody just gets at first sight what we are talking about yes it is very idl-like maybe what we really need to do is implement the ODMG stuff that's where a lot of andrewm's stuff comes form I think liek odl that's an odmg thing soe of the interafces are form that standard too yeah it would be good if it was a free standard ya = you don't need to buy a book dunno why you gotta pay for the stupid thing but in fact not even ANSI C is a free standard :((( you don't have to with CORBA heh well if I bought it could I let you all use it? can't say that i don't know how it would fit us bah, non-free standards suck if i implement a standard i don't want to implement parts of it well i want it 100% or not at all but 100% only if it fits us I think the cool thing is they have solved some of these problems I am nto sure of andrewm was conforming strictly to it probably not he was just hacking away our main problem now is imho that we need to get the code into a maintainable state organizational? yea we shouldn't hav to break client interfaces though should we? we will i talked with neilt lately ack don't say that dtm: will not liek me :P about all that semi implemented stuff oh ok but the DataObject interface like i am now removing from gcd parser you see that changing all that stuff that is not implemented anyway not the DataObject probably but for example the admin interface which is 0% implemented iirc derek (derek@cpe-24-221-112-50.az.sprintbbd.net) left irc: Ping timeout for derek[cpe-24-221-112-50.az.sprintbbd.net] making all biz objects map to CORBA objects i crummy performance right? will result in and we wil probably remove that pseudo security stuff chillywilly: yes although it could be a good thing to have optional someday btu aren't you marshalling a call anyway derek (derek@cpe-24-221-112-50.az.sprintbbd.net) joined #gnuenterprise. even if the interface is the same? chillywilly: sorry i have no experience in corba we would simply have to try of course i would like more to have at the client python program or RTFM a litte more hehe I tried to read the CORBA spec invoice.amount = 100 I fell alseep than obj.setField("amount", "100"); chillywilly: lol this was a while ago not a big difference there anyway only syntactically different I wonder if that is a n ODMG interface blah I dunno...I won't be buying that damn thing anyway not any time soon chillywilly: dont forget to respond to my blather in #phpgroupware when you're done here :) did you knwow that KDE is gonna can their home grown IPC thing and use SOAP? Using XML as an Object Interchange Format Contributed Paper This paper shows how to use XML as an object interchange format. It defines an XML document type, OIFML, and shows how it can be used to specify ODMG objects. from the ODMG site I knew I saw that somewhere see that is how they are doing it :P reinhard: http://www.odmg.org/library/readingroom/oifml.ps they use ODL, OQL, and OIFML so we should do noth actually :P both xml as interchage format odl stays too reinhard: what shoudl I call the scripting plugin thingy? i think it shoudl be in GNUe Common if I can make it generic enough jamest can use it for his triggers too well if you can think of a good acronym