| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Comments:
<tamp4x> how can i view what machines are connected to my mysql db
<Daveman> Hi Darien
<bobfield> tamp4x, show processlist
<lsmith> arjenAU: can you prevent users from messing with the sql_mode setting?
<lsmith> anyone else is free to answer this as well :-)
<bobfield> Do you mean globally or per client?
<lsmith> per client .. the point being to prevent stuff like ALLOW_INVALID_DATES
<lsmith> it seems globally is handled by super privileges
<lsmith> but you can overwrite that in your session
<rusty-> Guys: 145 table on my database is latin collation
<bobfield> that's what I'm coming up with as well
<rusty-> how do I change all these tables into another collation / charset ?
<lsmith> which ****s
<rusty-> using phpmyadmin or mysql prompt
<rusty-> Anybody can help ?
<lsmith> hmm .. i should test this and file a bug report of needed
<rusty-> Guys: how do I load a database.sql file with utf-8 charset ?
<arjenAU> lsmith: with their own connection settings? why?
<lsmith> because you want data consistency
<lsmith> and you dont want a user to be messing with that
<rusty-> Guys: how do I load a database.sql file with utf-8 charset ?
<arjenAU> lsmith: hmm. make it a bug report.
<lsmith> it seems you cannot disable this for timestamp columns .. so i guess migrating to timestamp is one approach
<bobfield> rusty-, was it dumped from utf8 data?
<lsmith> i havent tested this .. but the docs say its this way
<lsmith> i found http://bugs.mysql.com/bug.php?id=14799
<lsmith> which led to another doc fix
<lsmith> ok will file it .. its either a doc bug or a feature request :-)
<rusty-> bobfield, I load it before & I found it with latin1 charset
<rusty-> bobfield, for instance I've to load it with a different charset to work with a specific locale language
<bobfield> ah I begin to see
<bobfield> so dump from a prototype database in latin1, load into production as some country-specific charset/collation
<bobfield> to the tune of 145 tables
<rusty-> how ?
<rusty-> It will takes an ages to be dumped
<rusty-> it's 30 M
<bobfield> okay perhaps I misunderstand
<Jamesday> 30M is pretty small - should be fairly fast - no more than a few hours at worst
<arjenAU> lsmith: miguel's answer is interesting, he's asking the user which answer they think is correct ;-)
<rusty-> Is there anyway to load a database file with a diff charset
<rusty-> it's possible from phpmyadmin
<bobfield> dump the data and schema separately
<rusty-> but I can't make it because I've a lag/crap speed to upload a file around 30M
<rusty-> but it's previously uploaded
<rusty-> I've to load it with a diff charset using mysql prompt
<rusty-> What's the solution
<bobfield> does the sql file drop and recreate the table?
<firewire> 30M - a few hours?
<firewire> are you loading it on your cell phone?
<rusty-> firewire, yeah
<rusty-> bobfield, didn't get you
<rusty-> firewire. no
<bobfield> this sql file you have that loads the database, does it first drop/recreate the table(s)
<rusty-> bobfield, Or any other solution to change 145 table's charset
<rusty-> bobfield, no
<bobfield> so you still need to alter or recreate the schema with the correct charset&collation
<rusty-> bobfield, you mean I've to alter 145 one by one
<bobfield> maybe a php script would do the trick
<bobfield> do you already have a script somewhere to create these tables?
<rusty-> no
<rusty-> It's just a backup from vbulletin forum
<bobfield> plus you not only have to alter table defaults but individual column settings right?
<nbari> hi all, i have to tables the ones have a commun column (product_id) i want to know what products_id are missing in each tables any idea of how could i do that query?
<Understudy> Hello
<bobfield> rusty-, You can use mysqldump to dump just the schema, no data
<bobfield> edit it and change latin1 to whatever
<Prax01D> I'm wondering if there's a known problem with the debian package mysql-server-5.0_5.0.18-8_i386.deb? I keep getting the error "dpkg: error processing /var/cache/apt/archives/mysql-server-5.0_5.0.18-8_i386.deb (--unpack): subprocess pre-installation script returned error exit status 1".
<Prax01D> Doesn't appear to be corrupted.
<bobfield> rusty-, then drop the db, run the edited schema, load the data from the file
<bobfield> make sense?
<nbari> any ideas?
<nbari> how can i make a select all ID where does ID's not in that table
<bobfield> SELECT * from t1 left join t2 on t1.commonfield = t2.commonfield where t2.commonfield is null
<jgarbers> what's the right way to copy a table from one database to another?
<rusty-> bobfield, yeah but can you tell me how do I use mysqldump ?
<nbari> thanks bobfield
<rusty-> bobfield, I'm a newbie with mysql SORRY
<bobfield> mysqldump --no-data
<bobfield> mysqldump --no-data -h hostname -u username -p dbname > file.sql
<bobfield> ^ dumps just the table definitions
<rusty-> done for dumping
<Estes2> hum
<Estes2> I just joined a new node to my cluster.... it replicated the new node.... and deleted all tables of all databases on my cluster
<bobfield> rusty-, okay so pop that file in an editor
<Estes2> I *thought* mysql was "pro" enough to not do something sooooo stupid
<Estes2> I'm impressed
<HarrisonF> Estes2: cluster or replication?
<Estes2> cluster
<Estes2> I really didn't expect such a thing
<HarrisonF> you added a data node or sql node?
<Estes2> well
<Estes2> backup helped but.... still...
<Estes2> well, both actually, it's a node that doesn ndbd and API
<Estes2> doesn = does
<HarrisonF> you know that you can't add data nodes without doing a backup and restore right?
<HarrisonF> you restarted the cluster with --initial right?
<trizem> Is it possible to have a field in tableA share the same value as a field in tableB? and have it automatically update without UPDATE both tables when changinge tableB?
<Estes2> yes
<Estes2> no, i didn't know this
<Estes2> well, what is done is done now
<Estes2> must be my fault
<HarrisonF> and you know that --initial is designed to wipe out your data right? ;)
<Estes2> just i didn't expect this
<Estes2> HarrisonF, is it really or you're kidding me ?
<HarrisonF> yes
<Estes2> damn
<HarrisonF> that is the entire purpose of the flag
<Estes2> ok, i see
<Estes2> this _should_ be told in tutorials
<HarrisonF> Estes2: take a look at the --initial help output
<HarrisonF> Estes2: ndbd --help | grep initial
<Estes2> like tutorials on mysql.com for example
<rusty-> bobfield okay
<bobfield> yes?
<HarrisonF> which tutorial told you to use initial to add a node and didn't tell you take a backup first??
<Estes2> http://dev.mysql.com/tech-resources/articles/mysql-cluster-for-two-servers.html
<Estes2> didn't really specify
<Estes2> but since my cluster was not starting after adding the node, i added the --initial
<Estes2> ok, anyhow, no way to get back datas from this right ?
<HarrisonF> nope
<Estes2> ok
<Estes2> well, we'll deal with the backup
<Estes2> works again already
<Estes2> Why mysql has to use --initial to add an other node ?
<HarrisonF> adding a new ndbd will entirely change the node group setup and how the data is partitioned
<HarrisonF> you don't have to do it to add a new mysqld
<Estes2> I see
<Estes2> okay.... thanks :)
<rusty-> bobfield, how do I run the edited scheme
<bobfield> mysql -h hostname -u username -p dbname < file.sql
<rusty-> bobfield, you mean mysql -u root -p dbname < file.sql Then mysql -u root -p dbname < shababmi.sql
<bobfield> you got the idea
<eydaimon> what characters are necessary to escape when storing strings into a db? ' and what else?
<trizem> eydaimon: "OWE**49er
<rusty-> I've to load two time 1- the edited scheme 2- the data file
<rusty-> right?
<eydaimon> trizem: what?
<bobfield> rusty-, correct
<eydaimon> rusty-: scoop rusty?
<thesefirah> hello, can someone pls give me a phpmyadmin 2.8 conf file ?
<jade> how can i rename a database? i've been trying to move around databases at the file level and seem to have corrupted them.
<Tortel> hmm
<eydaimon> ouch
<Tortel> can I transfer a database from one computer to another?
<Darien> yes
<Tortel> would save me a few hours
<Tortel> yay
<Darien> jade: you rename a database by renaming the directory
<eydaimon> what characters are necessary to escape when storing strings into a db? ' and what else?
<jade> Darien, thanks
Return to
#mysql
or
Go to some related
logs:
unable to enter compaq armada 1700 bios
xml_parse php5 accents
gentoo gnome-panel Access denied
no acceptable C compiler foudn in $PATH
#freedesktop
adaptec 1200a fedora
#gentoo
exploit consolehelper shutdown
sound acpi thinkpad600
#lisp
|
|
