Armenian Knowledge Base  

Go Back   Armenian Knowledge Base > Technical sections > Webmaster Zone > Web Development
Register

Reply
 
LinkBack Thread Tools
Old 13.05.2003, 15:00   #1
В бой аргхххххххх!
 
hov's Avatar
 
Join Date: 09 2002
Location: Vik, Medieval Norway
Age: 35
Posts: 1,513
Downloads: 12
Uploads: 0
Reputation: 43 | 3
Default 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.
Reply With Quote
Old 14.05.2003, 06:00   #2
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: 09 2002
Location: Yerevan
Age: 36
Posts: 896
Downloads: 1
Uploads: 0
Reputation: 9 | 0
Default

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
Reply With Quote
Old 14.05.2003, 06:53   #3
Волк, просто волк...
 
_ WOLF _'s Avatar
 
Join Date: 07 2002
Location: /dev/null
Age: 72
Posts: 250
Downloads: 0
Uploads: 0
Reputation: 0 | 0
Default

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 07:05.
Reply With Quote
Old 14.05.2003, 06:59   #4
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: 09 2002
Location: Yerevan
Age: 36
Posts: 896
Downloads: 1
Uploads: 0
Reputation: 9 | 0
Default

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.
Reply With Quote
Old 14.05.2003, 07:00   #5
Stalker
 
Timewind's Avatar
 
Join Date: 09 2002
Location: Припять
Age: 83
Posts: 853
Downloads: 0
Uploads: 0
Reputation: 12 | 3
Default 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 ...
Reply With Quote
Old 14.05.2003, 07:08   #6
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: 09 2002
Location: Yerevan
Age: 36
Posts: 896
Downloads: 1
Uploads: 0
Reputation: 9 | 0
Default

2 Timewind
Ete txt filerov pahes, vonc es poisk@ kazmekerpelu? Henc togh static html pahi eli
Reply With Quote
Old 14.05.2003, 07:14   #7
Stalker
 
Timewind's Avatar
 
Join Date: 09 2002
Location: Припять
Age: 83
Posts: 853
Downloads: 0
Uploads: 0
Reputation: 12 | 3
Default 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 ...
Reply With Quote
Old 14.05.2003, 07:18   #8
Stalker
 
Timewind's Avatar
 
Join Date: 09 2002
Location: Припять
Age: 83
Posts: 853
Downloads: 0
Uploads: 0
Reputation: 12 | 3
Default

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 ...
Reply With Quote
Old 14.05.2003, 07:37   #9
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: 09 2002
Location: Yerevan
Age: 36
Posts: 896
Downloads: 1
Uploads: 0
Reputation: 9 | 0
Default

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'....
Reply With Quote
Old 14.05.2003, 07:46   #10
Stalker
 
Timewind's Avatar
 
Join Date: 09 2002
Location: Припять
Age: 83
Posts: 853
Downloads: 0
Uploads: 0
Reputation: 12 | 3
Default

ba! ))))

yes el ei et mtacum ......
et variant@ aveeli canr a
u yerevi kaprizni ...

tox lci baza e ....
inch problem ka v principe?
Reply With Quote
Old 15.05.2003, 14:21   #11
В бой аргхххххххх!
 
hov's Avatar
 
Join Date: 09 2002
Location: Vik, Medieval Norway
Age: 35
Posts: 1,513
Downloads: 12
Uploads: 0
Reputation: 43 | 3
Default

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.
Reply With Quote
Old 16.05.2003, 06:14   #12
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: 09 2002
Location: Yerevan
Age: 36
Posts: 896
Downloads: 1
Uploads: 0
Reputation: 9 | 0
Default

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?
Reply With Quote
Old 16.05.2003, 06:33   #13
Stalker
 
Timewind's Avatar
 
Join Date: 09 2002
Location: Припять
Age: 83
Posts: 853
Downloads: 0
Uploads: 0
Reputation: 12 | 3
Default 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.....
Reply With Quote
Old 16.05.2003, 07:02   #14
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: 09 2002
Location: Yerevan
Age: 36
Posts: 896
Downloads: 1
Uploads: 0
Reputation: 9 | 0
Default

Es el mi hat et dzev cragir gitem
Mascon - a kochvum
Reply With Quote
Old 17.05.2003, 13:40   #15
В бой аргхххххххх!
 
hov's Avatar
 
Join Date: 09 2002
Location: Vik, Medieval Norway
Age: 35
Posts: 1,513
Downloads: 12
Uploads: 0
Reputation: 43 | 3
Default

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.
Reply With Quote
Sponsored Links
Reply

Thread Tools


На правах рекламы:
реклама

All times are GMT. The time now is 17:40.


Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.