| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> EyeCue know about the table limits what i was asking though?
<1> what do you want to do?
<0> ok create a database for a user and only allow a certain number of tables in it to be created
<1> havent seen that kinda functionality
<1> i spose you could limit it using php
<0> i have
<1> and only allowing them create tables via a php page
<0> hmms
<0> :S
<0> i'll probably have to modify phpmyadmin then
<1> http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/User_resources.html
<0> make custom cl***es for it
<1> dont mind me
<2> select * from Household_Family where Q_No in (Select Q_No from Household_Survey where Family_Religion="Hindu" l);
<2> batman, ?
<0> bleh EyeCue that resource didn't help
<1> yeh i know
<1> i said forget it :)
<0> kanhaiya_kk did you get an error? if so please paste the error
<2> ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Select Q_No from Household_Survey where Family_Religion="Hindu"
<0> kanhaiya_kk please paste your query at pastebin.com and paste the link in here also paste the error in the pastebin
<2> http://rafb.net/paste/results/s9x4Pg47.html
<2> batman,
<2> batman, ping
<0> kanhaiya_kk it says valus with the "IN" operator must be enclosed in single quotes
<0> so try surrounding the delimeter or "nested query" in single quotes
<2> okay...means there is no need of brackets ?
<0> no
<0> you need those
<0> it should look like
<0> select * from Household_Family where Q_No in ('Select Q_No from Household_Survey where Family_Religion="Hindu"');
<3> kanhaiya_kk did that help your issue?
<2> yeah that prob is solved...but ?
<3> kanhaiya_kk yeah?
<2> wh_batman, http://rafb.net/paste/results/KTyhkL19.html
<4> for a before_save method... how do i reference the model object that is about to get saved? (i.e. in the method i call, i need to update an attribute, but what do i use to do this)?
<5> Hi, How can I find which directory that is the data directory?
<5> I am setting up replication
<4> self?
<6> show variables like 'datadir'
<5> and the howto tells me to change to it
<6> eh?
<6> wtf howto are you reading?
<5> http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
<5> gleam_: THat one
<5> change location into the master server's data directory, then execute this command:
<5> shell> tar -cvf /tmp/mysql-snapshot.tar .
<3> kanhaiya_kk i would like to help but its hard for me to help on things like that without being able to test hehe
<5> Like that it says
<6> it means "cd"
<6> oh you sai dchange to it
<6> not change it
<6> nevermind
<5> :)
<6> anyway, show variables like 'datadir'
<5> gleam_: Inside mysql client or what?
<6> sure
<6> or grep your my.cnf for datadir, but that might not return anything
<5> gleam_: I found a dir that hase files named as my databases in mysql might it be that dir /var/lib/mysql
<6> yup
<2> okay wh_batman
<2> so shall i wait ?
<3> just work on it a bit
<3> its probably some stupid mistake
<2> hmmm
<3> EyeCue, do you use a mysql auto backup utility and if so do you use bacula?
<1> nope
<1> i should though
<1> i use a custom mysqldump script myself
<3> know of a good backup utility?
<1> mysqlbackup.sh :D
<2> wh_batman, help ?
<1> its an sf project
<3> trying to think..
<3> mm
<2> hmmm
<3> ok... if i wanted to backup the databases every hour how would i do that?
<3> to where its automatic
<5> How do I start mysqld on ubuntu I did shutit down using mysqladmin -u root shutdown
<5> And when running mysqldump --master-data It wont work
<5> like --master-data swtich dont exsit
<6> are you only using --master-data? no other options? that's not valid
<3> granden, in terminal do sudo /etc/init.d/mysql restart
<6> and start it with /etc/init.d/mysql start
<3> yeah start hehe
<5> gleam_: Ok, but in the howto it dont tell me to use any other option
<3> anyone know of a good auto backup tool for mysql?
<5> it says that mysqldump is a slower way but it works for both MyISAM and InnoDB and Im using both
<5> should I do
<5> mysqldump --maste-data mysql?
<6> mysqldump --all-databases --master-data
<6> add on --opt too
<5> ok
<5> so mysqldump --all-databases --master-data --opt?
<6> sure
<1> i add drop db's as well
<5> EyeCue: Why?
<6> --opt and --all-databases should include that
<6> or just --opt
<5> Will that delete all databases on my master server?
<1> drop when you mysqlimport the dump
<6> it'll delete and then recreate them, i don't see the point
<6> you don't use mysqlimport on dumps
<1> well, all db's will include mysql
<6> granden, ignore :P
<1> so *shrug* i dont like errors on import
<1> :)
<5> EyeCue: Oh, so it is not droping my actual databases just the existing once?
<5> EyeCue: But the howto dont tell me to do that.
<1> well it will add a drop db if it already exists into the sql dump file
<6> granden, just do --all-databases --opt --master-data --single-transaction
<5> gleam_ and EyeCue could you tell me how to procede form step 5?
<5> in this
<5> http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
<1> probably not
<5> When I am using mysqldump instead
<1> ive got no experience with replication
<1> probably best not to :)
<5> ok
<7> whats the simplest way to transform a database into CSV format
<6> make the change to the my.cnf and then skip to step 6
<1> lampo see the fields-terminated-by, and fields-optionally-enclosed-by options
<1> and lines-terminated-by
<1> you want to terminate fields with , optionally enclosed by " and lines terminated by \n
<5> gleam_: Thanks
<5> I got a question again
<5> on step seven
<5> when starting the server
<5> I cant start it
<5> I get like this (making a pastebin to not spam the channel)
<6> use mysqld_safe instead of the rc script
<6> or jus tignore the commands it tells you to add
<6> since you've never setup the slave before
<5> http://pastebin.com/742457
<6> check /var/log/daemon.log for why the error happened
<5> some permission problem with a file
<5> I fixed it :)
<6> good job
<2> wh_batman, ?
<5> MASTER_HOST='master_host_name', can I use ip-number instead of hostname?
<5> gleam_: ?
<1> harcoding ip's **** :~(
<1> ****s
<6> sure
<6> and hardcoding ips is generally fine.
<1> until you upgrade dns :D
<6> huh?
<1> or move a box :D
<6> changing dns won't matter, which is part of the point
<6> furthermore you won't have to hit the name server to lookup the hostname
<1> such is the beauty of caching ns's
Return to
#mysql
or
Go to some related
logs:
vlc div3 decoder module gentoo
gentoo nothing in /boot
#gaim
fatal error -- couldn't initialize XFS library
#perl
kontact 6600 sync
dust2.mine.nu
#physics
need ford speed mostwant
#suse
|
|