database droped!

[Fateme Khodaei]

Salam be hamegi, komak lotfan

 

Ye DB ba 630 ta record:(  ro sahvan az phpmyadmin(local) drop kardam kasi midone chetor mishe restore kard?

 

Khili mamnoon

--
Regards
Fateme Khodaei

[vahid samarghandi]

ba salam

2 ravesh baraye bazyabi database felan voojood dare:

1.raveshe aval dashtane backup az database
2.raveshe dowom binary log, dar soorat nadashtane hich backupi az database mishe az dastoore
mysqlbinlog estefade kard ke tamame statementhai ke baese taghier dar database shodeand ro
rooye filei ba name <host_name>-bin.000001 zakhire mikone ke ba ezafe kardane 1 be soorate automatic
be passvande file dar har taghir, shooru be ezafe shodane raghame passvand mishe ke raghame bozorghtar
neshoon dahandeye akharin taghyire. hame in mavared dar soorati ghabele ejrast ke service binary log
active boode bash.

ba dastoor zir mitoonid akharin taghirat rooye database ro bazyabi konid:

mysqlbinlog log_file_name > update.sql

--
GNSInfo
Vahid samarghandi

[Fateme Khodaei]

Salam
mer c az reply
amma man chanta chizo motevaje nashodam hanouz
1-os windowse in dastori ke migin koja bayad bezanam
2-az koja befamam ke  service binary active ya na?
3-ehtemale restore shodan cheghade?
chon be db ehtiaj darim age ke shanse bargasht ziyad nis shoro konim be entry kardan.
mamnoon

--
Regards
Fateme Khodaei

[vahid samarghandi]

mojadadan salam

khahesh mikonam,

ba farze inke mysql dar drive C:\ nasb shode bashad masire dastresi be soorate zir mibashad
- aghar az xampp estefade mikonid, file dar shakhaye zir gharar dare:
c:\program files\xampp\mysql\bin\mysqlbinlog.exe
-aghar be soorate manual mysql ro nasb kardid dar shakhaye zir mitoonid be un dastresi peyda konid:
c:\program files\mysql\bin\mysqlbinlog.exe

az tarighe cmd (Dos prompt windows) be file zekr shode mitoonid dastresi peyda konid.
Start -> Run -> type <cmd> -> then enter your path

baad az vared kardane masir dar cmd mitoonid befahmid ke service binary log active boode ya na.

hame mavared too filehaye peyvast zekr shodand, lotfan oonaro motale befarmaeed.

dar soorati ke log faal nashode bashe fekr mikonam ke majboorid etelaatetoon ro dasti va dobare vared bokonid :(

vali baad az in yadetoon nare ke hatman ham backup beghirid va ham binary log ro faal konid.

mamnoon

--
GNSInfo
Vahid samarghandi

[Fateme Khodaei]

Salam

Bekhatere peygiriton khili tashakor mikonam.

Alan ke khone hastam, farda check mikonam natijaro etela midam,

Rasti man Easyphp estefade mikonam fekmikonam(motmaen nistama) in file mysqlbinlog.exe nabud to foldere mysql!

Hala sob ba deghate bishtari migardam shayad bashe.

Bazam mamnoonam az lotfeton.

[Saeid Moradi]

Hi,

Thanks Vahid , your guide was very informative .

I have MySql5 installed and log-bin option was *not* set as default !
for active that, I found [mysqld] section
on[C:/rootOfMySqlInstallationPath/my.ini] then I've add below text
after that:
log-bin=C:/rootOfMySqlInstallationPath/data

then restart the mysql service for see the effect. (log-bin.000001 on /data)

In my cases , I prefer to have entire database as one.sql file by
updating .sql file instead of work with phpMyAdmin , (also phpMyAdmin
has limitation for work with sql files more than 2MB) .

HTH.

Regards,
Saeid
p.s. *If* you are familiar with Maven build tool , there is a
plugin[http://mojo.codehaus.org/dbunit-maven-plugin/] for work with
database in XML format.

[vahid samarghandi]

Hello,

your welcome, Seaid and Fateme

We come to this group to help each other as much as possible.
This is the one of our feature to become alive in our life.
If we continue to be in a group or groups, It will bring flexibility,
Movement and Motivation to us.

you know, we know something about everything but we do not know
everything about something, therefore our weakness can covered by
establishment of a group, simply without jealousy and doubt, It should
have a great heart.

finally, we knew that this poem is listened so much but it had a little
affect in our community as I know.

بنی آدم اعضای یکدیگرند که در آفرینش ز یک گوهرند

چو عضوی به درد آورد روزگار دگر عضوها را نباشد قرار

My last sentence, follow the truth and find out what is it?, to achieve welfare.

Respectfully Yours

--
GNSInfo
Vahid samarghandi

[Saeid Moradi]

Hi Vahid,

Reading your post was very enjoyable and make sense about being good
member in all communities (include ACCP group) .

I am happy with being member of many groups on the web , and I use to
read most of the posts in these groups[1] , and I Think being good
member is always good for ourself, first then others ! ;-)

I didn't meet Vahid for long time , because he traveled into the India
after finishing some courses in APTECH iidco center. I wish health and
wealth and happiness for him in every where on world , but if you are in
Iran now, please inform me.

Wishes,
Saeid
*below forum and mailing lists are about Java and J2EE frameworks and
libraries .
[1]http://forum.springframework.org, us...@myfaces.apache.org,
us...@facelets.dev.java.net, us...@appfuse.dev.java.net
,Google-We...@googlegroups.com, us...@mojo.codehaus.org, etc...
*

[Fateme Khodaei]

Thank you so much Vahid for your useful reply.

I did what you saied excatly but I understood the Binary Service is disable!

You were good Vahid, I think I should enter all my data again:(

 

By the way, take a short look on my latest website:

www.roshdsoft.com

 

To finish, I appreciate you guys for all your help.

As Saeid saied, I'm happy with being member of this group too.

 

 

 

--
Regards
Fateme Khodaei

[Saeid Moradi]

Hi,

I saw the website with Firefox3  and seems you have done good job ! (Congrats to you and your team)

Regards,
Saeid
p.s. recently I deploy one project in Linux host and database was mysql,  the service provider create the SSH account for us to connect to the database , and it was very great things , because by this feature you can connect to the database by every tools that you want in special port on your local machine. HTH 

[Fateme Khodaei]

Thanks Saeid its your kindness, but there is no team!

I was alone in this project just Mohammad  Eghlima one of my classmate helped me when I had problems.

Mohammad thank you :)

 

P.A guys:

Our company have two pavilions in the national festival on digital media, hope to see you there.

[vahid samarghandi]

In the name of merciful and unique Allah

Hello Dears

First reply to Saied:

Dear Seaid, You are right, Also I am very gladly to became familiar with ACCP and its Honorable students.
After completing 2 years of ACCP 2003-2005 course since 1382, I and my wife made decision to continue
our education to getting evasive bachelor. :)

Still we are in India, God willing, the next year is my last year to catching BCA's undergraduate course certificate.
but end of each educational year around June, I am in Iran until 45 days. I hope next coming, I am so eager to seeing
all my old and talented friends, specially you.

At present I am in Bangalore southern of India, if you have any question about here, please feel free.

here is a link which is a brief about Bangalore: http://en.wikipedia.org/wiki/Bangalore

Second reply to Fateme

Thank you so much too. :)
I viewed Amazing website, Its look and feel is very user friendly, surely the strong team is behind it.
Congratulation to you and your team from my behalf.

