Recent posts in this topic
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
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.
Staff
Ilija Studen
on Jul 25. 2006. 2:18 pm
Hi,
I don't use MySQL console tool so I can't help you there... Somebody?
I don't use MySQL console tool so I can't help you there... Somebody?
activeCollab Team Member
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.
-d|--no-data No row information.
Topic is locked. If you have something important to say about issues discussed on this page please write at hi@a51dev.com.
