| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
Comments:
<0> drwx------ 2 mysql mysql 4096 Jan 13 13:26 /var/lib/mysql/pfreeman/
<1> but now u should be able to get ur prob fixed right?`
<0> well, mysqldump should now work, yes.
<1> ok
<2> aquarius: What reasons would you have for not allowing reading the tables? :)
<1> good question.
<0> salle: I can't think of any, but that's why I'm asking you chaps :)
<3> hi... i get a 'Table 'xxxxx' doesn't exist' on query on a slave server. the thing is that the query should not have been p***ed to the slave since this DB is not one of the DB's logged. any ideas?
<1> i can we know?
<4> hi im getting an error when i gunzip a mysql backup into a new machine, the error reads as "ERROR 1062 (23000) at line 23: Duplicate entry '1' for key 1", any ideas?
<5> hi, is there any way to limit numbers of databases for an user?
<1> -i +how
<6> can mysqlhotcopy copy ALL databases without specifically having to have a line for each one?
<1> the_beast: maybe stored procedures can control this.
<1> The_Beast: i mean i think with the help of stored procedures u could realize this. i dont know if there is an easier way.
<1> RichardP: ask the author of mysqlhotcopy
<4> can anyone point me in the right direction?
<1> i can try
<4> well the error im getting is coming about after i did a mysqldump -t, and am trying to gunzip < tables.gz | mysql tablename
<4> talking about some kind of duplicate entry 1 for key 1
<1> tables.gz contains an error
<4> line 23...
<1> mysqldump is not known to me, but ur error tells u what to do.
<1> u have to alter the primary key in ur table
<1> or u find an option of mysqldumb that ignores dublicate entries the one ore the other way
<1> or u delete the data of ur table so that it is empty, if the dublicatet entrie is invokted by a conflict of data in the tabe and data u want to put in
<1> this can happen if u backup ur table
<1> and than try to refiill the data without cleaning the table before u man ur backup copied back
<1> man = make
<4> hmm
<4> off topic, do you know whether or not zencart populates the address_book table at all after setup?
<1> what is zencard?
<1> to answer ur question: no
<4> ok
<0> Cheers for the help, all
<4> thats odd then, it gave that error but still completed the INSERT where the error was occuring
<1> sure
<1> ?
<5> e-PUNK2: thanks
<1> The_Beast: u are wellcome
<7> Is it posible to make rollbacks in mysql?
<1> yes
<7> what is it called? i.e. where should i read to learn how to?
<1> i would say "transaction" is a good key
<1> at mysql docu
<7> do i have to code my application specifik for use with transactions? or can i use regulare mysql applications, shut them down, rollback, and start them again?
<7> nevermind...google answered me
<7> thanks :)
<1> np
<8> Hi all... I have a postgresql database and I want to migrate to mysql... there's a tool that could import my data ? thank you.
<9> I've created a dump of a database using mysqldump, but how can I create a new database and import this dump, so i've got a duplicate?
<10> gday
<9> jo
<11> diederickhuijber: mysqladmin -p create yourdatabase & mysql -p yourdatabase < yourdump.sql
<9> Can you help me with the dump?
<9> also with innodb ?
<11> if its a dump, its a dump, the engine is stated in the create table statement
<11> diederickhuijber: open your dumpfile in any text editor to convince yourself
<12> Hi, I just updated mysql and when attempt to restart it I get: [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ojp1-bin' to avoid this problem. What do I need to correct and where?
<13> is there a way to create a new user and limit that user to a specific table or tables?
<4> how do i get mysqldump to export only table structure, i know -t exports it without structure, data only, but i need structure only, anyone know?
<14> !m nopea grant syntax
<15> nopea: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<14> !m pyre|cipher mysqldump
<15> pyre|cipher: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<14> pyre|cipher: check there for the options
<9> oke thanx!
<4> thanks
<13> can I run GRANT and REVOKE from phpmyadmin - or do I need to login to mysql?
<14> nopea: you can run it as a query, I'm pretty sure pma has a place to run a raw sql query
<13> it does - just wondering if I could run that type of query there
<14> should be able to
<13> lets find out :-)
<16> oh well, how do I know the current database in mysql client?
<17> you should just know :)
<16> eh.. :)
<18> I am having a problem that I believe to be a mysql problem here. I type in the command "mysqladmin -u root myrootp***word p***wordIwanttouse" (This is from a fresh install so I have not actually setup a p***word yet) When I do this, I get an error saying 'Access denied for user 'root'@'localhost' (using p***word: NO) Any ideas as to why I can't get access?
<14> select database(); should return it
<16> shabbs: thanks
<19> BriteLeaf: because you're not using a p***word
<19> BriteLeaf: also, you're using bad syntax
<18> getting the syntax from http://www.siliconvalleyccie.com/linux-adv/mysql.htm#_Toc105342541
<18> I thought the myrootp***word was using the p***word?
<18> myrootp***word btw (in case you didn't get it) is NOT my real p***word :P
<20> !man mysqladmin
<15> (mysqladmin, Administering a MySQL Server) : http://dev.mysql.com/doc/mysql/en/mysqladmin.html
<11> BriteLeaf: what you didn't get is that 'p***word' should be written litterally (it's the command you send to mysqladmin): mysqladmin -u root p***word hzuakjhfoieuzq
<21> BriteLeaf: mysqladmin --hlep
<21> s/hlep/help/
<18> oh
<18> well... that WOULD make the difference then, wouldn't it? lol
<18> thanks
<22> hi good morning to all
<22> i need some help
<22> how i can change mysql db username and p***word?
<23> Who's your host?
<22> 201.205.56.46 my computer
<23> oh I see
<22> can you help me?
<20> !m Keysmaker securing
<15> Keysmaker: (Securing the Initial MySQL Accounts) : http://dev.mysql.com/doc/mysql/en/Default_privileges.html
<20> !m Keysmaker grant
<15> Keysmaker: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<20> !m Keysmaker adding users
<15> Keysmaker: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<22> oo thanks
<22> im going to read that
<24> anyone familiar with using the Mysql connector .net ?
<22> finally!!!!!1
<22> i made it!
<22> i love my sql!!!
<19> what about our SQL?
<25> what causes the line "Init DB <db_name>" to show up in the logs? I seem to be getting it after every query instead of once per session ...
<21> mavis: each query you run needs to be ran against a particular schema
<21> mavis: the Init DB would the same as you type "use mysql" from the CLI tool.
<26> hi, I'm looking to do some billing from mysql stored data, and need to pull out whatever row's at 95% way through a bunch of ordered data? any suggestions?
<27> i have made mysql dump of a mediawiki. how can i import the db dump in mysql?
<14> biw: find out how many rows are in the table (count(*) will usually do) then take 95% of that and do a ceil on it, that's your row at 95% (unless I need more coffee)
<28> Ok, so here's a question: When I issue a select (this one takes a while to run) does mysql lock the table preventing other queries upon it? (MyISAM)
<25> RainMkr: ok, thanks!
<26> shabbs: I don't suppose I can do it in one mysql query?
<14> no, but you might be able to do it in a stored procedure (version 5.0 and up)
<29> biw - you can also do it without analyzing return values in two queries using variables
<29> if you just want to keep your codebase clean
<26> hmm
<26> I'd prefer to do it all in mysql if possible, otherwise I'd be reading the whole dataset into a php structure and doing stuff on it till I'm left with 1 value
<19> madsara: it only locks against writes
<19> madsara: you can have multiple concurrent reads
<26> there's per 5 minute samples over whatever timespan I'm interested in that it'll be performing the calculations on
<28> That's what I thought, but why then would in the processlist the LONGEST running process be a SELECT which seems to be locking all access to that table.
<28> ?
<19> madsara: it shouldn't lock all access, only prevent writes
<19> madsara: try doing SELECT COUNT(*) FROM table; and see if it works
<28> Then I read: A client issues a SELECT that takes a long time to run, Another client then issues an UPDATE on the same table. Another client then issues an UPDATE on the same table. This client waits until the SELECT is finished., *
<28> Another client issues another SELECT statement on the same table. Because UPDATE has higher priority than SELECT, this SELECT waits for the UPDATE to finish, and for the first SELECT to finish.
<19> nod
<30> I can't quite wrap my head around how to do this. I have a PHP array of some values (email addresses), and I want to make a MySQL query that checks them against an email field in a table, then returns whether they exist there or not.
<30> I could loop and check each one individually, but is there a way to do it all with just one MySQL query?
<14> ^Migs^: generate a query string in php by stringing together the values, either as OR emailfield = 'email1' OR ... or with emailfield IN ('email1', 'email2'...) etc
<30> oh
<30> that was obvious
<30> hehe, thanks
<31> where is the my.cnf file documented? I'm trying to set defaults for the clients
<24> wtf... why is it that with mysql connector .net, if i execute a query, and am looping through results with a datareader, i'm unable to do an ExecuteNonQuery with a different prepared statement?
<24> it tells me i have to close the datareader before i can execute the nonquery ... how do i get around this?
<19> fetch all the results from the datareader into a local variable, then close the data reader and execute your non-query
<24> ok, so put it all into some sort of collection and then loop through it again?
<24> that seems dumb
<14> or use another connection
<24> what would you recommend?
<19> two connections wastes resources on the server; a local collection wastes resources on the client
Return to
#mysql
or
Go to some related
logs:
#debian
gentoo genkernel 4Gig
#math
#css
#ubuntu
javascript eval associative array
gentoo shift-f12
wizzomafizzo
perl mysql injection prevent
#lisp
|
|