I am optimistic and full of hope that this group has infinite potential to working with together.

According to Saied's revering, I would like to say to my best friends, All of health, wealth and
happiness beside having belief to Allah.

Yours Faithfully

--
GNSInfo
Vahid samarghandi

[Saeid Moradi]

Hi,

@Vahid
I saw wiki page and pictures were very impressing ! ;-)   really is there like the pictures !? :-) (I am kidding)

And I will pray for you in your future study and please keep moving forward in next steps , we are behind you ! :-) (I am not kidding ;-))
surly you had some kind of unique experience out there and I will be very happy to hearing them from you in person, but it seems is not possible in near future .(because I will be in Australia at June(hopefully!))  anyway if you Blog your experience some where in the Web , I will be happy to read them.

@Fateme
You said : you were alone in this project ! you are kidding !! yes !? :-) 
if you were not , and *ifP you like ,please answer us on below questions : (Mohammad is in our group too, then he can help you if you like ;-))
1_How long time takes this project ? (please count work days only , if is possible)
2_Did you use any kind of CMS or something like them ? (in PHP I worked with WordPress and it has good support in Farsi)
3_The Design was your work too? (the Website has Neat Design in my opinion)
4_How much is flexible the Administrator part of project, and generally the backed ? (you can don't answer this question :))

Wishes,
Saeid
p.s. I like Java more than PHP :-)  &I think you know why ! ;-)

