| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> i'll pastebin it now
<1> What errors?
<0> You have an error in your SQL syntax near 'collate latin1_general_ci default NULL,
<2> importing to an older version of mysql i bet
<0> here's the code
<0> http://perry.pastebin.com/556400
<0> ugh.
<0> archivist, i thought that might be it
<0> yep. the server uses MySQL 3.23.49
<0> ewww
<3> :)
<2> well you need 4.1 or above for collations
<0> what should i do? just take out all the 'collate' stuff then?
<2> or export using the compatible mode
<0> will it still import my tables properly? (sqlyog must add the collate stuff automatically, because i didn't specify that)
<4> dammit, I really wish the rrd-ruby bindings were up to date...
<0> so, if i get rid of the collate stuff, i should have no errors?
<2> maybe but using the compat mode should be better
<5> is there a way to drop a database without the mysql command ?
<6> looks like debian packages for phpmyadmin don't have a drop button
<5> because i launch the server with "skip-grant-tables" option but the "access denied" remains :(
<6> yep ... was lacking AllowUserDropDatabase set to true in the configuration
<3> muhahaha!
<6> =)
<0> archivist, i can't find a compatibility mode... do you use sqlyog?
<2> no I dont, its part of mysqldump (which sqlyog may be driving for dumps)
<7> i have returned
<2> bounced off the snow
<7> grml
<2> !weather egnx
<8> Current conditions at East Midlands, United Kingdom: It is 6 C (44 F), windspeed is 24.14 km/h, and visibility is 6.44 km. (Information current as of 2006.02.15 1920 UTC).
<2> whats snow look like
<2> If you really want fun Jax try definable parts/items
<7> ah you always have an ace up your sleeve
<7> fill me in
<9> hey
<9> how does one display the current number of connections open?
<9> concurrent connections
<2> you have 1 sales item eg computer, and a table withe the questions in order to get the parts needed to build
<7> so say i make an extra table with product properties, and then another one for the values of the properties, i think that'd work *think*
<7> hm yes
<7> i got another issue though.
<0> if i run mysqldump where does the file get saved?
<7> say i got wines.. which usually only sell as bundles of 6 or 12
<2> some properties are exclusive with each other
<10> NBrepresent: stdout
<7> but then i also sell CPUs, which usually sells only one at a time.
<10> NBrepresent: unless you specify otherwise
<0> k
<7> but then you can also make tasting sets where you can put together 6 bottles, one of each type
<2> send me one of those
<9> I would think SHOW PROCESSLIST, but this doesn't appear to
<7> i'd rather send you the money with a list of which ones, so you cna buy them downtown,.. shipping will kill ;)
<2> hehe
<0> if i'm running mysql on windows, how do i access the command line?
<2> there should be a table that converts qties, 1 case 24 to 4 of case 6 etc
<0> it's as part of a xampp installation
<2> cmd prompt, mysql
<2> or cmd prompt, mysqldump etc
<7> archivist the question is. should i put the product as 1 or 6 in the products table.
<11> you should really be able to refer to an alias later in the select
<7> i'd say 1 is better, because otherwise u'd have to use fractions for quantities
<2> depends on the sales qtys eg you can buy 1 real 500mtrs wire and sell by the mtr
<0> that doesn't work...
<11> !tell NBrepresent about doesn't work
<8> Alrighty.
<7> ok i see another table with possible sale sizes
<0> sorry, it says that it's not a recognized batch file or program
<11> NBrepresent: mysql has to be in your path
<11> or you have to be in the directory where the program is
<0> ok, that should be xampp/mysql right?
<7> bin
<7> xampp/mysql/bin
<0> thanks
<0> now i'm in the right place, but it didn't work (i guess because mysqld was running?)
<11> gotta stop saying it doesn't work
<2> mysqld has to be running
<0> ok
<11> "now i'm in the right place, but this time I got such and such error"
<2> #define right place
<0> access denied using p***word NO
<0> that error
<11> much more useful for us to be able to help you :)
<11> NBrepresent: mysql -uroot -p and hit enter when it prompts for p***word
<11> unless you set a p***word already
<11> in that case enter whatever you set
<0> that gave me a mysql> prompt, and i tried my mysqldump command at that prompt, and an arrow appeared -> , but nothing else happened
<11> ...
<7> mysqldump is not a cmd you run in mysql
<11> you really should read the manual
<7> its a seperate binary in the bin dir
<0> ok, so i should exit after entering the p***word command?
<11> !m NBrepresent mysqldump
<8> NBrepresent: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<4> is it legal to use either () or {} for %x? i.e., %x(ls -l #{filter}) the same as %x{ ls -l #{filter}}
<0> ok, i have the same 'access denied for user ODBC , p***word NO' type message again
<0> after quitting the mysql> prompt
<0> and trying the mysqldump command from the right directory
<2> mysqldump -h and read put the parameters in the correct order
<0> mysqldump --compatible=mysql323 cst_kennedygal
<0> that's what the command is that's generating the same error. what does the -h option do?
<2> help so you can understand
<0> ah, defaults to localhost
<0> is there something wrong with the syntax of the command? it looks to me that i'm doing it right
<1> Compatible for 3.23??? Bad!
<1> What error are you getting?
<0> access denied for user ODBC@localhost using p***word NO
<1> So login
<1> P*** the appropriate login commands
<1> !m NBrepresent mysqldump
<0> from within mysqldump?
<8> NBrepresent: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<2> on the cmd line
<1> Read that. Find out how to specify user names and p***words
<0> ok! it worked
<0> did that output to a file or only to this window?
<12> Hello everyone. Would someone be willing to help me troubleshoot my upgrade to 5.0? It involves PHP on an XP box.
<2> just to the window, mysqldump blah >dumpfile.sql
<0> with the greater-than sign, or was that for emphasis?
<11> it's called a redirect
<11> you're saying whatever comes out of mysqldump > (redirect) to this file
<13> hey. anyone mind lending me a quick hint? how i can make mysql select * from table where `field` LIKE '%foo%' case insensitive?
<14> select * from table where `field` LIKE '%foo%'
<1> Case sensitivity is based on column type.
<11> or table collation
<14> Aww will, you ruined the fun.
<1> heh
<10> arturaz: do you have the option of using fulltext indexes ?
<13> hmm.. i think so ;-)
<10> where field = %foo% -- can't use an index but -- match (field) agains ('foo') does.
<10> it will be a lot faster for you.
<12> Anyone at all? I ran out of stuff to troubleshoot and the forums are stumped.
<15> Howdy
<14> Busy: Better to just ask a question than to ask if you can ask a question.
<12> I'll repeat - Would someone be willing to help me troubleshoot my upgrade to 5.0? It involves PHP on an XP box.
<14> I'll repeat:
<14> Busy: Better to just ask a question than to ask if you can ask a question.
<15> Busy: whats the problem?
<12> Ok, sorry. PHP won't connect to MySQL database. Command prompt works fine
<12> I've extensions are loaded fine, client API is the correct version
<0> shabbs: , archivist, thanks for your help. finally got it imported into 3.23
<1> Busy, Apparently not...
<15> Busy: what error do youget?
<12> Warning: mysqli::mysqli() [function.mysqli]: (HY000/2003): Can't connect to MySQL server on 'localhost' (10061) in ... file ... on line 9
<12> Error: Can't connect to MySQL server on 'localhost' (10061)
<16> alguien que hable espaol
<16> ??
<12> I'm using the current dlls from mysql.com
Return to
#mysql
or
Go to some related
logs:
#linux
map mail.aliases: internal yp server or client error
gentoo nv_sata hardware raid
#linux
#lisp
mdf2bin
uninitialized value in concatenation perl catalyst
php5 php.ini extensions_dir
libdevread3
sources.list universe + wmii
|
|