aC forum: activeCollab 0.6, community preview http://www.activecollab.com/forums/topic/117/ Recent posts on topic: activeCollab 0.6, community preview en-us Sun, 23 Nov 2008 12:55:56 UTC http://www.activecollab.com/forums/post/1384/#post1384 http://www.activecollab.com/forums/post/1384/#post1384 Post #45 by gog gog Yes, I know, that's why I copy pasted :)

]]> Tue, 25 Jul 2006 22:11:32 UTC http://www.activecollab.com/forums/post/1379/#post1379 http://www.activecollab.com/forums/post/1379/#post1379 Post #44 by seventoes seventoes man is a linux command, he might be using windows.

]]> Tue, 25 Jul 2006 20:46:10 UTC http://www.activecollab.com/forums/post/1362/#post1362 http://www.activecollab.com/forums/post/1362/#post1362 Post #43 by gog gog Try running mysqldump with an -d switch to backup only "structure". Havent tried it yes, but this is from man mysqldump
-d|--no-data No row information.

]]> Tue, 25 Jul 2006 14:23:46 UTC http://www.activecollab.com/forums/post/1361/#post1361 http://www.activecollab.com/forums/post/1361/#post1361 Post #42 by Ilija Studen Ilija Studen Hi,

I don't use MySQL console tool so I can't help you there... Somebody?

]]> Tue, 25 Jul 2006 14:18:15 UTC http://www.activecollab.com/forums/post/1336/#post1336 http://www.activecollab.com/forums/post/1336/#post1336 Post #41 by cm_gui cm_gui Hi Ilija

Sorry but I am a newbie and don't know much about Mysql and don't use MyPhpAdmin.

1) How do you "Make two backups of DB data: structure + data and only data" on the Mysql command line?

I usually use mysqldump to make a backup of my database, but it backs up everything.
How do I back up only the data?

2) How do you "Import data from DB backup. Just the data" on the command line?
Usually I do mysql –u root –p databasename < databasedumpfile but this import everything and not just the data.

Thank you very much in anticipation.

Gui



Ilija Studen:
For all of you who want to upgrade, please follow this routine:

1. Backup old files and data from database. Make two backups of DB data: structure + data and only data. First you'll need if something goes wrong and you need to revert back to alpha. Second you'll need to import in step 6.
2. Drop all activeCollab tables from database. Remember to backup first!
3. Upload 0.6 and rewrite old files with new ones.
4. Run the installer, same thing as the first time.
5. Select all tables and empty them. There is option in PHPMyAdmin or run TRUNCATE on all tables.
6. Import data from DB backup. Just the data, installer created the structure.
7. It shoud work. Go back to login screen.

That should do the trick. If anything goes wrong restore old files and data in database and we'll see what can be done.

]]> Mon, 24 Jul 2006 18:41:42 UTC http://www.activecollab.com/forums/post/935/#post935 http://www.activecollab.com/forums/post/935/#post935 Post #40 by halmat halmat Works on:

Mac OS X 10.4.7
PHP 5.1.4
MySQL 4.0.24
Apache 1.33

No problems at all

]]> Fri, 14 Jul 2006 18:37:32 UTC http://www.activecollab.com/forums/post/856/#post856 http://www.activecollab.com/forums/post/856/#post856 Post #39 by seventoes seventoes I'd be willing to help with the javascript bits. Im pretty experienced. I prefer jQuery, but i can adapt to other libraries too.

]]> Fri, 14 Jul 2006 04:38:20 UTC http://www.activecollab.com/forums/post/847/#post847 http://www.activecollab.com/forums/post/847/#post847 Post #38 by Ilija Studen Ilija Studen When you are exporting database as SQL you export two sets of information:

* database construction - have tables are constructed, relations between them etc
* data that is already in the tables

For backup you'll need both. For import when upgrading you don't need construction, just data. Construction is created by installer.

Ah, is it because when you restore the stuff that the installer fills in won't be over written? You'd have dupes causing all kinda nonsense?

Correct!

]]> Thu, 13 Jul 2006 23:44:16 UTC http://www.activecollab.com/forums/post/832/#post832 http://www.activecollab.com/forums/post/832/#post832 Post #37 by ajcowellwork ajcowellwork Bit of an SQL novice here (although I did manage to install without too much of a hassle so I can't be that bad). I'm running on Mac OSX and using MySQL Administrator to backup my db. In (1) below, is this like selecting the 'Backup Selected Schema Completely' option? The execution mode I've set is 'Lock All Tables'.

If this is simpler to just run a MySQL command - let me know and I'll google around to find out what I need.

Oh, another question - what is the purpose of (5) below? Ah, is it because when you restore the stuff that the installer fills in won't be over written? You'd have dupes causing all kinda nonsense?

Thanks for an awesome product!

A.

Ilija Studen:
For all of you who want to upgrade, please follow this routine:

1. Backup old files and data from database. Make two backups of DB data: structure + data and only data. First you'll need if something goes wrong and you need to revert back to alpha. Second you'll need to import in step 6.
2. Drop all activeCollab tables from database. Remember to backup first!
3. Upload 0.6 and rewrite old files with new ones.
4. Run the installer, same thing as the first time.
5. Select all tables and empty them. There is option in PHPMyAdmin or run TRUNCATE on all tables.
6. Import data from DB backup. Just the data, installer created the structure.
7. It shoud work. Go back to login screen.

That should do the trick. If anything goes wrong restore old files and data in database and we'll see what can be done.

]]> Thu, 13 Jul 2006 19:21:56 UTC http://www.activecollab.com/forums/post/782/#post782 http://www.activecollab.com/forums/post/782/#post782 Post #36 by Ilija Studen Ilija Studen We wanted to make sure that 0.6 works fine on most of the installations so we are still testing it. People found 7 bugs with this realease in 2 days. I think that 0.6 will be available as "official" download today or tomorrow.

Upgrade process is not currently automated. Automated updates will be available after we get to 1.0.

]]> Thu, 13 Jul 2006 03:31:07 UTC