| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> s/whacks/quacks/g
<1> Nuxi: what version are you running?
<2> My knowledge about sql syntaxs is very small
<0> will[werk]: YES, YOU TOO!!!!!
<3> Quak Quak Quak
<4> How do i delete a database, or rather delete every database to start fresh
<3> Drop your DB
<3> What's with all the deleting today?
<1> we hate data today
<0> no kidding
<4> postfixadmin wasnt my friend =(
<3> Delete it!
<0> NOW!
<2> Thanks guys, now to another question I would like to put this in a cron job, how would I do then, because the admin account uses a p***word.
<5> lilo?
<5> oops
<0> granden: put the p***word in ~/.my.cnf and run the sql with mysql -e
<6> drop table onToes;
<0> granden: errr, mysqldump :)
<2> inviso: mysqldump you mean?
<2> good got a bit scared that it wouldnt work with mysqldump :)
<2> inviso: I got a 2 lines paste to make, can I do it in the channel or do I need to pastebin it?
<0> here is fine
<4> I need to know a way to remove and purge all databases and tables in mysql to start fresh is there a way?
<2> error: Found option without preceding group in config file: /root/.my.cnf at line: 1
<2> Fatal error in defaults handling. Program aborted
<2> I get that when running
<2> mysqldump --all-databases > backup-home.sql -u admin -e > backup-home.sql
<2> thot
<2> wow that is completly wrong I see know :)
<2> now*
<7> shabbs, version 4.0.25
<2> mysqldump --all-databases > backup-home.sql -u admin -e
<1> hrm
<2> That i mean
<0> Aeudian: drop database should work fine
<1> well I won't state the obvious :D
<4> inviso: im no where near expert, so im not sure what drop database is
<0> !m Aeudian drop database
<8> Aeudian: (DROP DATABASE Syntax) : http://dev.mysql.com/doc/mysql/en/DROP_DATABASE.html
<9> !man drop
<8> (DROP PROCEDURE and DROP FUNCTION) : http://dev.mysql.com/doc/mysql/en/DROP_PROCEDURE.html
<0> archivist: laaazzy :)
<2> inviso: should I do something more then just add p***word to the first line in /root/.my.cnf ?
<9> hehe
<0> granden: yep
<0> granden: it needs to be setup correctly
<2> inviso: What?
<0> !m granden my.cnf
<8> granden: (Using Option Files) : http://dev.mysql.com/doc/mysql/en/Option_files.html
<2> thanks
<4> inviso: so if i do drop database *; would it do all databases?
<0> Aeudian: nope
<9> Aeudian, that would be stupid, you dont want to kill your user database
<4> archivist: yea but i have a file that was entering into mysql that now stops half way through with duplicate errors
<2> inviso: Thank you very much
<2> I cant thank you enough
<4> archivist: and by no means am i an expect to know what database and files i need to remove
<0> granden: np, enjoy
<4> hmm maybe i im doing something else wrong, "mysql -u root -pp***word < DATABASE_MYSQL.TXT" would build the mysql information inside the file to the sql server right?
<10> you need to specify a database
<10> after -pp***word
<1> unless it's in the file
<4> i think the file does
<2> So for restoring a backup could I do mysql -u admin -e < mysql-dumped-file.sql?
<10> how about you look at the file and see if it is specified
<0> granden: ***uming there are truncates or drops in the scripts to clear the old stuff out first, yes
<11> "SELECT fname, lname, company, address, address2, city, state, zip, country, phone, payid, ccexp, ccname, bankname, bankphone, email FROM user_public_data LEFT JOIN user_auth_data ON user_public_data.email = user_auth_data.user_key WHERE user_public_data.email = 'drew@goy.com'" any reason you can think of why im not getting the join data?
<10> no need for -e, granden. That would restore tables in the 'admin' database
<2> ok
<12> What's the name of the function that does this IF(blah = null) then MYVALUE else blah
<2> but I am using a .my.cnf file
<10> ok
<10> so am i
<2> dan__t: No need for -e anyway?
<11> nm i got it thanks
<9> !m Sembiance if
<8> Sembiance: (Control Flow Functions) : http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html
<13> is it possible (or wise) to select tables from another database (from within php); i'd need to do this to join user data from another table to the userid of the article database
<1> Sembiance: IFNULL(testfield, falsevalue)
<10> I don't know why you'd think using my.cnf would make a difference, granden
<10> it makes no difference ;)
<1> !m newpers join syntax
<8> newpers: (JOIN Syntax) : http://dev.mysql.com/doc/mysql/en/JOIN.html
<2> inviso: Why did you tell me to use -e ?
<2> What does that do
<12> shabbs: thanks
<0> granden: that was for mysql. -e for mysqldump is probably not a bad idea either
<0> !m granden mysqldump
<8> granden: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<10> granden, mysql --help --verbose
<13> shabbs: i don't see where it says how to specify a database name
<2> ah I see
<2> !m granden mysql
<8> granden: (mysql, the Command-Line Tool) : http://dev.mysql.com/doc/mysql/en/mysql.html
<13> SELECT * FROM db1.table1 FROM LEFT JOIN db2.table1 ON db1.table1.id = db2.table1.id WHERE....
<13> woudl that be right?
<2> oh -e in mysqldump is not the same as in mysql :)
<13> i don't think that would work
<0> granden: not at all
<2> I saw that checked both manual and compared :D
<2> Sorry to ask in this channel but you been really helpful, any of you have experience with PostgreSQL, and know how I do the same task there dump the databases and restore them easy?
<5> #postgres
<5> ql;
<5> gr
<0> lol
<1> newpers: tias
<14> inviso, you told me sth about Left join .I read the manual and i dont see how can this create a new row if the row i search for doesnt exist
<0> psofa: Create a new row with what data?
<13> tias?
<0> !tell us about tias
<9> Try It And See
<8> inviso asked me to tell you this: TIAS: Try It And See. You look silly asking if something will work when you can just try it and see. This channel is not a MySQL server ;-)
<2> inviso: I did create a file called .my.cnf in the homedir on the server now but now I get mysqldump: Got error: 1045: Access denied for user 'sysadmin'@'localhost' (using p***word: NO) when trying to connect
<2> like it could not find my p***word
<14> the new row would have a mplexid of maxmplexid+1 and frequency the frequncy i was looking for
<0> granden: did you put it under [client]?
<2> yes
<2> I only got [client]
<15> [client] \n p***word=p***wordherenoquotes
<2> p***word="p***word"
<15> no quotes
<16> hello, i just updated from 4.0 to 4.1, all is good, only that i have a database that had some hebrew in it, and now its in "latin1_swedish_ci" Collation and it shows question marks and wierd things, how could i change the Collation for all the database?
<2> I got qutes on this machine
<15> although that still shouldn't cause the error you got
<0> granden: p***=, not p***word=
<14> inviso, ?
<2> inviso: I got p***word= from he mysql page
<15> no, it's p***word=
<2> lol it is good Im logged in as root when I put it in roots homedir :)
<2> Sorry to bothering you guys
<0> psofa: what will the "new row" look like?
<14> inviso, i just answered a few lines ago :)
<0> psofa: hehe, I'm blind :)
<17> help I can't seem to change the vale of max_join_size.
<17> I entered into /etc/my.conf
<17> restarted mysqld
<17> but it *never* changes. I've been able to change max_allowed_packet with no problem.
<0> psofa: Are you issuing an insert select for each freqid?
<3> kaljfsd;
<3> Sorry, wrong window.
<5> will obviously meant to type that into #foquyd
<3> Uh.. yeah!
<14> inviso, nm i think ill use NON EXISTS
<0> psofa: If so, you'll have to do it a bit different than I was expecting. I suppose you could UNION with a row that has what you need and LIMIT 1 on the results of the union
Return to
#mysql
or
Go to some related
logs:
#fedora
#sed
qtorrent gentoo qsizepolicy
#perl
#math
Support for SATA (deprecated; conflicts with libata SATA driv
evms2 reiser4
#lisp
nvidia nfore linux x86_64
#suse
|
|