|
My MySQL Questions |
|
13.05.2003, 14:00
|
#1
|
В бой аргхххххххх!
Join Date: 09 2002
Location: Vik, Medieval Norway
Age: 42
Posts: 1,513
Rep Power: 5
|
My MySQL Questions
1. Vonc karelia table-y polnostiu copy anel mi bazaic urishi mej, ete failerin dostup chunem to-est' chem kara .frm, .MYD, .MYI filery copy anem urish bazai folder-i mej u vse.
2. Aid fileri hamar permissionery inchpes a petq kargavorel.
3. Hayeren stringer bazaium teghadrelu hamar incha petq.
4. Ete unem mijin chapsi teqster (orinaki hamar xagheri proxodkaner, kam asenq ergeri tabulaturaner) voronq petqa web interface-i mijocov hasaneli linen, aveli chishta aid teqstery pahel bazaium, te bazaium pahel miain teqstain fileri anunnery, isk teqstery arandzin folder-um. Qanaky karogha asenq lini ~1000, ~10000, ~100000 -i kargi, nayats depq.
|
|
|
14.05.2003, 05:00
|
#2
|
Web developer
Join Date: 09 2002
Location: Yerevan
Age: 43
Posts: 896
Rep Power: 0
|
1. phpMyAdmin qashi dir ( www.phpmyadmin.net), ira mej et function@ ka copy anelu. U menya v. 2.3.3, tam esli zaxodish' v konkretny table, est' link "Operations", tam uzhe razberesh'sya
2. Ete phpMyAdmin-ov qces, et tegh ka Users database, vor teghic karogh es user avelcnes konkret DB-i ra u permissioner dnes ira hamar.
3. Voch mi ban el petq chi, inq@ normal kgci (bayc de inch qan gitem hayeren "G" tari het inch vor problemner en arajanum ev DB-i mej dra tegh@ inch vor sybmola dnum)
4. Eli ete phpMyAdmin qces, et tegh ete nor baza stexces, Fielderum lriv typer@ kan. Isk vor@ inch e nshanakum ev inch chapsi e, karogh es http://www.mysql.com/ Manuali mej gtnes
|
|
|
14.05.2003, 05:53
|
#3
|
Волк, просто волк...
Join Date: 07 2002
Location: /dev/null
Age: 79
Posts: 250
Rep Power: 0
|
chishtn asats metsatar G-i het problemner der chen eghel esqan jamanak.
offtopic:
hetaqrqir a ov inch lutsum e talis MySQL-um hayeren@ ORDER anelu hamar??!!!
Last edited by _ WOLF _; 14.05.2003 at 06:05.
|
|
|
14.05.2003, 05:59
|
#4
|
Web developer
Join Date: 09 2002
Location: Yerevan
Age: 43
Posts: 896
Rep Power: 0
|
Wolf jan, im mot chishtn asac poqratar "g"-i het er problem, inch vor symbol er cuic talis, vonc vor "m"-i ev "n"-i xarnord liner.
|
|
|
|
re |
|
14.05.2003, 06:00
|
#5
|
Stalker
Join Date: 09 2002
Location: Припять
Age: 90
Posts: 853
Rep Power: 5
|
re
Mec texter@ karas pahes bazayum, dra qanakic problem chi arajana. mySQL kak takovoy arag a ashxatum, field type dnum es
'text' (65535), kam el 'long text' (4294967295) kheriqi ))
chnayac, yete php-ov es grum, karas txt filerov pahes, eli arag kashxati, prichom karas @nenc gres, vor et filer@ manage linen eli php-ov, avtomat, tekuz 100000 hat lini, nayi qo harmarutyan@.
Yes hayeren texti het problem chem unecel mySQL-um, G-ern el a berel normal .... server@ RedHat 7.3 tak ei drel ...
addressbook er heraxosi hamarneri, hasceneri, shat mec ...
__________________
... for long you live and high you fly ...
|
|
|
14.05.2003, 06:08
|
#6
|
Web developer
Join Date: 09 2002
Location: Yerevan
Age: 43
Posts: 896
Rep Power: 0
|
2 Timewind
Ete txt filerov pahes, vonc es poisk@ kazmekerpelu? Henc togh static html pahi eli
|
|
|
|
Re: _WOLF_ |
|
14.05.2003, 06:14
|
#7
|
Stalker
Join Date: 09 2002
Location: Припять
Age: 90
Posts: 853
Rep Power: 5
|
Re: _WOLF_
hetaqrqir a ov inch lutsum a talis MySQL-um hayeren@ ORDER anelu hamar??!!!
de sax problem@ inchic a galis, vor hayeren tarer@ iranc hertakanutyamb code-i het chi brnum ...
ka fonter vor et harc@ lucac a, normal a sharac, vonc vor ruserenn a etc. orinak "Aramian" font@
yes uzum em porcem @nenc anem et fontov ashxati ....
der teoriaya ..... bayc indz tvuma kashxati ....
BAYC arden havaqac hayeren text@ (sovorakan urish fonterov) sxal cuyc kta ...
|
|
|
14.05.2003, 06:18
|
#8
|
Stalker
Join Date: 09 2002
Location: Припять
Age: 90
Posts: 853
Rep Power: 5
|
Aram, et qanakov ??
chish es asum, poisk tenc vaxt shat zor klini ......
aveli lav a togda henc bazayi mej el tox pahi, a choj?
ham, hesht klini manage anel, ham search kashxati, etc...
el fileri het el gorc chi unena ...
|
|
|
14.05.2003, 06:37
|
#9
|
Web developer
Join Date: 09 2002
Location: Yerevan
Age: 43
Posts: 896
Rep Power: 0
|
Vopros ochen' sporny konechno zhe.
Ya dumayu luchshe bylo by napisat' parser kotory iz texta vytaskivaet vse keywordi, brasaet ix v otdel'nuyu bazu, a text celikom xranit v txt formate. No eto vse pisat'....
|
|
|
14.05.2003, 06:46
|
#10
|
Stalker
Join Date: 09 2002
Location: Припять
Age: 90
Posts: 853
Rep Power: 5
|
ba! ))))
yes el ei et mtacum ......
et variant@ aveeli canr a
u yerevi kaprizni ...
tox lci baza e ....
inch problem ka v principe?
|
|
|
|
|
|
15.05.2003, 13:21
|
#11
|
В бой аргхххххххх!
Join Date: 09 2002
Location: Vik, Medieval Norway
Age: 42
Posts: 1,513
Rep Power: 5
|
Quote:
Originally posted by Aram Ghazanchyan
1. phpMyAdmin qashi dir (www.phpmyadmin.net), ira mej et function@ ka copy anelu. U menya v. 2.3.3, tam esli zaxodish' v konkretny table, est' link "Operations", tam uzhe razberesh'sya
2. Ete phpMyAdmin-ov qces, et tegh ka Users database, vor teghic karogh es user avelcnes konkret DB-i ra u permissioner dnes ira hamar.
3. Voch mi ban el petq chi, inq@ normal kgci (bayc de inch qan gitem hayeren "G" tari het inch vor problemner en arajanum ev DB-i mej dra tegh@ inch vor sybmola dnum)
4. Eli ete phpMyAdmin qces, et tegh ete nor baza stexces, Fielderum lriv typer@ kan. Isk vor@ inch e nshanakum ev inch chapsi e, karogh es http://www.mysql.com/ Manuali mej gtnes
|
1. Servery imy chi. Chem uzum phpmyadmin qcel. U heto chem sirum es ed phpmyadmin-y. Aveli lav a isxodniknery knayem tenam inch metodova copy anum.
2. Axr indz lriv urish ban er petq "file permissionnnery". Isk MySQL-i userner shinelu hamar phpMyAdmin-i teghn el aveli lav a MySQL CC kogtagortsem kam command line.
3. Mersi
4. Es fielderi tipery gitem. Problemy ardiunavetutiun apahovelu ev harmarutian mej e. Asem vor search el erevi petq chi lini et teqsteri mej anel. U heto indz kak-to chi dzum etqan teqstery mi file-i mej qcel. Mek el tesar merav. Erevi sovorutian harca.
Verjy amenakarevory copy vonc kareli-a anel.
Es moment senc mtatseci
SELECT * INTO OUTFILE 'inchvorfile' FROM table
heto
LOAD DATA INFILE 'etnuinfile' REPLACE INTO TABLE urishdb.urishtable
Baic hly chem pordzel kap chka.
|
|
|
|
|
|
|
16.05.2003, 05:14
|
#12
|
Web developer
Join Date: 09 2002
Location: Yerevan
Age: 43
Posts: 896
Rep Power: 0
|
Quote:
1. Servery imy chi. Chem uzum phpmyadmin qcel. U heto chem sirum es ed phpmyadmin-y. Aveli lav a isxodniknery knayem tenam inch metodova copy anum.
|
Arandznapes vor qon@ chi, amena lav tarberak@ phpMyAdminna, nu kam el urish Web-based DB admin.
Quote:
4. Es fielderi tipery gitem. Problemy ardiunavetutiun apahovelu ev harmarutian mej e. Asem vor search el erevi petq chi lini et teqsteri mej anel. U heto indz kak-to chi dzum etqan teqstery mi file-i mej qcel. Mek el tesar merav. Erevi sovorutian harca.
|
Ete search-i mej ches ogtagorcelu, vse taki aveli lava arandzin file-ov pahes - DB-n peregruzka ches ani
Quote:
Verjy amenakarevory copy vonc kareli-a anel.
Es moment senc mtatseci
SELECT * INTO OUTFILE 'inchvorfile' FROM table
heto
LOAD DATA INFILE 'etnuinfile' REPLACE INTO TABLE urishdb.urishtable
|
Ete verjnakan et ezrakacutyan ekar, es chem haskanum inchi mi hat export chanel, heto el noric import? Nuin ban@ chi stacvum?
|
|
|
|
|
to HOV |
|
16.05.2003, 05:33
|
#13
|
Stalker
Join Date: 09 2002
Location: Припять
Age: 90
Posts: 853
Rep Power: 5
|
to HOV
@nger, yete TPC connction unes et compin, DB Tools ogtagorci!
yes arden qani tari a goh em.
Yete uzes karam tam, mec chi ....
inq@ WIN32 application a. xodi es tali talis es mySQL serveri IPn
DB name, etc. kpnum es, karas ameninch admin anes, import, export, mi DB urish, user management .....
kak raz xalxi serveri vra ban ches dnum ...
uzes, asa ktam.....
|
|
|
16.05.2003, 06:02
|
#14
|
Web developer
Join Date: 09 2002
Location: Yerevan
Age: 43
Posts: 896
Rep Power: 0
|
Es el mi hat et dzev cragir gitem
Mascon - a kochvum
|
|
|
17.05.2003, 12:40
|
#15
|
В бой аргхххххххх!
Join Date: 09 2002
Location: Vik, Medieval Norway
Age: 42
Posts: 1,513
Rep Power: 5
|
Aram Ghazanchyan >
Vse-taki mtatsum es vor shat teqster pahely peregruzkaia ?
Vortev ete et teqstery bazai mej chen drvum amen inch shat kokik-a stacvum, sirun a. Amen toghum minimum ban a grats.
isk export import inchov es anum ira vstroennyi konsol utilitkekov?
Timewind and Aram Ghazanchyan >
Et tsragrerin tsanot chem. Ogtagorsum em henc mysql.org -ic qashats MySQL Control Center-y. Ete uneq teghekutiunner pls areq vorosh hamematutiunner.
Regards, Hov.
|
|
|
All times are GMT. The time now is 18:06. |
|
|