#mysql
12 October 2007
Total 26 pages. You are browsing page 5/26.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
03:19 <****> I have been trying to setup replicatiion and I cant get it working
03:19 <****> read the howto again
03:19 <****> I have several times I need help
03:20 <****> everything in there is done - the problem is that the changes are not coming over to the slave db
03:21 <****> if i just do this : date_format( now(), '%Y'); i get an error
03:21 <****> in sql syntax
03:22 <****> tibyke: I need some pointers something that would help me figure out what I am missing
03:22 <****> !man date_format
03:22 <****> (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
03:22 <****> someone can show me how to declare and set a variable!!!
03:23 <****> please é_è
03:23 <****> wanderingii: What does the error say?
03:23 <****> Look there in your query
03:23 <****> is there a performance difference between different varbinary sizes? eg varbinary(5) and varbinary(10)
03:24 <****> SQL where is the error here Declare x int ;
03:24 <****> set x=10;
03:24 <****> select x as nombre;
03:24 <****> Are there different versions of mysql.h depending on whether I include devel stuff?
03:24 <****> merde
03:25 <****> sorry
03:25 <****> I installed mysql via MacPorts... and a file that compiles fine when I install mysql-devel does not compile
03:25 <****> and it will never compile !!!!
03:26 <****> I WAS MISSING THE SELECT
03:26 <****> *sigh*
03:26 <****> wanderingii good
03:26 <****> witch17: :P
03:29 <****> wycats I'm sorry..I hate this mysql
03:29 <****> lol
03:29 <****> huhu
03:29 <****> yeah... it needed to be compiled against mysql5-devel
03:29 <****> fuck
03:29 <****> I'm really nervous
03:29 <****> what?
03:29 <****> what version are you using?
03:29 <****> 5?
03:29 <****> me too
03:29 <****> this Declare x int ;
03:29 <****> set x=10;
03:29 <****> select x as nombre;
03:29 <****> how do i do the time without seconds?
03:29 <****> doesn't work!!
03:29 <****> whyyyyyyyyyyyyyyyy?
03:30 <****> what's the command for mysql daemon?
03:30 <****> mysqld doesn't seem to be around
03:31 <****> /etc/init.d/mysql* (something)
03:31 <****> ok I need to ask some questions on this database replication
03:31 <****> mysqld_safe is the angel script. mysqld is the daemon and often resides in /usr/sbin or under /usr/local/mysql somewhere depending on your install
03:32 <****> I'm on osx
03:32 <****> I have a server that has several databases on it and two other smaller servers that have different stuff on them
03:32 <****> wycats_: ah. depends on your isntall still. it should be installed as a service that gets automatically started.
03:32 <****> arjenAU: neither of those are on my system
03:32 <****> I want to have a database (one out of several) replicated across more then one system
03:32 <****> is that possible? or do I have to have all of the databases on each server
03:33 <****> wycats_: unless it's OSX Server, MySQL is not on OSX by default. you need to download it from mysql.com or dorsalsource.org
03:33 <****> can someone explain how I can get my database to display 1.99 instead of 1.9 i made the field a float
03:33 <****> but not sure why it wont display the other 9
03:33 <****> kur1j: because a float is a float. it's not precise.
03:33 <****> I really need some help here
03:33 <****> arjen: I installed the mysql port
03:33 <****> is there anyone that can explain this
03:33 <****> well what do i need to do?
03:33 <****> I am a newbie - this is something new that I am trying
03:33 <****> wycats_: ah! well, the port gives instructions on what to setup along the way. you may have missed that. redo the install and read ;-)
03:34 <****> anyone ?
03:34 <****> SiliconG: mysql.com/replication. yes you can do these things, but I dno't have time for details right nwo worry
03:34 <****> sorry even
03:34 * arjenAU has to run now
03:34 <****> kur1j: Try using an exact type.
03:35 <****> arjen: :)
03:35 <****> can i disable indexing when writing and later run a tool to reindex the table?
03:35 <****> hmm my querys are just returning null values, and i think it might be to do with the format im using to display the minutes, my current data is hh:mm pm/am and the format %r displays hh:mm:ss am/pm
03:36 <****> arjen: do you know the difference between MySQL-devel and MySQL for someone installing on regular *NIX box
03:36 <****> is there anyone out there that can help me debug my efforts setting up replication
03:36 <****> I have followed the manual and it is not working
03:36 <****> I need help
03:36 <****> come on - I am a newbie there have to be some masters out there in a sharing mood
03:39 <****> what is happening is the slave is listening ( I think ) but the changes are not being sent
03:39 <****> I dont know how to figure this out I need help
03:41 <****> I am getting an error when I try to "Load Data From Master"
03:41 <****> the error is ERROR 1219 (HY000): Error running query on master: Access denied; you need the RELOAD privilege for this operation
03:41 <****> The problem isn't obvious?
03:41 <****> You should not use LOAD DATA FROM MASTER anyways
03:41 <****> ok
03:41 <****> (per the documentation)
03:42 <****> well I imported the data using dump but nothing is working
03:42 <****> bye all
03:42 <****> please help me out seekwill
03:42 <****> I am stuck and frustrated
03:42 <****> Then stop and take a break.
03:42 <****> come on - help me out - I cant walk away now
03:43 <****> Sure you can
03:43 <****> please help me out
03:43 <****> If I'm doing this: UPDATE people SET original_id = (SELECT id FROM originals WHERE INSANE JOIN HERE)
03:43 <****> Begging is going to help
03:43 <****> fowlduck: UPDATE supports joins natively...
03:44 <****> ?
03:44 <****> !m fowlduck update syn
03:44 <****> fowlduck: (UPDATE Syntax) : http://dev.mysql.com/doc/mysql/en/update.html
03:44 <****> wanderingii: I'm back... still having trouble?
03:44 <****> seekwill - you seem to know this stuff help me
Total 26 pages. You are browsing page 5/26.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last