| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> the data was dumped just a bit ago.
<1> are you restoring from a dump made on the same version of mysql or are you upgrading?
<0> i can re-dump it.
<2> did you remove the data from the table before inserting it back in?
<0> upgrading only with a micro update.
<1> oh yes, did you wipe the table clean before reimportation? :)
<1> try: truncate tablename; before you re-import it
<0> INSERT INTO `lazanew_bbsearch_wordlist` VALUES ('??????',4,0),('??????',1099,0),('?????',110,0),('?????',1098,0),('????',1097,0),('???',1096,0),('?????',1095,0),('?????',1094,0$
<0> the
<0> the ??? is hebrew charecters i can see on my computer and you probably cant
<2> did ou delete the rows that that insert is inserting?
<0> hmm, i can delete the whole DB and create it as new one.
<1> try for a moment just to delete this row out of your dump and import it again, see what happens
<1> but before you do that, just wipe it all clean and see what happens on a fresh import
<0> i afraid that if i'll edit it with Pico it'll ruin the hebrew encoding.
<0> but i'll try
<1> if you're importing into a table that already has such an entry , obviously insertion will fail
<1> before you do that, just make sure you're importing into a CLEAN table
<0> what's the mysql command to dump all the data inside a db
<2> why are you doing an update this way anyawy?
<1> mysqldump -u username -p dbname tablename
<0> sec
<1> good question, why are you dumping and restoring?
<1> bbl
<0> supastuff these are different servers.
<3> Hey guys, i've got a problem here, 3 tables of my 2 databases shows "used"(translation) in the php myadmin, if i click to see the structure it says : Can't open file: 'webcal_entry.MYD'. (errno: 144) how can i fix that?
<3> and what could'Ve caused that all of a sudden
<4> is there an SQL statement I can use that will replace all instances of 'daily' with DAILY in one column of a table?
<5> !perror 144
<6> MySQL error: 144 = Table is crashed and last repair failed
<5> !m StaZ[work] table maintainence
<6> StaZ[work]: Nothing found
<2> aww
<5> !m StaZ[work] table recovery
<6> StaZ[work]: (Table Maintenance and Crash Recovery) : http://dev.mysql.com/doc/mysql/en/Table_maintenance.html
<5> I apparently can't spell :)
<2> you should spell maintenance better :)
<3> thanks inviso i'll check that
<5> Absenth: update table set col='DAILY' WHERE col='daily'
<4> inviso, thank you. ONce I get the firewall adjusted to I can speak to the database server I'll give it a shot.
<2> that will only replace a row where col = the literal string "daily"
<2> it won't replace "this is a daily occurrence" with "this is a DAILY occurrence"
<2> so if you need that, use replace()
<5> REPLACE for the set clause and LIKE or RLIKE for the where clause. Yay for inspecific questions
<4> gleam-, that col is actually rtType (as in report type) DAILY or MONTHLY should be the only options. but one of the automated Insert applications got it's logic in a bundle and stopped capitalizing the DAILY :(
<2> ok
<2> then do what inviso said
<5> !man UPPER
<6> (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<5> update table set col=UPPER(col) would work as well in that case
<2> you could also switch to enum:)
<5> very true
<7> yah, I was going to say, while you're at it, why not make it a TINYINT
<7> ;P
<2> ok
<2> heading to the datacenter
<2> XEN DAY!
<5> ENUM is just a fancy TINYINT
<7> I don't like fancy
<2> enum can be a fancy smallint too
<8> TINYINT?
<2> but why anyone would put more than ~10 values in an enum is beyond me
<5> yeah, unsigned tinyint
<8> yeah more like smallint
<5> eh?
<5> it caps at 255 entries, doesn't it?
<2> no
<2> 64k
<5> !man column types
<6> (Column Types) : http://dev.mysql.com/doc/mysql/en/Column_types.html
<5> gah
<5> lol
<4> inviso, gleam-: so the best fix is to A) change the "filetype" column to upper? or to use the update table set statement?
<2> i'd switch toe num for that
<5> Absenth: I'd do an set col=UPPER(col) to fix all lowercase and then switch the col type to an ENUM
<2> yes
<2> do that
<2> i'm outta here
<2> back in a bit
<5> later gleam-
<4> what's enum in a nutshell.
<5> List of Values
<5> enforces that the value is valid from a list you provide
<8> and maps that value to an integer
<5> yup
<5> But that's transparent from the user's perspective. It will return the symbolic string instead of the numeric representation
<8> its not transparent in one area though
<8> ordering
<5> true
<5> and very useful too :)
<8> aye
<4> lsmith, inviso: I'll look into that enum change. Since I'm the network guy, and our database person who's also our programmer isn't here I'm not sure I'm the one who should make those changes.
<4> sounds like it might be a great change though.
<9> argh
<9> is there any hack to get better performace on a desc sort on a string column?
<7> index it?
<9> I have.
<7> what's your query?
<9> one sec
<10> sorry gleam-, i had to go afk. thanks for the answer at 11:57am EST
<9> hmm... never mind, after taking out all the joins in the query it seems to be good. Must be something else
<11> Is there a known problem with Row Based Replication, not closing the tables/files properly? Running out of files and it's unlimited.. checking bugs now
<12> What's wrong with that? CREATE TABLE backup_reports (id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), bk_date DATETIME, bk_identifier VAR_CHAR(40), bk_size UNSIGNED INT, bk_logfile MEDIUMTEXT, bk_status INT);
<7> captrespect: the reason is probably that when you JOIN the index you made on the text column can't be used to order by
<13> how can i back up mysql database via SSH?
<0> S7[on] mysqldump -u USER -p DB > backup.sql
<13> ok tnx
<13> Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect
<13> why?
<14> how can I select date periods ?
<14> ie... only want rows stamped 2004+
<5> rudenstam: what column type?
<12> any ideas?
<5> !tell bluetree about what's wrong
<6> Alrighty.
<14> inviso: date
<5> S7[on]: server probably isn't started
<5> rudenstam: YEAR(col) = 2004
<12> ERROR 1064 (00000): You have an error in your SQL syntax near 'VAR_CHAR(40), bk_size UNSIGNED INT, bk_logfile MEDIUMTEXT, bk_status INT)' at line 1
<5> bluetree: no _ in VARCHAR
<12> geez
<12> thanks
<5> np, enjoy
<15> we get a bit of "extra" syntax in here, I wonder where it comes from
<16> howdy all.... I'm trying to build a query that selects items which are NOT referenced by items in another table -- how would one do such a thing?
<5> archivist: telemarketers :(
<5> optik_knight: select blah from a LEFT join b on cond where b.any_col IS NULL
<15> inviso outsouced syntax invention
<16> inviso, thanks, I'll try it...
<5> archivist: good call ;)
<14> inviso: thnx
<16> inviso, that seems to have worked -- my initial attempt at it didn't include "left" ... including that did the trick.
<5> optik_knight: yep, that's how it works. JOIN only returns matching, LEFT JOIN returns a row even if the join condition can't be met
<16> excellent. thanks ;)
<17> submission_date datetime default now() -- why is this bad??
<15> use timestamp type you cant use a function as default
<15> or insert now()
<17> i don't understand
<17> i can't use now() with datetime?
<15> now() is a function
<15> !man timestamp
<6> (Overview of Date and Time Types) : http://dev.mysql.com/doc/mysql/en/Date_and_time_type_overview.html
<18> so a 700m mysqldump
<18> i just wait... and wait... and wait, right?
Return to
#mysql
or
Go to some related
logs:
masnam0x
xrandr suse twinview
ajidahaka
#php
6.10 sudo dpkg-reconfigure locales
#gentoo
lineakconfig + ubuntu
not a valid identifierad linux
#php
openwrt rtorrent
|
|