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