| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Comments:
<0> My msqldump command is /usr/bin/mysqldump --opt -Q -uroot -pfoo --databases dbname > dump_file but it does not appear to add CREATE DATABASE statements in the dump file.
<0> Any ideas why?
<1> jsoft: Use -D
<1> jsoft: Sorry. It's -B, --databases
<2> If I have a where statement with several ORs is there a way to sort by which results applied to the most number of those ORs?
<0> salle: ok.. but isnt that just the same?
<3> hm how would you guys store currency values.. i guess you have to define one curreny as the curreny which is 1.00 or ?
<0> no that did not work.
<1> crzygrndpa: You have to duplicate that logic in some expression in SELECT part
<3> then do all calculations according to that one?
<1> jsoft: CREATE DATABASE is generated only if you use --databases or --all-databases option
<2> salle: is it similar to the SCORE option for fulltext?
<0> salle: I AM using those options, gees
<0> look above!
<1> jsoft: Then you have to have -n to suppress CREATE DATABASE
<4> anyone ever have a problem with your computer rebooting whenever you make a syntax error in mySQL?
<5> Jax you may need to account for currency conversion costs/errors
<0> salle: what? I Dont have an -n in there... look at the command line above...
<3> archivist well my first problem is this one: say i enter products in either EUR or USD. how can i convert one to the other, etc
<3> (expandable to n currencies)
<3> i'd have to store the conversion rate from every curreny to every other currency
<3> except if i use some reference currency
<5> and keep it up to date see oscommerce
<3> nah that's not important
<3> so do you just say USD is reference for example
<3> then store the conversion rates according to USD
<3> yeah i gues that makes sense
<6> i might keep a more stable currency than the usd as my reference :)
<6> i mean if your native currency is usd, go ahead
<0> Can anyone help me with my mysqldump problem. my mysqldump command is this: /usr/bin/mysqldump --opt -Q -uroot -pfoo --databases dbname > dump_file but it DOES NOT add CREATE DATABASE statements to the dump files.
<3> nah i think i'll pick Euro
<7> quick mysql/php question - Is using PEAR recommended or not?
<3> or swiss francs is native and quite stable ;)
<6> hehe
<3> anyway, doesn't matter, can always change
<0> damn it :(
<0> mysqldump is not behaving as advertised.
<5> Jax accountants my stab you if you get your currency calcs wrong
<5> my=may
<3> well
<5> taxman is worse though
<3> well, how do you account for currency loss?
<3> say i know the product's EUR price. and am displaying in CHF
<3> and the current rate from EUR to CHF is 1.5
<3> so say product costs 10 EUR, so it will cost 15 CHF
<5> see if you have any local rules
<3> what do i add now? :D
<3> i don't think we have to look for currency errors, because we enter the current euro course ourselves
<3> and EUR -> CHF is always like 1.5X
<3> i think we changed the course like once last year
<5> yes but the tax element of the conversion can affect what the taxman gets hence over here I would read the VAT guidlines
<5> which is likely to change very soon as a lot of vat avoidance is currently done that way (news paper article noted today)
<3> hm i'm just thinking if we can even allow clients to pay in EUR
<3> don't think so. we just buy the products in Euro, and sell them for CHF
<3> to people who only pay in CHF
<8> Hi Guys, having some trouble with ON DUPLICATE KEY UPDATE. How does one use it?
<3> so the sales price includes VAT already i think
<3> !man ON DUPLICATE KEY
<9> (INSERT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT.html
<3> http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
<3> that will help you the 2nd one
<5> Jax currently export has NO VAT in europe but likely/will be changing
<5> for inter europe transactions vat number must be recorded to be vat free
<3> we have a vat number
<5> vat69
<5> sherry iirc
<3> scotch whiskey iirc
<10> if i make a query like "SELECT * FROM images" to mysql. can i then later select a specific row by the id.. without having to do "SELECT * FROM images WHERE id = '$id'" ?
<3> flam you sure you want to do that?
<8> Guys, I looked at those pages, and I think my syntax is right could you look at this paste and tell me? http://sial.org/pbot/17410
<11> that's has potential to be very slow
<6> tt, select version()
<10> Jax: if i don't do it "my" way i have to make a mysql-query inside every loop. and that can't be nice for preformance?
<11> sure it can
<3> tt what version of mysql?
<5> flam youve got to do some thinking
<8> 2 secs
<8> 4.026
<8> *4.0.26
<6> that's why
<5> flam what happens when you have 100000 images
<6> can't use "on duplicat ekey update" until 4.1
<3> gleam_ damn it.. where do you know that from? it doesn't say in the docs >;/
<6> yes it does
<3> one thing i'd improve in mysql docs. every function with version
<10> archivist: well, might be better to do the mysql query in every loop :P i'll do that then
<6> http://dev.mysql.com/doc/refman/4.1/en/insert-on-duplicate.html
<3> http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
<5> flam get a range maybe
<3> doesn't say there anymore gleam_ >;/
<6> yeah, 5.0 doesn't mention things that changed in 4.1
<6> and 5.1 doesn't mention things that changed in 5.0
<6> yell at hillyer
<3> there should be a brief outline to every function, with exactly that information
<10> archivist: no, that wont work in my case. but hey, thanks for getting me to think :)
<3> with "first appearance" and "revisions"
<3> when functionality changes
<3> that would be VERY useful
<12> hello
<8> So how do I get around this, or can I?
<3> tt upgrade mysql if you can.
<12> how is the mysql5 backward compatibility?
<3> thomasje in what sense? you just can't have triggers / views and some other things
<3> otherwise most is backwards compatible, i'd say.
<12> oh oki :)
<12> yeah i want to install mysql5 to toy around with triggers and such
<13> will mysql perform much better with 2xcpu than with one ?
<3> will you perform much better with 2 brains than one?
<8> Can't upgrade, server is provided by ISP
<3> tt write the admin an e-mail with reasons why they need to upgrade. they should do it.
<14> how can I drop all my databases?
<3> Super-Fly you don't want to drop the mysql database :D
<3> or?
<14> well
<14> I can
<8> I'll try that, but in the short term is there any similar function in 4.0.26?
<14> doesn't matter
<14> gonna import a dump from somewhere else
<3> probly won't be able to login anymore though....
<14> see, I did source file.sql from the mysql command line stuff
<14> and it didn't import everything
<14> like any of my primary key's =\
<3> fun
<3> doesn't the file.sql have DROP TABLE IF EXISTS etc?
<14> nope
<3> that's fun ;)
<14> CREATE TABLE IF NOT EXISTS
<14> =\
<0> What is a way to quickly tell if a database exists or not?
<0> like, from the command line...
<3> jsoft something like...
<0> im writing a script to backup mysql databases, and previously I was looking in /var/lib/mysql/dbname for the right files... but now that I have moved my scripts to a non-root user I cant do that.
<3> mysql -u root -p -s -e 'SHOW DATABASES' | grep your_db | wc -l
<0> Jax: that is a sneaky plan
<0> :D
<3> you can provide the p***word in either ~/.my.cnf or in a temp file
<0> Ok cool, thanks
<3> or just directly do mysql -u root -pYourP*** -s -e 'SHOW DATABASES' | grep your_db | wc -l if you're not paranoid
<3> ;)
<13> Jax: ill take that as a yes
<3> Lrd_Matrx sorry, what?
<3> ah sorry, yes probly, if setup right
<13> <3> will you perform much better with 2 brains than one?
<13> Jax: if setup right ? =)
<3> well performance isn't only CPU dependant
<13> i've got the choice between a 2G memory 1x cpu / 2x cpu to use for mysql
<15> Well if you can have 2 as easily as one take 2.
<5> mysql is threaded so should use both cpus
<13> will mysql benfit alot from having 4G of memory ?
<16> Lrd_Matrx: if your database is of sufficient size. yes.
Return to
#mysql
or
Go to some related
logs:
fedora automount execute fstab memory stick
#linux
gentoo hda: dma_timer_expiry: dma status == 0xff
#math
file size limit exceeded unrar
tuxfamily gpkey
gentoo WARNING: Error inserting ath_rate_sample
#python
#mysql
#dns
|
|