hi all I am currently using otrs version 2.2.1 on windows small business server 2003. I intend to upgrade it to 2.2.4 or 2.2.5 because of the bugs in the first version. i would to know how i can backup my mysql database. i went through the website and it was suggested to use the phpmyadmin or mysqldump. can somebody tell me how i can access my server remotely to perform the backup. thank you _________________________________________________________________ Tried the new MSN Messenger? It’s cool! Download now. http://messenger.msn.com/Download/Default.aspx?mkt=en-in
Hi pri pri,
hi all
I am currently using otrs version 2.2.1 on windows small business server 2003. I intend to upgrade it to 2.2.4 or 2.2.5 because of the bugs in the first version. i would to know how i can backup my mysql database. i went through the website and it was suggested to use the phpmyadmin or mysqldump. can somebody tell me how i can access my server remotely to perform the backup. ? try a terminal sesssion. Or what did you mean?
-- Shawn Beasley ((otrs)) :: OTRS AG :: Norsk-Data-Straße 1 :: 61352 Bad Homburg Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Geschäftssitz: Bad Homburg Amtsgericht Bad Homburg, HRB 10751 Steuernummer: 003/240/97521 Aufsichtsratsvorsitzender: Burchard Steinbild Vorstandsvorsitzender: André Mindermann
thanks for your reply i havent tried it yet. but i want to know how i can access my database sorry if i sound very lame. thank you
Date: Thu, 14 Feb 2008 14:51:09 +0100> From: shawn.beasley@otrs.com> To: otrs@otrs.org> Subject: Re: [otrs] windows update for OTRS> > Hi pri pri,> > hi all> > > > > > I am currently using otrs version 2.2.1 on windows small business > > server 2003.> > I intend to upgrade it to 2.2.4 or 2.2.5 because of the bugs in the > > first version.> > i would to know how i can backup my mysql database. i went through the > > website and it was suggested to use the phpmyadmin or mysqldump.> > can somebody tell me how i can access my server remotely to perform > > the backup.> ? try a terminal sesssion. Or what did you mean?> > -- > Shawn Beasley> ((otrs)) :: OTRS AG :: Norsk-Data-Straße 1 :: 61352 Bad Homburg> Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18> http://www.otrs.com/ :: Communication with success!> > > Geschäftssitz: Bad Homburg> Amtsgericht Bad Homburg, HRB 10751> Steuernummer: 003/240/97521> > Aufsichtsratsvorsitzender: Burchard Steinbild> Vorstandsvorsitzender: André Mindermann> >
Post ads for free - to sell, rent or even buy.www.yello.in http://ss1.richmedia.in/recurl.asp?pid=186
hi i read from the website that i can use phpmyadmin or mysqldump but i do not know how i can access my server to run the commands phpmyadmin has to be downloaded separately is it?? thank you
From: nils@lemonbit.nl> To: otrs@otrs.org> Subject: Re: [otrs] windows update for OTRS> Date: Thu, 14 Feb 2008 16:36:36 +0100> > pri pri wrote:> > > i havent tried it yet. but i want to know how i can access my database> > sorry if i sound very lame.> > Well, you already said you found mysqldump and phpMyAdmin. Those are > indeed two options to create dumps of your OTRS database. What is the > problem?> > Nils Breunese.> _______________________________________________> OTRS mailing list: otrs - Webpage: http://otrs.org/> Archive: http://lists.otrs.org/pipermail/otrs> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs> Support or consulting for your OTRS system?> => http://www.otrs.com/
Post free property ads on Yello Classifieds now! www.yello.in http://ss1.richmedia.in/recurl.asp?pid=219
Install MySql admin and you'll be able to do a backup of the db's .... you can get it on the mysql website... pri pri a écrit:
hi
i read from the website that i can use phpmyadmin or mysqldump
but i do not know how i can access my server to run the commands
phpmyadmin has to be downloaded separately is it??
thank you
From: nils@lemonbit.nl To: otrs@otrs.org Subject: Re: [otrs] windows update for OTRS Date: Thu, 14 Feb 2008 16:36:36 +0100
pri pri wrote:
i havent tried it yet. but i want to know how i can access my database sorry if i sound very lame.
Well, you already said you found mysqldump and phpMyAdmin. Those are indeed two options to create dumps of your OTRS database. What is the problem?
Nils Breunese. _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
------------------------------------------------------------------------ It's about getting married. Click here! Try it! http://ss1.richmedia.in/recurl.asp?pid=201 ------------------------------------------------------------------------
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
--
Adriano Amaral wrote:
Install MySql admin and you'll be able to do a backup of the db's .... you can get it on the mysql website...
I don't think there is a Linux distribution that doesn't include mysqladmin. But I'd use the mysqldump tool (also included). http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html Nils Breunese.
thank you very much i will install and try theback up thank you
From: nils@lemonbit.nl> To: otrs@otrs.org> Subject: Re: [otrs] windows update for OTRS> Date: Thu, 14 Feb 2008 17:49:35 +0100> > Adriano Amaral wrote:> > > Install MySql admin and you'll be able to do a backup of the > > db's .... you can get it on the mysql website...> > I don't think there is a Linux distribution that doesn't include > mysqladmin. But I'd use the mysqldump tool (also included).> > http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html> > Nils Breunese.> _______________________________________________> OTRS mailing list: otrs - Webpage: http://otrs.org/> Archive: http://lists.otrs.org/pipermail/otrs> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs> Support or consulting for your OTRS system?> => http://www.otrs.com/
Tried the new MSN Messenger? It’s cool! Download now. http://messenger.msn.com/Download/Default.aspx?mkt=en-in
Nils, True but he's on Widoooze 2003 SBS. So either he install the mysqladmin on his PC or on the server. Either way he has to get the install from mysql site. I'll not advisie him on that if he was using a "real" OS. ;-) Nils Breunese (Lemonbit) a écrit:
Adriano Amaral wrote:
Install MySql admin and you'll be able to do a backup of the db's .... you can get it on the mysql website...
I don't think there is a Linux distribution that doesn't include mysqladmin. But I'd use the mysqldump tool (also included).
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
Nils Breunese. _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
--
Adriano Amaral wrote:
Nils,
True but he's on Widoooze 2003 SBS. So either he install the mysqladmin on his PC or on the server. Either way he has to get the install from mysql site.
I'll not advisie him on that if he was using a "real" OS. ;-)
Ah ok, I missed the Windows part. Sorry for the noise. Nils Breunese.
thank you very much i will try it
Date: Thu, 14 Feb 2008 11:16:47 -0500> From: a.amaral@ivic.qc.ca> To: otrs@otrs.org> Subject: Re: [otrs] windows update for OTRS> > Install MySql admin and you'll be able to do a backup of the db's .... > you can get it on the mysql website...> > pri pri a écrit:> > hi> > > > i read from the website that i can use phpmyadmin or mysqldump> > > > but i do not know how i can access my server to run the commands> > > > phpmyadmin has to be downloaded separately is it??> > > > thank you> > > >> >> > > From: nils@lemonbit.nl> > > To: otrs@otrs.org> > > Subject: Re: [otrs] windows update for OTRS> > > Date: Thu, 14 Feb 2008 16:36:36 +0100> > >> > > pri pri wrote:> > >> > > > i havent tried it yet. but i want to know how i can access my database> > > > sorry if i sound very lame.> > >> > > Well, you already said you found mysqldump and phpMyAdmin. Those are> > > indeed two options to create dumps of your OTRS database. What is the> > > problem?> > >> > > Nils Breunese.> > > _______________________________________________> > > OTRS mailing list: otrs - Webpage: http://otrs.org/> > > Archive: http://lists.otrs.org/pipermail/otrs> > > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs> > > Support or consulting for your OTRS system?> > > => http://www.otrs.com/> >> >> > ------------------------------------------------------------------------> > It's about getting married. Click here! Try it! > > http://ss1.richmedia.in/recurl.asp?pid=201> > ------------------------------------------------------------------------> >> > _______________________________________________> > OTRS mailing list: otrs - Webpage: http://otrs.org/> > Archive: http://lists.otrs.org/pipermail/otrs> > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs> > Support or consulting for your OTRS system?> > => http://www.otrs.com/> > -- > > _______________________________________________> OTRS mailing list: otrs - Webpage: http://otrs.org/> Archive: http://lists.otrs.org/pipermail/otrs> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs> Support or consulting for your OTRS system?> =ttp://www.otrs.com/
Post free property ads on Yello Classifieds now! www.yello.in http://ss1.richmedia.in/recurl.asp?pid=220
pri pri wrote:
i read from the website that i can use phpmyadmin or mysqldump
but i do not know how i can access my server to run the commands
That depends on how you can access the server in general. Can you login via SSH? VNC? NX? (Telnet? Etc.?) If so, you can use that method to run mysqldump from a terminal. You could also use some local MySQL command line or GUI client on your own computer if MySQL is configured to allow remote access for the user that can access the OTRS database.
phpmyadmin has to be downloaded separately is it??
Yes, it's a web interface for MySQL. Nils Breunese.
Windows SBS are available remotely via RemoteWorkgroup(a web-based RDP). If you have enabled this you simply access it via HTTP(S). If the admin enabled RDP and allowed it through the FW then that might be an option. Since you don't seem to know about the server administration. It will be far easier to walk over to the box and use the keyboard,mouse & monitor. We could be explaining how to access your server for a while since we don't know how it was setup.
-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Nils Breunese (Lemonbit) Sent: Thursday, February 14, 2008 11:19 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] windows update for OTRS
pri pri wrote:
i read from the website that i can use phpmyadmin or mysqldump
but i do not know how i can access my server to run the commands
That depends on how you can access the server in general. Can you login via SSH? VNC? NX? (Telnet? Etc.?) If so, you can use that method to run mysqldump from a terminal. You could also use some local MySQL command line or GUI client on your own computer if MySQL is configured to allow remote access for the user that can access the OTRS database.
phpmyadmin has to be downloaded separately is it??
Yes, it's a web interface for MySQL.
Nils Breunese. _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
participants (5)
-
Adriano Amaral -
LQ Marshall -
Nils Breunese (Lemonbit) -
pri pri -
Shawn Beasley