*** Quits: micahg (~micah@ubuntu/member/micahg) (Quit: Leaving.) | 00:22 | |
*** Joins: micahg (~micah@ubuntu/member/micahg) | 00:32 | |
*** Joins: davidinc (~davidinc@213.55.100.134) | 01:18 | |
*** Joins: kirillka (~Miranda@195.242.142.17) | 01:27 | |
*** Quits: kirillka (~Miranda@195.242.142.17) (Client Quit) | 01:27 | |
*** Quits: davidinc (~davidinc@213.55.100.134) (Read error: Connection reset by peer) | 01:59 | |
*** Joins: davidinc (~davidinc@213.55.100.134) | 02:00 | |
*** Joins: kirillka (~Miranda@195.242.142.17) | 02:04 | |
*** Joins: Rixie (~Rixie@0x4dd7390e.adsl.cybercity.dk) | 02:47 | |
*** Joins: Cupertino (~Cupez@62-177-158-122.dsl.bbeyond.nl) | 02:48 | |
*** Quits: Cupertino (~Cupez@62-177-158-122.dsl.bbeyond.nl) (Changing host) | 02:48 | |
*** Joins: Cupertino (~Cupez@unaffiliated/cupertino) | 02:48 | |
*** Quits: dhx1 (~anonymous@c122-107-170-247.eburwd5.vic.optusnet.com.au) (Remote host closed the connection) | 03:55 | |
*** Joins: dhx1 (~anonymous@c122-107-170-247.eburwd5.vic.optusnet.com.au) | 04:01 | |
*** Joins: Al_Chapone (~chatzilla@ATuileries-152-1-54-44.w82-123.abo.wanadoo.fr) | 04:17 | |
*** Quits: davidinc (~davidinc@213.55.100.134) (Remote host closed the connection) | 04:52 | |
*** Joins: davidinc (~davidinc@213.55.100.134) | 06:25 | |
*** Quits: Al_Chapone (~chatzilla@ATuileries-152-1-54-44.w82-123.abo.wanadoo.fr) (Quit: ChatZilla 0.9.86 [Firefox 3.6.10/20100914125854]) | 06:40 | |
nuclear_eclipse | holy developer list, batman! | 08:20 |
---|---|---|
dhx1 | more!! | 08:24 |
dhx1 | more talk = more code... err... wait :p | 08:24 |
*** Joins: istvanb (d917e473@gateway/web/freenode/ip.217.23.228.115) | 09:24 | |
istvanb | hello there | 09:24 |
istvanb | when a user creates a report he/she assigns the issue to a developer. Is there a way to show only the developers in the list and not everybody who has at least developer credentials? | 09:25 |
istvanb | its somehwat confusing to have the admins there | 09:26 |
nuclear_eclipse | istvanb: no, all access controls in mantis are based around minimum privilege levels | 09:27 |
istvanb | ok, thanks | 09:27 |
istvanb | I have another question :) | 09:28 |
istvanb | I need to migrate the existing mantis database to another server. I have tried the sqldump but I have failed (actually I have no real experience in these things). Is there like a step by step or easy solution described somewhere? | 09:28 |
nuclear_eclipse | it should just be a matter of: dump the sql database, import the dump into the new database, install mantis on the new server, copy all the old config files and plugins to the new install, and update the config with the new database credentials, and that should be it | 09:29 |
istvanb | yeah | 09:30 |
istvanb | however I was not able to perform the dump | 09:30 |
istvanb | I am using win xp on the old server and win2k8 on the destination | 09:32 |
nuclear_eclipse | I'm not really sure how to help you with that =\ | 09:33 |
istvanb | just give me the commands :D | 09:34 |
nuclear_eclipse | I don't know teh commands on windows | 09:34 |
nuclear_eclipse | on linux, it's `mysqldump databasename > dump.sql` to export and `mysql databasename < dump.sql` to import | 09:35 |
nuclear_eclipse | although with -u and -p parameters to define access credentials | 09:35 |
istvanb | actually thats what I have tried | 09:35 |
istvanb | exactly | 09:35 |
istvanb | do you know what is --opt | 09:35 |
nuclear_eclipse | but that won't work on windows | 09:35 |
istvanb | well I wrote something like | 09:36 |
nuclear_eclipse | you'll need to use something like mysqladmin or phpmyadmin to handle the export/import process | 09:36 |
istvanb | mysqldump --opt -p[askdjlfsd] user==username --all-database > dump.sql | 09:36 |
istvanb | brb in a sec! | 09:37 |
istvanb | back | 09:40 |
*** Quits: kirillka (~Miranda@195.242.142.17) (Quit: kirillka) | 09:56 | |
istvanb | I have tried it again | 09:57 |
istvanb | on my source the database is protected, so I have executed the following command: | 09:57 |
istvanb | mysqldump --user=username --password=password --all-databases > MANTIS.SQL | 09:58 |
istvanb | on the destination I have a fresh xampp install (I have checked the phpmyadmin and it worked) | 09:58 |
istvanb | then gave the following command: | 09:58 |
istvanb | mysqldump --user=root --all-databases < MANTIS.SQL | 09:59 |
istvanb | there were a lot of numbers and things running on the dos prompt | 09:59 |
istvanb | and then it says dump completed | 09:59 |
istvanb | but now I can not launch the phpmyadmin | 10:00 |
istvanb | it says connection for controluser as defined in your configuration failed | 10:00 |
istvanb | I think I am almost there I just need to resolve this | 10:00 |
istvanb | any guess plz, | 10:00 |
istvanb | ? | 10:00 |
nuclear_eclipse | well, you shouldn't be trying to use mysqldump to import the databases into your new intsall, that tool is only designed to export data | 10:01 |
istvanb | oh ok | 10:01 |
istvanb | so what would be the correct approach? | 10:01 |
nuclear_eclipse | it should just be `mysql --user=... --password=... < file.sql` | 10:02 |
istvanb | ok... is the first commmand correct or I have to repeat that on the source server as well? | 10:02 |
nuclear_eclipse | the first command is correct, although I personally don't like to use --all-databases, as that usually dumps a lot of stuff yo udon't want to dump; I prefer to just specify a single database name per dump | 10:03 |
istvanb | GEEZ man | 10:04 |
istvanb | after using the mysql instead of mysqldump | 10:04 |
istvanb | not it works | 10:04 |
istvanb | if you would be god I would join to your church | 10:04 |
istvanb | thanks a lot man, you just solved my problem | 10:05 |
istvanb | "not it works" means "now it works" | 10:05 |
nuclear_eclipse | you're welcome | 10:06 |
*** Joins: daryn (~daryn@h158.249.190.173.static.ip.windstream.net) | 10:25 | |
*** Quits: Cupertino (~Cupez@unaffiliated/cupertino) (Quit: I give up...) | 11:02 | |
*** Quits: istvanb (d917e473@gateway/web/freenode/ip.217.23.228.115) (Quit: Page closed) | 11:15 | |
*** Joins: geemee (~ocs@mailhost.exterity.com) | 11:54 | |
geemee | Hi there. When deleting a user the assigned to changes from the users name to a scored though "user X" How can I modify this table to change it to "A Name - Deleted Account" | 11:57 |
geemee | found it. just create a user in sql with the user ID and modfy the name to suit | 12:03 |
*** Quits: micahg (~micah@ubuntu/member/micahg) (Ping timeout: 265 seconds) | 12:16 | |
*** Joins: moto-moi (~hylke@cara.xs4all.nl) | 12:28 | |
*** Quits: geemee (~ocs@mailhost.exterity.com) (Remote host closed the connection) | 12:36 | |
*** Joins: siebrand (~beis@sm.xs4all.nl) | 12:57 | |
*** Joins: micahg (~micah@ubuntu/member/micahg) | 13:07 | |
*** Quits: micahg (~micah@ubuntu/member/micahg) (Remote host closed the connection) | 13:17 | |
*** Joins: micahg (~micah@ubuntu/member/micahg) | 13:19 | |
*** Joins: orac1 (~jb_buldog@082-146-096-042.dyn.adsl.xs4all.be) | 13:23 | |
*** Quits: davidinc (~davidinc@213.55.100.134) (Read error: Connection reset by peer) | 14:08 | |
*** Joins: davidinc (~davidinc@213.55.100.134) | 14:08 | |
*** Joins: billson (3c317a29@gateway/web/freenode/ip.60.49.122.41) | 14:15 | |
billson | hi all | 14:15 |
billson | anyone read me? | 14:15 |
*** Parts: Rixie (~Rixie@0x4dd7390e.adsl.cybercity.dk) | 14:17 | |
billson | testing 1 2 3 | 14:17 |
moto-moi | yeah | 14:18 |
moto-moi | test succeeded billson | 14:18 |
*** billson is now known as billson_29 | 14:18 | |
billson_29 | hi moto-moi | 14:19 |
billson_29 | i'm new to mantis... | 14:19 |
billson_29 | try few times to setup pass few months, and today 1st time succeeded connect from eclipse to mantis via mylyn | 14:20 |
billson_29 | anyone can help? | 14:21 |
moto-moi | pff, tried that a couple of times myself, and failed :P | 14:22 |
billson_29 | >_< | 14:22 |
billson_29 | did this chanel still active? :P | 14:23 |
moto-moi | yeah, but it seems it is atm a bit slow :) | 14:28 |
moto-moi | maybe people are eating or something like that | 14:29 |
billson_29 | ic, tks for infor | 14:29 |
billson_29 | coz i'm 1st time here | 14:29 |
moto-moi | np :) | 14:29 |
billson_29 | seems now is not a active time over here, c ya, here is 2am, gtg | 14:30 |
billson_29 | bye all | 14:30 |
*** Quits: davidinc (~davidinc@213.55.100.134) (Ping timeout: 264 seconds) | 14:33 | |
*** Parts: billson_29 (3c317a29@gateway/web/freenode/ip.60.49.122.41) | 14:33 | |
*** Joins: orac1_ (~jb_buldog@082-146-096-103.dyn.adsl.xs4all.be) | 15:31 | |
*** Quits: orac1 (~jb_buldog@082-146-096-042.dyn.adsl.xs4all.be) (Ping timeout: 265 seconds) | 15:32 | |
*** orac1_ is now known as orac1 | 15:32 | |
*** Quits: orac1 (~jb_buldog@082-146-096-103.dyn.adsl.xs4all.be) (Quit: ChatZilla 0.9.86 [Firefox 3.6.10/20100914125854]) | 16:14 | |
*** Quits: micahg (~micah@ubuntu/member/micahg) (Ping timeout: 265 seconds) | 16:49 | |
*** Joins: micahg (~micah@ubuntu/member/micahg) | 17:32 | |
*** Joins: djSupport_ (~djsupport@188-221-240-190.zone12.bethere.co.uk) | 17:46 | |
*** Quits: djSupport (~djsupport@188-221-240-190.zone12.bethere.co.uk) (Ping timeout: 260 seconds) | 17:49 | |
*** Quits: micahg (~micah@ubuntu/member/micahg) (Quit: Leaving.) | 18:45 | |
*** Quits: scribe9343423 (~scribe934@static.96.23.63.178.clients.your-server.de) (Remote host closed the connection) | 20:00 | |
*** Joins: scribe9343423 (~scribe934@static.96.23.63.178.clients.your-server.de) | 20:00 | |
*** Quits: tavasti (~tavasti@ov1.tavasti.fi) (Ping timeout: 240 seconds) | 22:25 | |
*** Quits: daryn (~daryn@h158.249.190.173.static.ip.windstream.net) (Quit: Ex-Chat) | 22:33 |
Generated by irclog2html.py 2.9.2 by Marius Gedminas - find it at mg.pov.lt!