| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> as am i :)
<0> hehe
<0> i forget everything
<1> i know the first one is packets
<0> byebye folks
<0> thanks ashica
<2> I may be missing something obvious I am moving from mysql 4.1 > 4.1 and I cannot get russian characters to import for the life of me - i have tried mysqldump and even rsync'ing the mysql data directory over, any ideas?
<3> hello, is there a free tool similar to sqlyog's database sync'ing tool?
<4> Jivedue: nope. That ain't work. Sorry lag
<5> eth00: 4.1 -> 4.1 ?
<2> Darien yes
<6> what are field attributes for?
<2> The russian characters show up as some weird things vs the real russians
<7> i have a mysql server installed on Mandriva linux, i forgot my root p***word, any way to recover it?
<2> I have tried mysqldump and moving via rsync/scp and also moving the entire mysql directory via rsync/scp
<2> samz you can reset the mysqld p***word easy enough
<8> !m samz reset p***word
<9> samz: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<6> eth00: is the character pack installed on the machine you want it to be on?
<2> Fushuing I have it on the webserver, should I look for something on the mysql?
<6> i'm the noob here :S
<6> i don't even know what field attributes are for!
<2> I don't see any "crylic" or "utf" rpms on the old box
<2> ahhh heh
<4> cya all
<10> how can i set a timestamp really equal to NULL
<8> define it with NULL
<10> forget it
<10> i just made them a datetime
<11> ah
<12> hey
<12> i have one question
<12> i have setuped mysql cluster
<12> if i change any thing on master does it cache on slave
<12> ?
<13> mysqueel
<14> Hi, how works an index on a datetime column? If I have a startDate column of type DATETIME and make an index on that column, my where clause is: where month(startDate)=2 and year(startDate)=2006, but If use explain my index is not selected, why?
<15> !m mtellez how mysql uses indexes
<9> mtellez: (How MySQL Uses Indexes) : http://dev.mysql.com/doc/mysql/en/MySQL_indexes.html
<2> Anybody know of a reason why a database from mysql 4.1 > 4.1 would have all the crylic characters messed up BUT I can create them fine on the database so the support is on both just fine
<15> eth00: how did you do the migration?
<2> I tried mysqldump and moved the file via scp/rsync and i even tried the entire /var/lib/mysql directory via rsync/scp
<15> there is an argument (which I don't recall off the top of my head) to mysqldump that specifies character set for the dump; you probably need to specify it, as well as during the re-import.
<15> !m eth00 mysqldump
<9> eth00: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<2> --set-defaultchar=utf8 or something
<15> yes, but it might not be utf8 ? there are other cyrillic encodings iirc.
<15> eth00: also, if your dump file doesn't specify SET NAMES utf8; (if it is indeed utf8) at the top, add that line to the dump before you re-import it.
<2> Ok
<15> remember: character set is selected on a per-connection basis, so you have to reset it at the beginning of every connection you make.
<2> Is there a way to make sure of what character set the db is using currently?
<15> erm, show create table foo; perhaps. there is another way, but I don't recall.
<2> the my.cnf has nothing in it specifying a db
<2> Ok
<15> just pick one or several tables and try that.
<16> about the new games as mmorpg based on php and mysql. i searched alot how to create one and found nothing can help do you think it is possible to do so with help of u ?
<17> PHP based MMORPG? I think we have a different idea of the term.
<2> /*!40101 SET NAMES utf8 */;
<2> Yeah looks like I already have the utf8 stuff in the .sql
<16> mhillyer : there are many about this kind of games. i got .sql for the game but i don't know how to make it work as game
<16> yeah like mafia games gangs pimps etc
<15> eth00: how are you verifying that they're "messed up" ?
<17> Ok, we certainly have a different definition.
<2> I am looking at the database via phpmyadmin and they are scrambled and a lot longer then before
<15> eth00: not sure about phpmyadmin, it may not issue the SET NAMES utf8.
<2> @CAA:89 D>;45@
<17> Ok then.
<2> well I am also trying the web frontend - it works for new information but not for the old stuff
<15> and it's possible again, that they weren't originally encoded as such. I've seen some hack programs use proprietary encoding for CJK characters that weren't utf8, SJIS, or iso2022
<8> run "show variable like 'char%';" from the phpmyadmin and you will know if it set names to tuf8
<2> lokus one moment
<15> yar, listen to lokus. I don't use these tools or PHP ;)
<8> me too don;t use these tools actually
<2> hmm lokus so are you saying paste one of the russian characters in? I ask because when i try my ssh client does ???
<2> ERROR 1064 (42000): 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 'variable like 'char%'' at line 1
<2> and because of that I am ***uming just that line is not supposed to work
<8> show variables like 'char%'
<8> i missed the s
<2> http://pastebin.com/654933
<2> and for the record both servers show the same thing
<8> it is expectin latin1 then
<2> should I try to export/import it as latin1 ?
<8> but it is client dependant, did you run from the phpmyadmin
<2> i ran the above from ssh
<2> the client webserver I actually can switch back to the old mysql server and it works fine so i am pretty sure it is a mysqld issue and not a httpd client issue
<8> ok
<8> then the backup/restore could pose a problem
<8> can you view the sql file correctly on an editor or the web browser?
<2> i can view it in vi fine, though it is 1.1gb so hard to search
<8> with the proper charset
<8> what charset is your vi using?
<2> default english/us, I do not speak/use russian so it would not be that charset
<8> can you see the russian char?
<8> not likely
<2> let me try to open it up, I don't think so and searching for it would be hard I cannot paste into my client
<2> the db has relatively little russian characters
<2> *few
<15> eth0: if it's really utf8, you can do the painful thing and use hexdump -C, then xref between that and unicode.org ;)
<2> I did also try using rsync/scp to copy the entire /var/lib/mysql directory over which should work regardless
<15> eth00: I had to do that while trying to ensure my kanji database was correct. once it's all working properly though, you will never have to do it again ;)
<2> haha
<8> need to know what charset is the dump file
<2> http://pastebin.com/654943
<15> pretty much. in my case, it was a GIGO issue. the database itself *will* store the data properly, it's just a matter of loading (and dumping) it properly.
<2> the charset looks like it is dependent on the client - both mysqld are the same for that
<15> <15> remember: character set is selected on a per-connection basis, so you have to reset it at the beginning of every connection you make.
<2> how do you usually move a db? rsync/scp should both not corrupt it correct?
<8> but there is SET NAMES utf8 so the dump file should import correctly
<2> I know technically you should use a dump but for replicating a server i have always copied the directory and for normal US text it works great
<8> eth00: can you do a show create table on the table containing the russian char and see what is the column character set
<2> i don't think i can do that, I am not sure how the db is organized
<8> eth00: copy directory works well if you stop the server first
<2> I did stop all writes going to it so that should be enough
<2> let me just bring it fully offline
<8> that is enough, why don;t you try the copy method
<8> flush tables with read lock is good enough for myisam tables
<2> Yeah i will try it again and see if it works, i just noticed the db was still doign some writes
<15> HI WILL
<2> lokus no luck, I actually was able to stop reads easy enough because of this m/cluster software we are using -- though soon enough ill be rid of it
<8> m/cluster, so you have multiple mysql server, just stop one and copy
<8> m/cluster should be able to sync when you restart it later
<8> or better still if you can add another node to you m/cluster
<8> ignore the add node
<2> yeah I actually put it in deffered standby
<8> not sure what does deffered standby actually do, but safer to pull it off, or run a flush tables with read lock through a direct connection to the mysql server while it is in deffered standby
<18> Hi, all, who is using phpMyAdmin to admin Mysql
<19> hi
<2> lokus ok thansk for the help ill see if i can figure it out thats still not working, the deffered standby stops all writes to the server and places them in some sort of a queue so the db is not touched
<19> i'd like to extend mysql by creating a virtual table that is populated by a custom function. how can Ido that ? I'd need to do a web-query to populate the table.
<3> back!
<3> hello, is there a free tool similar to sqlyog's database structure sync'ing tool?
<12> can some one tell me this
<12> i have this error when restoring dump to new server
<12> collate latin1_general_ci NOT NULL default
<12> ERROR 1064 at line 2: 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 'collate latin1_general_ci NOT NULL default '',
<12> `type` varchar
<12> what to do
<12> any one
<12> ?
<20> hey. just having a little head wrapping my head around a simple regexp. i'm wanting to see if my field contains either ',5,' or ',10,' (or any number of these), using regexp
<5> (,(5|10))+
<5> oops
<5> (,(5|10),)+
<5> that will match ,5, though, not ,5
<5> meaning that 5,5,5,5 will only match once
<20> ok. thanks. i'll try that.
<5> and 5,5,10 will only match once as well
<20> as long as it matches at least once it's alright :)
<21> What happened to the Backup API planned for 5.1? (Brian Aker's I think)
<5> it was stolen by aliens
Return to
#mysql
or
Go to some related
logs:
sabayon r51
wxPython ubuntu apt-get breezy
#perl
only udma2
cannot allocate memory mount dreambox
#web
#math
twisted.words robot
#debian
#perl
|
|