[Fateme Khodaei]

Hi and hope you all be ok.

First sorry for delay, because of holydays again! (God bless our Parliament's Man to have a such a nice holydays)

Now, answering Saeid questions:
 
I am not really joking, I was alone :D

1- This project took around 65 days for all analyse, design and develop tasks.

2- No CMS was used, I just saw what others did and got good points of them and implemented on my project, it's not cheating, isn't it? :O)

Sometimes, using CMS is a perfect choice but as we needed something different and I don't know CMS much well, I prefer to write everything from the begging. I also had a big problem with 'F' character in Farsi which some of my friends such as Babak Taraghi (the only person who I think you know him) helped me to solved it.

3- Now about the design, its obvious Saeid, you are STYLISH ;) I'm happy you and others approve my design.

4- And for the the last question, I attached a small view of Administrator part for you to see what sections it has.

 

If any questions left, feel free to ask :)

 

Have Fun

 

 

--
Regards
Fateme Khodaei

[Fateme Khodaei]

--
Regards
Fateme Khodaei

[Saeid Moradi]

Hi,

delay because of holidays is acceptable , no body is in front of his/her computer ! ;-)

and about answers , again I am surprise !  
65 days + No CMS + Nice Design + Farsi problems == Great Job ++ Congrats :-)

I compare your result with one of my works , they are a little different , but both of them are *Web application* and the result will be render to the browser , no matter what is on back , PHP, JAVA , whatever . I see simplicity on your work which I think is important thing for growing the application and you got that by your great work.
 
we hope we see more actions from members of this group by sharing and asking.
Also I will be happy to answer question about Java and JEE. (AFAIK)

Regards,
Saeid
p.s. Babak Taraghi is one of my friends , the best feture of him is , he is always himself ! :-)

[Fateme Khodaei]

Hey Saeid, This project is not as good as you described.

Anyway, thanks again.

[monavary mohamad]

ba salam be doastan

aghar kasi hast ke bekhad to 1 sherkat khososi ba hoghog v mazayae mamoli kar kone faghat baraye vorod etelaaat kar kone lotfan 1 emial be man bezane ke morefish konam

merC - monavari

[Saeid Moradi]

Salaam Mohammad,

Az zahere dastan entor be nazar meyad ke ya kare rotine , (va ehtemalan be takhasos khasi neyaz nadare!) 

Be nazare man kari metone khob bashe ke dar rastaye alaghe va eshteyagh adam bashe va az anjam oon beshe lezat bebari.
shayad jomle paeen manzore mano behtar beresone ! ;-)

*Find the job you love, you will not work a day in your life.

Thanks
Saeid 
*I don't know who said this ! :-)

[monavary mohamad]

ba salam mojadad

bale hamontor ke dostemon agha saeeid goftan 1 kar sade v rotin hast - ama be har hal in 1 kar alaan mojod hast aghe kasi bod ke bekhad  man dar khedmatam

ba tashakor - monavary

[Fateme Khodaei]

Hi

 

Data entry of 630 records finished!

It took just 13 days:D

Thanks everybody

 

Have a good day


--
Regards
Fateme Khodaei

[monavary mohamad]

[Mehdi Hallaji]

http://www.ox.ac.uk/media/news_stories/2008/080815.html