AKB Forums

Go Back   AKB Forums > Technical sections > Languages, Compilers and Interpreters > Web Development
Home Register Blogs FAQ Members List Calendar Downloads Arcade Mark Forums Read

Web Development Java/PHP/Perl/ASP and more

Troubles when posting message? Click here! :: Проблемы с отправлением сообщения? Нажмите сюда!

Reply
 
LinkBack Thread Tools Display Modes
Old May 13, 2003, 14:00   #1
В бой аргхххххххх!
 
hov's Avatar
 
Join Date: Sep 2002
Location: Vik, Medieval Norway
Posts: 1,497
Rep Power: 7
Reputation: 48
Send a message via ICQ to hov
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.
hov is offline   Reply With Quote Quote selected
Old May 14, 2003, 05:00   #2
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: Sep 2002
Location: Yerevan
Posts: 892
Rep Power: 7
Reputation: 14
Send a message via ICQ to Aram Ghazanchyan Send a message via MSN to 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
Aram Ghazanchyan is offline   Reply With Quote Quote selected
Old May 14, 2003, 05:53   #3
Волк, просто волк...
 
_ WOLF _'s Avatar
 
Join Date: Jul 2002
Location: /dev/null
Posts: 250
Rep Power: 7
Reputation: 10
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??!!!
__________________
00000000h: 41 72 61 6D 20 4D 6B 68 69 74 61 72 79 61 6E;

Last edited by _ WOLF _ : May 14, 2003 at 06:05.
_ WOLF _ is offline   Reply With Quote Quote selected
Old May 14, 2003, 05:59   #4
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: Sep 2002
Location: Yerevan
Posts: 892
Rep Power: 7
Reputation: 14
Send a message via ICQ to Aram Ghazanchyan Send a message via MSN to Aram Ghazanchyan
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.
Aram Ghazanchyan is offline   Reply With Quote Quote selected
Old May 14, 2003, 06:00   #5
Stalker
 
Timewind's Avatar
 
Join Date: Sep 2002
Location: Припять
Posts: 847
Rep Power: 7
Reputation: 14
Send a message via ICQ to Timewind Send a message via Skype™ to Timewind
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 ...
Timewind is offline   Reply With Quote Quote selected
Old May 14, 2003, 06:08   #6
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: Sep 2002
Location: Yerevan
Posts: 892
Rep Power: 7
Reputation: 14
Send a message via ICQ to Aram Ghazanchyan Send a message via MSN to Aram Ghazanchyan
2 Timewind
Ete txt filerov pahes, vonc es poisk@ kazmekerpelu? Henc togh static html pahi eli
Aram Ghazanchyan is offline   Reply With Quote Quote selected
Old May 14, 2003, 06:14   #7
Stalker
 
Timewind's Avatar
 
Join Date: Sep 2002
Location: Припять
Posts: 847
Rep Power: 7
Reputation: 14
Send a message via ICQ to Timewind Send a message via Skype™ to Timewind
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 ...
__________________
... for long you live and high you fly ...
Timewind is offline   Reply With Quote Quote selected
Old May 14, 2003, 06:18   #8
Stalker
 
Timewind's Avatar
 
Join Date: Sep 2002
Location: Припять
Posts: 847
Rep Power: 7
Reputation: 14
Send a message via ICQ to Timewind Send a message via Skype™ to Timewind
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 ...
__________________
... for long you live and high you fly ...
Timewind is offline   Reply With Quote Quote selected
Old May 14, 2003, 06:37   #9
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: Sep 2002
Location: Yerevan
Posts: 892
Rep Power: 7
Reputation: 14
Send a message via ICQ to Aram Ghazanchyan Send a message via MSN to Aram Ghazanchyan
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'....
Aram Ghazanchyan is offline   Reply With Quote Quote selected
Old May 14, 2003, 06:46   #10
Stalker
 
Timewind's Avatar
 
Join Date: Sep 2002
Location: Припять
Posts: 847
Rep Power: 7
Reputation: 14
Send a message via ICQ to Timewind Send a message via Skype™ to Timewind
ba! ))))

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

tox lci baza e ....
inch problem ka v principe?
__________________
... for long you live and high you fly ...
Timewind is offline   Reply With Quote Quote selected
Old May 15, 2003, 13:21   #11
В бой аргхххххххх!
 
hov's Avatar
 
Join Date: Sep 2002
Location: Vik, Medieval Norway
Posts: 1,497
Rep Power: 7
Reputation: 48
Send a message via ICQ to hov
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.
hov is offline   Reply With Quote Quote selected
Old May 16, 2003, 05:14   #12
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: Sep 2002
Location: Yerevan
Posts: 892
Rep Power: 7
Reputation: 14
Send a message via ICQ to Aram Ghazanchyan Send a message via MSN to Aram Ghazanchyan
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?
Aram Ghazanchyan is offline   Reply With Quote Quote selected
Old May 16, 2003, 05:33   #13
Stalker
 
Timewind's Avatar
 
Join Date: Sep 2002
Location: Припять
Posts: 847
Rep Power: 7
Reputation: 14
Send a message via ICQ to Timewind Send a message via Skype™ to Timewind
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.....
__________________
... for long you live and high you fly ...
Timewind is offline   Reply With Quote Quote selected
Old May 16, 2003, 06:02   #14
Web developer
 
Aram Ghazanchyan's Avatar
 
Join Date: Sep 2002
Location: Yerevan
Posts: 892
Rep Power: 7
Reputation: 14
Send a message via ICQ to Aram Ghazanchyan Send a message via MSN to Aram Ghazanchyan
Es el mi hat et dzev cragir gitem
Mascon - a kochvum
Aram Ghazanchyan is offline   Reply With Quote Quote selected
Old May 17, 2003, 12:40   #15
В бой аргхххххххх!
 
hov's Avatar
 
Join Date: Sep 2002
Location: Vik, Medieval Norway
Posts: 1,497
Rep Power: 7
Reputation: 48
Send a message via ICQ to hov
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.
hov is offline   Reply With Quote Quote selected
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 11:39.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
This board was founded on September 29, 2001
Powered by Viper Internet

Affordable Web Hosting | ParevNet

Buy text link