| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> salah> Can anybody please help me take a backup? I would be very thankful if I got any help
<1> flooding ftw
<0> shabbs, my windows is useless
<2> if an application is based on a number of simple queries, is it wise to move the database into a separated host? Or the cost of the networking layer instead of a unix domain socket will make things worse?
<0> nathe, sorry
<2> s/things/thinks
<3> nvm bout my problem i worked it out myself
<4> antirez - it's generally better to have a dedicated database machine, if you can
<0> shabbs, I am getting an error which don't let me access my windows, so I don't have any GUI
<2> sjrussel, ok thank you... so the next question follows :)
<5> salah: sounds like you're SOL. get a win09 bootdisk and get into dos
<2> having a dedicated host, I may like to have N dedicated hosts
<5> err win98
<2> but my application need that after a write is performed, the read will be visible the next query, so all the hosts should be in sync
<0> shabbs, ok, any idea where to get one?
<2> what's the best solution to reach this?
<4> well, if you have 1 database machine, it's in sync
<2> sjrussel, sure, but if I've N?
<5> salah: no idea, check google. you could also try repairing the windows install with your windows CD
<4> not unless you use NDB
<0> shabbs, there is no possibility for that. So I tried this: http://www.techspot.com/vb/topic41200.html and some others, still no luck
<6> someones gotta be able to help me here: throw me a bone at least
<4> !man antirez NDB
<7> Nothing found.
<4> !man antirez engine
<7> Nothing found.
<6> c'mon guys why isn't this darn FULLTEXT search working?
<4> !google site:dev.mysql.com engine NDB
<7> site:dev.mysql.com engine NDB: http://dev.mysql.com/doc/mysql/en/MySQL_Cluster_Overview.html
<5> salah: then get a 2nd hard drive if you don't have one, put it in, boot into win98, copy out the mysql datadir to the other drive and reformat/reinstall windows
<2> lo, I found Nucleid Acid in Google :)
<5> salah: once you're back up, install mysql and copy the datadir back
<2> thank you very much sjrussel
<4> EagertoLearn - we don't know what the issue is
<0> okey, so then I can just install MySQL, and copy the old files into the C:\Program Files\MySQL directory and log in as usual?
<5> salah: that'd be the idea. make sure you copy any config files (ini) that maybe in other directories
<5> salah: and that you install everything the same way again
<0> okey, I will try that. thanks for the help
<2> ok, NDB is exactly what I was looking for
<0> should I also try to copy the registry?
<6> OK I FIGURED OUT WHY IT WASN't WORKING!!!!!
<6> does anyone care to learn ????
<2> EagertoLearn, sure
<6> i had the 'BUGS BUNNY' stored as 'BUGS_BUNNY________'
<6> (old thing where it puts underscores instead of spaces- replacing with spaces fixed it)
<2> oh yeah
<6> so search for 'bunny' will return if name is 'BUGS BUNNY' but not if 'BUGS_BUNNY______'
<6> any ideas how to solve this problem? i would prefer to keep underscores in
<4> wth did you have it stored like that?
<4> why?
<8> EagertoLearn: _ is not word delimiter
<6> because
<9> store in two forms space separated and _
<6> if customers enter the ' char it crashes the db
<8> EagertoLearn: Because it is not defined as such
<6> so we convert ' into >> and <space> into _
<6> so i can't make it use _ as a word delimiter?
<5> EagertoLearn: why not just escape the charaters?
<2> time to go for me, see you soon. And thanks for the help.
<9> learn mysql_escape_string
<6> oh that will deal with invalid chars like ' for me?
<5> yeah, you're not the only one that had to insert ' into a database field
<4> you seriously convert ' to >>?
<6> ok what does it convert the ' into????
<4> escaping issues explain ' but why space to _?
<5> EagertoLearn: it doesn't convert it, it escapes it so that it can be properly inserted
<10> does someone have a link to escape sequences for mysql queries?
<11> hi
<4> b1n0ry
<11> how can i do to repair a data base?
<4> use ' => \' is all you really nead
<6> not sure our software has always been that way
<12> hello
<11> i know "repair table "name"", but i need repair so much tables
<10> sjrussel: i.e. if i want to insert a string that contains a ' i use 'Chris\' insert'
<6> can't understand the the space --> _ either come to think of it
<11> how can i do?
<6> but its screwing up our fulltext searches now
<4> right
<12> i have difficulties running default mysql installation
<12> on slackware 10.1
<6> so is the only character i need to worry about is '?????
<5> valtovar: loop through the tables in the database with a script
<6> is that the only one that will bring down my database and reduce it to rubble?
<12> where can i post a log
<12> ?
<4> aha, it's Institutional Stupidity, not Personal Stupidity then...
<10> sjrussel: problem is if i convert all instances of ' to \' and someone actually enters \' then i get \\' and the \ is escaped instead of the ' (if \\ is a valid escape sequence in mysql)
<4> b1n0ry - taht's why people write libraries
<10> which is what i'm doing
<6> sjrussel is ' the only character that i need to worry about anyway?
<4> see your api, what ever language
<4> b1n0ry - your api will do that for you
<10> sjrussel: i'm writing the api
<13> what's the best way to dump a database considering that i have tables & fields that use reserved words?
<4> for a languate youdeveloped yourself?
<5> EagertoLearn: no, normally you also worry about "
<6> single and double quotes?
<12> anyone willing to help ?
<6> i guess there is no reason to conver <space> into ---> _ this, is there?
<5> EagertoLearn: and a few other things. but if you use the api escape function it'll take care of it for you
<5> EagertoLearn: no, there isn't
<10> sjrussel: no, but existing api's use too much memory. i'm using php. PEAR::DB uses about 300k just by including it and creating an object. ADOdb isn't much better.
<6> is api escape a windows API?
<5> EagertoLearn: what language are you using to access mysql?
<4> b1n0ry - that's several api's but you should ust use mysql_real_escape_string if you're using the standard mysql api
<6> VB
<6> but yes we can use API's in VB
<10> that'll work
<5> EagertoLearn: as sjrussel said its' part of the mysql API (C) so it should be available through VB
<6> interesting so i download and install the mysql API library or something like and access it in VB essentially? (i'll go read to learn further)
<6> but that's the basic idea?
<4> uhh, no
<6> :/
<4> you are probably already using it
<6> or is the mysql API already on this computer since it is running a mysql SERVER
<10> EagertoLearn: there are dll files that you can register in windows with regsvr32. then you can include them as references in your vb project.
<6> ahhhh ok
<6> been there done that b4
<4> eagertolearn - if you can connect to mysql in VB, you have the standard api already
<4> client, NOT server
<6> ok so someone just explain what exactly does this magical API do to say, for example, 'Don's House' ---> what does it store?
<10> EagertoLearn: i've also had success using MyODBC and the standard MS ODBC object
<14> Don\'s House IIRC
<6> you mean Don\s House
<4> no, it stores Don's House
<4> no
<6> hrm
<6> how can it
<4> it only has to get past the parser
<6> that would crash the query
<6> INsert into customers (Name, Addy) Values ('don's house', '123') :::: CRASHES
<14> ok, I shut up for now and let the pros talk :D
<4> I think this explanation is to complicated for you now, Eager.. just try it
<14> INsert into customers (Name, Addy) Values ('don\'s house', '123')
<4> ndee - you're right about what the query looks like
<14> ok
<14> got a little bit confused ;)
<4> I don't think that's what the database stores though
<6> ok so basically "insert into customers (NAME, Addy) Values (API(this_string), '123') will work?
<6> with this_string = 'don's house'
<15> hi guys, anyone use cocoa mysql
<6> ok last time i ask: no way to make FULLTEXTSEARCH use _ for a word delimiter rather than <space>?
<4> you could recompile mysql
<6> :(
<6> ok thanks for all the help guys - i guess there is no rational reason to convert spaces into _'s -- that's just plain stupid
Return to
#mysql
or
Go to some related
logs:
#web
ati x1100 slow ubuntu
#math
8mb in kb
#perl
grub-install repair suse chroot
#linux
qtparted no device found
apptitude kubuntu desktop
Xlib: connection to :0.0 refused by server osd_cat
|
|